How many clubs have players with the position "Right Wing"?
select count ( * ) from club as t1 join player as t2 on t1.club_id = t2.club_id where t2.position = "Right Wing"
How many total players are there?
select count ( * ) from player
Can you list all the players?
select * from player
How many positions are there in total?
select count ( distinct position ) from player