Who is the advisor for that major?
select advisor from student where major  =   ( SELECT Major FROM STUDENT GROUP BY major ORDER BY count ( * )  DESC LIMIT 1 ) 
advisor for that major refers to selecting the advisor name from the student table where the major is the most common (or popular) among students;