Who is the advisor for the major with the second most number of students?
select advisor from student where major in  ( SELECT Major FROM STUDENT GROUP BY major ORDER BY count ( * )  DESC LIMIT 2 )  and major ! =   ( SELECT Major FROM STUDENT GROUP BY major ORDER BY count ( * )  DESC LIMIT 1 ) 
advisor for the major with the second most number of students refers to selecting the advisor associated with the major that ranks second in terms of student count;