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;
human
Thanks! Lastly, (I am about to run out of time) can you filter that list to show me which year had the most degrees conferred?
assistant
SELECT YEAR FROM degrees GROUP BY YEAR ORDER BY SUM( degrees ) DESC LIMIT 1 ;