Which major has the most students?
select major from student group by major order by count ( * ) desc limit 1
How many students are in that major?
select count ( * ) from student group by major order by count ( * ) desc limit 1
What are their names, please?
select lname,fname from student where major in ( select major from student group by major order by count ( * ) desc limit 1 )
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 )
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 )