CREATE TABLE table_203_682 (id NUMBER, "year" NUMBER, "goalkeeper" CLOB, "defenders" CLOB, "midfielders" CLOB, "forwards" CLOB)

how long did jamie swanner play as goal keeper ?
SELECT COUNT("year") FROM table_203_682 WHERE "goalkeeper" = 'jamie swanner'
SELECT COUNT("year") FROM "table_203_682" WHERE "goalkeeper" = 'jamie swanner'