CREATE TABLE table_name_47 (date VARCHAR, opponent_in_the_final VARCHAR)

When did Adam Thompson play in the final?
SELECT date FROM table_name_47 WHERE opponent_in_the_final = "adam thompson"
SELECT "date" FROM "table_name_47" WHERE "adam thompson" = "opponent_in_the_final"