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;
Advisor with the most students refers to MAX(COUNT(student_id)); list advisor and the number of students refers to selecting Advisor and COUNT(*)