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;