Query: compute_snapshot_encryption_setting_collection_status

select
  status,
  count(*)
from
  (
    select
      case
        when encryption_setting_collection_enabled then 'enabled'
        else 'disabled'
      end as status
    from
      azure_compute_snapshot
  ) as cs
group by
  status
order by
  status;