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