Batch Job Performance Tiers
A medium SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L4
Interview Prompt
The data platform team is grading batch job throughput for their quarterly review. Each job's total rows processed determines its tier: 30,000 or more is 'Outstanding', 20,000 to 29,999 is 'Satisfactory', 10,000 to 19,999 is 'Unsatisfactory', and anything below 10,000 is 'Poor'. Show each job's name, total rows, and tier, with the highest-throughput jobs first.
Summary
Every batch job gets a grade.
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