Name who wrote number 47
CREATE TABLE table_15584067_4 (written_by VARCHAR, no_in_series VARCHAR)
SELECT written_by FROM table_15584067_4 WHERE no_in_series = 47
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_15584067_4 (written_by VARCHAR, no_in_series VARCHAR) Question: Name who wrote number 47 [/INST] SELECT written_by FROM table_15584067_4 WHERE no_in_series = 47 </s>