user: Question: Who is the director of the episode whom Scott Peters is the writer?
Columns: ['No.', '#', 'Title', 'Director', 'Writer', 'US air date', 'Storyteller', 'Villains']
Types: ['real', 'real', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: [27.0, 1.0, '"The Tale of the Midnight Ride"', 'D. J. MacHale', 'Darren Kotania', 'January 8, 1994', 'Tucker', 'Brad & The Headless Horseman']
SQL:

assistant: SELECT "Director" FROM "Table" WHERE "Writer" = 'Scott Peters';