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