Report all majors that have less than 3 students.
CREATE TABLE STUDENT (Major VARCHAR)
SELECT Major FROM STUDENT GROUP BY Major HAVING COUNT(*) < 3
### Context: CREATE TABLE STUDENT (Major VARCHAR) ### Question: Report all majors that have less than 3 students. ### Answer: SELECT Major FROM STUDENT GROUP BY Major HAVING COUNT(*) < 3