Successful Call Volume per Endpoint
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
- L5
Interview Prompt
The reliability team is zeroing in on the routes that carry real load on the API gateway, the endpoints in `api_calls` handling a heavy share of the traffic. For those endpoints, count the successful calls each one served, listed from most successes to fewest.
Summary
Not every ping is honest.
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