What does the following window function return for each row? SUM(sales) OVER (PARTITION BY region ORDER BY sale_date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)

Question

SQL Data Analyst — Medium

What does the following window function return for each row? SUM(sales) OVER (PARTITION BY region ORDER BY sale_date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)

Accepted Answer

The window function SUM(sales) OVER (PARTITION BY region ORDER BY sale_date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) calculates a running total of sales within each region, ordered by date. This means it adds up the sales values from the beginning of each region to the current row.