drop table Garment;
create table GARMENT(GCODE int primary key, GNAME varchar(20) not null, SIZE varchar(12) not null,COLOUR varchar(20) not null,PRICE float not null);
insert into Garment values(111,'TShirt','XL','Red',1400.00);
insert into Garment values(112,'Jeans','L','Blue',1600.00);
insert into Garment values(113,'Skirt','M','Black',1100.00);
insert into Garment values(114,'Ladies Jacket','XL','Blue',4000.00);
insert into Garment values(115,'Trousers','L','Brown',1500.00);
insert into Garment values(116,'LadiesTop','L','Pink',1200.00);

update Garment set colour ='orange' where GCODE= 116;
Select * From GARMENT ;
select count(*) from garment where Size='L';
update Garment set price= price+ price*10/100 where size ='XL' ;
Delete from garment where GCODE= 116;
select * from garment order by price desc;