Create table product(Pcode varchar(20) primary key,Pname varchar(20),Uprice int(20),Manufacturer  varchar(20));
insert into product values("P01","Washing Powder",120,"Surf");
insert into product values("P02","ToothPaste",54,"Colgate");
insert into product values("P03","Soap",25,"Lux");
insert into product values("P04","Toothpaste",65,"Pepsodent");
insert into product values("P05","Soap",38,"Dove");
insert into product values("P06","Shampoo",245,"Dove");
Alter table product add Discount Decimal(8,1);
update product set discount=case when uprice>100 then 0.10*uprice 
when uprice<100 then 0 end;
select * from product;