Query: ecs_snapshot_storage_by_account

select
  a.title as "Account",
  sum(CAST (s.source_disk_size AS INTEGER)) as "GB"
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;