SELECT major, COUNT(*) AS number_of_players  FROM football_players GROUP BY major;

SELECT major, COUNT(*) AS number_of_players FROM football_players WHERE major = 'CSCI'  GROUP BY major;