[Solved] Identify the error in this SQL query that tries to calculate a cumulative sum of sales per region:SELECT region, sales, SUM(sales) OVER (PARTITION region ORDER BY date) AS cumulative_sales FROM... | SQL

SQL - Advanced Window Functions

Identify the error in this SQL query that tries to calculate a cumulative sum of sales per region:

SELECT region, sales, SUM(sales) OVER (PARTITION region ORDER BY date) AS cumulative_sales FROM sales_data;

AMissing parentheses around PARTITION BY clause.

BIncorrect keyword; should be PARTITION BY instead of PARTITION.

CORDER BY cannot be used inside window functions.

DSUM() cannot be used as a window function.

Step-by-Step Solution

Solution:

Step 1: Check window function syntax
The correct syntax requires PARTITION BY, not just PARTITION.
Step 2: Validate other parts
ORDER BY inside OVER() is valid for running totals; SUM() is valid as window function.
Final Answer:
Incorrect keyword; should be PARTITION BY instead of PARTITION. -> Option B
Quick Check:
Use PARTITION BY, not PARTITION alone [OK]

Quick Trick: Use PARTITION BY, not just PARTITION [OK]

Common Mistakes:

Master "Advanced Window Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Identify the error in this SQL query that tries to calculate a cumulative sum of sales per region: