For each department, how many students does it have?
select count(*), dept_code from student group by dept_code
For each department, what is the total hours worked by those students?
select sum(stu_hrs), dept_code from student group by dept_code