CREATE TABLE table_204_986 (id NUMBER, "#" NUMBER, "event year" NUMBER, "season" CLOB, "flag bearer" CLOB)

how many years were held in summer ?
SELECT COUNT("event year") FROM table_204_986 WHERE "season" = 'summer'
SELECT COUNT("event year") FROM "table_204_986" WHERE "season" = 'summer'