Query: virtual_network_num_ips

with cidrs as (
  select
    masklen(
      (
        trim(
          '"'
          FROM
            a :: text
        )
      ) :: cidr
    ) as "Mask Length",
    power(
      2,
      32 - masklen(
        (
          trim(
            '"'
            FROM
              a :: text
          )
        ) :: cidr
      )
    ) as num_ips
  from
    azure_virtual_network,
    jsonb_array_elements(address_prefixes) as a
  where
    lower(id) = $1
)
select
  sum(num_ips) as "IP Addresses"
from
  cidrs;