SELECT Advisor FROM STUDENT GROUP BY Advisor HAVING COUNT(*)  >  2
Report all advisors that advise more than 2 students.
SELECT Advisor FROM STUDENT GROUP BY Advisor HAVING COUNT ( * ) > 2
select advisor from student group by advisor having count ( * ) > value
Report all advisors that advise more than 2 students .