CREATE TABLE table_204_186 (id NUMBER, "season" CLOB, "tier" NUMBER, "division" CLOB, "place" CLOB)

how many seasons are there ?
SELECT COUNT("season") FROM table_204_186
SELECT COUNT("season") FROM "table_204_186"