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

what is the total amount of goals from all people ?
SELECT SUM("goals") FROM table_204_340
SELECT SUM("goals") FROM "table_204_340"