Alert Response Breakdown

A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

The incident response team is running a quarterly postmortem on alert handling. For every service, they need total alerts fired, how many were critical severity, how many were high severity, how many were never acknowledged, and the average number of alerts per status category. Normalize severity to lowercase before bucketing. Present services with the most total alerts first.

Summary

An on-call postmortem asks which services are bleeding alerts nobody acknowledges.

Practice This Problem

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