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

how many matches were held in mexico city ?
SELECT COUNT(*) FROM table_204_212 WHERE "location" = 'mexico city'
SELECT COUNT(*) FROM "table_204_212" WHERE "location" = 'mexico city'