Contents of the ORDERS Table​

Multiple Choice

Contents of the ORDERS table​

-​Based upon the contents of the ORDERS table,which of the following will display how many orders were shipped to each state?

A) ​SELECT shipstate,COUNT(*)
FROM orders;
B) ​SELECT shipstate,COUNT(customer#)
FROM orders;
C) ​SELECT shipstate,COUNT(*)
FROM orders
HAVING COUNT(*) >0
D) ​SELECT shipstate,COUNT(*)
FROM orders
GROUP BY shipstate;