Skip to content
Skills
Problems
Questions
Drills
Roles
Skills
Interview
Contest
Leaderboard
Problems
Questions
Drills
Roles
Skills
Interview
Contest
Leaderboard
Home
/
SQL
/
Running Totals
SQL Running Totals problems
4 problems, easiest first.
Cumulative Hires by Year
running-totals · dates · group-by
medium
Ledger Running Balance
running-totals · window-functions
medium
Customers Driving 80% of Revenue
running-totals · window-functions · ctes
hard
Daily Revenue with Missing Days Filled
recursive-cte · dates · running-totals
hard
Dates
16
Window Functions
13
Null Handling
11
Aggregation
11
Group By
8
Joins
7
Case When
6
Sorting
6
Strings
5
Subqueries
5
Select Filter
4
Running Totals
4
Ctes
3
Recursive Cte
3
Set Operations
2
Ranking
2
Deduplication
2
Self Join
2
Gaps And Islands
2