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
[{'EMPLOYEE_ID': 0, 'MAX(end_date)': '0000-00-00'}, {'EMPLOYEE_ID': 101, 'MAX(end_date)': '1997-03-15'}, {'EMPLOYEE_ID': 102, 'MAX(end_date)': '1998-07-24'}, {'EMPLOYEE_ID': 114, 'MAX(end_date)': '1999-12-31'}, {'EMPLOYEE_ID': 122, 'MAX(end_date)': '1999-12-31'}, {'EMPLOYEE_ID': 176, 'MAX(end_date)': '1999-12-31'}, {'EMPLOYEE_ID': 200, 'MAX(end_date)': '1998-12-31'}, {'EMPLOYEE_ID': 201, 'MAX(end_date)': '1999-12-19'}]