What is all the job history information?
select * from job_history
What are the unique employee ids?
select employee_id from job_history group by employee_id
What are the latest end dates corresponding to each one?
select employee_id, max(end_date) from job_history group by employee_id