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'
job id for each employee refers to T1.job_id; in the Finance department refers to WHERE T2.department_name = 'Finance'; JOIN is used to combine rows from two or more tables based on a related column between them.