SQL20 别名 代码如下: select vend_id,vend_name as vname,vend_address as vaddress,vend_city as vcity from Vendors order by vname SQL21 打折 select prod_id,prod_price,round(prod_price*0.9,3) as sale_price from Products