Task: Text to Code
Input (English): Step 1: For each row in races table, find the corresponding rows in constructorStandings table.
Step 2: find constructorStandingsId, name of the results of step 1 with largest value of constructorId
Output (English): SELECT T2.constructorStandingsId , T1.name FROM races AS T1 JOIN constructorStandings AS T2 ON T1.raceId = T2.raceId ORDER BY T2.constructorId Desc LIMIT 1