user: Question: Who are all directors when Sherwood Schwartz is the writer?
Columns: ['Episode #', 'Season #', 'Title', 'Directed by', 'Written by', 'Original airdate', 'Production code (order they were made) #']
Types: ['real', 'real', 'text', 'text', 'text', 'text', 'real']
Sample row: [1.0, 101.0, '"The Honeymoon"', 'John Rich', 'Sherwood Schwartz', 'September26,1969', 0.0]
SQL:

assistant: SELECT "Directed by" FROM "Table" WHERE "Written by" = 'Sherwood Schwartz';