What are the total number of credits offered by each department?
SELECT sum(T1.crs_credit) ,  T1.dept_code FROM course AS T1 JOIN CLASS AS T2 ON T1.crs_code  =  T2.crs_code GROUP BY T1.dept_code
SELECT sum(T1.crs_credit) ,  T1.dept_code FROM course AS T1 JOIN CLASS AS T2 ON T1.crs_code  =  T2.crs_code GROUP BY T1.dept_code
[{'sum(T1.crs_credit)': 15.0, 'DEPT_CODE': 'ACCT'}, {'sum(T1.crs_credit)': 27.0, 'DEPT_CODE': 'CIS'}]