Query: database_autonomous_db_by_tenancy

select
   t.name as "Tenancy",
   count(a.id)::numeric as "Autonomous DBs"
from
  oci_database_autonomous_database as a,
  oci_identity_tenancy as t
where
  t.id = a.tenant_id
group by
  t.name
order by
  t.name;