user: Question: What was the rank# of the opponent when the result of the game was W42-14?
Columns: ['Date', 'Time', 'Opponent#', 'Rank #', 'Result', 'Attendance']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['09/10/1988', '9:00pm', '9 Michigan', '13', 'W19-17', '59,075']
SQL:

assistant: SELECT "Rank #" FROM "Table" WHERE "Result" = 'W42-14';