Which Advisor has most of students? List advisor and the number of students.
CREATE TABLE Student (Advisor VARCHAR)
SELECT TOP 1 Advisor, COUNT(*) FROM Student GROUP BY Advisor ORDER BY COUNT(Advisor) DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE Student (Advisor VARCHAR) Question: Which Advisor has most of students? List advisor and the number of students. [/INST] SELECT TOP 1 Advisor, COUNT(*) FROM Student GROUP BY Advisor ORDER BY COUNT(Advisor) DESC </s>