Task: Text to Code
Input (English): Step 1: For each row in employees table, find corresponding rows in departments table and in jobs table.
Step 2: find EMPLOYEE_ID, JOB_TITLE of the results of step 1 whose DEPARTMENT_NAME equals 80
Output (English): SELECT T3.EMPLOYEE_ID , T2.JOB_TITLE FROM departments AS T1 JOIN jobs AS T2 JOIN employees AS T3 ON T1.DEPARTMENT_ID = T3.DEPARTMENT_ID AND T3.JOB_ID = T2.JOB_ID AND T1.DEPARTMENT_ID = T3.DEPARTMENT_ID WHERE T1.DEPARTMENT_NAME = 80