What are the title(s) of episodes directed by david solomon and written by marti noxon?
CREATE TABLE table_28195971_1 (title VARCHAR, directed_by VARCHAR, written_by VARCHAR)
SELECT title FROM table_28195971_1 WHERE directed_by = "David Solomon" AND written_by = "Marti Noxon"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_28195971_1 (title VARCHAR, directed_by VARCHAR, written_by VARCHAR) Question: What are the title(s) of episodes directed by david solomon and written by marti noxon? [/INST] SELECT title FROM table_28195971_1 WHERE directed_by = "David Solomon" AND written_by = "Marti Noxon" </s>