Query: ons_notification_topic_unused_count

select
  count(*) as value,
  'No Subscriptions' as label,
  case count(*) when 0 then 'ok' else 'alert' end as type
from
  oci_ons_notification_topic t
  left join oci_ons_subscription s on t.topic_id = s.topic_id
where
  s.id is null;