SELECT employee_id ,  MAX(end_date) FROM job_history GROUP BY employee_id
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
select employee_id , max ( end_date ) from job_history group by employee_id
display the employee ID for each employee and the date on which he ended his previous job .