CREATE TABLE table_204_42 (id NUMBER, "season" NUMBER, "level" CLOB, "division" CLOB, "section" CLOB, "position" CLOB, "movements" CLOB)

how long have they been playing ?
SELECT MAX("season") - MIN("season") FROM table_204_42
SELECT MAX("season") - MIN("season") FROM "table_204_42"