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

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