CREATE TABLE table_name_42 (year VARCHAR2, result VARCHAR2)

How many years have a Result of nominated?
SELECT COUNT(year) FROM table_name_42 WHERE result = "nominated"
SELECT COUNT("year") FROM "table_name_42" WHERE "nominated" = "result"