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
Find the total credits of all classes 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
Find the total credits of all classes offered by each department .