Regions by Alert Volume
A medium 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
- medium
- Seniority
- L3
Interview Prompt
We're building an incident heatmap by region from the alert log, and on-call wants the noisiest regions on top. Each alert only names its service, and the region comes from that service's health checks. Count the alerts per region.
Summary
Some regions are quiet. Others never stop screaming.
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