Name the number of episodes for sam snape
CREATE TABLE table_27208817_1 (episode VARCHAR, writer VARCHAR)
SELECT COUNT(episode) FROM table_27208817_1 WHERE writer = "Sam Snape"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_27208817_1 (episode VARCHAR, writer VARCHAR) Question: Name the number of episodes for sam snape [/INST] SELECT COUNT(episode) FROM table_27208817_1 WHERE writer = "Sam Snape" </s>