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";