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