user: ### NOW ANSWER:
Question: Who is the opponent in 1992?
Columns: ['Rank', 'Score', 'Player', 'Club', 'Opponent', 'Year', 'Round', 'Venue']
Types: ['text', 'text', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['1', '18.1', 'Fred Fanning', 'Melbourne', 'St Kilda', '1947', '19', 'Junction Oval']
SQL:

assistant: SELECT "Opponent" FROM "Table" WHERE "Year" = '1992';