Table: pan_american_chile_medals
Columns: year
edition
host_city
gold
silver
bronze
total

Question: What is the lowest VIII Edition Gold with a Silver of 4?
SQL: SELECT MIN("gold") FROM pan_american_chile_medals WHERE "silver" = 4 AND "edition" = 'viii'

Question: What is the highest Edition I Bronze with a Gold higher than 9 and a Silver higher than 10?
SQL: SELECT MAX("bronze") FROM pan_american_chile_medals WHERE "silver" > 10 AND "edition" = 'i' AND "gold" > 9

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

Question: Which Host City has more than 6 Silver and a Total of 22?
SQL: SELECT "host_city" FROM pan_american_chile_medals WHERE "silver" > 6 AND "total" = 22