Query: ecs_disk_by_status

select
  usage_status,
  count(*) as "Disks"
from
  (
    select
      status,
      case
        when status = 'In_use' then 'in-use'
        else 'unused'
      end usage_status
    from
      alicloud_ecs_disk
  ) as t
group by
  usage_status
order by
  usage_status desc;