easy5 pts · first answer countssql

Counting orders per customer

Which SQL query returns the number of orders for each customer?

A.SELECT customer_id, COUNT(*) FROM orders;B.SELECT COUNT(DISTINCT customer_id) FROM orders;C.SELECT customer_id, COUNT(*) AS n_orders FROM orders GROUP BY customer_id;D.SELECT customer_id FROM orders ORDER BY COUNT(*);

← Ice cream and drowning Customers with no orders →