Get Premium

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.

0

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

Questions
Meta SWE Interview QuestionsAmazon SWE Interview QuestionsGoogle SWE Interview QuestionsOpenAI SWE Interview QuestionsAnthropic SWE Interview QuestionsEngineering Manager (EM) Interview Questions
Learn
Learn System DesignLearn DSALearn BehavioralLearn ML System DesignLearn Low Level DesignGuided Practice
Links
FAQPricingGift PremiumHello Interview Premium
Legal
Terms and ConditionsPrivacy PolicySecurity
Contact
About UsProduct Support

7511 Greenwood Ave North Unit #4238 Seattle WA 98103

© 2026 Optick Labs Inc. All rights reserved.

Leetcode 3451. Find Invalid IP Addresses | Hello Interview