Contents of the ORDERS Table

Multiple Choice

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#;