SELECT Major FROM STUDENT GROUP BY Major HAVING COUNT(*)  <  3
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 ( * ) < value
Report all majors that have less than 3 students .