What years had a ranking of 1?
CREATE TABLE table_name_99 (years VARCHAR, ranking VARCHAR)
SELECT years FROM table_name_99 WHERE ranking = 1
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_99 (years VARCHAR, ranking VARCHAR) Question: What years had a ranking of 1? [/INST] SELECT years FROM table_name_99 WHERE ranking = 1 </s>