CREATE TABLE table_203_191 (id NUMBER, "year" NUMBER, "group" CLOB, "award" CLOB, "result" CLOB, "notes" CLOB)

how many awards has he been nominated for and not won ?
SELECT COUNT("award") FROM table_203_191 WHERE "result" = 'nominated'
SELECT COUNT("award") FROM "table_203_191" WHERE "result" = 'nominated'