You want to find the total sales per region but only for regions where total sales exceed 1000. Which query correctly uses GROUP BY and filters groups?

hard📝 Application Q8 of 15

SQL - GROUP BY and HAVING

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

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

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

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

Step-by-Step Solution

Solution:

Step 1: Understand filtering groups
Filtering groups after aggregation requires HAVING, not WHERE.
Step 2: Check query order
HAVING comes after GROUP BY; SELECT region, SUM(sales) FROM sales_data GROUP BY region HAVING SUM(sales) > 1000; uses correct syntax and order.
Final Answer:
SELECT region, SUM(sales) FROM sales_data GROUP BY region HAVING SUM(sales) > 1000; -> Option A
Quick Check:
Use HAVING to filter groups = D [OK]

Quick Trick: Use HAVING to filter grouped results [OK]

Common Mistakes:

MISTAKES

Using WHERE to filter aggregated results
Placing HAVING before GROUP BY
Confusing WHERE and HAVING

Master "GROUP BY and HAVING" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

More SQL Quizzes

You want to find the total sales per region but only for regions where total sales exceed 1000. Which query correctly uses GROUP BY and filters groups?

Step 1: Understand filtering groups

Step 2: Check query order

Final Answer:

Quick Check:

Want More Practice?