CREATE TABLE table_204_310 (id NUMBER, "month" CLOB, "year" NUMBER, "player" CLOB, "county" CLOB, "club" CLOB, "position" NUMBER)

how many players were from waterford ?
SELECT COUNT("player") FROM table_204_310 WHERE "county" = 'waterford'
SELECT COUNT("player") FROM "table_204_310" WHERE "county" = 'waterford'