what rank has years until mandatory retirement of 6 years?
CREATE TABLE table_name_55 (rank VARCHAR, years_until_mandatory_retirement VARCHAR)
SELECT rank FROM table_name_55 WHERE years_until_mandatory_retirement = "6 years"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_55 (rank VARCHAR, years_until_mandatory_retirement VARCHAR) Question: what rank has years until mandatory retirement of 6 years? [/INST] SELECT rank FROM table_name_55 WHERE years_until_mandatory_retirement = "6 years" </s>