Service With Most Critical Alerts
A hard SQL mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.
- Domain
- SQL
- Difficulty
- hard
- Seniority
- L4
Interview Prompt
The incident commander is triaging whichever service in `alert_events` has fired the most critical alerts. Return every alert that service has fired, with each row also carrying that service's critical alert count.
Summary
One service keeps setting off the alarms.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write and run your SQL against a real database
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision