Return on Patience

A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant feedback.

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

The best answers cost the least time. Find the ones that pay off.

Practice This Problem

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