Query: blockstorage_block_volume_storage_by_tenancy

select
   t.title as "Tenancy",
   sum(v.size_in_gbs) as "GB"
 from
   oci_core_volume as v,
   oci_identity_tenancy as t
 where
   t.id = v.tenant_id and v.lifecycle_state <> 'TERMINATED'
 group by
   t.title
 order by
   t.title;