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