Error Category Breakdown
A hard SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- hard
- Seniority
- L4
Interview Prompt
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.
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