Table: medals_2011
Columns: nation
gold
silver
bronze
total

Question: How many bronzes are there for the total nation with 112 silver and a total of 72?
SQL: SELECT AVG("bronze") FROM medals_2011 WHERE "total" > 72 AND "nation" = 'total' AND "silver" < 112

Question: What is the highest bronze for San Marino with less than 82 total and less than 3 golds?
SQL: SELECT MAX("bronze") FROM medals_2011 WHERE "total" < 82 AND "nation" = 'san marino' AND "gold" < 3

Question: How many golds were there when there was more than 11 bronze and 29 in total?
SQL: SELECT COUNT("gold") FROM medals_2011 WHERE "bronze" > 11 AND "total" = 29

Question: What was Montenegro's average bronze with less than 7 silver and more than 4 golds?
SQL: SELECT AVG("bronze") FROM medals_2011 WHERE "silver" < 7 AND "nation" = 'montenegro' AND "gold" > 4

Question: How many golds were there for Iceland with more than 15 silver?
SQL: SELECT COUNT("gold") FROM medals_2011 WHERE "silver" > 15 AND "nation" = 'iceland'

Question: What was Andorra's total with less than 10 silver and more than 5 bronze?
SQL: SELECT SUM("total") FROM medals_2011 WHERE "silver" < 10 AND "nation" = 'andorra' AND "bronze" > 5