SELECT Advisor ,  count(*) FROM Student GROUP BY Advisor ORDER BY count(Advisor) DESC LIMIT 1;
Which Advisor has most of students? List advisor and the number of students.
SELECT Advisor , count ( * ) FROM Student GROUP BY Advisor ORDER BY count ( Advisor ) DESC LIMIT 1 ;
select advisor , count ( * ) from student group by advisor order by count ( advisor ) desc limit value
Which Advisor has most of students ? List advisor and the number of students .