How many credits does the department offer?
SELECT sum(crs_credit) ,  dept_code FROM course GROUP BY dept_code
SELECT sum(crs_credit) ,  dept_code FROM course GROUP BY dept_code
[{'sum(crs_credit)': 6.0, 'DEPT_CODE': 'ACCT'}, {'sum(crs_credit)': 14.0, 'DEPT_CODE': 'CIS'}]