CREATE TABLE club (name VARCHAR2, Club_ID VARCHAR2)
CREATE TABLE player (Club_ID VARCHAR2, Position VARCHAR2)

Show the names of clubs that have players with position '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"
SELECT "T1"."name" FROM "club" "T1" JOIN "player" "T2" ON "Right Wing" = "T2"."Position" AND "T1"."Club_ID" = "T2"."Club_ID"