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: Qual é a localização do distrito de Salem?
 ###Tabelas: CREATE TABLE postseason_game_log (postseason_game_log_id AUTO_INCREMENT PRIMARY KEY, Game INT, Date VARCHAR, Opponent VARCHAR, Score VARCHAR, Loss VARCHAR, Save VARCHAR, Attendance INT, Record VARCHAR) CREATE TABLE tamil_nadu_government_allopathic_western_medical_colleges (tamil_nadu_government_allopathic_western_medical_colleges_id AUTO_INCREMENT PRIMARY KEY, College Name VARCHAR, Location VARCHAR, District VARCHAR, Affiliation VARCHAR, Estd VARCHAR) CREATE TABLE most-visited_countries_by_international_tourist_arrivals (most-visited_countries_by_international_tourist_arrivals_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Country VARCHAR, UNWTO Region VARCHAR, International tourist arrivals (2012) VARCHAR, International tourist arrivals (2011) VARCHAR, Change (2011 to 2012) VARCHAR, Change (2010 to 2011) VARCHAR) CREATE TABLE 1996_to_1999 (1996_to_1999_id AUTO_INCREMENT PRIMARY KEY, Year INT, Title VARCHAR, Role VARCHAR, Producer VARCHAR, Director VARCHAR) CREATE TABLE composition_of_the_14th_seanad (composition_of_the_14th_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)  
SELECT Location FROM tamil_nadu_government_allopathic_western_medical_colleges WHERE District = salem district