CREATE TABLE table_54235 ("Year" FLOAT, "Award" CLOB, "Category" CLOB, "Work" CLOB, "Result" CLOB)

Which award did Scream receive a nomination and/or win for in 1997?
SELECT "Award" FROM table_54235 WHERE "Work" = 'scream' AND "Year" = '1997'
SELECT "Award" FROM "table_54235" WHERE "Work" = 'scream' AND "Year" = '1997'