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: Eu quero a data da vaga para a partida do gerente demissionário e saindo da Gordon Wylde.
 ###Tabelas: CREATE TABLE managerial_changes (managerial_changes_id AUTO_INCREMENT PRIMARY KEY, Team VARCHAR, Outgoing manager VARCHAR, Manner of departure VARCHAR, Date of vacancy VARCHAR, Replaced by VARCHAR, Date of appointment VARCHAR) CREATE TABLE most_career_games (most_career_games_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Games INT, Player VARCHAR, Club/Clubs VARCHAR, Career span VARCHAR) CREATE TABLE appearances_by_team (appearances_by_team_id AUTO_INCREMENT PRIMARY KEY, Appearances INT, Team VARCHAR, Wins INT, Losses INT, Winning percentage INT, Season(s) VARCHAR) CREATE TABLE minor_sports_teams (minor_sports_teams_id AUTO_INCREMENT PRIMARY KEY, Club VARCHAR, Sport VARCHAR, League VARCHAR, Venue VARCHAR, Championships (Years) VARCHAR) CREATE TABLE medals_table (medals_table_id AUTO_INCREMENT PRIMARY KEY, Rank VARCHAR, Nation VARCHAR, Gold INT, Silver INT, Bronze INT, Total INT)  
SELECT Date of vacancy FROM managerial_changes WHERE Manner of departure = resigned AND Outgoing manager = gordon wylde