Loading...
Top Error-Service Pair
A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- mid, senior
Problem
During an incident postmortem, you need to find the error-service combination responsible for the most resolved incidents. Build an identifier by combining the error type and service name from the error tracker, then count how many unique errors that combination produced where the corresponding alert was eventually resolved. Return only the top-ranked combinations, including ties, sequenced alphabetically.
Practice This Problem
Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a live PostgreSQL database and grades it instantly.