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