Error Severity Buckets

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

Domain

SQL

Difficulty

easy

Seniority

L3

Problem

On-call wants every recorded error tagged with a human severity label based on how often it has fired: 0 occurrences is NONE, 1 to 5 is LOW, 6 to 20 is MODERATE, 21 to 50 is HIGH, anything above 50 is CRITICAL. Skip rows that aren't attributed to a service. Show each error type alongside its severity.

Summary

Errors sorted by how much they hurt.

Practice This Problem

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