Which of the following is the correct syntax to calculate a running total of sales per department using OVER with PARTITION BY?

easy📝 Syntax Q12 of 15

SQL - Window Functions Fundamentals

Which of the following is the correct syntax to calculate a running total of sales per department using OVER with PARTITION BY?

ASELECT department, sales, SUM(sales) OVER ORDER BY date PARTITION BY department AS running_total FROM sales_data;

BSELECT department, sales, SUM(sales) OVER (PARTITION BY department ORDER BY date) AS running_total FROM sales_data;

CSELECT department, sales, SUM(sales) PARTITION BY department OVER ORDER BY date AS running_total FROM sales_data;

DSELECT department, sales, SUM(sales) OVER (ORDER BY date PARTITION BY department) AS running_total FROM sales_data;

Step-by-Step Solution

Solution:

Step 1: Identify correct OVER clause order
The correct syntax places PARTITION BY before ORDER BY inside the parentheses after OVER.
Step 2: Check each option's syntax
SELECT department, sales, SUM(sales) OVER (PARTITION BY department ORDER BY date) AS running_total FROM sales_data; correctly uses SUM(sales) OVER (PARTITION BY department ORDER BY date). Others misplace PARTITION BY or OVER keywords.
Final Answer:
SELECT department, sales, SUM(sales) OVER (PARTITION BY department ORDER BY date) AS running_total FROM sales_data; -> Option B
Quick Check:
PARTITION BY before ORDER BY inside OVER [OK]

Quick Trick: Remember: OVER (PARTITION BY ... ORDER BY ...) is the correct order [OK]

Common Mistakes:

Master "Window Functions Fundamentals" in SQL

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More SQL Quizzes