What is the total credit does each department offer?
SELECT sum(crs_credit) ,  dept_code FROM course GROUP BY dept_code
total credit offered by each department refers to SUM(crs_credit) GROUPED BY dept_code;