[Solved] Identify the error in this query:SELECT region, product, SUM(amount) FROM sales GROUP BY ROLLUP region, product; | PostgreSQL

PostgreSQL - Aggregate Functions and GROUP BY

Identify the error in this query:

SELECT region, product, SUM(amount) FROM sales GROUP BY ROLLUP region, product;

AROLLUP cannot be used with text columns

BSUM() cannot be used with ROLLUP

CGROUP BY cannot include multiple columns

DMissing parentheses around columns in ROLLUP

Step-by-Step Solution

Solution:

Step 1: Check ROLLUP syntax
ROLLUP requires parentheses around the list of columns: ROLLUP(column1, column2).
Step 2: Identify error in query
The query misses parentheses around region and product inside ROLLUP, causing syntax error.
Final Answer:
Missing parentheses around columns in ROLLUP -> Option D
Quick Check:
ROLLUP syntax needs parentheses [OK]

Quick Trick: Always use parentheses with ROLLUP columns [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: