CREATE TABLE table_51685 ("Name" CLOB, "Rank" CLOB, "Years until mandatory retirement" CLOB, "Appointed by" CLOB, "Year appointed" FLOAT)

what rank has years until mandatory retirement of 6 years?
SELECT "Rank" FROM table_51685 WHERE "Years until mandatory retirement" = '6 years'
SELECT "Rank" FROM "table_51685" WHERE "Years until mandatory retirement" = '6 years'