CREATE TABLE course (dept_code VARCHAR(255), crs_credit INTEGER)
What is the total credit does each department offer?
    
SQL: SELECT SUM(crs_credit), dept_code FROM course GROUP BY dept_code