The Ones We Watch
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
We run an observability platform. Among the services that have at least one alert wired up in alert_events, total up the error occurrences each has logged and list them busiest first.
Summary
Only the services still under watch count. Rank them by where the errors gather.
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