CREATE TABLE table_6707 ("Date" CLOB, "Opponent#" CLOB, "Site" CLOB, "Result" CLOB, "Attendance" CLOB)

Who was the opponent in the game that was attended by 42,000 people?
SELECT "Opponent#" FROM table_6707 WHERE "Attendance" = '42,000'
SELECT "Opponent#" FROM "table_6707" WHERE "Attendance" = '42,000'