Query: cloudfront_distribution_sni_status

select
  sni_status,
  count(*)
from (
  select
    case when viewer_certificate ->> 'SSLSupportMethod' <> 'sni-only' then 'disabled' else 'enabled' end as sni_status
  from
    aws_cloudfront_distribution
) as d
group by
  sni_status
order by
  sni_status;