Find the total credits of courses provided by different department.
select sum(credits), dept_name from course group by dept_name