What are the names of the clubs that have players in 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"
names of the clubs = SELECT T1.name; have players in the position of 'Right Wing' refers to WHERE T2.Position = 'Right Wing'; joining data from two tables (club and player) refers to JOIN.