Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: Quem eram os parceiros durante os tempos em que Harry Johnson Hazel Hotchkiss Wightman era o oponente?
 ###Tabelas: CREATE TABLE typical_values_of_sfc_for_thrust_engines (typical_values_of_sfc_for_thrust_engines_id AUTO_INCREMENT PRIMARY KEY, Engine type VARCHAR, Scenario VARCHAR, SFC in lb/(lbf·h) INT, SFC in g/(kN·s) INT, Specific impulse (s) INT, Effective exhaust velocity (m/s) INT) CREATE TABLE negotiation_progress (negotiation_progress_id AUTO_INCREMENT PRIMARY KEY, Screening Started VARCHAR, Screening Completed VARCHAR, Chapter Unfrozen VARCHAR, Chapter Opened VARCHAR, Chapter Closed VARCHAR) CREATE TABLE mixed_doubles:_8_3_titles_5_runner-ups (mixed_doubles:_8_3_titles_5_runner-ups_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Year INT, Championship VARCHAR, Surface VARCHAR, Partner VARCHAR, Opponents VARCHAR, Score VARCHAR) CREATE TABLE assembly_plants (assembly_plants_id AUTO_INCREMENT PRIMARY KEY, Company VARCHAR, Parent company VARCHAR, Parent headquarters VARCHAR, Plant VARCHAR, Models produced VARCHAR, Production (latest figures) VARCHAR) CREATE TABLE 2005–present (2005–present_id AUTO_INCREMENT PRIMARY KEY, Season INT, Player VARCHAR, Club VARCHAR, Goals INT, Games INT, Rate INT)  
SELECT Partner FROM mixed_doubles:_8_3_titles_5_runner-ups WHERE Opponents = Harry Johnson Hazel Hotchkiss Wightman