Database: dorm_1
Question: How many students are there in each major?
SQL:
SELECT count(*) ,  major FROM student GROUP BY major