The Address That Changed
A medium SQL mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L5
Interview Prompt
The relocation team is reviewing our customers table, which keeps one row per address a customer has lived at, tagged with that address's country. Return every address row with the customer's customer_id, first_name, that address's country, and the customer's total number of moves.
Summary
Addresses change. History must not be erased.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write and run your SQL against a real database
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision