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 chang myon (장면) deixou o cargo?
 ###Tabelas: CREATE TABLE online_selection (online_selection_id AUTO_INCREMENT PRIMARY KEY, Artist VARCHAR, Song VARCHAR, Lyrics (l) / Music (m) VARCHAR, Votes VARCHAR, Place VARCHAR) CREATE TABLE republic_of_korea_1948-presents (republic_of_korea_1948-presents_id AUTO_INCREMENT PRIMARY KEY, President VARCHAR, Vice INT, Romanized (Hangul) VARCHAR, Took office VARCHAR, Left office VARCHAR, Political party VARCHAR) CREATE TABLE semifinal_scores (semifinal_scores_id AUTO_INCREMENT PRIMARY KEY, State VARCHAR, Swimsuit INT, Evening Gown INT, Interview INT, Average INT) CREATE TABLE in_general_elections (in_general_elections_id AUTO_INCREMENT PRIMARY KEY, Year VARCHAR, General Election VARCHAR, Seats Won INT, Change in Seat INT, % of votes VARCHAR, votes swing VARCHAR) CREATE TABLE international_recognition (international_recognition_id AUTO_INCREMENT PRIMARY KEY, Index VARCHAR, Score VARCHAR, PALOP rank VARCHAR, CPLP rank VARCHAR, n Africa rank VARCHAR, World rank VARCHAR, Year INT)  
SELECT Left office FROM republic_of_korea_1948-presents WHERE Romanized (Hangul) = chang myon (장면)