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: Qual é o resultado de 2007 quando o resultado de 2010 foi 2r, no US Open?
 ###Tabelas: CREATE TABLE 4-8-4 (4-8-4_id AUTO_INCREMENT PRIMARY KEY, Class VARCHAR, Wheel arrangement VARCHAR, Fleet number(s) VARCHAR, Manufacturer VARCHAR, Serial numbers VARCHAR, Year made VARCHAR, Quantity made VARCHAR, Quantity preserved VARCHAR, Year(s) retired VARCHAR) CREATE TABLE grand_slam_women's_doubles_performance_timeline (grand_slam_women's_doubles_performance_timeline_id AUTO_INCREMENT PRIMARY KEY, Tournament VARCHAR, 2007 VARCHAR, 2010 VARCHAR, 2011 VARCHAR, 2012 VARCHAR, 2013 VARCHAR) CREATE TABLE title_holders_from_2000_until_2010 (title_holders_from_2000_until_2010_id AUTO_INCREMENT PRIMARY KEY, Year INT, Miss Universe Philippines VARCHAR, Binibining Pilipinas-World VARCHAR, Binibining Pilipinas-International VARCHAR, Binibining Pilipinas-Tourism VARCHAR, First runner-up VARCHAR, Second runner-up VARCHAR) CREATE TABLE men's_doubles:_6_4_titles_2_runner-ups (men's_doubles:_6_4_titles_2_runner-ups_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Year INT, Championship VARCHAR, Surface VARCHAR, Partner VARCHAR, Opponents in the final VARCHAR, Score in the final VARCHAR) CREATE TABLE notable_final_matches (notable_final_matches_id AUTO_INCREMENT PRIMARY KEY, Opponent VARCHAR, Res. VARCHAR, Class VARCHAR, Score VARCHAR, Date VARCHAR, Competition VARCHAR, Notes VARCHAR)  
SELECT 2007 FROM grand_slam_women's_doubles_performance_timeline WHERE 2010 = 2r AND Tournament = us open