Show all advisors and corresponding number of students.
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: Show all advisors and corresponding number of students. [/INST] SELECT advisor, COUNT(*) FROM Student GROUP BY advisor </s>