Query: cloudfront_distribution_by_status

select
  case
    when enabled then 'Enabled'
    else 'Disabled'
  end as "Status",
  count(*) as "Distributions"
from
  aws_cloudfront_distribution
group by
  "Status"
order by
  "Status";