CREATE TABLE table_204_525 (id DECIMAL, "rank" DECIMAL, "player" TEXT, "county" TEXT, "tally" TEXT, "total" DECIMAL, "opposition" TEXT)

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