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

L4

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.

Summary

Latency spread across endpoints.

Practice This Problem

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