How many total credits are offered by each department?
select sum(credits), dept_name from course group by dept_name