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