Average Latency by Status
An easy 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
- easy
- Seniority
- L3
Interview Prompt
During a latency spike investigation, the on-call engineer needs to know whether slow responses correlate with specific HTTP status codes. Show the average latency for each status code across all API calls.
Summary
Each status code has its own latency story.
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