CREATE TABLE Student (Major VARCHAR)

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