You want to list customers who have placed more than 3 orders, each with amount over 50. Which query correctly applies WHERE and HAVING?

hard📝 Application Q8 of 15

SQL - GROUP BY and HAVING

ASELECT customer_id FROM orders GROUP BY customer_id HAVING amount > 50 AND COUNT(*) > 3;

BSELECT customer_id FROM orders WHERE amount > 50 GROUP BY customer_id HAVING COUNT(*) > 3;

CSELECT customer_id FROM orders HAVING amount > 50 AND COUNT(*) > 3 GROUP BY customer_id;

DSELECT customer_id FROM orders WHERE COUNT(*) > 3 AND amount > 50 GROUP BY customer_id;

Step-by-Step Solution

Solution:

Step 1: Filter individual orders
Use WHERE to filter orders with amount > 50 before grouping.
Step 2: Filter groups by order count
Use HAVING to filter customers with more than 3 such orders.
Final Answer:
SELECT customer_id FROM orders WHERE amount > 50 GROUP BY customer_id HAVING COUNT(*) > 3; -> Option B
Quick Check:
WHERE filters rows; HAVING filters groups [OK]

Quick Trick: WHERE filters rows; HAVING filters groups after aggregation [OK]

Common Mistakes:

MISTAKES

Master "GROUP BY and HAVING" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes