CREATE TABLE table_name_47 (year INT, result VARCHAR)

Name the average year for result of nominated
SELECT AVG(year) FROM table_name_47 WHERE result = "nominated"
SELECT AVG("year") FROM "table_name_47" WHERE "nominated" = "result"