[Solved] Why does this query cause an error?SELECT region, SUM(amount) FROM sales GROUP BY CUBE region; — Ans: Missing parentheses around the column in CUBE | PostgreSQL

PostgreSQL - Aggregate Functions and GROUP BY

Why does this query cause an error?

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

ASUM() cannot be used with CUBE

BMissing parentheses around the column in CUBE

CGROUP BY cannot use functions like CUBE

Dregion column does not exist

Step-by-Step Solution

Solution:

Step 1: Check CUBE syntax
CUBE requires parentheses around the list of columns: GROUP BY CUBE(region).
Step 2: Identify error in query
The query misses parentheses around region inside CUBE, causing syntax error.
Final Answer:
Missing parentheses around the column in CUBE -> Option B
Quick Check:
CUBE syntax = GROUP BY CUBE(cols) [OK]

Quick Trick: Always use parentheses with CUBE columns [OK]

Common Mistakes:

Master "Aggregate Functions and GROUP BY" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Why does this query cause an error?