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: Quem era o gerente anterior de Charleroi?
 ###Tabelas: CREATE TABLE former_judges (former_judges_id AUTO_INCREMENT PRIMARY KEY, State VARCHAR, Born/Died VARCHAR, Active service VARCHAR, Chief Judge VARCHAR, Senior status VARCHAR, Appointed by VARCHAR, Reason for termination VARCHAR) CREATE TABLE during_summer_break (during_summer_break_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 1971_isle_of_man_senior_tt_500cc_final_standings (1971_isle_of_man_senior_tt_500cc_final_standings_id AUTO_INCREMENT PRIMARY KEY, Place INT, Rider VARCHAR, Country VARCHAR, Machine VARCHAR, Speed VARCHAR, Time VARCHAR, Points INT) CREATE TABLE list_of_silpathorn_award_winners (list_of_silpathorn_award_winners_id AUTO_INCREMENT PRIMARY KEY, Year INT, Literature VARCHAR, Music VARCHAR, Film VARCHAR, Performing arts VARCHAR) CREATE TABLE record_against_other_players (record_against_other_players_id AUTO_INCREMENT PRIMARY KEY, Player VARCHAR, Ranking INT, Record VARCHAR, Hardcourt VARCHAR, Clay VARCHAR, Grass VARCHAR, Carpet VARCHAR)  
SELECT Outgoing manager FROM during_summer_break WHERE Team = Charleroi