Query: vpc_by_account

select
  a.title as "account",
  count(v.*) as "vpcs"
from
  alicloud_vpc as v,
  alicloud_account as a
where
  a.account_id = v.account_id
group by
  account
order by
  account;