Rapid Retry Detection

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

Domain

SQL

Difficulty

medium

Seniority

L5

Problem

During an incident postmortem, the on-call engineer needs to detect retry storms. Using the api_calls table, find all calls where the same user hit the same endpoint within 5 minutes after a call that returned an error status (status >= 400). Return the user_id, endpoint, the failed call time, and the retry call time.

Summary

Detect retried API calls within 5 minutes of failure.

Practice This Problem

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