SELECT Major FROM STUDENT GROUP BY Major HAVING COUNT(*)  <  3
What are the majors only less than three students are studying?
SELECT Major FROM STUDENT GROUP BY Major HAVING COUNT ( * ) < 3
select major from student group by major having count ( * ) < value
What are the majors only less than three students are studying ?