SCHEMA:
CREATE TABLE table_name_1 (total VARCHAR, bronze VARCHAR, host_city VARCHAR, gold VARCHAR)
User Question:
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