Loudest in the Room

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

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

An operations dashboard spotlights the busiest API endpoints each day. For every day, surface the endpoints whose daily call count is among the three highest counts that day, and report the day, the endpoint, and its level (1 for the busiest count, 3 for the third highest), earliest day first.

Summary

Every day, a few endpoints carry the load. Surface them.

Practice This Problem

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