coders.sh *

Loading Developers Heaven

The Data Leaker

Mission brief

Hard

Someone is scraping our endpoints! Find the IP address that made more than 2 requests in a single minute in our truncated logs.

Find IP addresses with >2 hits per minute (simulating 100).

Someone is scraping our endpoints! Find the IP address that made more than 2 requests in a single minute in our truncated logs.

access_logs

idINT

ip_addressVARCHAR

timestampDATETIME

One SQL table. One SQL condition.
Still tricky for most developers.

Initializing Database Engine v1.8.0...

Write a SQL query, then click Run Query

Keep practicing

Similar difficulty and topics — pick up where you left off or stretch your SQL skills.

Title	Complexity	Status	Solve
The Skimming Intern	Medium	Not solved	Solve
Git Blame Detective	Medium	Not solved	Solve
The Shadow Follower	Hard	Not solved	Solve