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;