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: Qual foi a maneira de saída do gerente da pré-temporada da equipe que marcou o fim do mandato como interino?
 ###Tabelas: CREATE TABLE oil_refining_and_petrochemical_facilities (oil_refining_and_petrochemical_facilities_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Location VARCHAR, Launched INT, Acquired VARCHAR, Capacity, mln tpa VARCHAR) CREATE TABLE election (election_id AUTO_INCREMENT PRIMARY KEY, Event VARCHAR, Date VARCHAR, DP / DA INT, NP / NNP VARCHAR, COPE VARCHAR, ACDP INT, Others INT) CREATE TABLE public_companies (public_companies_id AUTO_INCREMENT PRIMARY KEY, State Rank by Revenue INT, Company Name VARCHAR, National Rank INT, Revenue ($billions) 2012 estimate VARCHAR, Headquarters City VARCHAR, Known for VARCHAR) 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 uk_ratings (uk_ratings_id AUTO_INCREMENT PRIMARY KEY, Episode number INT, Title VARCHAR, Original airing on Channel 4 VARCHAR, Time of airing on Channel 4 VARCHAR, Total viewers and Rank on C4 VARCHAR, Total viewers VARCHAR)  
SELECT Team FROM managerial_changes WHERE Position in managerial_changes = pre-season AND Manner of departure = end of tenure as caretaker