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: Onde fica o vale dos pinheiros?
 ###Tabelas: CREATE TABLE percussion_scholastic_concert_world_class (percussion_scholastic_concert_world_class_id AUTO_INCREMENT PRIMARY KEY, Ensemble VARCHAR, Gold Medals INT, Silver Medals INT, Bronze Medals INT, Total Medals INT) CREATE TABLE list_of_recent_lower_tier_county_cup_south_winners (list_of_recent_lower_tier_county_cup_south_winners_id AUTO_INCREMENT PRIMARY KEY, Season VARCHAR, Junior (South) Winners VARCHAR, Intermediate (South) Winners VARCHAR, Minor (South) Winners VARCHAR, Primary (South) Winners VARCHAR) CREATE TABLE all-time_medal_table (all-time_medal_table_id AUTO_INCREMENT PRIMARY KEY, Nation VARCHAR, Gold INT, Silver INT, Bronze INT, Total INT) CREATE TABLE results_by_ward (results_by_ward_id AUTO_INCREMENT PRIMARY KEY, Ward VARCHAR, Bello VARCHAR, Ben-Tahir VARCHAR, Doucet VARCHAR, Furtenbacher VARCHAR, Gauthier VARCHAR, Haydon VARCHAR, Larter VARCHAR, Lawrance VARCHAR, Libweshya VARCHAR, Liscumb VARCHAR) CREATE TABLE top_100_in_the_united_states (top_100_in_the_united_states_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Name VARCHAR, Location VARCHAR, State VARCHAR, Designer, Year VARCHAR)  
SELECT Location FROM top_100_in_the_united_states WHERE Name = pine valley