Show all majors and corresponding number of students.
select major, count(*) from student group by major