CREATE TABLE table_22324 ("No." FLOAT, "#" FLOAT, "Title" CLOB, "Directed by" CLOB, "Written by" CLOB, "Canadian air date" CLOB, "U.S. air date" CLOB, "Production code" FLOAT, "Canadian viewers  ( million ) " CLOB)

Who directed the episode that aired on July 29, 2011?
SELECT "Directed by" FROM table_22324 WHERE "U.S. air date" = 'July 29, 2011'
SELECT "Directed by" FROM "table_22324" WHERE "U.S. air date" = 'July 29, 2011'