How many credits does each department offer?
select dept_name, sum(credits) from course group by dept_name
What is the name of the department which offers the most?
select dept_name from course group by dept_name order by sum(credits) desc limit 1