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