Not All Fires Are Equal
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 incident response team only trusts alert data from services that also appear in the health check system. Among those services, for any service-severity combination that fired more than once in 2026, first count the alerts per combination, then compute the average of those counts for each severity level, rounded to one decimal place.
Summary
The alert volume varies. So does what it means.
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