Which award did Scream receive a nomination and/or win for in 1997?
CREATE TABLE "awards" (
  "year" real,
  "award" text,
  "category" text,
  "work" text,
  "result" text
);
SELECT "award" FROM "awards" WHERE "work"='scream' AND "year"=1997;