SELECT sum(credits) ,  dept_name FROM course GROUP BY dept_name
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
How many total credits are offered by each department ?