What information do you have on each advisor?
select * from student group by advisor
What is the name for each advisor?
select advisor from student group by advisor
Which of those are for advisors who have more than 1 students?
select advisor from student group by advisor having count(*) >= 2