Do not used IN condition.

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

Table Name: PARTS

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

WAREHOUSE CL 3 AP 2 SG 1 AP 2 AP WAREHOUSE 9 RECORD BV06 belongs to HOME GYM KV29 belongs to TREADMILL 10 DESCRIPTION PRICE.5+PRICE-100 HOME GYM CORDLESS DRILL 119142.5 19392.5 SCRIPTION ONHAND NEW ONHAND 18 8 12 12 8 9 ASHER RYER 18 19 DISHWASHER READMILL