Query: ecs_snapshot_by_encryption_status

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