user: ### NOW ANSWER:
Question: who directed the episode James Clavell wrote?
Columns: ['Episode #', 'Prod #', 'Title', 'Directed by', 'Written by', 'Originalairdate']
Types: ['real', 'real', 'text', 'text', 'text', 'text']
Sample row: [1.0, 102.0, '"Episode in Bathurst"', 'Peter Maxwell', 'Gene Roddenberry', '10 September 1960']
SQL:

assistant: SELECT "Directed by" FROM "Table" WHERE "Written by" = 'James Clavell';