Query: compute_instance_by_region

select
  region,
  count(i.*) as "Regions"
from
  oci_core_instance as i
where
  lifecycle_state <> 'TERMINATED'
group by
  region;