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';
human
What are the country of FTE_AY 178?
assistant
SELECT t1.county FROM campuses AS t1 JOIN enrollments AS t2 ON t1.id = t2.campus WHERE t2.FTE_AY = 178;
human
What campus had more than 400 total enrollment but more than 200 full time enrollment in year 1956?
assistant
SELECT T1.campus FROM campuses AS t1 JOIN enrollments AS t2 ON t1.id = t2.campus WHERE t2.year = 1956 AND totalenrollment_ay > 400 AND FTE_AY > 200 ;