CREATE TABLE table_203_790 (id NUMBER, "week" NUMBER, "date" CLOB, "opponent" CLOB, "result" CLOB, "attendance" NUMBER)

was attendance higher week 4 or week 8 ?
SELECT "week" FROM table_203_790 WHERE "week" IN (4, 8) ORDER BY "attendance" DESC LIMIT 1
SELECT "week" FROM "table_203_790" WHERE "week" IN (4, 8) ORDER BY "attendance" DESC FETCH FIRST 1 ROWS ONLY