Which category has 24 nominated work?
CREATE TABLE "awards" (
  "year" real,
  "award" text,
  "category" text,
  "nominated_work" text,
  "result" text
);
SELECT "category" FROM "awards" WHERE "nominated_work"='24';