SELECT count(*) ,  major FROM student GROUP BY major
How many students are there in each major?
SELECT count ( * ) , major FROM student GROUP BY major
select count ( * ) , major from student group by major
How many students are there in each major ?