Please show the most common occupation of players.
CREATE TABLE player (Occupation VARCHAR)
SELECT TOP 1 Occupation FROM player GROUP BY Occupation ORDER BY COUNT(*) DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE player (Occupation VARCHAR) Question: Please show the most common occupation of players. [/INST] SELECT TOP 1 Occupation FROM player GROUP BY Occupation ORDER BY COUNT(*) DESC </s>