CREATE TABLE table_203_372 (id NUMBER, "from" NUMBER, "to" NUMBER, "name" CLOB, "party" CLOB, "position" NUMBER)

who served the most years as mayor ?
SELECT "name" FROM table_203_372 ORDER BY "to" - "from" DESC LIMIT 1
SELECT "name" FROM "table_203_372" ORDER BY "to" - "from" DESC FETCH FIRST 1 ROWS ONLY