Task: Text to Code
Input (English): Step 1: For each row in team table, find corresponding rows in match_season table and in player table.
Step 2: find Season, Name, player's Team of the results of step 1
Output (English): SELECT T2.Season , T1.Name , T3.Team FROM team AS T1 JOIN match_season AS T2 ON T1.Team_id = T2.Team JOIN player AS T3 ON T1.Team_id = T3.Team