Table schema:
CREATE TABLE course (dept_code VARCHAR, crs_credit INTEGER)

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