The Severity Matrix
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 on-call lead is prepping the weekly review and wants one table showing how each service's alerts break down by severity. For every service, show the service name with a count of its alerts at each severity level (critical, warning, info, and unlabeled), plus a total alert count. Sort by total alerts from highest to lowest, breaking ties alphabetically by service name.
Summary
When services cry wolf, the numbers reveal who's serious.
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