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 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, and anything above 50 is CRITICAL. Treat any error whose occurrence count was never recorded as CRITICAL, since on-call escalates anything it cannot size. Skip rows that aren't attributed to a service, and show each error type alongside its label.

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.