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
how many campuses are presented on the table
assistant
SELECT COUNT( * ) FROM campuses;
human
list out the campuses name
assistant
SELECT campus FROM campuses;
human
what is the location of California State University-Bakersfield
assistant
SELECT location FROM campuses WHERE campus = 'California State University-Bakersfield';
human
what is the county of California State University-Chico
assistant
SELECT county FROM campuses WHERE campus = "California State University-Chico" ;