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