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.

Company

Level

Region

Comments

Your account is free and you can post anonymously if you choose.

Hello Interview Premium

Recent interview questions

System Design Guided Practice

Exclusive content

Learn More

Leetcode 3451. Find Invalid IP Addresses

Question Timeline

Comments

Questions

Learn

Links

Legal

Contact