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