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