For each player, show the name and the team.
select player, years_played from player
What about adding the corresponding team name for each record?
select t1.player, t1.years_played,t2.name from player as t1 join team as t2 on t1.team = t2.team_id where t2.name = "Columbus Crew"
What are the players and years played for those who are from team "Brown Erdman"?
select t1.player, t1.years_played from player as t1 join team as t2 on t1.team = t2.team_id where t2.name = "Brown Erdman"
What about that of "Columbus Crew"?
select t1.player, t1.years_played from player as t1 join team as t2 on t1.team = t2.team_id where t2.name = "Columbus Crew"