Query: identity_groups_by_tenancy

select
  t.name as "Tenancy",
  count(g.*) as "Total"
from
  oci_identity_group as g,
  oci_identity_tenancy as t
where
  t.id = g.tenant_id
group by
  t.name
order by count(g.*) desc;