how many players have spans above three years ?
CREATE TABLE table_204_342 (
    id number,
    "#" number,
    "player" text,
    "span" text,
    "caps" number,
    "total caps" number,
    "win %" text
)
SELECT COUNT("player") FROM table_204_342 WHERE "span" - "span" > 3
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 have spans above three years ? ### Input: CREATE TABLE table_204_342 (
    id number,
    "#" number,
    "player" text,
    "span" text,
    "caps" number,
    "total caps" number,
    "win %" text
) ### Response: SELECT COUNT("player") FROM table_204_342 WHERE "span" - "span" > 3