[Solved] Identify the error in this query:SELECT category, region, SUM(amount) FROM sales_data GROUP BY GROUPING SETS ((category), region); | PostgreSQL

PostgreSQL - Aggregate Functions and GROUP BY

Identify the error in this query:

SELECT category, region, SUM(amount) FROM sales_data GROUP BY GROUPING SETS ((category), region);

AThe SELECT clause must include GROUPING() function.

BSUM(amount) cannot be used with GROUPING SETS.

CGROUPING SETS cannot include more than one column.

DThe second grouping set 'region' is not enclosed in parentheses.

Step-by-Step Solution

Solution:

Step 1: Review GROUPING SETS syntax
Each grouping set must be enclosed in parentheses.
Step 2: Analyze the query
The query has GROUPING SETS ((category), region) where 'region' is not in parentheses.
Step 3: Identify the error
Missing parentheses around 'region' causes syntax error.
Final Answer:
The second grouping set 'region' is not enclosed in parentheses. -> Option D
Quick Check:
Each grouping set requires parentheses [OK]

Quick Trick: Always enclose each grouping set in parentheses [OK]

Common Mistakes:

Master "Aggregate Functions and GROUP BY" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Identify the error in this query: