SELECT vend_name 
FROM Vendors 

WHERE vend_country = 'USA' AND vend_state = 'CA'
ORDER BY vend_name

将order by 放到语句最后即可。
知识点，考察sql关键词的顺序。order by 的位置位于所有语句的倒数第二，倒数第一是 limit