Query: ecs_snapshot_by_usage

select
  snapshot_usage,
  count(*) as "Snapshots"
from (
  select usage,
    case when usage = 'none' then
      'unused'
    else
      'in-use'
    end snapshot_usage
  from
    alicloud_ecs_snapshot) as t
group by
  snapshot_usage
order by
  snapshot_usage;