I have attached question file, starter file for sql. plus i have answer for more than 85%, i just need help on some questions only, and then you have to run the file in sql plus and give me the output

DROP TABLE ORDERDETAIL_jxa ; DROP TABLE ORDER_jxa; DROP TABLE CUSTOMER_jxa; DROP TABLE SALESREP_jxa; DROP TABLE PRODUCT_jxa; DROP TABLE COMMISSION_jxa; DROP TABLE DEPARTMENT_jxa; DROP TABLE PRODCAT_jxa; -- PART IA -- Create tables using the best data types, and create them in the proper order.

CREATE TABLE PRODCAT_jxa ( ProdCatID NUMBER(2), ProdCatName VARCHAR(20) NOT NULL, PRIMARY KEY (ProdCatID) ) ; CREATE TABLE DEPARTMENT_jxa ( DeptID NUMBER(2) , DeptName VARCHAR(15) NOT NULL, PRIMARY KEY (DeptID) ) ; CREATE TABLE COMMISSION_jxa( CommClass CHAR(1), CommRate NUMBER(2,2) NOT NULL, PRIMARY KEY (CommClass) ) ; CREATE TABLE PRODUCT_jxa( ProdID NUMBER(4), ProdName VARCHAR(25) NOT NULL, ProdCatID NUMBER(2) NOT NULL, ProdPrice NUMBER(5,2) NOT NULL, PRIMARY KEY (ProdID), FOREIGN KEY (ProdCatID) REFERENCES PRODCAT_jxa ) ; CREATE TABLE SALESREP_jxa( SalesRepID NUMBER(3), SalesRepFName VARCHAR(15) NOT NULL, SalesRepLName VARCHAR(15) NOT NULL, CommClass CHAR(1) NOT NULL, DeptID NUMBER(2) NOT NULL, PRIMARY KEY (SalesRepID), FOREIGN KEY (CommClass) REFERENCES COMMISSION_jxa, FOREIGN KEY (DeptID) REFERENCES DEPARTMENT_jxa ) ; CREATE TABLE CUSTOMER_jxa( CustID CHAR(4), CustFName VARCHAR(15) NOT NULL, CustLName VARCHAR(15) NOT NULL, CustPhone CHAR(10), SalesRepID NUMBER(4) NOT NULL, PRIMARY KEY (CustID), FOREIGN KEY (SalesRepID) REFERENCES SALESREP_jxa ) ; CREATE TABLE ORDER_jxa( OrderID NUMBER(4), OrderDate DATE NOT NULL, CustID CHAR(4) NOT NULL, PRIMARY KEY (OrderID), FOREIGN KEY (CustID) REFERENCES CUSTOMER_jxa ) ; CREATE TABLE ORDERDETAIL_jxa( OrderID NUMBER(4), ProdID NUMBER(4), ProdQty NUMBER(4) NOT NULL, ProdPrice NUMBER(5,2) NOT NULL, PRIMARY KEY (OrderID,ProdID), FOREIGN KEY (OrderID) REFERENCES ORDER_jxa, FOREIGN KEY (ProdID) REFERENCES PRODUCT_jxa ) ; COMMIT ; -- Part IIA -- Insert rows into each table.

