Alert Hotspots by Service and Severity

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

Domain

SQL

Difficulty

easy

Seniority

L3

Problem

The on-call team wants to identify which service and severity combinations generate the most noise. For each pairing, show the alert count, sorted from most alerts to fewest.

Summary

Some services and severities light up more than others.

Practice This Problem

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