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 campus has the most faculties in year 2003?
assistant
SELECT T1.campus FROM campuses AS T1 JOIN faculty AS T2 ON T1.id = T2.campus WHERE T2.year = 2003 ORDER BY T2.faculty DESC LIMIT 1
human
Which university is in Los Angeles county and opened after 1950?
assistant
SELECT campus FROM campuses WHERE county = 'Los Angeles' AND YEAR > 1950
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
human
Find the name of the campuses opened before 1800.
assistant
SELECT campus FROM campuses WHERE YEAR < 1800
human
Find all the campuses opened in 1958.
assistant
SELECT campus FROM campuses WHERE YEAR = 1958
human
Which campus was opened between 1935 and 1939?
assistant
SELECT campus FROM campuses WHERE YEAR >= 1935 AND YEAR <= 1939 ;