user: ### NOW ANSWER:
Question: Who was the opponent in the game that was attended by 42,000 people?
Columns: ['Date', 'Opponent#', 'Site', 'Result', 'Attendance']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['10/02/1926', 'North Dakota', 'Memorial Stadium • Minneapolis, MN', 'W51-0', '18,000']
SQL:

assistant: SELECT "Opponent#" FROM "Table" WHERE "Attendance" = '42,000';