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: Se a posição na tabela for a 10ª, e a forma de saída foi por renúncia, qual foi a data da vaga?
 ###Tabelas: CREATE TABLE doubles_3–2 (doubles_3–2_id AUTO_INCREMENT PRIMARY KEY, Edition VARCHAR, Round VARCHAR, Date VARCHAR, Partner VARCHAR, Surface VARCHAR, Opponents VARCHAR, Result VARCHAR) CREATE TABLE terror_and_other_attacks_1968–1987 (terror_and_other_attacks_1968–1987_id AUTO_INCREMENT PRIMARY KEY, Military deaths INT, Civilian deaths (including foreigners) INT, Total deaths INT, Military and/or Civilian wounded VARCHAR, Total casualties VARCHAR) CREATE TABLE managerial_changes (managerial_changes_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Outgoing head coach VARCHAR, Manner of departure VARCHAR, Date of vacancy VARCHAR, Position in table VARCHAR, Incoming head coach VARCHAR, Date of appointment VARCHAR) CREATE TABLE liquid_measures (liquid_measures_id AUTO_INCREMENT PRIMARY KEY, Unit VARCHAR, Russian VARCHAR, Translation VARCHAR, Ratio VARCHAR, Cubic inches (exact) VARCHAR, Metric value VARCHAR, Imperial VARCHAR, US Customary VARCHAR) CREATE TABLE stations_under_construction (stations_under_construction_id AUTO_INCREMENT PRIMARY KEY, Station VARCHAR, Extension VARCHAR, City/Neighborhood VARCHAR, Projected opening INT, Transit Connections VARCHAR, Park and ride? VARCHAR)  
SELECT Date of vacancy FROM managerial_changes WHERE Manner of departure = Resigned AND Position in managerial_changes = 10th