user: ### NOW ANSWER:
Question: Who directed the episode written by Tony O'Grady (pseudonym of Brian Clemens)?
Columns: ['Episode #', 'Prod #', 'Title', 'Directed by', 'Written by', 'Originalairdate', 'Filmed']
Types: ['real', 'real', 'text', 'text', 'text', 'text', 'text']
Sample row: [1.0, 104.0, '"Diplomatic Immunity"', 'Leslie Norman', 'Dennis Spooner', '28 September 1966', 'Aug/Sept 1965']
SQL:

assistant: SELECT "Directed by" FROM "Table" WHERE "Written by" = 'Tony O''Grady (pseudonym of Brian Clemens)';