What is the total credit does each department offer?
CREATE TABLE course (dept_code VARCHAR, crs_credit INTEGER)
SELECT SUM(crs_credit), dept_code FROM course GROUP BY dept_code
### Context: CREATE TABLE course (dept_code VARCHAR, crs_credit INTEGER) ### Question: What is the total credit does each department offer? ### Answer: SELECT SUM(crs_credit), dept_code FROM course GROUP BY dept_code