Who was the opponent in the game that was attended by 42,000 people?
CREATE TABLE table_6707 (
    "Date" text,
    "Opponent#" text,
    "Site" text,
    "Result" text,
    "Attendance" text
)
SELECT "Opponent#" FROM table_6707 WHERE "Attendance" = '42,000'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Who was the opponent in the game that was attended by 42,000 people? ### Input: CREATE TABLE table_6707 (
    "Date" text,
    "Opponent#" text,
    "Site" text,
    "Result" text,
    "Attendance" text
) ### Response: SELECT "Opponent#" FROM table_6707 WHERE "Attendance" = '42,000'