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

L4

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.

Summary

Best throughput per call.

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.