Loading...
Retried Failed API Calls
A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- senior
Problem
The platform reliability team suspects users are hammering the payment endpoint after failures. In the api_calls table, find cases where the same user hit the same endpoint again within 5 minutes of a failed call. A call is failed when its status is not 200. Return each user, the endpoint, and how many retried calls they made.
Practice This Problem
Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a live PostgreSQL database and grades it instantly.