Oracle 12c: SQL
3rd Edition
ISBN: 9781305251038
Author: Joan Casteel
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 2, Problem 3MC
Which of the following is not a valid SELECT statement?
- a. SELECT lastname, firstname FROM customers;
- b. SELECT * FROM orders;
- c. Select FirstName NAME from CUSTOMERS;
- d. SELECT lastname Last Name FROM customers;
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Write a SELECT statement that uses a correlated subquery to return one row per customer, representing the customer's oldest order (the one with the earliest date).
Each row should include these five columns:
first_name
last_name
order_id
order_date
total quantity
Include only orders with a total order quantity greater than 2.
Subject: MySQL
Changes this SQL query statement to Xquery Statements
select distinct company_name
from (employee natural join works) join company using (company_name)
where employee.city = 'Omaha' or employee.city = 'Lincoln'
select distinct street, employee.city
from manages, employee natural join works
where company_name = 'Union Pacific';
Which of the following statements is valid? (refer to the tables in the JustLee Books database.)a. SELECT title FROM booksWHERE retail<(SELECT cost FROM booksWHERE isbn = '9959789321');b. SELECT title FROM booksWHERE retail = (SELECT cost FROM booksWHERE isbn = '9959789321' ORDER BY cost);c. SELECT title FROM booksWHERE category IN (SELECT cost FROM orderitemsWHERE isbn = '9959789321');d. none of the above statements
Chapter 2 Solutions
Oracle 12c: SQL
Ch. 2 - Prob. 1RQCh. 2 - What are the two required clauses for a SELECT...Ch. 2 - What is the purpose of the SELECT statement?
Ch. 2 - What does an asterisk () in the SELECT clause of a...Ch. 2 - What is the purpose of a column alias?Ch. 2 - How do you indicate that a column alias should be...Ch. 2 - When is it appropriate to use a column alias?
Ch. 2 - What are the guidelines to keep in mind when using...Ch. 2 - Prob. 9RQCh. 2 - What is a NULL value?
Ch. 2 - Which of the following SELECT statements displays...Ch. 2 - Which clause is required in a SELECT...Ch. 2 - Which of the following is not a valid SELECT...Ch. 2 - Which of the following symbols represents...Ch. 2 - Prob. 5MCCh. 2 - Prob. 6MCCh. 2 - Which of the following is a valid SELECT...Ch. 2 - Which of the following symbols is used in a SELECT...Ch. 2 - Prob. 9MCCh. 2 - When must a comma be used in the SELECT clause of...Ch. 2 - Prob. 11MCCh. 2 - Which clause is not required in a SELECT...Ch. 2 - Which of the following lines of the SELECT...Ch. 2 - Which of the following lines of the SELECT...Ch. 2 - Which of the following lines of the SELECT...Ch. 2 - Which of the following lines of the SELECT...Ch. 2 - Which of the following lines of the SELECT...Ch. 2 - Which of the following lines of the SELECT...Ch. 2 - Which of the following lines of the SELECT...Ch. 2 - Which of the following lines of the SELECT...Ch. 2 - Prob. 1HOACh. 2 - Prob. 2HOACh. 2 - Prob. 3HOACh. 2 - Prob. 4HOACh. 2 - Prob. 5HOACh. 2 - Prob. 6HOACh. 2 - Prob. 7HOACh. 2 - Create a list of each book title stored in the...Ch. 2 - Prob. 9HOACh. 2 - List all information for each order item. Include...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Which of the following lines of the SELECT statement contains an error? 1 SELECT ISBN, 2 retail-cost 3 FROM books; a. line 1 b. line 2 c. line 3 d. There are no errors.arrow_forwardWhich of the following is a valid SELECT statement? a. SELECT TITLES TITLE! FROM BOOKS; b. SELECT customer# FROM books; c. SELECT title AS Book Title from books; d. all of the abovearrow_forwardWhich of the following SELECT statements displays a list of customer names from the CUSTOMERS table? SELECT customer names FROM customers; SELECT “Names” FROM customers; SELECT firstname, lastname FROM customers; SELECT firstname, lastname, FROM customers; SELECT firstname, lastname, “Customer Names” FROM customers;arrow_forward
- Which of the following lines of the SELECT statement contains an error? 1 SELECT * 2 FROM publishers; line 1 line 2 There are no errors.arrow_forwardWhich of the following lines of the SELECT statement contains an error? 1 SELECT title, cost, 2 cost2 3 'With 200% Markup' 4 FROM books; a. line 1 b. line 2 c. line 3 d. line 4 e. There are no errors.arrow_forwardWhich of the following statements retrieves data from the Sales table and stores it in the CompanyDataSet? Me.CompanyDataSet.Fill(Me.Sales) Me.SalesBindingSource.Fill(Me.CompanyDataSet) Me.SalesBindingNavigator.Fill(Me.CompanyDataSet.Sales) Me.SalesTableAdapter.Fill(Me.CompanyDataSet.Sales)arrow_forward
- Which of the following lines of the SELECT statement contains an error? 1 SELECT name, contact 2 "Person to Call", phone 3 FROM publisher; a. line 1 b. line 2 c. line 3 d. There are no errors.arrow_forwardWhich of the following is not a valid SELECT statement?a. SELECT STDDEV(retail)FROM books;b. SELECT AVG(SUM(retail))FROM ordersNATURAL JOIN orderitems NATURAL JOIN booksGROUP BY customer#;c. SELECT order#, TO_CHAR(SUM(retail), '999.99')FROM orderitems JOIN books USING(isbn)GROUP BY order#;d. SELECT title, VARIANCE(retail-cost)FROM booksGROUP BY pubid;arrow_forwardWhich of the following statements retrieves data from the Sales table and stores it in the CompanyDataSet? a. Me.CompanyDataSet.Fill(Me.Sales) b. Me.SalesBindingSource.Fill(Me.CompanyDataSet) c. Me.SalesBindingNavigator.Fill(Me.CompanyDataSet.Sales) d. Me.SalesTableAdapter.Fill(Me.CompanyDataSet.Sales)arrow_forward
- SELECT COUNT(INV_NUMBER) AS 'Total Invoices', SUM(TOTAL_PRICE) AS 'Total Sales', MIN(TOTAL_PRICE) AS 'Minimum Customer Purchases', MAX(TOTAL_PRICE) AS 'Largest Customer Purchases', ROUND(AVG(TOTAL_PRICE), 2) AS 'Average Customer Purchases'FROM (SELECT CUS_CODE, LINE.INV_NUMBER AS INV_NUMBER, ROUND(SUM(LINE.LINE_PRICE * LINE.LINE_UNITS), 2) AS TOTAL_PRICEFROM INVOICE, LINE WHERE INVOICE.INV_NUMBER = LINE.INV_NUMBER GROUP BY CUS_CODE, LINE.INV_NUMBERORDER BY CUS_CODE, LINE.INV_NUMBER)INVOICELINE; i use this code but it didn't show the same value as in the questionarrow_forwardUse select statements to create queries that answer the following questions. Only provide the information requested. Do not provide the output. All tables are provided below List the name and price for all bouquets priced under $79.99 List the first name and last name for all customers without phone numbers. List the name of all bouquets priced at $39.99 or over.arrow_forwardthe employee table have the following . ask user what is the employee_id and how much employee wants to contribute 2 substitutions variable from end user &emp_id &contribution_amount If employee salary is in between $1000-$3999 And if employee's contribution amount is less than $100 then company match $100 if employee's contribution amount is greater than 100 but less than $200 then company match $75 if employee's contribution amount is greater than $200 then company match $50 $4000-$6999 And if employee's contribution amount is less than $100 then company match $150 if employee's contribution amount is greater than 100 but less than $200 then company match $100 if employee's contribution amount is greater than $200 then company match $75 $7000-$12000And if employee's contribution amount is less than $100 then company match $200 if employee's contribution amount is greater than…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage LearningNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
How to Design DB Tables for any Application? (The Basics); Author: Studytonight;https://www.youtube.com/watch?v=XUdNVaSikqY;License: Standard YouTube License, CC-BY
Create a Table (Introduction to Oracle SQL); Author: Database Star;https://www.youtube.com/watch?v=BiV1IrzB1sY;License: Standard Youtube License