DB Quacks SQL Tutorial · Chapter 5
The Running Man: A SUM OVER Story
Marathon runner duck jogs up panting with a fitness tracker. Training for the Data Marathon! I need to track my daily progress - show each day with my total distance so far, like a growing bank balance. Focus on my personal journey!
Your task
Show daily distances for the duck with id 1 with a cumulative running total of distance over time using the 'data/daily_distances.csv' file. You will be calculating running totals using window functions.