medium10 pts · first answer countssql

Customers with many orders

Which query lists customers who have placed more than 5 orders?

A.SELECT customer_id, COUNT(*) FROM orders WHERE COUNT(*) > 5 GROUP BY customer_id;B.SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id HAVING COUNT(*) > 5;C.SELECT customer_id FROM orders WHERE order_count > 5;D.SELECT customer_id, COUNT(*) FROM orders ORDER BY COUNT(*) > 5;

← Repeated data in a table Process cycle efficiency →