What are the employee ids for each employee and final dates of employment at their last job?
SELECT employee_id ,  MAX(end_date) FROM job_history GROUP BY employee_id
employee ids for each employee refers to employee_id; final dates of employment at their last job refers to MAX(end_date);