CREATE TABLE table_204_523 (id NUMBER, "week" NUMBER, "date" CLOB, "opponent" CLOB, "score" CLOB, "result" CLOB, "attendance" NUMBER, "record" CLOB)

tell me the number of people that attended the first game they won in october .
SELECT "attendance" FROM table_204_523 WHERE "result" = 'win' AND "date" = 10 ORDER BY "date" LIMIT 1
SELECT "attendance" FROM "table_204_523" WHERE "date" = 10 AND "result" = 'win' ORDER BY "date" FETCH FIRST 1 ROWS ONLY