Query: compute_instance_by_tenancy

select
  t.title as "Tenancy",
  count(i.*) as "Instances"
from
  oci_core_instance as i,
  oci_identity_tenancy as t
where
  t.id = i.tenant_id and i.lifecycle_state <> 'TERMINATED'
group by
  t.title
order by
  t.title;