Query: identity_users_by_tenancy

select
  t.name as "tenancy",
  count(u.*) as "total"
from
  oci_identity_user as u,
  oci_identity_tenancy as t
where
  t.id = u.tenant_id
group by
  tenancy
order by count(u.*) desc;