Find the total credits of courses provided by different department.
SELECT sum(credits) ,  dept_name FROM course GROUP BY dept_name
total credits of courses = SUM(credits); provided by different department = GROUP BY dept_name;