What are the employee ids for employees in department 80?
select employee_id from employees where department_id = 80
Also, what are their job titles?
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