What is the department id for the Finance department?
select department_id from departments where department_name = 'Finance'
How many employees work in that department?
select count ( * ) 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?
select t1.first_name from employees as t1 join departments as t2 on t1.department_id = t2.department_id where t2.department_name = 'Finance'
What is the job id for each employee in the Finance department?
select t1.job_id from employees as t1 join departments as t2 on t1.department_id = t2.department_id where t2.department_name = 'Finance'
What are their employee IDs?
select t1.employee_id from employees as t1 join departments as t2 on t1.department_id = t2.department_id where t2.department_name = 'Finance'