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
Show the faculty lines in campus 'Humboldt State University' in every year.
assistant
SELECT T1.year , T1.faculty FROM faculty AS T1 JOIN campuses AS T2 ON T1.campus = T2.id WHERE T2.campus = 'Humboldt State University';
human
How about those in campus 'Long Beach State University'?
assistant
SELECT T1.year , T1.faculty FROM faculty AS T1 JOIN campuses AS T2 ON T1.campus = T2.id WHERE T2.campus = "Long Beach State University" ;