Table schema:
CREATE TABLE student (major VARCHAR)

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