Query: oss_bucket_by_logging_status

with logging_status as (
  select
    case when logging ->> 'TargetBucket' = '' then 'disabled' else 'enabled'
    end as status
  from
    alicloud_oss_bucket
)
select
  status,
  count(*)
from
  logging_status
group by
  status;