CREATE TABLE table_204_948 (id NUMBER, "year" NUMBER, "award" CLOB, "category" CLOB, "film" CLOB, "result" CLOB)

how many awards did this actor receive for his role in challenge ?
SELECT COUNT("award") FROM table_204_948 WHERE "film" = 'challenge'
SELECT COUNT("award") FROM "table_204_948" WHERE "film" = 'challenge'