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 Schema
Correct output but can you use 'over'?
Over allows us to break down our aggregate functions, it is often used for running totals next question
select name, sum(weight) over (order by name) as running_total_weight from cats order by name