Loading...
Endpoint Latency Spread
A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- mid
Problem
Our API monitoring tracks latency per endpoint. For each endpoint, surface the gap between the highest and lowest observed latency, the ratio of highest to lowest, and both extreme values. Exclude any entries with zero latency, and rank by the ratio from highest to lowest.
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.