CREATE TABLE table_25740548_4 (directed_by VARCHAR2, production_code VARCHAR2)

Who directed the episode with production code ca311?
SELECT directed_by FROM table_25740548_4 WHERE production_code = "CA311"
SELECT "directed_by" FROM "table_25740548_4" WHERE "CA311" = "production_code"