How many episodes did David Jackson write and direct?
CREATE TABLE table_11695215_1 (written_by VARCHAR, directed_by VARCHAR)
SELECT COUNT(written_by) FROM table_11695215_1 WHERE directed_by = "David Jackson"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_11695215_1 (written_by VARCHAR, directed_by VARCHAR) Question: How many episodes did David Jackson write and direct? [/INST] SELECT COUNT(written_by) FROM table_11695215_1 WHERE directed_by = "David Jackson" </s>