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

how many times was waterford the opposition ?
SELECT COUNT(*) FROM table_204_952 WHERE "opposition" = 'waterford'
SELECT COUNT(*) FROM "table_204_952" WHERE "opposition" = 'waterford'