编写一个查询来查找每个员工的第一份工作的最后一天

SELECT employees.employee_id, employees.first_name, employees.last_name, jobs.start_date AS first_job_start_date, jobs.end_date AS first_job_end_date
FROM employees
JOIN job_history ON employees.employee_id = job_history.employee_id
JOIN jobs ON job_history.job_id = jobs.job_id
WHERE job_history.start_date = (
  SELECT MIN(start_date)
  FROM job_history
  WHERE job_history.employee_id = employees.employee_id
)