CREATE TABLE restaurant (resid NUMBER, resname CLOB, address CLOB, rating NUMBER)
CREATE TABLE restaurant_type (restypeid NUMBER, restypename CLOB, restypedescription CLOB)
CREATE TABLE type_of_restaurant (resid NUMBER, restypeid NUMBER)
CREATE TABLE visits_restaurant (stuid NUMBER, resid NUMBER, time TIME, spent NUMBER)
CREATE TABLE student (stuid NUMBER, lname CLOB, fname CLOB, age NUMBER, sex CLOB, major NUMBER, advisor NUMBER, city_code CLOB)

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