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
can you show me campuses years?
assistant
SELECT Year FROM Campuses;
human
can you show me campuses county?
assistant
SELECT County FROM Campuses;
human
can you show me a list of degrees?
assistant
SELECT * FROM degrees;
human
how many faculty lines are there in the university that conferred the least number of degrees in year 2001?
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 = 2001 ORDER BY t3.degrees LIMIT 1 ;