分析

关键词：where,order

用法：select [列名] from [表名] where 判断条件 order by ..

思路：where的用法在order之前

代码

SELECT vend_name 
FROM Vendors 
WHERE vend_country = 'USA' AND vend_state = 'CA'
ORDER BY vend_name ;