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

PostgreSQL - Aggregate Functions and GROUP BY

Identify the error in this query using CUBE:

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

AGROUP BY cannot use CUBE with more than one column.

BSUM(amount) cannot be used with CUBE.

CMissing parentheses around columns in CUBE function.

Dregion and product must be in ORDER BY, not GROUP BY.

Step-by-Step Solution

Solution:

Step 1: Check CUBE syntax
CUBE requires parentheses around the columns: CUBE(region, product).
Step 2: Validate other parts
SUM(amount) is valid, multiple columns allowed, ORDER BY is unrelated.
Final Answer:
Missing parentheses around columns in CUBE function. -> Option C
Quick Check:
CUBE syntax needs parentheses [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

Identify the error in this query using CUBE: