Query: objectstorage_bucket_by_tenancy

select
  t.title as "Tenancy",
  count(b.*) as "Buckets"
from
  oci_objectstorage_bucket as b,
  oci_identity_tenancy as t
where
  t.id = b.tenant_id
group by
  t.title
order by
  t.title;