Daily Error Resolution Ratio
A medium SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L4
Interview Prompt
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.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write your sql solution with real code execution
- Get instant feedback and a hire/no-hire decision