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

how many times has dev been nominated for an award but lost ?
SELECT COUNT(*) FROM table_204_948 WHERE "result" = 'nominated'
SELECT COUNT(*) FROM "table_204_948" WHERE "result" = 'nominated'