分析

关键词：别名---as

用法：[列名] as [新列名]

代码

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