Query: s3_bucket_versioning_mfa_status

with versioning_mfa_status as (
  select
    case
      when versioning_mfa_delete then 'enabled' else 'disabled'
    end as visibility
  from
    aws_s3_bucket
)
select
  visibility,
  count(*)
from
  versioning_mfa_status
group by
  visibility;