Double Take
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
- L3
Interview Prompt
A downstream team flagged that our data quality checks table has the same table-and-column combination landing on multiple rows. Surface every pair that repeats along with how many times it shows up, worst offenders first, and include each pair's standing among the offenders and its share of all the duplicated records.
Summary
Passed QA twice. That's the problem.
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