Loading...
Most Efficient API Endpoint
A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- mid
Problem
We define endpoint efficiency as the ratio of successful calls (status 200) to average latency. Considering only endpoints with at least 5 total calls, which endpoint has the highest efficiency? Show the endpoint, call count, average latency, and the efficiency ratio.
Practice This Problem
Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a live PostgreSQL database and grades it instantly.