Who was the director for To Have and Have Not, earlier than 1945 with WB studio?
CREATE TABLE "filmography" (
  "year" real,
  "title" text,
  "role" text,
  "studio" text,
  "director" text
);
SELECT "director" FROM "filmography" WHERE "studio"='wb' AND "year"<1945 AND "title"='to have and have not';