user: ### NOW ANSWER:
Question: How many episodes were written by Tom Scharpling and Daniel Dratch?
Columns: ['Series no.', 'No. in season', 'Title', 'Written by', 'Directed by', 'Original air date']
Types: ['real', 'real', 'text', 'text', 'text', 'text']
Sample row: [46.0, 1.0, '"Mr. Monk and the Other Detective"', 'Hy Conrad', 'Eric Laneuville', 'July8,2005']
SQL:

assistant: SELECT COUNT("No. in season") FROM "Table" WHERE "Written by" = 'Tom Scharpling and Daniel Dratch';