user: ### NOW ANSWER:
Question: Name the title that was written by R. Scott Gemmill
Columns: ['Series #', 'Season #', 'Title', 'Directed by', 'Written by', 'Original air date']
Types: ['real', 'real', 'text', 'text', 'text', 'text']
Sample row: [224.0, 1.0, '"One for the Road"', 'Christopher Chulack', 'Joe Sachs', 'September23,2004']
SQL:

assistant: SELECT "Title" FROM "Table" WHERE "Written by" = 'R. Scott Gemmill';