Query: vpc_by_region

select
  region as "Region",
  count(*) as "VPCs"
from
  aws_vpc
group by
  region
order by
  region;