Error Category Breakdown

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

Domain

SQL

Difficulty

hard

Seniority

L4

Problem

During an incident postmortem, the on-call engineer needs to categorize error tracks into three buckets by their error type: those related to timeouts, those related to connections, and those related to memory. For each category, show its label and how many error-track rows fall into it (a count of matching rows, not a sum of the count column).

Summary

Postmortem time. Categorize the errors.

Practice This Problem

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