display the employee ID for each employee and the date on which he ended his previous job.
CREATE TABLE job_history (employee_id VARCHAR, end_date INTEGER)
SELECT employee_id, MAX(end_date) FROM job_history GROUP BY employee_id
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE job_history (employee_id VARCHAR, end_date INTEGER) Question: display the employee ID for each employee and the date on which he ended his previous job. [/INST] SELECT employee_id, MAX(end_date) FROM job_history GROUP BY employee_id </s>