SCHEMA:
CREATE TABLE Student (major VARCHAR)
User Question:
Show all majors and corresponding number of students.


SELECT major, COUNT(*) FROM Student GROUP BY major