-- PRODCAT INSERT INTO PRODCAT_jxa VALUES (1, 'Hand Tools'); INSERT INTO PRODCAT_jxa VALUES (2, 'Power Tools'); INSERT INTO PRODCAT_jxa VALUES (3, 'Measuring Tools'); INSERT INTO PRODCAT_jxa VALUES (4, 'Fasteners'); INSERT INTO PRODCAT_jxa VALUES(5, 'Hardware'); INSERT INTO PRODCAT_jxa VALUES (6, 'Misc'); insert rows into DEPARTMENT INSERT INTO DEPARTMENT_jxa VALUES(10, 'Store Sales'); INSERT INTO DEPARTMENT_jxa VALUES(14, 'Corp Sales'); INSERT INTO DEPARTMENT_jxa VALUES(16, 'Web Sales'); -- COMMISSION INSERT INTO COMMISSION_jxa VALUES('A', 0.1); INSERT INTO COMMISSION_jxa VALUES('B', 0.08); INSERT INTO COMMISSION_jxa VALUES('C', 0.05); INSERT INTO COMMISSION_jxa VALUES('Z', 0); -- PRODUCT INSERT INTO PRODUCT_jxa VALUES(121, 'BD Hammer',1, 7.00); INSERT INTO PRODUCT_jxa VALUES(228, 'Makita Power Drill', 2, 65.00); INSERT INTO PRODUCT_jxa VALUES(235, 'Makita Power Drill Pro', 1, 65.00); INSERT INTO PRODUCT_jxa VALUES(480, '1# BD Nails', 4, 3.00); INSERT INTO PRODUCT_jxa VALUES (407, '1# BD Screws', 4, 4.25); INSERT INTO PRODUCT_jxa VALUES(610, '3M Duct Tape', 6, 1.75); INSERT INTO PRODUCT_jxa VALUES (618, '3M Masking Tape', 6, 1.25); INSERT INTO PRODUCT_jxa VALUES (380, 'Acme Yard Stick', 3, 1.25); INSERT INTO PRODUCT_jxa VALUES (535, 'Schlage Door Knob', 5, 7.50); INSERT INTO PRODUCT_jxa VALUES (123, 'Acme Pry Bar', 1, 5.00); INSERT INTO PRODUCT_jxa VALUES(229, 'BD Power Drill', 2, 59.00); INSERT INTO PRODUCT_jxa VALUES(124, 'Acme Hammer', 1, 6.50); -- SALESREP INSERT INTO SALESREP_jxa VALUES(10, 'Alice', 'Jones', 'A', 10); INSERT INTO SALESREP_jxa VALUES(12, 'Greg', 'Taylor', 'B', 14); INSERT INTO SALESREP_jxa VALUES(14, 'Sara', 'Day', 'Z', 10); INSERT INTO SALESREP_jxa VALUES(8, 'Kay', 'Price', 'C', 14); INSERT INTO SALESREP_jxa VALUES(20, 'Bob', 'Jackson', 'B', 10); INSERT INTO SALESREP_jxa VALUES(22, 'Micah', 'Moore', 'Z', 16); --CUSTOMER INSERT INTO CUSTOMER_jxa VALUES('S100', 'John', 'Smith', '2145551212', 10); INSERT INTO CUSTOMER_jxa VALUES('A120', 'Jane', 'Adams', '8175553434', 12); INSERT INTO CUSTOMER_jxa VALUES('J090', 'Tim' , 'Jones', NULL, 14); INSERT INTO CUSTOMER_jxa VALUES('B200', 'Ann', 'Brown', '9725557979', 8); INSERT INTO CUSTOMER_jxa VALUES('G070', 'Kate', 'Green', NULL, 20); INSERT INTO CUSTOMER_jxa VALUES('S120', 'Nicole', 'Sims', NULL, 22); --ORDER INSERT INTO ORDER_jxa VALUES(100, '24-Jan-2020', 'S100'); INSERT INTO ORDER_jxa VALUES(101, '25-Jan-2020', 'A120'); INSERT INTO ORDER_jxa VALUES(102, '25-Jan-2020', 'J090'); INSERT INTO ORDER_jxa VALUES(103, '26-Jan-2020', 'B200'); INSERT INTO ORDER_jxa VALUES(104, '26-Jan-2020', 'S100'); INSERT INTO ORDER_jxa VALUES(105, '26-Jan-2020', 'B200'); INSERT INTO ORDER_jxa VALUES(106, '27-Jan-2020', 'G070'); INSERT INTO ORDER_jxa VALUES(107, '27-Jan-2020', 'J090'); INSERT INTO ORDER_jxa VALUES(108, '27-Jan-2020', 'S120'); --ORDERDETAIL INSERT INTO ORDERDETAIL_jxa VALUES(100, 121, 2, 8.00); INSERT INTO ORDERDETAIL_jxa VALUES(100, 228, 1, 65.00); INSERT INTO ORDERDETAIL_jxa VALUES(100, 480, 2, 3.00); INSERT INTO ORDERDETAIL_jxa VALUES(100, 407, 1, 4.25); INSERT INTO ORDERDETAIL_jxa VALUES(101, 610, 200, 1.75); INSERT INTO ORDERDETAIL_jxa VALUES(101, 618, 100, 1.25); INSERT INTO ORDERDETAIL_jxa VALUES(102, 380, 2, 1.25); INSERT INTO ORDERDETAIL_jxa VALUES(102, 121, 1, 7.00); INSERT INTO ORDERDETAIL_jxa VALUES(102, 535, 4, 7.50); INSERT INTO ORDERDETAIL_jxa VALUES(103, 121, 50, 7.00); INSERT INTO ORDERDETAIL_jxa VALUES(103, 123, 20, 6.25); INSERT INTO ORDERDETAIL_jxa VALUES(104, 229, 1, 50.00); INSERT INTO ORDERDETAIL_jxa VALUES(104, 610, 200, 1.75); INSERT INTO ORDERDETAIL_jxa VALUES(104, 380, 2, 1.25); INSERT INTO ORDERDETAIL_jxa VALUES(104, 535, 4, 7.50); INSERT INTO ORDERDETAIL_jxa VALUES(105, 610, 200, 1.75); INSERT INTO ORDERDETAIL_jxa VALUES(105, 123, 40, 5.00); INSERT INTO ORDERDETAIL_jxa VALUES(106, 124, 1, 6.50); INSERT INTO ORDERDETAIL_jxa VALUES(107, 229, 1, 59.00); INSERT INTO ORDERDETAIL_jxa VALUES(108, 235, 1, 65.00); --Save all rows to disk COMMIT ; -- Part III -- Modify/add data.

--CUSTOMER UPDATE CUSTOMER_jxa SET CustPhone = '2145551234' WHERE CustID = 'B200' ; INSERT INTO CUSTOMER_jxa VALUES('G119', 'Amanda', 'Green', NULL, 14) ; --ORDER UPDATE ORDER_jxa SET OrderDate = '28-Jan-2022' WHERE OrderID = 108; INSERT INTO ORDER_jxa VALUES(109, '28-Jan-2022', 'G119') ; --ORDERDETAIL UPDATE ORDERDETAIL_jxa SET ProdPrice = 62.00 WHERE ProdID = 235 AND OrderID = 108 ; INSERT INTO ORDERDETAIL_jxa VALUES(108, 407, 1, 5.25); INSERT INTO ORDERDETAIL_jxa VALUES(108,618,2,2.15); INSERT INTO ORDERDETAIL_jxa VALUES(109,121,1,8.25); INSERT INTO ORDERDETAIL_jxa VALUES(109,480,1,3.75); COMMIT;