user: Question: What are the title(s) of episodes directed by David Solomon and written by Marti Noxon?
Columns: ['№', '#', 'Title', 'Directed by', 'Written by', 'Original air date', 'Production code', 'U.S. viewers (millions)']
Types: ['real', 'real', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: [79.0, 1.0, '" Buffy vs. Dracula "', 'David Solomon', 'Marti Noxon', 'September26,2000', '5ABB01', '5.8']
SQL:

assistant: SELECT "Title" FROM "Table" WHERE "Directed by" = 'David Solomon' AND "Written by" = 'Marti Noxon';