CREATE TABLE table_204_952 (id NUMBER, "rank" NUMBER, "player" CLOB, "county" CLOB, "tally" CLOB, "total" NUMBER, "opposition" CLOB)

if you added all the total 's up , what would the number be ?
SELECT SUM("total") FROM table_204_952
SELECT SUM("total") FROM "table_204_952"