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;