What are the club names?
select name from club
How many of them have at least one player?
select count(name) from club where club_id in (select club_id from player)
Which ones have no players at all?
select name from club where club_id not in (select club_id from player)