Contents of the ORDERS table

-Based upon the contents of the ORDERS table in the accompanying figure,which of the following queries will list all orders contained in the ORDERS table that have been shipped based upon the customer# and order#?
A) SELECT * FROM orders WHERE shipdate IS NOT NULL ORDER BY customer#,order#;
B) SELECT * FROM orders WHERE shipdate IS NULL ORDER BY customer#,order#;
C) SELECT * FROM orders WHERE shipdate IS NOT NULL ORDERED BY customer#,order#;
D) SELECT * FROM orders WHERE shipdate IS NOT NULL SORTED BY customer#,order#;

Question

Contents of the ORDERS table
 
-Based upon the contents of the ORDERS table in the accompanying figure,which of the following queries will list all orders contained in the ORDERS table that have been shipped based upon the customer# and order#?​
A) ​SELECT * FROM orders WHERE shipdate IS NOT NULL ORDER BY customer#,order#; 
B) ​SELECT * FROM orders WHERE shipdate IS NULL ORDER BY customer#,order#; 
C) ​SELECT * FROM orders WHERE shipdate IS NOT NULL ORDERED BY customer#,order#; 
D) ​SELECT * FROM orders WHERE shipdate IS NOT NULL SORTED BY customer#,order#;

Quizplus · Accepted Answer

Option A selects all orders that have been shipped (i.e. where the shipdate is not null) and orders them based on customer# and order# which is the requirement for the query. Option B selects all orders that have not been shipped (i.e. where shipdate is null), which is not the requirement for the query. Options C and D are incorrect as there is no "ORDERED BY" or "SORTED BY" clause in SQL.

Contents of the ORDERS Table