<p>CREATE TABLE EMPLOYEES(</p><p>EMPLOYEE_ID NUMBER(6) PRIMARY KEY NOT NULL,</p><p>FIRSTNAME VARCHAR(10),</p><p>LASTNAME VARCHAR(10)NOT NULL,</p><p>JOB_ID VARCHAR(10),</p><p>SALARY NUMBER(8,2),</p><p>MANAGER_ID NUMBER(6),</p><p>DEPARTMENT_ID NUMBER(4));</p><p>INSERT INTO EMPLOYEES VALUES(100,'STEVEN','KING','AD_PRES',24000,NULL,90);</p><p>INSERT INTO EMPLOYEES VALUES(101,'NENA','KOCHAR','AD_VP',17000,100,90);</p><p>INSERT INTO EMPLOYEES VALUES (102,'LEX','DEHAAN','AD_VP',17000,100,90);</p><p>INSERT INTO EMPLOYEES VALUES(103,'ALEXANDER','HUNOLD','IT_PROG',NULL,101,60);</p><p>INSERT INTO EMPLOYEES