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

against which opponent were there the most people in attendance ?
SELECT "opponent" FROM table_203_478 ORDER BY "attendance" DESC LIMIT 1
SELECT "opponent" FROM "table_203_478" ORDER BY "attendance" DESC FETCH FIRST 1 ROWS ONLY