select prod_id,prod_price,prod_price*0.9 sale_price from Products

若想保留几位小数的写法

select

prod_id,prod_price,round(prod_price*0.9,1) sale_price

from

Products