Hi,

You can do something similar to what I did below.

update products set p_price = p_price * 1.10 WHERE p_code LIKE 'ffc%' or p_code LIKE 'dcc%';

If you want to do all the math through just SQL, you can do something similiar to the following:

SELECT session, SUM((markup/100.0* price + price)* amount * units) AS total FROM cart, fruit WHERE...