CREATE TABLE table_204_340 (id DECIMAL, "name" TEXT, "year inducted" DECIMAL, "position" TEXT, "apps" DECIMAL, "goals" DECIMAL)

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