Structure of the ORDERS table

-Which of the following is a valid SQL statement to retrieve data from the ORDERS table?
A) SELECT DISTINCT customer#, DISTINCT order# FROM orders;
B) SELECT customer#, street, city, state, zip FROM orders;
C) SELECT order#, orderdate, shipdate FROM orders;
D) all of the above

Question

Structure of the ORDERS table
 
-Which of the following is a valid SQL statement to retrieve data from the ORDERS table?
A) SELECT DISTINCT customer#, DISTINCT order# FROM orders; 
B) SELECT customer#, street, city, state, zip FROM orders; 
C) SELECT order#, orderdate, shipdate FROM orders; 
D) all of the above

Quizplus · Accepted Answer

Option C selects relevant columns from the ORDERS table - order# and dates, which are likely to be useful in tracking and processing orders. Option A is incorrect as you cannot use DISTINCT keyword twice for multiple columns, and also it selects irrelevant columns. Option B is incorrect because it selects columns that are not completely relevant to the ORDERS table, it may belong to a different table.

Structure of the ORDERS Table