Task: Text to Code
Input (English): Step 1: find the EMPLOYEE_ID of employees table.
Step 2: For each row in departments table, find the corresponding rows in job_history table.
Step 3: find job_history's EMPLOYEE_ID of the results of step 2 whose LOCATION_ID equals 100.
Step 4: show the rows that are in the results of step 1 but not in the results of step 3
Output (English): SELECT T1.EMPLOYEE_ID FROM employees AS T1 EXCEPT SELECT T3.EMPLOYEE_ID FROM departments AS T2 JOIN job_history AS T3 ON T2.DEPARTMENT_ID = T3.DEPARTMENT_ID WHERE T2.LOCATION_ID = 100