Query: ibm_is_vpc_subnet_by_zone

select
  zone ->> 'name' as Zone,
  count(*)
from
  ibm_is_subnet
where
  vpc ->> 'crn' = $1
group by
  zone ->> 'name'
order by
  zone ->> 'name';