Query: api_gatewayv2_api_by_account

select
  acc.title as "Account",
  count(api.*)
from
  aws_api_gatewayv2_api as api,
  aws_account as acc
where
  api.account_id = acc.account_id
group by
  acc.title
order by
  acc.title;