SQL Query to find IP addresses that exist in multiple sites?

We are in the process of cleaning up our sites, groups, and schedules and have noticed that some IPs (single or in ranges) have been duplicated over the years. One example may be that there is a region or country specific site, and then later there were sites created by state or physical site location. We want to identify where these overlaps are. I am usually pretty good with SQL, but the logic behind “is this single IP inside of a range of IPs” is beyond my skills.

This Rapid7 Github might help

insightvm-sql-queries/sql-query-export at master · rapid7/insightvm-sql-queries · GitHub

insightvm-sql-queries/sql-query-export/Assets_in_Multiple_Sites.sql at master · rapid7/insightvm-sql-queries · GitHub