Required:

- Use the Parts table below. This activity covers all SELECT statement

- Based on the given table: PARTS as shown below, write the PL/SQL in order to get the printed output per number.

- Do not used IN condition.

- Copy and paste the PL/SQL code on the space provided after each questions.

Table Name: PARTS

CREATE TABLE PARTS( PARTNUM CHAR(4) PRIMARY KEY, DESCRIPTION VARCHAR(20), ONHAND NUMBER(6), CLASS CHAR(5), WAREHOUSE NUMBER(6), PRICE NUMBER(6)); INSERT INTO PARTS VALUES('AT94', 'IRON',50,'HW',3,2495); INSERT INTO PARTS VALUES('BVO6','HOME GYM' ,45,'SG',2,79495); INSERT INTO PARTS VALUES('CD52','MICROWAVE OVEN',32,'AP',1,165); INSERT INTO PARTS VALUES('DL71','CORDLESS DRILL',21,'HW',3,12995); INSERT INTO PARTS VALUES('DR93','GAS RANGE',21,'AP',2,495); INSERT INTO PARTS VALUES('DW11','WASHER',12,'AP',3,399); INSERT INTO PARTS VALUES('FD21','STAND MIXER',22,'HW',3,159); INSERT INTO PARTS VALUES('KL62','DRYER',12,'AP',1,349); INSERT INTO PARTS VALUES('KT03','DISHWASHER',8,'AP',3,595); INSERT INTO PARTS VALUES('KV29','TREADMILL',9,'SG',2,1390); 

WAREHOUSE CL DESCRIPTION ONHAND CL 1. 3 AP 2 SG 1 AP 2 AP 3 HW 50 HN 45 SG 32 AP 21 HW 8 AP 12 AP 22 HW 12 AP 8 AP 9 SG HOME GYM ICROWAVE OVEN ORDLESS DRILL RANGE ASHER STAND MIXER DRYER DISHWASHER RECORD READMILL 2. BV06 belongs to HOME GYM KV29 belongs to TREADMILL 8. What is the advantage of using Logical Condition? DESCRIPTION PRICE*. 5 PRICE-100 PRICE*.5 GYM- 119142.5 19392.5 CORDLESS DRILL ESCRIPTION ONHAND NEW ONHAND S RANGE 18 ASHER DRYER 12 12 4 DISHWASHER READMILL 18 19 DESCRIPTION PTION- -- ONHAND CL 5 WASHER DRYER 12 AP 12 AP ESCRIPTION ONHAND CL 6. 32 AP 8 AP 8 AP ICROWAVE OVEN S RANGE ISHWASHER