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

hard📝 Application Q8 of 15

SQL - Aggregate Functions

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 WHERE Amount > 1000 GROUP BY Region;

DSELECT Region, SUM(Amount) FROM Sales GROUP BY Region WHERE SUM(Amount) > 1000;

Step-by-Step Solution

Solution:

Step 1: Understand filtering aggregated results
Filtering on aggregated values requires HAVING, not WHERE.
Step 2: Identify correct query structure
SELECT Region, SUM(Amount) FROM Sales GROUP BY Region HAVING SUM(Amount) > 1000; uses HAVING SUM(Amount) > 1000 after GROUP BY, which is correct.
Final Answer:
SELECT Region, SUM(Amount) FROM Sales GROUP BY Region HAVING SUM(Amount) > 1000; -> Option A
Quick Check:
Use HAVING to filter aggregated data [OK]

Quick Trick: Use HAVING to filter after aggregation, not WHERE [OK]

Common Mistakes:

MISTAKES

Master "Aggregate Functions" 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