CREATE TABLE table_204_212 (id NUMBER, "wager" CLOB, "winner" CLOB, "loser" CLOB, "location" CLOB, "date" CLOB, "notes" CLOB)

how many matches were in 2011 ?
SELECT COUNT(*) FROM table_204_212 WHERE "date" = 2011
SELECT COUNT(*) FROM "table_204_212" WHERE "date" = 2011