Contents of the ORDERS table

-Based on the contents of the ORDERS table,which of the following SQL statements will display the number of orders that have not been shipped?
A) SELECT order#,COUNT(shipdate) FROM orders WHERE shipdate IS NULL;
B) SELECT order#,COUNT(shipdate) FROM orders WHERE shipdate IS NULL GROUP BY order#;
C) SELECT COUNT(shipdate) FROM orders WHERE shipdate IS NULL;
D) SELECT COUNT(*) FROM orders WHERE shipdate IS NULL;

Question

Contents of the ORDERS table​
 
-​Based on the contents of the ORDERS table,which of the following SQL statements will display the number of orders that have not been shipped?
A) SELECT order#,COUNT(shipdate) FROM orders WHERE shipdate IS NULL; 
B) ​SELECT order#,COUNT(shipdate) FROM orders WHERE shipdate IS NULL GROUP BY order#; 
C) ​SELECT COUNT(shipdate) FROM orders WHERE shipdate IS NULL; 
D) ​SELECT COUNT(*) FROM orders WHERE shipdate IS NULL;

Quizplus · Accepted Answer

Option D is the correct choice as it uses the COUNT (*) function to count the total number of records in the ORDERS table where the shipdate is NULL. This will give us the total number of orders that have not been shipped. Option A and B both use the COUNT function but also include the order# column which could lead to incorrect results as it will only count orders that have at least one NULL shipdate. Option C only returns the count of NULL shipdates but does not give us the total number of orders that have not been shipped.

Contents of the ORDERS Table​

Contents of the ORDERS Table