The Long Tail

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

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

The performance team is hunting the latency tail on the API gateway, where the request logs record the HTTP `method` inconsistently, sometimes in lowercase. For each method, average the `latency` of its five slowest calls, and list the methods from the highest average down.

Summary

Averages hide the pain. The tail is where SLOs live.

Practice This Problem

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