API Calls With and Without Errors
A medium SQL mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L3
Interview Prompt
The API reliability team is triaging error rates across the platform. For each endpoint, give a breakdown of how many calls completed cleanly versus how many produced an error message, along with the total call volume per endpoint.
Summary
Some calls succeed. Some do not. Break it down.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write and run your SQL against a real database
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision