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