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;