Database: college_1
Question: How many credits does the department offer?
SQL:
SELECT sum(crs_credit) ,  dept_code FROM course GROUP BY dept_code