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 year did any college confer the most amount of degrees?
assistant
SELECT T3.year FROM campuses AS T1 JOIN faculty AS T2 ON T1.id = t2.campus JOIN degrees AS T3 ON T1.id = t3.campus AND t2.year = t3.year ORDER BY t3.degrees DESC LIMIT 1;
human
How about the year before that? | Did you mean which college conferred the most number of degrees in 2003? | Yes
assistant
SELECT t1.campus FROM campuses AS T1 JOIN faculty AS T2 ON T1.id = t2.campus JOIN degrees AS T3 ON T1.id = t3.campus AND t2.year = t3.year WHERE t3.year = 2003 ORDER BY t3.degrees DESC LIMIT 1;
human
How many faculty were at California State University-Channel Islands, in the year of 2002?
assistant
SELECT T2.faculty FROM campuses AS T1 JOIN faculty AS T2 ON T1.id = t2.campus JOIN degrees AS T3 ON T1.id = t3.campus AND t2.year = t3.year WHERE t2.year = 2002 AND t1.campus = 'California State University-Channel Islands';
human
How about for California State University-chico? | Do you mean in the year 2002? | Yes
assistant
SELECT T2.faculty FROM campuses AS T1 JOIN faculty AS T2 ON T1.id = t2.campus JOIN degrees AS T3 ON T1.id = t3.campus AND t2.year = t3.year WHERE t2.year = 2002 AND t1.campus = 'California State University-Chico';
human
How about for the year 1965?
assistant
SELECT DISTINCT T1.location FROM campuses AS T1 JOIN faculty AS T2 ON T1.id = t2.campus JOIN degrees AS T3 ON T1.id = t3.campus AND t2.year = t3.year WHERE t1.year = 1965 AND t1.campus = "California State University-Bakersfield" ;