SELECT major ,  count(*) FROM Student GROUP BY major
How many students are there for each major?
SELECT major , count ( * ) FROM Student GROUP BY major
select major , count ( * ) from student group by major
How many students are there for each major ?