What is the total credits of all courses?
select sum(crs_credit) from course
Give the number for each department.
select sum(crs_credit), dept_code from course group by dept_code