What is the latest year they were nominated?
CREATE TABLE "awards" (
  "year" real,
  "award" text,
  "work" text,
  "category" text,
  "result" text
);
SELECT MAX("year") FROM "awards" WHERE "result"='nominated';