SELECT Advisor FROM STUDENT GROUP BY Advisor HAVING count(*)  >  2
Which advisors are advising more than 2 students?
SELECT Advisor FROM STUDENT GROUP BY Advisor HAVING count ( * ) > 2
select advisor from student group by advisor having count ( * ) > value
Which advisors are advising more than 2 students ?