SELECT count(*) ,  major FROM student GROUP BY major
Find the number of students in each major.
SELECT count ( * ) , major FROM student GROUP BY major
select count ( * ) , major from student group by major
Find the number of students in each major .