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;

Question

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;

Quizplus · Accepted Answer

The correct query for this question should group the orders by the shipstate and then count the number of orders per state. Option D is the only query that group the orders by the shipstate using GROUP BY and counts the number of orders in each state. Option A only counts the orders without grouping by state, option B tries to count by customer# which is not relevant for this question, and option C uses the HAVING clause incorrectly. Therefore, option D is the best choice.

Contents of the ORDERS Table​

Contents of the ORDERS Table