I want to know advisor with the most number of students
select advisor from student group by advisor order by count ( * ) desc limit 1
What about the advisor with the least number of students
select advisor from student group by advisor order by count ( * ) asc limit 1
Could you tell me the names of both advisors with the most and the least number of students?
select advisor from student where advisor = ( select advisor from student group by advisor order by count ( * ) asc limit 1 ) or advisor = ( select advisor from student group by advisor order by count ( * ) desc limit 1 ) group by advisor