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

how many times has he been nominated in total ?
SELECT COUNT(*) FROM table_203_643 WHERE "result" = 'nominated'
SELECT COUNT(*) FROM "table_203_643" WHERE "result" = 'nominated'