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