SELECT sum(credits) ,  dept_name FROM course GROUP BY dept_name
Find the total credits of courses provided by different department.
SELECT sum ( credits ) , dept_name FROM course GROUP BY dept_name
select sum ( credits ) , dept_name from course group by dept_name
Find the total credits of courses provided by different department .