Query: blockstorage_block_volume_by_tenancy

select
  t.name as "Tenancy",
  count(v.id)::numeric as "Block volumes"
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.name
order by
  t.name;