Which of the following is a valid SQL statement?
a. SELECT SUM(quantityretail) "Total Sales"FROM orders JOIN orderitems ON orders.order# = orderitems.order#JOIN books ON orderitems ON orderitems.ISBN = books.ISBNWHERE orderdate = '02-APR-03';
b. SELECT SUM(quantityretail) "Total Sales"FROM orders JOIN orderitems ON orders.order# = orderitems.order#JOIN books ON orderitems ON orderitems.ISBN = books.ISBNHAVING orderdate = '02-APR-03';
c. SELECT customer#, SUM(quantityretail) "Total Sales"FROM orders JOIN orderitems ON orders.order# = orderitems.order#JOIN books ON orderitems ON orderitems.ISBN = books.ISBNHAVING orderdate = '02-APR-03';
d. SELECT customer#, SUM(quantityretail) "Total Sales"FROM orders JOIN orderitems ON orders.order# = orderitems.order#JOIN books ON orderitems ON orderitems.ISBN = books.ISBNHAVING orderdate = '02-APR-03'GROUP BY customer#;
.D
You might also like to view...
The first analysis deliverable, the logical specification, is used in systems selection to choose the appropriate software to be acquired from external sources
Indicate whether the statement is true or false
For the United States, countervailing duty cases consist of allegations of
a. foreign impediments to American exports. b. dumping by foreign exporting companies. c. foreign export subsidies. d. monopoly pricing by foreign importing companies.
Both the number of entries and the number of ledger accounts decrease when you change to a backflush costing system
Indicate whether the statement is true or false
Which document provides information to possible new franchisees on 20 items required by the Federal Trade Commission?
A. Marketing statement B. Business plan agreement C. Disclosure statement D. Buy-sell agreement