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