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