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;
major has between 2 and 30 number of students refers to HAVING COUNT(Major) BETWEEN 2 AND 30; list major and the number of students refers to SELECT Major, COUNT(*)