How many total credits are offered by each department?
SELECT sum(credits) ,  dept_name FROM course GROUP BY dept_name
SELECT sum(credits) ,  dept_name FROM course GROUP BY dept_name
[{'sum(credits)': 40, 'dept_name': 'Accounting'}, {'sum(credits)': 37, 'dept_name': 'Astronomy'}, {'sum(credits)': 30, 'dept_name': 'Athletics'}, {'sum(credits)': 23, 'dept_name': 'Biology'}, {'sum(credits)': 34, 'dept_name': 'Civil Eng.'}, {'sum(credits)': 37, 'dept_name': 'Comp. Sci.'}, {'sum(credits)': 67, 'dept_name': 'Cybernetics'}, {'sum(credits)': 28, 'dept_name': 'Elec. Eng.'}, {'sum(credits)': 28, 'dept_name': 'English'}, {'sum(credits)': 49, 'dept_name': 'Finance'}, {'sum(credits)': 33, 'dept_name': 'Geology'}, {'sum(credits)': 29, 'dept_name': 'History'}, {'sum(credits)': 37, 'dept_name': 'Languages'}, {'sum(credits)': 20, 'dept_name': 'Marketing'}, {'sum(credits)': 34, 'dept_name': 'Math'}, {'sum(credits)': 40, 'dept_name': 'Mech. Eng.'}, {'sum(credits)': 38, 'dept_name': 'Physics'}, {'sum(credits)': 23, 'dept_name': 'Pol. Sci.'}, {'sum(credits)': 44, 'dept_name': 'Psychology'}, {'sum(credits)': 21, 'dept_name': 'Statistics'}]