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 2 AND 30;
[{'Major': 50, 'count(*)': 2}, {'Major': 520, 'count(*)': 6}, {'Major': 540, 'count(*)': 2}, {'Major': 550, 'count(*)': 5}, {'Major': 600, 'count(*)': 18}]