Which query correctly finds customers who placed more than 3 orders?

Question

Answer

SELECT customer_id, COUNT(*) FROM orders GROUP BY customer_id HAVING COUNT(*) > 3;

Answer

SELECT customer_id FROM orders WHERE customer_id > 3 GROUP BY customer_id;

Answer

SELECT customer_id FROM orders HAVING customer_id > 3;

Answer

SELECT customer_id, COUNT(*) FROM orders ORDER BY COUNT(*) > 3;

Answer

SELECT customer_id, COUNT(*) FROM orders WHERE COUNT(*) > 3 GROUP BY customer_id;

Crowdly