CREATE TABLE table_203_407 (id NUMBER, "name" CLOB, "party" CLOB, "province" CLOB, "term expires" NUMBER, "years in office" CLOB)

who has had the shortest term in office
SELECT "name" FROM table_203_407 ORDER BY "years in office" - "years in office" LIMIT 1
SELECT "name" FROM "table_203_407" ORDER BY "years in office" - "years in office" FETCH FIRST 1 ROWS ONLY