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 é o status em vestal
 ###Tabelas: CREATE TABLE 2012_calendar_year_ratios_of_crime_per_100000_population (2012_calendar_year_ratios_of_crime_per_100000_population_id AUTO_INCREMENT PRIMARY KEY, State VARCHAR, City VARCHAR, Population INT, Violent Crime VARCHAR, Murder and Non-Negligent Manslaughter VARCHAR, Forcible Rape VARCHAR, Robbery VARCHAR, Aggravated Assault VARCHAR, Property Crime VARCHAR, Burglary VARCHAR, Larceny-Theft VARCHAR, Motor Vehicle Theft VARCHAR) CREATE TABLE tests_conducted_by_aqsiq (tests_conducted_by_aqsiq_id AUTO_INCREMENT PRIMARY KEY, Producer VARCHAR, Product VARCHAR, Samples taken INT, Samples failed INT, Melamine content(mg/kg) INT) CREATE TABLE 2000_version (2000_version_id AUTO_INCREMENT PRIMARY KEY, Cast VARCHAR, 1951 ( BBC ) VARCHAR, 1957 (BBC) VARCHAR, 1968 (BBC) VARCHAR, 1970 (film) VARCHAR, 2000 ( Carlton Television ) VARCHAR) CREATE TABLE bmi_awards (bmi_awards_id AUTO_INCREMENT PRIMARY KEY, Year INT, Category VARCHAR, Nominee(s) VARCHAR, Episode VARCHAR, Result VARCHAR) CREATE TABLE undergraduate_chapters_associate_chapters__&__colonies (undergraduate_chapters_associate_chapters__&__colonies_id AUTO_INCREMENT PRIMARY KEY, Greek Designation VARCHAR, Collegiate Institution VARCHAR, Charter Date VARCHAR, Status VARCHAR, City VARCHAR, U.S. State/District VARCHAR)  
SELECT Status FROM undergraduate_chapters_associate_chapters__&__colonies WHERE City = Vestal