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

how many players have a total above 10 ?
SELECT COUNT(DISTINCT "player") FROM table_204_525 WHERE "total" > 10
SELECT COUNT(DISTINCT "player") FROM "table_204_525" WHERE "total" > 10