CREATE TABLE table_204_123 (id NUMBER, "week" NUMBER, "date" CLOB, "kickoff" CLOB, "opponent" CLOB, "results\ final score" CLOB, "results\ team record" CLOB, "game site" CLOB, "attendance" NUMBER)

what is the total amount of attendance between the first and second weeks ?
SELECT SUM("attendance") FROM table_204_123 WHERE "week" IN (1, 2)
SELECT SUM("attendance") FROM "table_204_123" WHERE "week" IN (1, 2)