Endpoint Ranking
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
The SRE team wants the slowest endpoints surfaced for a performance review. For each endpoint in api_calls, count its calls and compute its average latency, skipping rows where latency is NULL. Then rank endpoints by average latency, slowest first, with ties sharing a position. Return the endpoint, call count, average latency, and position.
Summary
The slowest endpoints. Called to the principal's office.
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