Loading...
Top Regions by Critical Alerts
A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- mid
Problem
During an incident postmortem, the on-call engineer needs to know which regions produce the most critical alerts. Use service health checks to map each service to its region, count critical-severity alerts per region, and return the top 5 regions by alert volume.
Practice This Problem
Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a live PostgreSQL database and grades it instantly.