Show me the names of the 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 entries in the player table;