Your goal: know exactly which rows a join keeps, repeats or drops, and say
it out loud the way interviewers want to hear it.
How this works (about 20 minutes)
- Maya's live board shows two small tables: gym members and their visits.
- For each join, tap your guess for the row count first. Then the rows appear.
- Four times you write a query yourself in the board's editor and tap Run. Matching rows turn green; missing rows show as ghosts.
- Three quick checks along the way: tap your answer on the board.
Tips
- Before predicting, ask yourself: what happens to rows with no match?
- Any SQL dialect is fine. Rough syntax is fine; the logic matters.
- Read the module reading first: SQL Joins.
- Interrupt any time to ask a question.