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 era Dainty June quando Tammy Blanchard era Louise?
 ###Tabelas: 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) CREATE TABLE popularity_of_terrestrial_tv_stations (popularity_of_terrestrial_tv_stations_id AUTO_INCREMENT PRIMARY KEY, TV Station (Operator) VARCHAR, 2005 INT, 2006 INT, 2007 INT, 2008 INT, 2009 INT, 2010 INT, 2011 1H INT) CREATE TABLE nine_pieces (nine_pieces_id AUTO_INCREMENT PRIMARY KEY, Standard order INT, English translation VARCHAR, Transcription (based on Pinyin) VARCHAR, Traditional Chinese VARCHAR, Simplified Chinese VARCHAR) CREATE TABLE stage_casts (stage_casts_id AUTO_INCREMENT PRIMARY KEY, Productions VARCHAR, Rose VARCHAR, Louise VARCHAR, Dainty June VARCHAR, Herbie VARCHAR, Director VARCHAR) CREATE TABLE appearances_through_the_2011-12_season (appearances_through_the_2011-12_season_id AUTO_INCREMENT PRIMARY KEY, Seasons INT, Team VARCHAR, Ch.Wins INT, Promotions INT, Relegations INT)  
SELECT Dainty June FROM stage_casts WHERE Louise = tammy blanchard