What are the majors only less than three students are studying?
select major from student group by major having count(*) < 3