Which Advisor has most of students? List advisor and the number of students.
CREATE TABLE Student (Advisor VARCHAR)
SELECT Advisor, COUNT(*) FROM Student GROUP BY Advisor ORDER BY COUNT(Advisor) DESC LIMIT 1
### Context: CREATE TABLE Student (Advisor VARCHAR) ### Question: Which Advisor has most of students? List advisor and the number of students. ### Answer: SELECT Advisor, COUNT(*) FROM Student GROUP BY Advisor ORDER BY COUNT(Advisor) DESC LIMIT 1