Slowest Endpoint

Mission brief

Challenge Briefing

Medium

Window Functions
PERCENTILE_CONT
Subqueries

Our production servers are hitting high latency spikes, and the SRE team needs to identify the culprit. Standard averages are hiding the problem—we need to look at the "tail latency." Your mission is to find the API endpoint with the worst 99th Percentile (P99) latency.

Slowest Endpoint

Query a request_logs table to find the API endpoint that has the highest 99th percentile latency.

The Narrative

Schema Diagram

request_logs

endpointVARCHAR

latency_msINT

Challenge a Friend

One SQL table. One SQL condition.
Still tricky for most developers.

SQL Editor

Terminal Output

Initializing Database Engine v1.8.0...

Write a SQL query, then click Run Query

Keep practicing

Try another challenge

Similar difficulty and topics — pick up where you left off or stretch your SQL skills.

View all

Title	Complexity	Status	Solve
The Skimming Intern	Medium	Not solved	Solve
Git Blame Detective	Medium	Not solved	Solve
The Shadow Follower	Hard	Not solved	Solve

coders.sh *

Slowest Endpoint

The Narrative

Schema Diagram

Challenge a Friend

SQL Editor

Terminal Output

Try another challenge