CREATE TABLE team (Name VARCHAR(255), Team_id VARCHAR(255)); CREATE TABLE match_season (Season VARCHAR(255), Player VARCHAR(255), Team VARCHAR(255))
Show the season, the player, and the name of the team that players belong to.
    
SQL: SELECT T1.Season, T1.Player, T2.Name FROM match_season AS T1 JOIN team AS T2 ON T1.Team = T2.Team_id