What are the club names for each player?
select t1.name, t2.name from club as t1 join player as t2 on t1.club_id = t2.club_id
How many players are there in each club?
select t1.name, count(*) from club as t1 join player as t2 on t1.club_id = t2.club_id group by t1.name
Which clubs have players who are the position of "Right Wing".
select t1.name from club as t1 join player as t2 on t1.club_id = t2.club_id where t2.position = "Right Wing"