Table schema:
CREATE TABLE Student (major VARCHAR)

Question: Show all majors and corresponding number of students.
SQL: SELECT major, COUNT(*) FROM Student GROUP BY major