Query: ons_notification_topic_by_tenancy

select
  c.title as "Tenancy",
  count(t.*) as "Topics"
from
  oci_ons_notification_topic as t,
  oci_identity_tenancy as c
where
  c.id = t.tenant_id
group by
  c.title
order by
  c.title;