UPDATE customer_tbl SET outstanding_amt=outstanding_amt-(outstanding_amt*.10) WHERE cust_country='India' AND grade=1;