which year holds rank 2?
CREATE TABLE table_name_89 (year INTEGER, rank VARCHAR)
SELECT MAX(year) FROM table_name_89 WHERE rank = "2"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_89 (year INTEGER, rank VARCHAR) Question: which year holds rank 2? [/INST] SELECT MAX(year) FROM table_name_89 WHERE rank = "2" </s>