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
Hello! Can you show me a list of all of the years for which there is data?
assistant
SELECT DISTINCT YEAR FROM degrees;
human
Thank you! Can you update this list to include how many degrees were conferred each year?
assistant
SELECT SUM( degrees ) , YEAR FROM degrees GROUP BY YEAR ;