Loading project…
SQLIntermediateabout 5 hours14 lessons
Recommended first: Pit Wall
Pit Wall covered one race. Now you are the analyst for Halcyon Racing and the whole 2026 championship is in the database: ten Grands Prix, thirteen drivers, five thousand laps. Each lesson answers a harder question (subqueries, CTEs, window functions, pivots, set operations, views) until the season dashboard shows the standings with position-change arrows, points progression, teammate head-to-heads, a race-pace heatmap and the championship decided by tiebreaks, all in SQL.
Each lesson adds one working part to your build.
Chapter 1
Subqueries, CTEs and conditional aggregation: answer a question that needs another answer first.
Chapter 2
NULLs, dates, text and gaps in the calendar, then the tools that keep it tidy: set operations, recursion and views.
Qualifying and the NULL problem
20 min110 XPAdds Qualifying ladder
Calendar and steward reports
22 min110 XPAdds Season calendar, Steward reports
Honours board with set operations
16 min100 XPAdds Honours board
Recursive CTEs: no gaps
22 min120 XPAdds Points by round
Views and teammate head-to-head
22 min120 XPAdds Teammate head-to-head
Chapter 3
Window functions: rank, accumulate and compare rows without collapsing them.
Chapter 4
Catch the silent join bug, read the query plan, and finish with standings decided entirely in SQL.