Who are all directors when Sherwood Schwartz is the writer?
CREATE TABLE table_2342078_2 (directed_by VARCHAR, written_by VARCHAR)
SELECT directed_by FROM table_2342078_2 WHERE written_by = "Sherwood Schwartz"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_2342078_2 (directed_by VARCHAR, written_by VARCHAR) Question: Who are all directors when Sherwood Schwartz is the writer? [/INST] SELECT directed_by FROM table_2342078_2 WHERE written_by = "Sherwood Schwartz" </s>