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: Quando Brendan Rodgers deixou seu cargo?
 ###Tabelas: CREATE TABLE apea's_campeonato_paulista (apea's_campeonato_paulista_id AUTO_INCREMENT PRIMARY KEY, Position INT, Team VARCHAR, Points INT, Played INT, Drawn INT, Lost INT, Against INT, Difference VARCHAR) CREATE TABLE doubles:_15_9–6 (doubles:_15_9–6_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Date INT, Surface VARCHAR, Partner VARCHAR, Opponents in the final VARCHAR, Score in the final VARCHAR) CREATE TABLE points_for_the_2008_09_season (points_for_the_2008_09_season_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Pld. INT, Goals INT, Assists INT, Points INT, Pims INT) CREATE TABLE episodes_and_ratings (episodes_and_ratings_id AUTO_INCREMENT PRIMARY KEY, Episode INT, First broadcast Denmark ( DR1 ) VARCHAR, Official TNS Gallup ratings INT, First broadcast UK ( BBC Four ) VARCHAR, Official BARB ratings INT) CREATE TABLE end-of-season_managerial_changes (end-of-season_managerial_changes_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Club VARCHAR, Date of departure VARCHAR, Replacement VARCHAR, Date of appointment VARCHAR)  
SELECT Date of departure FROM end-of-season_managerial_changes WHERE Name = brendan rodgers