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 is the number of faculty lines in campus 'Long Beach State University' in 2002?
assistant
SELECT faculty FROM faculty AS T1 JOIN campuses AS T2 ON T1.campus = T2.id WHERE T1.year = 2002 AND T2.campus = 'Long Beach State University'
human
What is the average fee on a CSU campus in 2005?
assistant
SELECT avg(campusfee) FROM csu_fees WHERE YEAR = 2005
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
What are the names of all campuses located at Chico?
assistant
SELECT campus FROM campuses WHERE LOCATION = 'Chico'
human
Which campus has the most degrees conferred in all times?
assistant
SELECT campus FROM degrees GROUP BY campus ORDER BY sum(degrees) DESC LIMIT 1
human
How many CSU campuses are there?
assistant
SELECT COUNT( * ) FROM campuses ;