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