user: ### NOW ANSWER:
Question: How many # were written by David Hoselton?
Columns: ['No.', '#', 'Title', 'Directed by', 'Written by', 'U.S. viewers (million)', 'Rank (week)', 'Original air date']
Types: ['real', 'real', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: [72.0, 2.0, '" The Right Stuff "', 'Deran Sarafian', 'Doris Egan & Leonard Dick', '17.44', '6', 'October2,2007']
SQL:

assistant: SELECT MAX("#") FROM "Table" WHERE "Written by" = 'David Hoselton';