human
Considering the provided database schema and associated query, produce SQL code to retrieve the answer to the query. 
###Database Schema: #, No., Title, Directed by, Written by, Viewers, Original airdate, Prod. code
###Question: what is the total number of films directy and written by john callaghan?
gpt
SELECT COUNT Directed by FROM table WHERE Written by = John Callaghan