SELECT Advisor FROM STUDENT GROUP BY Advisor HAVING count(*)  >  2
Report the distinct advisors who have 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 the distinct advisors who have more than 2 students .