DROP TABLE EMPLOYEE;CREATE TABLE EMPLOYEE (EMPNO CHAR(6) NOT NULL, FIRSTNME VARCHAR(12) NOT NULL, MIDINIT CHAR(1), LASTNAME VARCHAR(15) NOT NULL, WORKDEPT CHAR(3), PHONENO CHAR(4), HIREDATE DATE, JOB CHAR(8), EDLEVEL SMALLINT NOT NULL, SEX CHAR(1), BIRTHDATE DATE, SALARY DECIMAL(9, 2), BONUS DECIMAL(9, 2), COMM DECIMAL(9, 2))DATA CAPTURE NONE COMPRESS NO;-- Insert data into the Employee tableINSERT INTO EMPLOYEE VALUES ('000010','CHRISTINE','I','HAAS','A00','3978','1965-01-01','PRES',18,'F','1933-08-24',+0052750.00,+0001000.00,+0004220.000);INSERT INTO EMPLOYEE VALUES ('000020','MICHAEL','L','THOMPSON','B01','3476','1973-10-10','MANAGER',18,'M','1948-02-02',+0041250.00,+0000800.00,+0003300.00);INSERT INTO EMPLOYEE VALUES ('000030','SALLY','A','KWAN','C01','4738','1975-04-05','MANAGER',20,'F','1941-05-11',+0038250.00,+0000800.00,+0003060.00);INSERT INTO EMPLOYEE VALUES ('000050','JOHN','B','GEYER','E01','6789','1949-08-17','MANAGER',16,'M','1925-09-15',+0040175.00,+0000800.00,+0003214.00);INSERT INTO EMPLOYEE VALUES ('000060','IRVING','F','STERN','D11','6423','1973-09-14','MANAGER',16,'M','1945-07-07',+0032250.00,+0000500.00,+0002580.00);INSERT INTO EMPLOYEE VALUES ('000070','EVA','D','PULASKI','D21','7831','1980-09-30','MANAGER',16,'F','1953-05-26',+0036170.00,+0000700.00,+0002893.00);INSERT INTO EMPLOYEE VALUES ('000090','EILEEN','W','HENDERSON','E11','5498','1970-08-15','MANAGER',16,'F','1941-05-15',+0029750.00,+0000600.00,+0002380.00);INSERT INTO EMPLOYEE VALUES ('000100','THEODORE','Q','SPENSER','E21','0972','1980-06-19','MANAGER',14,'M','1956-12-18',+0026150.00,+0000500.00,+0002092.00);INSERT INTO EMPLOYEE VALUES ('000110','VINCENZO','G','LUCCHESSI','A00','3490','1958-05-16','SALESREP',19,'M','1929-11-05',+0046500.00,+0000900.00,+0003720.00);INSERT INTO EMPLOYEE VALUES ('000120','SEAN','','O''CONNELL','A00','2167','1963-12-05','CLERK',14,'M','1942-10-18',+0029250.00,+0000600.00,+0002340.00);INSERT INTO EMPLOYEE VALUES ('000130','DOLORES','M','QUINTANA','C01','4578','1971-07-28','ANALYST',16,'F','1925-09-15',+0023800.00,+0000500.00,+0001904.00);INSERT INTO EMPLOYEE VALUES ('000140','HEATHER','A','NICHOLLS','C01','1793','1976-12-15','ANALYST',18,'F','1946-01-19',+0028420.00,+0000600.00,+0002274.00);INSERT INTO EMPLOYEE VALUES ('000150','BRUCE','','ADAMSON','D11','4510','1972-02-12','DESIGNER',16,'M','1947-05-17',+0025280.00,+0000500.00,+0002022.00);INSERT INTO EMPLOYEE VALUES ('000160','ELIZABETH','R','PIANKA','D11','3782','1977-10-11','DESIGNER',17,'F','1955-04-12',+0022250.00,+0000400.00,+0001780.00);INSERT INTO EMPLOYEE VALUES ('000170','MASATOSHI','J','YOSHIMURA','D11','2890','1978-09-15','DESIGNER',16,'M','1951-01-05',+0024680.00,+0000500.00,+0001974.00);INSERT INTO EMPLOYEE VALUES ('000180','MARILYN','S','SCOUTTEN','D11','1682','1973-07-07','DESIGNER',17,'F','1949-02-21',+0021340.00,+0000500.00,+0001707.00);INSERT INTO EMPLOYEE VALUES ('000190','JAMES','H','WALKER','D11','2986','1974-07-26','DESIGNER',16,'M','1952-06-25',+0020450.00,+0000400.00,+0001636.00);INSERT INTO EMPLOYEE VALUES ('000200','DAVID','','BROWN','D11','4501','1966-03-
03','DESIGNER',16,'M','1941-05-29',+0027740.00,+0000600.00,+0002217.00);INSERT INTO EMPLOYEE VALUES ('000210','WILLIAM','T','JONES','D11','0942','1979-04-11','DESIGNER',17,'M','1953-02-23',+0018270.00,+0000400.00,+0001462.00);INSERT INTO EMPLOYEE VALUES ('000220','JENNIFER','K','LUTZ','D11','0672','1968-08-29','DESIGNER',18,'F','1948-03-19',+0029840.00,+0000600.00,+0002387.00);INSERT INTO EMPLOYEE VALUES ('000230','JAMES','J','JEFFERSON','D21','2094','1966-11-21','CLERK',14,'M','1935-05-30',+0022180.00,+0000400.00,+0001774.00);INSERT INTO EMPLOYEE VALUES ('000240','SALVATORE','M','MARINO','D21','3780','1979-12-05','CLERK',17,'M','1954-03-31',+0028760.00,+0000600.00,+0002301.00);INSERT INTO EMPLOYEE VALUES ('000250','DANIEL','S','SMITH','D21','0961','1969-10-30','CLERK',15,'M','1939-11-12',+0019180.00,+0000400.00,+0001534.00);INSERT INTO EMPLOYEE VALUES ('000260','SYBIL','P','JOHNSON','D21','8953','1975-09-11','CLERK',16,'F','1936-10-05',+0017250.00,+0000300.00,+0001380.00);INSERT INTO EMPLOYEE VALUES ('000270','MARIA','L','PEREZ','D21','9001','1980-09-30','CLERK',15,'F','1953-05-26',+0027380.00,+0000500.00,+0002190.00);INSERT INTO EMPLOYEE VALUES ('000280','ETHEL','R','SCHNEIDER','E11','8997','1967-03-24','OPERATOR',17,'F','1936-03-28',+0026250.00,+0000500.00,+0002100.00);INSERT INTO EMPLOYEE VALUES ('000290','JOHN','R','PARKER','E11','4502','1980-05-30','OPERATOR',12,'M','1946-07-09',+0015340.00,+0000300.00,+0001227.00);INSERT INTO EMPLOYEE VALUES ('000300','PHILIP','X','SMITH','E11','2095','1972-06-19','OPERATOR',14,'M','1936-10-27',+0017750.00,+0000400.00,+0001420.00);INSERT INTO EMPLOYEE VALUES ('000310','MAUDE','F','SETRIGHT','E11','3332','1964-09-12','OPERATOR',12,'F','1931-04-21',+0015900.00,+0000300.00,+0001272.00);INSERT INTO EMPLOYEE VALUES ('000320','RAMLAL','V','MEHTA','E21','9990','1965-07-07','FIELDREP',16,'M','1932-08-11',+0019950.00,+0000400.00,+0001596.00);INSERT INTO EMPLOYEE VALUES ('000330','WING','','LEE','E21','2103','1976-02-23','FIELDREP',14,'M','1941-07-18',+0025370.00,+0000500.00,+0002030.00);INSERT INTO EMPLOYEE VALUES ('000340','JASON','R','GOUNOT','E21','5698','1947-05-05','FIELDREP',16,'M','1926-05-17',+0023840.00,+0000500.00,+0001907.00);