CREATE TABLE table_name_1 (total VARCHAR, bronze VARCHAR, host_city VARCHAR, gold VARCHAR)

What's the Total for a Mexico City game with a Gold of less than 4 and a Bronze of less than 2?
SELECT COUNT(total) FROM table_name_1 WHERE host_city = "mexico city" AND gold < 4 AND bronze < 2
SELECT COUNT("total") FROM "table_name_1" WHERE "bronze" < 2 AND "gold" < 4 AND "host_city" = "mexico city"