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 região possui uma vila de Chassagne-Montrachet?
 ###Tabelas: CREATE TABLE list_of_grand_crus (list_of_grand_crus_id AUTO_INCREMENT PRIMARY KEY, Grand Cru VARCHAR, Region VARCHAR, Village VARCHAR, Wine style VARCHAR, Vineyard surface (2010) VARCHAR) CREATE TABLE theater_credits (theater_credits_id AUTO_INCREMENT PRIMARY KEY, Year INT, Play VARCHAR, Role VARCHAR, Theatre VARCHAR, Location VARCHAR) CREATE TABLE managers (managers_id AUTO_INCREMENT PRIMARY KEY, Nationality VARCHAR, Matches INT, Drawn INT, Lost INT, Win % INT) CREATE TABLE belfast_and_northern_counties_railway_1848–1903__&__northern_counties_committee_1903–1949 (belfast_and_northern_counties_railway_1848–1903__&__northern_counties_committee_1903–1949_id AUTO_INCREMENT PRIMARY KEY, Class VARCHAR, Type VARCHAR, Fleet numbers VARCHAR, Quantity made INT, Manufacturer VARCHAR, Date made VARCHAR, Date withdrawn VARCHAR) CREATE TABLE wins_50 (wins_50_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Date VARCHAR, Tournament VARCHAR, Surface VARCHAR, Partner VARCHAR, Opponents in the final VARCHAR, Score in the final VARCHAR)  
SELECT Region FROM list_of_grand_crus WHERE Village = chassagne-montrachet