Find the name of the department that offers the highest total credits?
CREATE TABLE course (dept_name VARCHAR, credits INTEGER)
SELECT TOP 1 dept_name FROM course GROUP BY dept_name ORDER BY SUM(credits) DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE course (dept_name VARCHAR, credits INTEGER) Question: Find the name of the department that offers the highest total credits? [/INST] SELECT TOP 1 dept_name FROM course GROUP BY dept_name ORDER BY SUM(credits) DESC </s>