Contents of the ORDERS table

-Based on the contents of the ORDERS table,which of the following SELECT statements will determine the number of orders placed by each customer?
A) SELECT COUNT(DISTINCT(customer#)) FROM orders;
B) SELECT COUNT(*) FROM orders;
C) SELECT customer#,COUNT(customer#) FROM orders GROUP BY customer#;
D) none of the above

Question

Contents of the ORDERS table​
 
-​Based on the contents of the ORDERS table,which of the following SELECT statements will determine the number of orders placed by each customer?
A) ​SELECT COUNT(DISTINCT(customer#)) FROM orders; 
B) ​SELECT COUNT(*) FROM orders; 
C) ​SELECT customer#,COUNT(customer#) FROM orders GROUP BY customer#; 
D) ​none of the above

Quizplus · Accepted Answer

Option C is the correct choice as it includes the customer number and groups the rows by customer number, and uses COUNT to count the number of orders for each customer. Option A only gives the count of distinct customer numbers, but does not group the orders by customers. Option B only gives the count of total orders in the table, not by customers.

Contents of the ORDERS Table​

Contents of the ORDERS Table