SELECT vend_name
FROM Vendors 
where vend_state = 'CA' and vend_country = 'USA'
# SQL中的等于就是=没有赋值符号