Your goal: solve three easy SQL problems the way a strong candidate does:
clarify, write a clean query, walk through it, and handle the edge cases.
How this works (about 25 minutes)
- Each problem appears on the notepad: tables, sample rows and the ask.
- Ask clarifying questions out loud, then type your query below the problem and say "done".
- Daniel reads it, asks you to walk through it, then asks follow-up questions.
- No hints and no feedback during the interview. A written report follows.
Tips
- Any mainstream SQL dialect is fine. Say which one you are using.
- Think out loud. State your assumptions.
- Check your query against the sample rows before you say done.
- Read the module reading first: SQL Practice: Easy Problems.
- Taken this mock before? Tell Daniel at the start and he will use different problems.