Initializing...

Chapter 6: Window Functions

6-2

Your Progress

Running Total

You can use aggregate functions like SUM() as window functions to calculate running totals.

SELECT date, amount, 
       SUM(amount) OVER (ORDER BY date) as running_total
FROM sales;

Task: Calculate the running total of sales ordered by day.

Run a query to see results