Which California State University is located in Kern County?
select campus from campuses where campus like "%california state university%" and county = "Kern"
What year was California State University-Chico started?
select year from campuses where campus = "California state university-Chico"
Which campus has the smallest faculty
select t1.campus from campuses as t1 join faculty as t2 on t1.id = t2.campus where t2.faculty = ( select min ( faculty ) from faculty )
Which campus was started in 2002?
select campus from campuses where year = 2002