分析

关键词：where

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

判断条件：逻辑运算符---and，or

代码

select vend_name
from Vendors
where vend_state='CA' and vend_country='USA'