Report all majors that have less than 3 students.
CREATE TABLE STUDENT (Major VARCHAR)
SELECT Major FROM STUDENT GROUP BY Major HAVING COUNT(*) < 3
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE STUDENT (Major VARCHAR) Question: Report all majors that have less than 3 students. [/INST] SELECT Major FROM STUDENT GROUP BY Major HAVING COUNT(*) < 3 </s>