The Severity Matrix

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

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

The on-call lead is prepping the weekly reliability review and needs one table showing, for each service, how its alerts split across the severity levels plus a total count. Severity is typed in by hand and the same level turns up in different capitalizations, so treat those as one; put the busiest services at the top.

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 checks it automatically.