Find the number of students in each major.
CREATE TABLE student (major VARCHAR)
SELECT COUNT(*), major FROM student GROUP BY major
### Context: CREATE TABLE student (major VARCHAR) ### Question: Find the number of students in each major. ### Answer: SELECT COUNT(*), major FROM student GROUP BY major