构建表及数据的SQL语句；

create table more_employees( EMPLOYEE_ID INT,MANAGER_ID INT,FIRST_NAME varchar(20),LAST_NAME varchar(20),TITLE VARCHAR(20),SALARY INT);
insert into more_employees values( 1 , null, 'James', ' Smith ', 'CEO ',800000);
insert into more_employees values( 2,1, 'Ron','Johnson', 'Sales Manager',600000);
insert into more_employees values( 3,2,' Fred','Hobbs','Sales Person ',200000);
insert into more_employees values( 4,1,' Susan','Jones ' ,'Support Manager',500000);
insert into more_employees values( 5,2,' Rob','Green','Sales Person',40000);
insert into more_employees values( 6,4,' Jane','Brown','Support Person',45000);
insert into more_employees values( 7,4,' John', 'Grey','Support Manage',30000);
insert into more_employees values( 8,7,' Jean', 'Blue','Support Person',29000);
insert into more_employees values( 9,6,' Henry', ' Heyson' , 'Support Person',30000);
insert into more_employees values( 10,1,'Kevin', 'Black' , 'Ops Manager',100000);
insert into more_employees values( 11,10, 'Keith', 'Long' , 'Ops Person',50000);
insert into more_employees values( 12,10,'Frank', 'Howard' , 'Ops Person',45000);
insert into more_employees values( 12,10,'Frank','Howard','Ops Person',45000);

转载之:http://blog.csdn.net/wh62592855/article/details/4704104