Query: objectstorage_bucket_encryption_status

select
  encryption_status,
  count(*)
from
  (
    select
      id,
      case
        when kms_key_id is null then 'oracle-managed'
        else 'customer-managed'
      end as encryption_status
    from
      oci_objectstorage_bucket
  ) as b
group by
  encryption_status
order by
  encryption_status desc;