SELECT advisor FROM Student GROUP BY advisor HAVING count(*)  >=  2
Show all advisors who have at least two students.
SELECT advisor FROM Student GROUP BY advisor HAVING count ( * ) > = 2
select advisor from student group by advisor having count ( * ) > = value
Show all advisors who have at least two students .