Table schema:
CREATE TABLE player (Occupation VARCHAR)

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