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