user: Question: Who wrote the episode "Confession"?
Columns: ['#', 'Title', 'Directed by', 'Written by', 'Original air date', 'Production code', 'U.S. viewers (in millions)']
Types: ['real', 'text', 'text', 'text', 'text', 'real', 'text']
Sample row: [1.0, '"Prophecy"', 'Mark Beesley', 'John Shiban & Ken Biller & Stephen Tolkin', 'November1,2008', 101.0, '5.88']
SQL:

assistant: SELECT "Written by" FROM "Table" WHERE "Title" = '"Confession"';