CREATE TABLE table_201_29 (id NUMBER, "#" CLOB, "picture" CLOB, "name" CLOB, "took office" CLOB, "left office" CLOB, "party" CLOB)

which president had the shortest term without being deposed ?
SELECT "name" FROM table_201_29 ORDER BY JULIANDAY("left office") - JULIANDAY("took office") LIMIT 1
SELECT "name" FROM "table_201_29" ORDER BY JULIANDAY("left office") - JULIANDAY("took office") FETCH FIRST 1 ROWS ONLY