CREATE TABLE table_204_371 (id NUMBER, "team" CLOB, "competition" CLOB, "category" CLOB, "appearances\ start" NUMBER, "appearances\ sub" NUMBER, "goals" NUMBER, "team record" CLOB)

how many total goals were scored ?
SELECT SUM("goals") FROM table_204_371
SELECT SUM("goals") FROM "table_204_371"