SELECT sum(crs_credit) ,  dept_code FROM course GROUP BY dept_code
What is the total credit does each department offer?
SELECT sum ( crs_credit ) , dept_code FROM course GROUP BY dept_code
select sum ( crs_credit ) , dept_code from course group by dept_code
What is the total credit does each department offer ?