Contents of the ORDERS Table​

question 17

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;