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: Em que data Kim Fogh substituiu o gerente anterior?
 ###Tabelas: CREATE TABLE tournament_summary (tournament_summary_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Team VARCHAR, Played INT, Wins INT, Ties INT, Losses INT, Points INT) 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, Position in table 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) CREATE TABLE group_b2 (group_b2_id AUTO_INCREMENT PRIMARY KEY, Nation VARCHAR, Skip VARCHAR, Third VARCHAR, Second VARCHAR, Lead VARCHAR) CREATE TABLE all-time_ranking_in_the_championship_playoff_since_the_introduction_of_the_playoff_system_in_2009 (all-time_ranking_in_the_championship_playoff_since_the_introduction_of_the_playoff_system_in_2009_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Club VARCHAR, Seasons INT, Played INT, Drew INT, Lost INT, Points INT, Avg. Points INT, Goals for INT, Goals against INT, Goal diff INT)  
SELECT Date of appointment FROM managerial_changes WHERE Replaced by = Kim Fogh