CREATE TABLE table_204_42 (id DECIMAL, "season" DECIMAL, "level" TEXT, "division" TEXT, "section" TEXT, "position" TEXT, "movements" TEXT)

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