Error Severity Buckets
A easy SQL mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.
- Domain
- SQL
- Difficulty
- easy
- Seniority
- L3
Interview Prompt
On-call wants every recorded error tagged with a severity label based on how often it has fired: 0 occurrences is NONE, 1 to 5 is LOW, 6 to 20 is MODERATE, 21 to 50 is HIGH, and anything above 50 is CRITICAL. Treat any error whose occurrence count was never recorded as CRITICAL, since on-call escalates anything it cannot size. Skip rows that aren't attributed to a service, and show each error type alongside its label.
Summary
Errors sorted by how much they hurt.
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