Query: mysql_backup_by_tenancy

select
  c.title as "Tenancy",
  count(b.*) as "MySQL Backups"
from
  oci_mysql_backup as b,
  oci_identity_tenancy as c
where
  c.id = b.tenant_id and lifecycle_state <> 'DELETED'
group by
  c.title
order by
  c.title;