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