select 
vend_id,
vend_name as vname,
vend_address as vaddress,
vend_city as vcity
from Vendors
order by vend_name

知识点：列别名的使用
易错点：vcity 在最后边，位置也会导致错误