CREATE TABLE table_11695215_1 (written_by VARCHAR2, directed_by VARCHAR2)

How many episodes did David Jackson write and direct?
SELECT COUNT(written_by) FROM table_11695215_1 WHERE directed_by = "David Jackson"
SELECT COUNT("written_by") FROM "table_11695215_1" WHERE "David Jackson" = "directed_by"