Which Advisor has most of students? List advisor and the number of students.
create table student (advisor varchar, PRIMARY KEY (advisor))
select advisor, count(*) from student group by advisor order by count(advisor) desc limit 1