How many students are there in each major?
select count(*), major from student group by major