CREATE TABLE table_204_770 (id NUMBER, "season" NUMBER, "date" CLOB, "jia-a/csl winner" CLOB, "result" CLOB, "fa cup winner" CLOB, "scorers" CLOB, "stadium" CLOB)

how many had a total goals scored over 6 ?
SELECT COUNT(*) FROM table_204_770 WHERE "result" + "result" > 6
SELECT COUNT(*) FROM "table_204_770" WHERE "result" + "result" > 6