Pipeline Recovery by Priority
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
- L3
Interview Prompt
For each pipeline run that completed successfully after January 1, 2026, find every batch job that started on the same calendar day. Show the pipeline name and the batch job priority, along with the minimum, average, and maximum pipeline duration in seconds for each pipeline name and priority combination.
Summary
Recovery time, priority by priority.
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