Ghosts in the Scheduler

A easy SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

easy

Seniority

L3

Problem

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.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.