SELECT Major ,  count(*) FROM Student GROUP BY Major HAVING count(Major) BETWEEN 2 AND 30;
Which major has between 2 and 30 number of students? List major and the number of students.
SELECT Major , count ( * ) FROM Student GROUP BY Major HAVING count ( Major ) BETWEEN 2 AND 30 ;
select major , count ( * ) from student group by major having count ( major ) between value and value
Which major has between 2 and 30 number of students ? List major and the number of students .