What is the name of the deparment with the highest enrollment?
SELECT dept_name FROM student GROUP BY dept_name ORDER BY count(*) DESC LIMIT 1
highest enrollment refers to MAX(count(student_id)); department name refers to dept_name;