[Solved] Given the table sales with columns region and amount, what will this query return?SELECT region, SUM(amount) FROM sales GROUP BY region HAVING SUM(amount) > 1000; | SQL

SQL - GROUP BY and HAVING

Given the table sales with columns region and amount, what will this query return?

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

AAll regions with total sales greater than 1000

BAll regions with total sales less than or equal to 1000

CAll sales records with amount greater than 1000

DSyntax error due to HAVING clause

Step-by-Step Solution

Solution:

Step 1: Group sales by region and sum amounts
The query groups rows by region and calculates total amount per region.
Step 2: Filter groups with total sales > 1000
The HAVING clause keeps only regions where the sum is greater than 1000.
Final Answer:
All regions with total sales greater than 1000 -> Option A
Quick Check:
HAVING filters groups by aggregate sum [OK]

Quick Trick: HAVING filters groups by aggregate results [OK]

Common Mistakes:

MISTAKES

Master "GROUP BY and HAVING" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Given the table sales with columns region and amount, what will this query return?