CREATE TABLE player (Occupation VARCHAR(255))
Show different occupations along with the number of players in each occupation.
    
SQL: SELECT Occupation, COUNT(*) FROM player GROUP BY Occupation