Which window function calculates a running total of sales ordered by date within each region?
SQL Data AnalystHard
SQL Data Analyst — Hard
Which window function calculates a running total of sales ordered by date within each region?
Explanation
ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW explicitly defines the frame from the first row of the partition to the current row, producing a running total.
