Query: ecs_disk_by_encryption_status

select
    encryption_status,
    count(*) as "Disks"
from (
    select encrypted,
    case when encrypted then
        'enabled'
    else
        'disabled'
    end encryption_status
from
    alicloud_ecs_disk) as t
group by
    encryption_status
order by
    encryption_status desc;