Daily Error Resolution Ratio

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

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

The reliability team tracks how fast alert noise clears each day. For every calendar day, find how many unique errors were logged with the type written exactly as 'TypeError' (case-variant spellings such as TYPEERROR or typeerror belong to other types and must be left out) next to how many alerts were marked resolved on that same day, keeping every day that had a 'TypeError' report even when no alert resolved. Return the date, the reported count, the resolved count, and the resolved-to-reported ratio rounded to two decimals, earliest day first.

Summary

Reported versus removed. The daily ratio.

Practice This Problem

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