For each advisor, report the total number of students advised by him or her.
CREATE TABLE STUDENT (Advisor VARCHAR)
SELECT Advisor, COUNT(*) FROM STUDENT GROUP BY Advisor
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE STUDENT (Advisor VARCHAR) Question: For each advisor, report the total number of students advised by him or her. [/INST] SELECT Advisor, COUNT(*) FROM STUDENT GROUP BY Advisor </s>