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
Which major has highest number of students?List the students First name?
select major, fname from student where major = ( select major from student group by major order by count ( * ) desc limit 1 )
Which major has least number of students?List the students First name?
select major, fname from student where major = ( select major from student group by major order by count ( * ) asc limit 1 )