Query: vcn_ipv4_count

with cidrs as (
  select
    power(2, 32 - masklen(b :: cidr)) as num_ips
  from
    oci_core_vcn,
    jsonb_array_elements_text(cidr_blocks) as b
  where
    id = $1
)
select
  sum(num_ips) as "IPv4 Addresses"
from
  cidrs;