Which year has the most degrees conferred?
CREATE TABLE degrees (YEAR VARCHAR, degrees INTEGER)
SELECT TOP 1 YEAR FROM degrees GROUP BY YEAR ORDER BY SUM(degrees) DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE degrees (YEAR VARCHAR, degrees INTEGER) Question: Which year has the most degrees conferred? [/INST] SELECT TOP 1 YEAR FROM degrees GROUP BY YEAR ORDER BY SUM(degrees) DESC </s>