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 parceiro tem uma pontuação de 6-7, 7-6, 6-7?
 ###Tabelas: CREATE TABLE current_membership (current_membership_id AUTO_INCREMENT PRIMARY KEY, School VARCHAR, Location VARCHAR, Mascot VARCHAR, Colors VARCHAR, Enrollment INT, IHSA Classes 2/3/4 VARCHAR, IHSA Music Class VARCHAR, IHSA Football Class VARCHAR, IHSA Cheerleading Class VARCHAR) CREATE TABLE record_vs._other_most-played_di_opponents (record_vs._other_most-played_di_opponents_id AUTO_INCREMENT PRIMARY KEY, Kansas State vs. VARCHAR, Games played INT, Overall Record VARCHAR, Last 5 Meetings VARCHAR, Last 10 Meetings VARCHAR, Current Streak VARCHAR, Last Meeting VARCHAR) CREATE TABLE house_of_rohan-chabot (house_of_rohan-chabot_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Birth VARCHAR, Marriage VARCHAR, Became Duke VARCHAR, Ceased to be Duke VARCHAR, Death VARCHAR, Spouse VARCHAR) CREATE TABLE 2000:_indiana_fever_miami_sol_portland_fire_seattle_storm (2000:_indiana_fever_miami_sol_portland_fire_seattle_storm_id AUTO_INCREMENT PRIMARY KEY, Pick INT, Player VARCHAR, Nationality VARCHAR, New WNBA Team VARCHAR, Former WNBA Team VARCHAR, College/Country/Team VARCHAR) CREATE TABLE doubles:_9_6_titles_–_3_runner-ups (doubles:_9_6_titles_–_3_runner-ups_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Date VARCHAR, Tournament VARCHAR, Surface VARCHAR, Partner VARCHAR, Opponents VARCHAR, Score VARCHAR)  
SELECT Partner FROM doubles:_9_6_titles_–_3_runner-ups WHERE Score = 6–7, 7–6, 6–7