SQL Review: Common Trip-ups

ICS4U · Lakefield College School

This page runs a real SQLite database in your browser. Each lesson has a short explanation, worked examples with their actual results, and the most common trip-ups to watch for. Then it's your turn: type a query in an exercise box and your result appears as you type (or press Ctrl/⌘ + Enter to run it right away). The expected result is shown next to yours, and when they match you'll see ✓ Correct. If you're stuck, ask for a hint first, and only then the solution. You can't break anything: every query runs on a fresh copy of the data. Your queries and progress are saved in this browser. The tables hold the games from class plus a few extra, so some results will look a little different from your notes. Every exercise has a Show the tables section right above the query box, so you can look at the data while you type. You can also open the tables in a new tab and keep them beside this page.