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

tell me the number of summer olympics on the list .
SELECT COUNT(*) FROM table_204_266 WHERE "season" = 'summer'
SELECT COUNT(*) FROM "table_204_266" WHERE "season" = 'summer'