[Solved] Given a table sales with columns region, month, and amount, what will this query return?SELECT region, month, amount, SUM(amount) OVER (PARTITION BY region ORDER BY month) AS running_total FROM sales; | SQL

SQL - Advanced Window Functions

Given a table sales with columns region, month, and amount, what will this query return?

SELECT region, month, amount, SUM(amount) OVER (PARTITION BY region ORDER BY month) AS running_total FROM sales;

AAverage sales amount per month across all regions.

BTotal sales amount for all regions combined.

CA running total of sales amount per region ordered by month.

DSales amount only for the first month in each region.

Step-by-Step Solution

Solution:

Step 1: Analyze the window function usage
SUM(amount) OVER (PARTITION BY region ORDER BY month) calculates a running total per region ordered by month.
Step 2: Understand output columns
The query returns each row with region, month, amount, and the cumulative sum of amount within that region up to that month.
Final Answer:
A running total of sales amount per region ordered by month. -> Option C
Quick Check:
Window SUM with PARTITION and ORDER BY = running total per group [OK]

Quick Trick: PARTITION BY groups, ORDER BY defines running total order [OK]

Common Mistakes:

Master "Advanced Window Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Given a table sales with columns region, month, and amount, what will this query return?