CREATE TABLE table_name_17 (opponent VARCHAR2, year VARCHAR2)

Who is the opponent in 1992?
SELECT opponent FROM table_name_17 WHERE year = "1992"
SELECT "opponent" FROM "table_name_17" WHERE "1992" = "year"