How many students are in that major?
SELECT count ( * )  FROM STUDENT GROUP BY major ORDER BY count ( * )  DESC LIMIT 1
How many students in the major refers to COUNT(*); that major implies grouping by major;