Noisy Endpoints

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

Domain

SQL

Difficulty

medium

Seniority

L3

Problem

The SRE team is triaging an incident and needs to see which API endpoints are throwing the most errors, where any response code at or above 400 counts as a failure. For each endpoint with more than 13 failures, return the endpoint, its failure count, and the typical response time across those failed calls, most failure-prone first.

Summary

The routes generating the most noise.

Practice This Problem

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