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
What campuses were opened between 1935 and 1939?
assistant
SELECT campus FROM campuses WHERE YEAR > = 1935 AND YEAR < = 1939;
human
What campuses were opened after that? | Do you mean opened after 1939? | Yes, please
assistant
SELECT campus FROM campuses WHERE YEAR > 1939;
human
How many total campuses were opened?
assistant
SELECT COUNT( * ) FROM campuses ;