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 dirigiu o episódio escrito por Cyrus Nowrasteh?
 ###Tabelas: CREATE TABLE season_1:_1997 (season_1:_1997_id AUTO_INCREMENT PRIMARY KEY, Episode # INT, Title VARCHAR, Directed by VARCHAR, Written by VARCHAR, Original airdate VARCHAR) CREATE TABLE non-resident_heads_of_missions (non-resident_heads_of_missions_id AUTO_INCREMENT PRIMARY KEY, Mission VARCHAR, Resident Country VARCHAR, Local Location VARCHAR, Local Mission VARCHAR, Non-Resident Head of Mission VARCHAR, Local Position VARCHAR) CREATE TABLE sheffield_united_career (sheffield_united_career_id AUTO_INCREMENT PRIMARY KEY, Division VARCHAR, League Apps (Sub) INT, League Goals INT, FA Cup Apps (Sub) VARCHAR, FA Cup Goals INT, FL Cup Apps (Sub) INT, FL Cup Goals INT, Other Apps INT, Other Goals INT, Total Apps (Sub) VARCHAR, Total Goals INT) CREATE TABLE 2010_senior_manx_grand_prix_practice_times__&__leaderboard (2010_senior_manx_grand_prix_practice_times__&__leaderboard_id AUTO_INCREMENT PRIMARY KEY, Rank INT, Rider VARCHAR, Sat 21 Aug VARCHAR, Mon 23 Aug VARCHAR, Tues 24 Aug VARCHAR, Wed 25 Aug VARCHAR, Thurs 26 Aug VARCHAR, Fri 27 Aug VARCHAR, Sat 28 Aug VARCHAR) CREATE TABLE 1970s_colts_11-9 (1970s_colts_11-9_id AUTO_INCREMENT PRIMARY KEY, Year INT, Date VARCHAR, Winner VARCHAR, Result VARCHAR, Loser VARCHAR, Location VARCHAR)  
SELECT Directed by FROM season_1:_1997 WHERE Written by = cyrus nowrasteh