Your goal: write correct basic SQL quickly and spot the small traps that
silently change an answer in an interview.
How it works (about 20 minutes)
- Maya's live board shows the tables and an example query for each step.
- You type your own query in the board's editor, then tap Run.
- Maya checks it; the board marks your rows right, missing or extra.
- A few quick checks cover the classic traps: tap your answer.
What you will practice
- SELECT, aliases and WHERE
- AND, OR, NOT and parentheses
- LIKE with % and _
- NULL: IS NULL and "not equal" filters
- ORDER BY with LIMIT and OFFSET
- IN and BETWEEN
- One interview-style query that combines them
Tips
- SQL is Postgres-style. MySQL or SQL Server habits are fine; Maya will
mention the difference.
- Style does not matter. Returning the right rows does.
- Say "hint", "repeat", "skip" or "next" any time.
- Read the SQL Basics notes first if you have not.