Query: s3_bucket_public_access_blocked

with public_block_status as (
  select
    case
      when
        block_public_acls
        and block_public_policy
        and ignore_public_acls
        and restrict_public_buckets
      then 'blocked' else 'not blocked'
    end as block_status
  from
    aws_s3_bucket
)
select
  block_status,
  count(*)
from
  public_block_status
group by
  block_status;