Query: ecs_security_group_by_acount

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