Query: vpc_subnet_by_az

select
  availability_zone,
  count(*)
from
  aws_vpc_subnet
where
  vpc_id = $1
group by
  availability_zone
order by
  availability_zone