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;