How many credits does the department offer?
select sum(crs_credit), dept_code from course group by dept_code