In progress · 2026 – now

SQL Notebook

Short, practical SQL lessons, from joins to window functions, written as I learn them.

SQL

1select player, wins,
2  rank() over (
3    order by wins desc
4  ) as place
5from leaderboard
6where season = 3
7limit 10;

A running set of SQL notes: each one solves a real problem, explains why the query works, and points out the mistake I made the first time.