SELECT
COUNT(distinct ResourceID) as [Count],
IP_Subnets0 as Subnet
FROM
dbo.v_RA_System_IPSubnets
WHERE
IP_Subnets0 NOT IN (SELECT IPSubnet FROM
dbo.v_SiteRoamingBoundary_IPSubnet)
GROUP BY
IP_Subnets0
ORDER BY
IP_Subnets0
SELECT
COUNT(distinct ResourceID) as [Count],
IP_Subnets0 as Subnet
FROM
dbo.v_RA_System_IPSubnets
WHERE
IP_Subnets0 NOT IN (SELECT IPSubnet FROM
dbo.v_SiteRoamingBoundary_IPSubnet)
GROUP BY
IP_Subnets0
ORDER BY
IP_Subnets0