Contents of the ORDERS Table​

Multiple Choice

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;