For teachers

Ready-to-teach lessons

Three 50-minute lessons with a plan, the arcade, a printable worksheet and common mistakes: SELECT and WHERE, GROUP BY and HAVING, JOIN and LEFT JOIN.

SELECT and WHERE lessonA first SQL class in 50 minutes: from the arcade to writing filters with AND, OR and exact text. With a printable worksheet.GROUP BY and HAVING lessonCounting, summing and filtering groups in 50 minutes, with the difference between WHERE and HAVING made clear. With a printable worksheet.JOIN and LEFT JOIN lessonJoining two tables and finding what's missing in 50 minutes, closing with a real detective case. With a printable worksheet.

Want the answer key?

The worksheet answers and the solutions to all 28 cases aren't published, so students won't find them. Write to us from your institutional email and we'll send them, at no cost.

Request the answer key

The arcade, the lessons and the first two cases are free and need no account. For your group to have all 28 cases, the classroom license is free too: how to request it →