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;