In which year were most departments established?
CREATE TABLE department (creation VARCHAR)
SELECT TOP 1 creation FROM department GROUP BY creation ORDER BY COUNT(*) DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE department (creation VARCHAR) Question: In which year were most departments established? [/INST] SELECT TOP 1 creation FROM department GROUP BY creation ORDER BY COUNT(*) DESC </s>