What are all of the advisors?
select distinct advisor from student
How many advise 2 students or less?
select count(*) from (select advisor from student group by advisor having count(*) <= 2)
How many advise more than 2 students?
select count(*) from (select advisor from student group by advisor having count(*) > 2)
Please report these advisors.
select advisor from student group by advisor having count(*) > 2