The Severity Matrix

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 on-call lead is prepping the weekly review and wants one table showing how each service's alerts break down by severity. For every service, show the service name with a count of its alerts at each severity level (critical, warning, info, and unlabeled), plus a total alert count. Sort by total alerts from highest to lowest, breaking ties alphabetically by service name.

Summary

When services cry wolf, the numbers reveal who's serious.

Practice This Problem

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