Latency Quartiles Per Endpoint
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
For the API performance review, divide each endpoint's calls into four equal-sized buckets by latency, then for each endpoint-bucket pair show the minimum latency, maximum latency, and average latency. Results should appear ordered by endpoint name, then by bucket number.
Summary
Quartile breakdowns. Endpoint by endpoint.
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