Can you show me the club names and ids?
select name, club_id from club
Hmm, I want to know the player ids, names and their club ids.
select player_id, name, club_id from player
Please list the names of those clubs that do not have any players.
select name from club where club_id not in ( select club_id from player )