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