CREATE TABLE table_203_671 (id NUMBER, "name" CLOB, "rank" CLOB, "age" NUMBER, "years until mandatory retirement" CLOB, "appointed by" CLOB, "year appointed" NUMBER)

who has the least number of years until their mandatory retirement ?
SELECT "name" FROM table_203_671 ORDER BY "years until mandatory retirement" LIMIT 1
SELECT "name" FROM "table_203_671" ORDER BY "years until mandatory retirement" FETCH FIRST 1 ROWS ONLY