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 a escola dos amigos?
 ###Tabelas: CREATE TABLE game_summaries (game_summaries_id AUTO_INCREMENT PRIMARY KEY, Date VARCHAR, Visiting team VARCHAR, Home team VARCHAR, Stadium VARCHAR, Regular season / Preseason VARCHAR) CREATE TABLE nielsen_ratings_broadcast_history (nielsen_ratings_broadcast_history_id AUTO_INCREMENT PRIMARY KEY, Season INT, Premiere VARCHAR, Finale VARCHAR, Rank VARCHAR, Rating VARCHAR) CREATE TABLE oceania_and_maritime_southeast_asia (oceania_and_maritime_southeast_asia_id AUTO_INCREMENT PRIMARY KEY, Perpetrator VARCHAR, Location VARCHAR, Country VARCHAR, Killed INT, Injured VARCHAR) CREATE TABLE new_mexico_counties_ranked_by_per_capita_income (new_mexico_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) CREATE TABLE current_member_schools (current_member_schools_id AUTO_INCREMENT PRIMARY KEY, School VARCHAR, Location VARCHAR, Enrolment INT, Founded INT, Denomination VARCHAR, Boys/Girls VARCHAR, Day/Boarding VARCHAR, School Colors VARCHAR)  
SELECT Location FROM current_member_schools WHERE School = the friends' school