CREATE TABLE table_204_340 (id NUMBER, "name" CLOB, "year inducted" NUMBER, "position" CLOB, "apps" NUMBER, "goals" NUMBER)

what is the combined number of goals earned by the hall of famers of 2006 , 2010 , and 2012 ?
SELECT SUM("goals") FROM table_204_340 WHERE "year inducted" IN (2006, 2010, 2012)
SELECT SUM("goals") FROM "table_204_340" WHERE "year inducted" IN (2006, 2010, 2012)