easy5 pts · first answer countssqlaggregation

Filtering grouped results

You need customers who placed more than 5 orders. Which query is correct?

-- orders(id, customer_id, total)

A.SELECT customer_id, COUNT(*) FROM orders WHERE COUNT(*) > 5 GROUP BY customer_idB.SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id ORDER BY COUNT(*) DESC LIMIT 5C.SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id HAVING COUNT(*) > 5D.SELECT customer_id, COUNT(*) FROM orders WHERE customer_id > 5 GROUP BY customer_id

← COUNT and AVG with NULLs Naming a test that uses a real DB →