When did Adam Thompson play in the final?
CREATE TABLE table_name_47 (date VARCHAR, opponent_in_the_final VARCHAR)
SELECT date FROM table_name_47 WHERE opponent_in_the_final = "adam thompson"
### Context: CREATE TABLE table_name_47 (date VARCHAR, opponent_in_the_final VARCHAR) ### Question: When did Adam Thompson play in the final? ### Answer: SELECT date FROM table_name_47 WHERE opponent_in_the_final = "adam thompson"