What year was The Horn Blows at Midnight, directed by Raoul Walsh?
CREATE TABLE "filmography" (
  "year" real,
  "title" text,
  "role" text,
  "studio" text,
  "director" text
);
SELECT AVG("year") FROM "filmography" WHERE "director"='raoul walsh' AND "title"='the horn blows at midnight';