The 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

L3

Problem

The API gateway team is cracking down on abusive traffic patterns. Find the two clients generating the most blocked requests, where a request counts as blocked when the blocked value is greater than 0. Show each client and their blocked count, sorted from most blocked to least.

Summary

Somewhere in the noise, two keep knocking. Find who.

Practice This Problem

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