The Running Total Jumps
sales:
| day | amount |
|---|---|
| 1 | 10 |
| 1 | 20 |
| 2 | 30 |
| 3 | 40 |
SELECT day, amount,
sum(amount) OVER (ORDER BY day) AS running
FROM sales
ORDER BY day, amount;
Reading down the running column, what are the four values?
Sign in to answer questions and track your progress
Sign In