CREATE TABLE table_204_838 (id NUMBER, "year" NUMBER, "award" CLOB, "category" CLOB, "nominated work" CLOB, "result" CLOB)

what is the total number of awards that he has won ?
SELECT COUNT("award") FROM table_204_838 WHERE "result" = 'won'
SELECT COUNT("award") FROM "table_204_838" WHERE "result" = 'won'