SELECT sum(stu_hrs) ,  dept_code FROM student GROUP BY dept_code
How many hours do the students spend studying in each department?
SELECT sum ( stu_hrs ) , dept_code FROM student GROUP BY dept_code
select sum ( stu_hrs ) , dept_code from student group by dept_code
How many hours do the students spend studying in each department ?