CREATE TABLE table_204_506 (id NUMBER, "seasons" NUMBER, "team" CLOB, "ch.wins" NUMBER, "promotions" NUMBER, "relegations" NUMBER)

which three teams have been playing for the most seasons ?
SELECT "team" FROM table_204_506 WHERE "seasons" = (SELECT MAX("seasons") FROM table_204_506)
SELECT "team" FROM "table_204_506" WHERE "seasons" = (SELECT MAX("seasons") FROM "table_204_506")