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.