Query: mysql_db_system_with_backups

select
  case when b.id is null then 'disabled' else 'enabled' end as status,
  count(distinct s.id)
from
  oci_mysql_db_system as s
  left join oci_mysql_backup as b on s.id = b.db_system_id
where
  s.lifecycle_state <> 'DELETED'
group by
  status;