Query: oss_bucket_by_public_access_blocked_status

with public_block_status as (
  select
    case
      when acl = 'private' then 'private'
      else 'public'
    end as block_status
  from
    alicloud_oss_bucket
)
select
  block_status,
  count(*)
from
  public_block_status
group by
  block_status;