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 foi o parceiro de Bob Bryan no Campeonato onde o resultado é US Open (2)?
 ###Tabelas: CREATE TABLE number_of_operations (number_of_operations_id AUTO_INCREMENT PRIMARY KEY, Date of Sterilization VARCHAR, Age 10-19 INT, Age 20-29 INT, Age 30-39 INT, Age 40-49 INT, Age 50-59 INT, Age Unknown INT, Total INT) CREATE TABLE brazil's_15_busiest_airports_by_passenger_traffic (brazil's_15_busiest_airports_by_passenger_traffic_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Location VARCHAR, Total Passengers INT, Annual change VARCHAR, Capacity in use VARCHAR) CREATE TABLE executive_commissioners (executive_commissioners_id AUTO_INCREMENT PRIMARY KEY, Year VARCHAR, Communications and Corporate Affairs VARCHAR, Human Resources & Operations VARCHAR, Local Affairs VARCHAR, Academic & University Affairs VARCHAR, External Affairs VARCHAR) CREATE TABLE mixed_doubles:_9_7–2 (mixed_doubles:_9_7–2_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Year INT, Championship VARCHAR, Surface VARCHAR, Partner VARCHAR, Opponents VARCHAR, Score VARCHAR) CREATE TABLE number_of_championships_by_school (number_of_championships_by_school_id AUTO_INCREMENT PRIMARY KEY, University VARCHAR, Men's INT, Women's INT, Runner-up INT, Total Championships INT)  
SELECT Partner FROM mixed_doubles:_9_7–2 WHERE Championship = US Open (2)