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: Nomeie o parceiro para 14 de outubro de 2007.
 ###Tabelas: CREATE TABLE doubles:_15_8–7 (doubles:_15_8–7_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Date VARCHAR, Surface VARCHAR, Partner VARCHAR, Opponents VARCHAR, Score VARCHAR) CREATE TABLE entries (entries_id AUTO_INCREMENT PRIMARY KEY, Driver VARCHAR, Entrant VARCHAR, Constructor VARCHAR, Chassis VARCHAR, Engine VARCHAR, Tyre VARCHAR) CREATE TABLE 2008_ladder (2008_ladder_id AUTO_INCREMENT PRIMARY KEY, Mininera DFL VARCHAR, Wins INT, Byes INT, Losses INT, Draws INT, Against INT) CREATE TABLE composition_of_the_6th_seanad (composition_of_the_6th_seanad_id AUTO_INCREMENT PRIMARY KEY, Administrative Panel INT, Agricultural Panel INT, Cultural and Educational Panel INT, Industrial and Commercial Panel INT, Labour Panel INT, National University of Ireland INT, University of Dublin INT, Nominated by the Taoiseach INT, Total INT) CREATE TABLE 2011_junior_manx_grand_prix_practice_times__&__leaderboard (2011_junior_manx_grand_prix_practice_times__&__leaderboard_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Rider VARCHAR, Sat 20 Aug VARCHAR, Mon 22 Aug VARCHAR, Tues 23 Aug VARCHAR, Wed 24 Aug VARCHAR, Thurs 25 Aug VARCHAR, Fri 26 Aug VARCHAR)  
SELECT Partner FROM doubles:_15_8–7 WHERE Date = 14 october 2007