CREATE TABLE table_name_16 (bronze INT, rank VARCHAR, total VARCHAR, gold VARCHAR)

How many bronze's on average for nations with over 1 total, less than 2 golds, ranked 2nd?
SELECT AVG(bronze) FROM table_name_16 WHERE total > 1 AND gold < 2 AND rank = 2
SELECT AVG("bronze") FROM "table_name_16" WHERE "gold" < 2 AND "rank" = 2 AND "total" > 1