List codes of all courses and their credits.
select crs_credit, crs_code from course
What is the total number of credits for each department?
select sum(t1.crs_credit), t1.dept_code from course as t1 join class as t2 on t1.crs_code = t2.crs_code group by t1.dept_code