The Loudest in the Room
A medium SQL mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.
- Domain
- SQL
- Difficulty
- medium
- Seniority
- L3
Interview Prompt
A wave of credential-stuffing has been hammering the login endpoint, and the gateway team wants its two worst offenders. From the rate_limits log, find the clients with the most blocked requests on that endpoint, along with their totals.
Summary
Somewhere in the noise, two keep knocking. Find who.
How This Interview Works
- Read the vague prompt (just like a real interview)
- Ask clarifying questions to the AI interviewer
- Write and run your SQL against a real database
- Answer the interviewer's follow-up questions, then get a hire or no-hire decision