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

L4

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.

Summary

Which regions have the highest volume of critical alerts

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.