With yes under writer and in 2014, what is the director?
CREATE TABLE "filmography" (
  "year" real,
  "film" text,
  "director" text,
  "producer" text,
  "writer" text
);
SELECT "director" FROM "filmography" WHERE "year"=2014 AND "writer"='yes';