Query: ibm_is_vpc_num_ips_for_vpc

with cidrs as (
  select
    a ->> 'cidr' as cidr_block,
    masklen((a ->> 'cidr') :: cidr) as "Mask Length",
    power(2, 32 - masklen((a ->> 'cidr') :: cidr)) as num_ips
  from
    ibm_is_vpc,
    jsonb_array_elements(address_prefixes) as a
  where
    crn = $1
)
select
  sum(num_ips) as "IP Addresses"
from
  cidrs;