Query: acm_certificate_by_transparency_logging_preference

select
  certificate_transparency_logging_preference_status,
  count(*)
from
  (
    select
      certificate_transparency_logging_preference,
      case
        when certificate_transparency_logging_preference = 'ENABLED' then 'enabled'
        else 'disabled'
      end certificate_transparency_logging_preference_status
    from
      aws_acm_certificate
  ) as t
group by
  certificate_transparency_logging_preference_status
order by
  certificate_transparency_logging_preference_status desc;