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
For each date, count unique TypeError errors flagged and how many alerts were resolved on the same day. For dates with reports but no resolutions, show zero. Include the date, reported count, resolved count, and ratio.
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