display the employee ID for each employee and the date on which he ended his previous job.
select employee_id, max(end_date) from job_history group by employee_id