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

知识点：列计算及别名点使用