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

how many teams had the most seasons ?
SELECT COUNT("team") FROM table_204_506 WHERE "seasons" = (SELECT MAX("seasons") FROM table_204_506)
SELECT COUNT("team") FROM "table_204_506" WHERE "seasons" = (SELECT MAX("seasons") FROM "table_204_506")