Ghosts in the Scheduler
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
- L3
Interview Prompt
Our batch scheduler keeps a fleet of jobs that still claim to be running but never recorded an end time. Among jobs that started during 2025, count how many report a running status, in whatever casing, and still have no `ended` timestamp.
Summary
It says running. It has been running.
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