CREATE TABLE student (major VARCHAR(255))
Find the number of students in each major.
    
SQL: SELECT COUNT(*), major FROM student GROUP BY major