[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; | PostgreSQL

PostgreSQL - Aggregate Functions and GROUP BY

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;

ARegions with total sales less than or equal to 1000

BSyntax error due to HAVING clause

CRegions with total sales greater than 1000

DAll regions regardless of sales

Step-by-Step Solution

Solution:

Step 1: Understand GROUP BY and SUM
The query groups rows by region and sums the amount for each group.
Step 2: Apply HAVING filter
HAVING filters groups where the sum is greater than 1000.
Final Answer:
Regions with total sales greater than 1000 -> Option C
Quick Check:
HAVING filters groups with SUM(amount) > 1000 = D [OK]

Quick Trick: HAVING filters groups after aggregation, not individual rows [OK]

Common Mistakes:

Master "Aggregate Functions and GROUP BY" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

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