How many students are in each department?
select count(*), dept_code from student group by dept_code