What are the names of all clubs that do not have any players?
SELECT name FROM CLub WHERE Club_ID NOT IN (SELECT Club_ID FROM player)
clubs that do not have any players refers to clubs with no corresponding records in the player table; names of all such clubs = SELECT name FROM Club WHERE Club_ID NOT IN (SELECT Club_ID FROM player);