How many students are in each department?
select dept_name, count(*) from student group by dept_name
What is the name of the department with the most?
select dept_name from student group by dept_name order by count(*) desc limit 1