CREATE TABLE table_203_485 (id NUMBER, "year" CLOB, "show" CLOB, "role" CLOB, "notes" CLOB)

what was the most years a show lasted ?
SELECT MAX("year" - "year") FROM table_203_485
SELECT MAX("year" - "year") FROM "table_203_485"