how many players were from waterford ?
CREATE TABLE table_204_310 (
    id number,
    "month" text,
    "year" number,
    "player" text,
    "county" text,
    "club" text,
    "position" number
)
SELECT COUNT("player") FROM table_204_310 WHERE "county" = 'waterford'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: how many players were from waterford ? ### Input: CREATE TABLE table_204_310 (
    id number,
    "month" text,
    "year" number,
    "player" text,
    "county" text,
    "club" text,
    "position" number
) ### Response: SELECT COUNT("player") FROM table_204_310 WHERE "county" = 'waterford'