How many total credits are offered?
select sum(credits) from course
Find the totals by department name.
select sum(credits), dept_name from course group by dept_name