How many students are there?
select count(*) from student
Count this by department.
select count(*), dept_name from student group by dept_name