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

how many summer flag bearers have there been ?
SELECT COUNT("flag bearer") FROM table_204_266 WHERE "season" = 'summer'
SELECT COUNT("flag bearer") FROM "table_204_266" WHERE "season" = 'summer'