display the employee ID and job name for all those jobs in department 80.
SELECT T1.employee_id ,  T2.job_title FROM employees AS T1 JOIN jobs AS T2 ON T1.job_id  =  T2.job_id WHERE T1.department_id = 80
SELECT T1.employee_id ,  T2.job_title FROM employees AS T1 JOIN jobs AS T2 ON T1.job_id  =  T2.job_id WHERE T1.department_id = 80
[{'EMPLOYEE_ID': 145, 'JOB_TITLE': 'Sales Manager'}, {'EMPLOYEE_ID': 146, 'JOB_TITLE': 'Sales Manager'}, {'EMPLOYEE_ID': 147, 'JOB_TITLE': 'Sales Manager'}, {'EMPLOYEE_ID': 148, 'JOB_TITLE': 'Sales Manager'}, {'EMPLOYEE_ID': 149, 'JOB_TITLE': 'Sales Manager'}, {'EMPLOYEE_ID': 150, 'JOB_TITLE': 'Sales Representative'}, {'EMPLOYEE_ID': 151, 'JOB_TITLE': 'Sales Representative'}, {'EMPLOYEE_ID': 152, 'JOB_TITLE': 'Sales Representative'}, {'EMPLOYEE_ID': 153, 'JOB_TITLE': 'Sales Representative'}, {'EMPLOYEE_ID': 154, 'JOB_TITLE': 'Sales Representative'}, {'EMPLOYEE_ID': 155, 'JOB_TITLE': 'Sales Representative'}, {'EMPLOYEE_ID': 156, 'JOB_TITLE': 'Sales Representative'}, {'EMPLOYEE_ID': 157, 'JOB_TITLE': 'Sales Representative'}, {'EMPLOYEE_ID': 158, 'JOB_TITLE': 'Sales Representative'}, {'EMPLOYEE_ID': 159, 'JOB_TITLE': 'Sales Representative'}, {'EMPLOYEE_ID': 160, 'JOB_TITLE': 'Sales Representative'}, {'EMPLOYEE_ID': 161, 'JOB_TITLE': 'Sales Representative'}, {'EMPLOYEE_ID': 162, 'JOB_TITLE': 'Sales Representative'}, {'EMPLOYEE_ID': 163, 'JOB_TITLE': 'Sales Representative'}, {'EMPLOYEE_ID': 164, 'JOB_TITLE': 'Sales Representative'}, {'EMPLOYEE_ID': 165, 'JOB_TITLE': 'Sales Representative'}, {'EMPLOYEE_ID': 166, 'JOB_TITLE': 'Sales Representative'}, {'EMPLOYEE_ID': 167, 'JOB_TITLE': 'Sales Representative'}, {'EMPLOYEE_ID': 168, 'JOB_TITLE': 'Sales Representative'}, {'EMPLOYEE_ID': 169, 'JOB_TITLE': 'Sales Representative'}, {'EMPLOYEE_ID': 170, 'JOB_TITLE': 'Sales Representative'}, {'EMPLOYEE_ID': 171, 'JOB_TITLE': 'Sales Representative'}, {'EMPLOYEE_ID': 172, 'JOB_TITLE': 'Sales Representative'}, {'EMPLOYEE_ID': 173, 'JOB_TITLE': 'Sales Representative'}, {'EMPLOYEE_ID': 174, 'JOB_TITLE': 'Sales Representative'}, {'EMPLOYEE_ID': 175, 'JOB_TITLE': 'Sales Representative'}, {'EMPLOYEE_ID': 176, 'JOB_TITLE': 'Sales Representative'}, {'EMPLOYEE_ID': 177, 'JOB_TITLE': 'Sales Representative'}, {'EMPLOYEE_ID': 179, 'JOB_TITLE': 'Sales Representative'}]