The Ones Worth Paging

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

Domain

SQL

Difficulty

hard

Seniority

L3

Problem

The SRE team is building a triage chart covering the three severity levels that call for action: CRITICAL, ERROR, and WARN. Show each of these levels alongside the total number of log entries recorded for it.

Summary

Three levels wake someone up at night. Tally each one.

Practice This Problem

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