Give the distinct advisors of students.
select distinct advisor from student
Which of those advises the most students?
select advisor from student group by advisor order by count(advisor) desc limit 1;
Give the count, too.
select advisor, count(*) from student group by advisor order by count(advisor) desc limit 1;