Which California State University is located in Kern County?
SELECT campus from campuses where campus like "%California State University%" and county  =  "Kern"
California State University located in refers to campus LIKE '%California State University%' and county = 'Kern';