The Noise Floor

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

Domain

SQL

Difficulty

medium

Seniority

mid

Problem

For each service, we want to know what percentage of its alerts are high or critical severity. Surface only the services where more than half of the alerts qualify, report that percentage rounded to one decimal, worst first with ties broken by service name.

Summary

Not every alert deserves a 3 a.m. page. Find the services where most of them claim they do.

Practice This Problem

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