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