Required: 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);

PARTNUM	DESCRIPTION	ONHAND	CLASS	WAREHOUSE	PRICE
AT94	IRON	50	HW	3	2495
BVO6	HOME GYM	45	SG	2	79495
CD52	MICROWAVE OVEN	32	AP	1	165
DL71	CORDLESS DRILL	21	HW	3	12995
DR93	GAS RANGE	21	AP	2	495
DW11	WASHER	12	AP	3	399
FD21	STAND MIXER	22	HW	3	159
KL62	DRYER	12	AP	1	349
KT03	DISHWASHER	8	AP	3	595
KV29	TREADMILL	9	SG	2	1390

PARTS structure

COLUMN NAME	DATA TYPE/SIZE	KEY	NULL
PARTNUM	CHAR 4	PRIMARY	NOT NULL
DESCRIPTION	VARCHAR 20		NOT NULL
ONHAND	NUMBER 6
CLASS	CHAR 5
WAREHOUSE	NUMBER 6
PRICE	NUMBER 6

1. Create a report listing only the column PARTNUM, CLASS and ONHAND of all parts where partnum is equal to AT94, DR93 and KV29. (Note 1 query only and do not use logical condition)

2. Create a report listing only the column DESCRIPTION, ONHAND, CLASS and PRICE of all price where the description ends with letter N.

3. Create a report listing only the column DESCRIPTION, WAREHOUSE, CLASS and PRICE of all parts where the description contains keyword SHE.

4. Create a report listing only the column DESCIPTION, PARTNUM, CLASS and PRICE of all parts where the description fourth letter starting from the first is equal to D.

5. Create a report showing all rows and columns sort the description in ascending order.