can you please help me to find the code ?

hint : Company DDL

create table DEPARTMENT ( DNAME VARCHAR(30), DNUMBER NUMBER(4) PRIMARY KEY, MGR_SSN CHAR(9), MGR_START_DATE DATE); create table EMPLOYEE ( FNAME VARCHAR(30), MINIT CHAR(1), LNAME VARCHAR(30), SSN CHAR(9) PRIMARY KEY, BDATE DATE, ADDRESS VARCHAR(30), SEX CHAR(1), SALARY NUMBER(5), SUPER_SSN CHAR(9), DNO NUMBER(4)); ALTER TABLE EMPLOYEE ADD CONSTRAINT SEXCHECK CHECK (SEX IN ('M','F')); ALTER TABLE EMPLOYEE ADD CONSTRAINT SALARYCHECK CHECK (SALARY >= 1000 AND SALARY  
INSERT INTO DEPARTMENT VALUES('Research',5,null,to_date('1988-05-22','yyyy-mm-dd')); INSERT INTO DEPARTMENT VALUES('Administration',4,null,to_date('1995-01-01','yyyy-mm-dd')); INSERT INTO DEPARTMENT VALUES('Headquarters',1,null,to_date('1981-06-19','yyyy-mm-dd')); INSERT INTO EMPLOYEE VALUES('James','E','Borg','888665555',to_date('1937-11-10', 'yyyy-mm-dd'), '450 Stone,Houston,TX','M',55000,null,'1'); INSERT INTO EMPLOYEE VALUES('Franklin','T','Wong','333445555',to_date('1955-12-08','yyyy-mm-dd'),'638 Voss,Houston,TX','M',40000,'888665555','5'); INSERT INTO EMPLOYEE VALUES('John','B','Smith','123456789',to_date('1965-01-09','yyyy-mm-dd'),'731 Fondren,Houston,TX','M',30000,'333445555','5'); INSERT INTO EMPLOYEE VALUES('Jennifer','S','Wallace','987654321',to_date('1941-06-20', 'yyyy-mm-dd'),'291 Berry,Bellaire,TX','F',43000,'888665555','4'); INSERT INTO EMPLOYEE VALUES('Alicia','J','Zelaya','999887777',to_date('1968-01-19', 'yyyy-mm-dd'),'3321 Castle,Spring,TX','F',25000,'987654321','4'); INSERT INTO EMPLOYEE VALUES('Ramesh','K','Narayan','666884444',to_date('1962-09-15', 'yyyy-mm-dd'),'975 Fire Oak,Humble,TX','M',38000,'333445555','5'); INSERT INTO EMPLOYEE VALUES('Joyce','A','English','453453453',to_date('1972-07-31', 'yyyy-mm-dd'),'5631 Rice,Houston,TX','F',25000,'333445555','5'); INSERT INTO EMPLOYEE VALUES('Ahmad','V','Jabbar','987987987',to_date('1969-03-29', 'yyyy-mm-dd'),'980 Dallas,Houston,TX','M',25000,'987654321','4'); UPDATE DEPARTMENT SET MGR_SSN='333445555' WHERE DNUMBER=5; UPDATE DEPARTMENT SET MGR_SSN='987654321' WHERE DNUMBER=4; UPDATE DEPARTMENT SET MGR_SSN='888665555' WHERE DNUMBER=1; INSERT INTO DEPT_LOCATIONS VALUES(1,'Houston'); INSERT INTO DEPT_LOCATIONS VALUES(4,'Stafford'); INSERT INTO DEPT_LOCATIONS VALUES(5,'Bellaire'); INSERT INTO DEPT_LOCATIONS VALUES(5,'Sugarland'); INSERT INTO DEPT_LOCATIONS VALUES(5,'Houston'); INSERT INTO PROJECT VALUES('ProductX',1,'Bellaire',5); INSERT INTO PROJECT VALUES('ProductY',2,'Sugarland',5); INSERT INTO PROJECT VALUES('ProductZ',3,'Houston',5); INSERT INTO PROJECT VALUES('Computerization',10,'Stafford',4); INSERT INTO PROJECT VALUES('Reorganization',20,'Houston',1); INSERT INTO PROJECT VALUES('Newbenefits',30,'Stafford',4); INSERT INTO WORKS_ON VALUES('123456789',1,32.5); INSERT INTO WORKS_ON VALUES('123456789',2,7.5); INSERT INTO WORKS_ON VALUES('666884444',3,40.0); INSERT INTO WORKS_ON VALUES('453453453',1,20.0); INSERT INTO WORKS_ON VALUES('453453453',2,20.0); INSERT INTO WORKS_ON VALUES('333445555',2,10.0); INSERT INTO WORKS_ON VALUES('333445555',3,10.0); INSERT INTO WORKS_ON VALUES('333445555',10,10.0); INSERT INTO WORKS_ON VALUES('333445555',20,10.0); INSERT INTO WORKS_ON VALUES('999887777',30,30.0); INSERT INTO WORKS_ON VALUES('999887777',10,10.0); INSERT INTO WORKS_ON VALUES('987987987',10,35.0); INSERT INTO WORKS_ON VALUES('987987987',30,5.0); INSERT INTO WORKS_ON VALUES('987654321',30,20); INSERT INTO WORKS_ON VALUES('987654321',20,15.0); INSERT INTO WORKS_ON VALUES('888665555',20,null); INSERT INTO DEPENDENT VALUES('333445555','Alice','F',to_date('1986-04-05','yyyy-mm-dd'),'Daughter'); INSERT INTO DEPENDENT VALUES('333445555','Theodore','M',to_date('1983-10-25','yyyy-mm-dd'),'Son'); INSERT INTO DEPENDENT VALUES('333445555','Joy','F',to_date('1958-05-03','yyyy-mm-dd'),'Spouse'); INSERT INTO DEPENDENT VALUES('987654321','Abner','M',to_date('1942-02-28','yyyy-mm-dd'),'Spouse'); INSERT INTO DEPENDENT VALUES('123456789','Michael','M',to_date('1988-01-04','yyyy-mm-dd'),'Son'); INSERT INTO DEPENDENT VALUES('123456789','Alice','F',to_date('1988-12-30','yyyy-mm-dd'),'Daughter'); INSERT INTO DEPENDENT VALUES('123456789','Elizabeth','F',to_date('1967-05-05','yyyy-mm-dd'),'Spouse'); commit; 
  ITAP 3371 LAB1 FALL 2020 Instructions: Save this file as Lab1_YourlD_LabSection (replace Yourld with your ID and LabSection with your section. Upload your final solution to Blackboard, in the Lab 01 Assignment found in: Database II LAB_211 Course Course Assignments Content Area Lab 01 Content Folder Lab 01 Assignment In this lab, you are going to use the EMPLOYEE and DEPENDENT tables in the COMPANY database schema used in GEIT 3341 DB I. If you still have this schema, you are ready to do this lab, otherwise, run the scripts Company DDL and Company DML you will find in the Scrips folder. Log in to Oracle SQL Developer/Oracle Live SQL and answer the following questions. 2) For the EMPLOYEE table, write a query that uses searched CASE to determine a bonus for each employee according to the following rules: (5 points) w If the salary is less or equal 25000, the bonus is 10% of the salary If the salary is less or equal 40000, the bonus is 15% of the salary Otherwise, the bonus is 20% of the salary That is, your query should display the following output: ENAME LNAME Bonus($) James 11000 6000 4500 8600 Franklin John Jennifer Alicia Ramesh Joyce Ahmad Borg Wong Smith Wallace Zelaya Narayan English Jabbar 2500 5700 2500 2500 Insert here your query