List major and number of students for majors with 2 to 30 number of students
select major, count ( * ) from student group by major having count ( major ) between 2 and 30
Which majors have between 2 and 20 students? Show me major and number of students
select major, count ( * ) from student group by major having count ( major ) between 2 and 20