Find the total credits of courses provided by different department.
CREATE TABLE course (dept_name VARCHAR, credits INTEGER)
SELECT SUM(credits), dept_name FROM course GROUP BY dept_name
<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 total credits of courses provided by different department. [/INST] SELECT SUM(credits), dept_name FROM course GROUP BY dept_name </s>