user: ### NOW ANSWER:
Question: Who is the director when the writter is Andrea Newman?
Columns: ['No. in series', 'Title', 'Directed by', 'Written by', 'Original air date', 'U.S. viewers (millions)']
Types: ['real', 'text', 'text', 'text', 'text', 'text']
Sample row: [2.0, '"In Which Sam Receives an Unexpected Visitor"', 'Tony Goldwyn', 'Mike Ostrowski', 'October3,2007', '12.30']
SQL:

assistant: SELECT "Directed by" FROM "Table" WHERE "Written by" = 'Andrea Newman';