CREATE TABLE table_28195971_1 (title VARCHAR2, directed_by VARCHAR2, written_by VARCHAR2)

What are the title(s) of episodes directed by david solomon and written by marti noxon?
SELECT title FROM table_28195971_1 WHERE directed_by = "David Solomon" AND written_by = "Marti Noxon"
SELECT "title" FROM "table_28195971_1" WHERE "David Solomon" = "directed_by" AND "Marti Noxon" = "written_by"