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