List the player, position and the corresponding team for each player.
select t1.player,t1.position, t2.name from match_season as t1 join team as t2 on t1.team = t2.team_id
Which ones are from the team 'Evalyn Feil', show the positions only?
select t1.position from match_season as t1 join team as t2 on t1.team = t2.team_id where t2.name = 'Evalyn Feil'
What about the team name "Ryley Goldner"?
select t1.position from match_season as t1 join team as t2 on t1.team = t2.team_id where t2.name = "Ryley Goldner"