Find the number of students in each major.
SELECT count(*) ,  major FROM student GROUP BY major
SELECT count(*) ,  major FROM student GROUP BY major
[{'count(*)': 2, 'Major': 50}, {'count(*)': 1, 'Major': 100}, {'count(*)': 6, 'Major': 520}, {'count(*)': 2, 'Major': 540}, {'count(*)': 5, 'Major': 550}, {'count(*)': 18, 'Major': 600}]