skip to today's puzzle

Learn SQL, one sip at a time

Short lessons in plain English. Each one explains a single idea, shows a tiny example, and the rows it gives back. Read one, then try it in today's puzzle.

Everything here is free and works in any major database — PostgreSQL, MySQL, SQLite, SQL Server and BigQuery. Whether you're learning SQL online for the first time, brushing up for an interview, or just want a cozier way to practice, pick a topic below and start sipping.

The basics

Filtering rows

Sorting

Aggregates and grouping

SQL WHERE vs HAVING visual guide
The Cookie Tin Guide: filter rows first, then filter whole groups.

Joining tables

SQL JOIN diagram & cheat sheet
FULL OUTER, LEFT, RIGHT and INNER JOIN side by side, with result tables.

Combining results

Window functions

Going deeper

Common questions

Can I learn SQL online for free here?
Yes. Every lesson and every daily SQL puzzle is free, with no signup required. Each lesson covers one idea — SELECT, WHERE, JOIN, GROUP BY — with a tiny example and the exact rows it returns.
How long does each SQL lesson take?
Each lesson is a single screen: one idea, one small query, one result table. There are no timers and no pressure — read one whenever you have a coffee-break moment.
I'm a complete beginner. Where should I start?
Start with SELECT and WHERE in the first section, then work down the page in order. The sections build on each other: filtering rows, then sorting and limiting, then grouping, then joining tables.
Do these lessons work with my database?
The lessons teach standard SQL that works in PostgreSQL, MySQL, SQLite, SQL Server and BigQuery. Where a dialect differs, the lesson says so in an 'in the wild' note.