Show different occupations along with the number of players in each occupation.
CREATE TABLE player (Occupation VARCHAR)
SELECT Occupation, COUNT(*) FROM player GROUP BY Occupation
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE player (Occupation VARCHAR) Question: Show different occupations along with the number of players in each occupation. [/INST] SELECT Occupation, COUNT(*) FROM player GROUP BY Occupation </s>