Query: ecs_snapshot_by_account

select
  a.title as "Account",
  count(s.*) as "Snapshots"
from
  alicloud_ecs_snapshot as s,
  alicloud_account as a
where
  a.account_id = s.account_id
group by
  a.title
order by
  a.title;