Query: vpc_ipv6_count

with cidrs as (
  select
    power(2, 128 - masklen((b ->> 'Ipv6CidrBlock'):: cidr)) as num_ips
  from
    alicloud_vpc,
    jsonb_array_elements(ipv6_cidr_blocks) as b
  where
    vpc_id = $1
)
select
  sum(num_ips) as "IPv6 Addresses"
from
  cidrs;