Query: emr_cluster_logging_encryption_status

with clusters as (
  select
    case
      when log_encryption_kms_key_id is null then 'Disabled'
      else 'Enabled'
    end as log_encryption_status
  from
    aws_emr_cluster
)
select
  log_encryption_status,
  count(*)
from
  clusters
group by
  log_encryption_status