Task: Text to Code
Input (English): Step 1: For each row in races table, find the corresponding rows in lapTimes table.
Step 2: find url, races's time of the results of step 1 whose milliseconds greater than 100000
Output (English): SELECT T1.url , T1.time FROM races AS T1 JOIN lapTimes AS T2 ON T1.raceId = T2.raceId WHERE T2.milliseconds > 100000