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