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