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
Find the id of year 1956? | do you mean the id of the campus that is opened in 1956? | Yes
assistant
SELECT id FROM campuses WHERE year = 1956;
human
How many TotalEnrollment of Campus California State University-Channel Islands?
assistant
SELECT t2.TotalEnrollment_AY FROM campuses AS t1 JOIN enrollments AS t2 ON t1.id = t2.campus WHERE t1.campus = "California State University-Channel Islands" ;