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