Query: ecs_instance_by_account

select
  a.title as "account",
  count(i.*) as "total"
from
  alicloud_ecs_instance as i,
  alicloud_account as a
where
  a.account_id = i.account_id
group by
  account
order by count(i.*) desc;