Database: college_1
Question: What is the total credit does each department offer?
SQL:
SELECT sum(crs_credit) ,  dept_code FROM course GROUP BY dept_code