You want to find the total sales per region but only for regions with sales over 1000. Which query correctly uses grouping and filtering?

hard📝 Application Q8 of 15

SQL - GROUP BY and HAVING

ASELECT region, SUM(amount) FROM sales GROUP BY region HAVING SUM(amount) > 1000;

BSELECT region, SUM(amount) FROM sales WHERE SUM(amount) > 1000 GROUP BY region;

CSELECT region, SUM(amount) FROM sales GROUP BY region WHERE SUM(amount) > 1000;

DSELECT region, SUM(amount) FROM sales HAVING SUM(amount) > 1000 GROUP BY region;

Step-by-Step Solution

Solution:

Step 1: Understand filtering after grouping
Filtering on aggregate results requires HAVING clause after GROUP BY.
Step 2: Check query syntax
SELECT region, SUM(amount) FROM sales GROUP BY region HAVING SUM(amount) > 1000; correctly uses GROUP BY then HAVING to filter sums over 1000.
Final Answer:
SELECT region, SUM(amount) FROM sales GROUP BY region HAVING SUM(amount) > 1000; -> Option A
Quick Check:
Filter aggregates with HAVING after GROUP BY [OK]

Quick Trick: Use HAVING to filter grouped aggregate results [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