CREATE TABLE table_203_842 (id NUMBER, "#" NUMBER, "date" CLOB, "venue" CLOB, "opponent" CLOB, "score" NUMBER, "result" CLOB, "competition" CLOB)

what was the total number of appearances in 2005 ?
SELECT COUNT(*) FROM table_203_842 WHERE "date" = 2005
SELECT COUNT(*) FROM "table_203_842" WHERE "date" = 2005