CREATE TABLE table_204_707 (id NUMBER, "year" NUMBER, "english title" CLOB, "chinese title" CLOB, "director" CLOB, "role" CLOB)

what is the difference in years between his last role and his first role ?
SELECT MAX("year") - MIN("year") FROM table_204_707
SELECT MAX("year") - MIN("year") FROM "table_204_707"