CREATE TABLE table_203_559 (id NUMBER, "no." NUMBER, "name" CLOB, "took office" CLOB, "left office" CLOB, "president served under" CLOB, "notable for" CLOB)

who was in office for the least amount of time ?
SELECT "name" FROM table_203_559 ORDER BY "left office" - "took office" LIMIT 1
SELECT "name" FROM "table_203_559" ORDER BY "left office" - "took office" FETCH FIRST 1 ROWS ONLY