CREATE TABLE STUDENT (Major VARCHAR2)

Report all majors that have less than 3 students.
SELECT Major FROM STUDENT GROUP BY Major HAVING COUNT(*) < 3
SELECT "Major" FROM "STUDENT" GROUP BY "Major" HAVING COUNT(*) < 3