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

what team had the most ch . wins during season 8 ?
SELECT "team" FROM table_204_506 WHERE "seasons" = 8 ORDER BY "ch.wins" DESC LIMIT 1
SELECT "team" FROM "table_204_506" WHERE "seasons" = 8 ORDER BY "ch.wins" DESC FETCH FIRST 1 ROWS ONLY