Noisy Endpoints

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

Domain

SQL

Difficulty

medium

Seniority

L3

Problem

The SRE team is triaging an incident and needs a quick view of which API endpoints are generating the most error traffic. A response code at or above 400 counts as a failure. For each endpoint that has accumulated more than two such failures, show the endpoint, the total number of failures, and the typical response time across those failed calls. List from the most failure-prone endpoint to the least.

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 grades it automatically.