What year is the latest year that has no under director?
CREATE TABLE "filmography" (
  "year" real,
  "film" text,
  "director" text,
  "producer" text,
  "writer" text
);
SELECT MAX("year") FROM "filmography" WHERE "director"='no';