Which major has between 2 and 30 number of students? List major and the number of students.
create table student (major varchar, PRIMARY KEY (major))
select major, count(*) from student group by major having count(major) between 2 and 30