CREATE TABLE table_203_485 (id DECIMAL, "year" TEXT, "show" TEXT, "role" TEXT, "notes" TEXT)

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