Name the highest year with rank of 22 and accolade of singles of 1999
CREATE TABLE table_name_89 (year INTEGER, accolade VARCHAR, rank VARCHAR)
SELECT MAX(year) FROM table_name_89 WHERE accolade = "singles of 1999" AND rank = "22"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_89 (year INTEGER, accolade VARCHAR, rank VARCHAR) Question: Name the highest year with rank of 22 and accolade of singles of 1999 [/INST] SELECT MAX(year) FROM table_name_89 WHERE accolade = "singles of 1999" AND rank = "22" </s>