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;