user: Question: How many titles are there for the episode written by Tom Scharpling? 
Columns: ['No. in series', 'No. in season', 'Title', 'Directed by', 'Written by', 'Original air date', 'U.S. viewers (millions)']
Types: ['real', 'real', 'text', 'text', 'text', 'text', 'text']
Sample row: [110.0, 1.0, '"Mr. Monk\'s Favorite Show"', 'Randall Zisk', 'Jack Bernstein', 'August7,2009', '5.14']
SQL:

assistant: SELECT COUNT("Title") FROM "Table" WHERE "Written by" = 'Tom Scharpling';