CREATE TABLE table_204_212 (id DECIMAL, "wager" TEXT, "winner" TEXT, "loser" TEXT, "location" TEXT, "date" TEXT, "notes" TEXT)

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