Query: api_gatewayv2_api_by_region

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