CREATE TABLE table_203_89 (id NUMBER, "#" NUMBER, "name\ ( birth-death ) " CLOB, "took office" CLOB, "left office" CLOB, "monarch" CLOB, "prime minister" CLOB)

which governor served for the least number of years ?
SELECT "name\n(birth-death)" FROM table_203_89 ORDER BY "left office" - "took office" LIMIT 1
SELECT "name\n(birth-death)" FROM "table_203_89" ORDER BY "left office" - "took office" FETCH FIRST 1 ROWS ONLY