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;