What is the total credit does each department offer?
select sum(crs_credit), dept_code from course group by dept_code