create table EMPLOYEE ( EMPNO int NOT NULL, ENAME VARCHAR(10), MGR int, HIREDATE DATE, SAL DECIMAL(7,2), DEPTNAME VARCHAR(10) ) insert into EMPLOYEE(EMPNO, ENAME, MGR, HIREDATE, SAL, DEPTNAME) values (1, 'SMITH', 3, '1980-12-17', 800.00, 'BANKING'); insert into EMPLOYEE(EMPNO, ENAME, MGR, HIREDATE, SAL, DEPTNAME) values (2, 'ALLEN', 4, '1981-02-20', 1600.00, 'INSURANCE'); insert into EMPLOYEE(EMPNO, ENAME, MGR, HIREDATE, SAL, DEPTNAME) values (3, 'WARD', null, '1981-02-22', 1250.00, 'BANKING'); insert into EMPLOYEE(EMPNO, ENAME, MGR, HIREDATE, SAL, DEPTNAME) values (4, 'JONES', null, '1981-04-02', 2975.00, 'INSURANCE'); insert into EMPLOYEE(EMPNO, ENAME, MGR, HIREDATE, SAL, DEPTNAME) values (5, 'MARTIN', 4, '1981-09-28', 1250.00, 'INSURANCE'); insert into EMPLOYEE(EMPNO, ENAME, MGR, HIREDATE, SAL, DEPTNAME) values (6, 'BLAKE', 7, '1981-05-01', 2850.00, 'SERVICES'); insert into EMPLOYEE (EMPNO, ENAME, MGR, HIREDATE, SAL, DEPTNAME) values (7, 'CLARK', null, '1981-06-09', 2450.00, 'SERVICES'); insert into EMPLOYEE(EMPNO, ENAME, MGR, HIREDATE, SAL, DEPTNAME) values (8, 'SCOTT', 4, '1981-12-09', 3000.00, 'INSURANCE'); insert into EMPLOYEE(EMPNO, ENAME, MGR, HIREDATE, SAL, DEPTNAME) values (9, 'KING', 3, '1981-11-17', 5000.00, 'BANKING'); insert into EMPLOYEE(EMPNO, ENAME, MGR, HIREDATE, SAL, DEPTNAME) values (10, 'TURNER', 4, '1981-09-08', 1500.00, 'INSURANCE'); insert into EMPLOYEE(EMPNO, ENAME, MGR, HIREDATE, SAL, DEPTNAME) values (11, 'ADAMS', 3, '1981-01-12', 1100.00, 'BANKING'); insert into EMPLOYEE(EMPNO, ENAME, MGR, HIREDATE, SAL, DEPTNAME) values (12, 'JAMES', 7, '1981-12-03', 950.00, 'SERVICES'); insert into EMPLOYEE(EMPNO, ENAME, MGR, HIREDATE, SAL, DEPTNAME) values (13, 'FORD', 4, '1981-12-03', 3000.00, 'INSURANCE'); insert into EMPLOYEE(EMPNO, ENAME, MGR, HIREDATE, SAL, DEPTNAME) values (14, 'MILLER', 4, '1981-01-23', 1300.00, 'INSURANCE');