CREATE TABLE job_history (employee_id VARCHAR2, end_date NUMBER)

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"