Who are the employees working in the Finance department?
select * from employees as t1 join departments as t2 on t1.department_id = t2.department_id where t2.department_name = 'Finance'
What are their first names and job ids?
select t1.first_name, t1.job_id from employees as t1 join departments as t2 on t1.department_id = t2.department_id where t2.department_name = 'Finance'