select prod_id,prod_price,prod_price*0.9 as sale_price
from Products;