What are the different majors?
select distinct major from student
How many students does each major has?
select major, count(*) from student group by major
Which one has the most students?
select major from student group by major order by count(*) desc limit 1