Report all majors.
select distinct major from student
Report the number of students per major as well.
select major, count(*) from student group by major
Order the majors by decreasing number of students.
select major, count(*) from student group by major order by count(*) desc
Which major has the most students?
select major from student group by major order by count(*) desc limit 1