Who are the advisors of the students?
select advisor from student
Order the advisors by the number of students they have.
select advisor from student group by advisor order by count(*)
Who has the most?
select advisor from student group by advisor order by count(*) desc limit 1