编辑代码

CREATE DATABASE test;
use test;
create table employment_history
(
staff_id INT,
start_date DATETIME,  end_date DATETIME, employment_id VARCHAR(10), section_id INT
);
insert into employment_history (staff_id, start_date, end_date, employment_id,section_id)values (102, '1993-01-13', '1998-07-24','IT_PROG', 60);
insert into employment_history (staff_id, start_date, end_date, employment_id,section_id)values (101, '1989-09-21', '1993-10-27','AC_ACCOUNT', 110);
select EMPLOYMENT_ID from employment_history;