Find the name of department has the highest amount of students?
SELECT dept_name FROM student GROUP BY dept_name ORDER BY count(*) DESC LIMIT 1
department with the highest amount of students refers to MAX(COUNT(student_id));