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 é o diretor de Glendale com Greg Smorel como diretor de ensino fundamental e Joleen Reinholz como diretora de ensino médio durante 2006-2007?
 ###Tabelas: CREATE TABLE episodes_and_ratings (episodes_and_ratings_id AUTO_INCREMENT PRIMARY KEY, Episode INT, First broadcast Denmark ( DR1 ) VARCHAR, Official TNS Gallup ratings INT, First broadcast UK ( BBC Four ) VARCHAR, Official BARB ratings INT) CREATE TABLE list_of_sherbrooke_boroughs (list_of_sherbrooke_boroughs_id AUTO_INCREMENT PRIMARY KEY, Borough VARCHAR, Components VARCHAR, Population INT, Number of Borough Councilors INT, Number of Municipal Councilors INT) CREATE TABLE internet_availability (internet_availability_id AUTO_INCREMENT PRIMARY KEY, Nation VARCHAR, Population (thousands) INT, Internet subscriptions (2000) (thousands of users) INT, Internet subscriptions (2008) (thousands of users) INT, % growth (2000–2008) INT, % Internet users INT) CREATE TABLE district_administration (district_administration_id AUTO_INCREMENT PRIMARY KEY, Year VARCHAR, Superintendent VARCHAR, Glendale Principal VARCHAR, H.H. Principal VARCHAR, Maplemere Principal VARCHAR, W.R. Principal VARCHAR, M.S. Principal VARCHAR, H.S. Principal VARCHAR, H. S. Asst. Principal VARCHAR) CREATE TABLE north_carolina_counties_ranked_by_per_capita_income (north_carolina_counties_ranked_by_per_capita_income_id AUTO_INCREMENT PRIMARY KEY, County VARCHAR, Per capita income VARCHAR, Median household income VARCHAR, Median family income VARCHAR, Population INT, Number of households INT)  
SELECT Glendale Principal FROM district_administration WHERE M.S. Principal = greg smorel AND H.S. Principal = joleen reinholz AND Year = 2006-2007