human
Schema:
Campuses (Id, Campus, Location, County, Year)
csu_fees (Campus, Year, CampusFee)
degrees (Year, Campus, Degrees)
discipline_enrollments (Campus, Discipline, Year, Undergraduate, Graduate)
enrollments (Campus, Year, TotalEnrollment_AY, FTE_AY)
faculty (Campus, Year, Faculty)
Please answer with SQL.
assistant
Sure, I understand.
human
Which California State University is located in Kern County?
assistant
SELECT campus FROM campuses WHERE campus LIKE '%California State University%' AND county = 'Kern';
human
What year was California State University-Chico started?
assistant
SELECT year FROM campuses WHERE campus = 'California State University-Chico';
human
Which campus has the smallest faculty
assistant
SELECT T1.campus FROM campuses AS T1 JOIN faculty AS T2 ON T1.id = T2.campus WHERE T2.faculty = ( SELECT MIN( faculty ) FROM faculty ) ;