create table FURNITURE
(no integer,
 item_name char(15),
 type char(15),
 DOS date,
 Price decimal,
 Discount integer);

insert into FURNITURE values( 1,'WHITE LOTUS','DOUBLE BED','23-FEB-02',30000.00,25);
insert into FURNITURE values( 2,'PINK FEATHER','BABY COT','20-JAN-02',7000.00,20);
insert into FURNITURE values( 3,'DOLPHIN','BABY COT','19-FEB-02',9500.00,20);
insert into FURNITURE values( 4,'DECENT','OFFICE TABLE','01-JAN-02',25000.00,30);
insert into FURNITURE values( 5,'COMFORT ZONE','DOUBLE BED','12-JAN-02',25000.00,25);
insert into FURNITURE values( 6,'DONALD','BABY COT','24-FEB-02',6500.00,15);
insert into FURNITURE values( 7,'ROYAL FINISH','OFFICE TABLE','20-FEB-02',18000.00,30);
insert into FURNITURE values( 8,'ROYAL TIGER','SOFA','22-FEB-02',31000.00,30);
insert into FURNITURE values( 9,'ECONO SITTING','SOFA','13-DEC-01',9500.00,25);
insert into FURNITURE values( 10,'EATING PARADISE','DINING TABLE','19-FEB-02',11500.00,25);