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

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'