CREATE TABLE table_204_342 (id NUMBER, "#" NUMBER, "player" CLOB, "span" CLOB, "caps" NUMBER, "total caps" NUMBER, "win %" CLOB)

how many players have spans above three years ?
SELECT COUNT("player") FROM table_204_342 WHERE "span" - "span" > 3
SELECT COUNT("player") FROM "table_204_342" WHERE "span" - "span" > 3