Show me the names of all clubs?
select name from club
Show me the name of the club that has the id number 3 ?
select name from club where club_id = '3'
Show me the region of the club BK Slide?
select region from club where name = 'BK Slide'
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 )