DELETE FROM Player p WHERE p.status = ’inactive’ AND p.teams IS EMPTY
Description: This query deletes all inactive players who are not on a team.