Where the Rows Go
A easy SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- easy
- Seniority
- mid
Interview Prompt
Our ingestion pipelines read raw records and write cleaned ones, and each job stamps its own run status, so a run that finished shows up as 'success' in whatever mix of upper and lower case that job happens to use. Across the runs that finished successfully, find the pipelines losing the most records between what they read and what they wrote, biggest losses first.
Summary
Every batch reads more than it writes. Find the pipelines quietly losing the most on the way through.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your sql solution with real code execution
- Get instant feedback and a hire/no-hire decision