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