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