The Fast Lane

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 score an API endpoint's efficiency as its successful calls (status 200) divided by its average latency, so an endpoint that returns more good responses for less waiting scores higher. For every endpoint with at least 5 calls, return its call count, average latency, and efficiency, most efficient first.

Summary

Every millisecond has to earn its keep.

Practice This Problem

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