[Solved] Identify the issue in this query intended to calculate a running total of amount ordered by transaction_date across all rows:SELECT id, amount, SUM(amount) OVER (PARTITION BY category ORDER BY... | SQL

SQL - Advanced Window Functions

Identify the issue in this query intended to calculate a running total of amount ordered by transaction_date across all rows:

SELECT id, amount, SUM(amount) OVER (PARTITION BY category ORDER BY transaction_date) AS running_total FROM sales;

AORDER BY clause inside OVER() is invalid syntax

BMissing GROUP BY clause to aggregate amounts

CUsing PARTITION BY category splits the running total by category, not across all rows

DSUM() cannot be used with OVER() for running totals

Step-by-Step Solution

Solution:

Step 1: Understand PARTITION BY effect
PARTITION BY divides rows into groups; running total restarts per group.
Step 2: Goal is running total across all rows
Including PARTITION BY category causes separate totals per category, not a global running total.
Final Answer:
Using PARTITION BY category splits the running total by category, not across all rows -> Option C
Quick Check:
PARTITION BY limits running total scope [OK]

Quick Trick: PARTITION BY resets running total per group [OK]

Common Mistakes:

Master "Advanced Window Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Identify the issue in this query intended to calculate a running total of amount ordered by transaction_date across all rows: