Find the number of students in each major.
select count(*), major from student group by major