SQL - GROUP BY and HAVING
You have a sales table with columns region, salesperson, and amount. Write a query to find regions where the average sales amount per salesperson is greater than 500.
Which query is correct?
You have a sales table with columns region, salesperson, and amount. Write a query to find regions where the average sales amount per salesperson is greater than 500.Which query is correct?
hard📝 Application Q8 of 15
Step-by-Step Solution
Solution:
Step 1: Understand grouping needed
To find average per salesperson in each region, group by both region and salesperson.Step 2: Apply HAVING to filter averages > 500
HAVING AVG(amount) > 500 filters groups with average sales above 500.Final Answer:
SELECT region, AVG(amount) FROM sales GROUP BY region, salesperson HAVING AVG(amount) > 500; -> Option BQuick Check:
Group by region and salesperson, then HAVING filter = C [OK]
Quick Trick: Group by all non-aggregated columns before HAVING [OK]
Common Mistakes:
MISTAKES- Grouping only by region when salesperson is selected
- Placing HAVING before GROUP BY
Master "GROUP BY and HAVING" in SQL
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore SQL Quizzes