Report all advisors that advise more than 2 students.
CREATE TABLE STUDENT (Advisor VARCHAR)
SELECT Advisor FROM STUDENT GROUP BY Advisor HAVING COUNT(*) > 2
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE STUDENT (Advisor VARCHAR) Question: Report all advisors that advise more than 2 students. [/INST] SELECT Advisor FROM STUDENT GROUP BY Advisor HAVING COUNT(*) > 2 </s>