Number of students in each major?
select major, count ( * ) from student group by major
List of majors?
select distinct ( major ) from student
LName.
select major, lname from student
What about FName?
select major, fname from student
Which major has the most number of students?
select major from student group by major order by count ( * ) desc limit 1
Which major has the least?
select major from student group by major order by count ( * ) asc limit 1