Running Totals
Question:
The cats must be ordered by name and will enter an elevator one by one. We would like to know what the running total weight is.
Return: name, running total weight
Order by: name
Show Table
Cats:
| name | varchar |
| breed | varchar |
| weight | float |
| color | varchar |
| age | int |
Show Desired Output
Desired output:
| name | running_total_weight |
| Alfie | 5.50 |
| Ashes | 10.00 |
| Charlie | 14.80 |
| Felix | 19.80 |
| Millie | 25.20 |
| Misty | 30.90 |
| Molly | 35.10 |
| Oscar | 41.20 |
| Puss | 46.30 |
| Smokey | 52.40 |
| Smudge | 57.30 |
| Tigger | 61.10 |
Query Window:
Correct output but can you use 'over'?
×
Good work!
Over allows us to break down our aggregate functions, it is often used for running totals next question
Show Answer
Answer:
select name, sum(weight)
over (order by name) as running_total_weight
from cats order by name