what is the total number of films directy and written by john callaghan?
CREATE TABLE table_27547668_4 (directed_by VARCHAR, written_by VARCHAR)
SELECT COUNT(directed_by) FROM table_27547668_4 WHERE written_by = "John Callaghan"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_27547668_4 (directed_by VARCHAR, written_by VARCHAR) Question: what is the total number of films directy and written by john callaghan? [/INST] SELECT COUNT(directed_by) FROM table_27547668_4 WHERE written_by = "John Callaghan" </s>