user: ### NOW ANSWER:
Question: Who directed the episode with production code CA311?
Columns: ['Series #', 'Season #', 'Title', 'Directed by', 'Written by', 'Original air date', 'Production code', 'U.S. viewers (million)']
Types: ['real', 'real', 'text', 'text', 'text', 'text', 'text', 'text']
Sample row: [28.0, 1.0, '"Hang on to Yourself"', 'Allan Kroeker', 'Matt Corman & Chris Ord', 'July10,2012', 'CA301', '3.50']
SQL:

assistant: SELECT "Directed by" FROM "Table" WHERE "Production code" = 'CA311';