Leetcode 3451. Find Invalid IP Addresses
Write an SQL query that parses and validates IPv4 strings in the logs (invalid if any octet >255, any octet has leading zeros, or there are not exactly 4 octets), counts occurrences per IP, and returns IPs with their invalid_count ordered by invalid_count and ip in descending order.
Question Timeline
See when this question was last asked and where, including any notes left by other candidates.
All Regions
Hello Interview Premium
Your account is free and you can post anonymously if you choose.