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 é o escritor da Red Rose Chain LTD?
 ###Tabelas: CREATE TABLE record_vs._other_opponents_at_least_15_games_played (record_vs._other_opponents_at_least_15_games_played_id AUTO_INCREMENT PRIMARY KEY, Missouri vs. VARCHAR, Overall Record VARCHAR, at Columbia VARCHAR, at Opponents Venue VARCHAR, at Neutral Site VARCHAR, Last 5 Meetings VARCHAR, Last 10 Meetings VARCHAR, Current Streak VARCHAR) CREATE TABLE minority_democratic_leadership (minority_democratic_leadership_id AUTO_INCREMENT PRIMARY KEY, State ranked in partisan order VARCHAR, Percentage Republicans VARCHAR, Percentage Democrats VARCHAR, Republican/ Democratic VARCHAR, Republican seat plurality VARCHAR) CREATE TABLE inhabited_territories (inhabited_territories_id AUTO_INCREMENT PRIMARY KEY, Territory VARCHAR, Abbr. VARCHAR, Capital VARCHAR, Acquired INT, Territorial status VARCHAR, Population ( 2010 ) INT, House seat INT) CREATE TABLE 2007 (2007_id AUTO_INCREMENT PRIMARY KEY, Film VARCHAR, Director(s) VARCHAR, Producer(s) VARCHAR, Writer(s) VARCHAR, Recipient VARCHAR, Award VARCHAR) CREATE TABLE fsfe_examination_result_analysis_–_2009 (fsfe_examination_result_analysis_–_2009_id AUTO_INCREMENT PRIMARY KEY, Subject VARCHAR, No. Sat INT, No. Passed INT, % Pass INT, Highest mark INT, Lowest mark INT, Mean INT)  
SELECT Writer(s) FROM 2007 WHERE Recipient = red rose chain ltd