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

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" NULLS FIRST LIMIT 1