Structure of the ORDERS table

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

Question

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

Quizplus · Accepted Answer

Option B is the correct SQL statement to retrieve data from the ORDERS table as it selects specific columns (order#, orderdate, shipdate) from the table. Option C selects columns that are not present in the ORDERS table (customer#, street, city, state, zip) and Option D uses the keyword DISTINCT in an incorrect manner. Option A is not a valid choice as it is not specific to one correct SQL statement.

Structure of the ORDERS Table