Table: small_games_2013
Columns: nation
gold
silver
bronze
total

Question: What is the average total medals of the team with 2 gold and less than 1 silver?
SQL: SELECT AVG("total") FROM small_games_2013 WHERE "gold" = 2 AND "silver" < 1

Question: What is the lowest amount of silver medals Iceland, who has less than 87 medals, has?
SQL: SELECT MIN("silver") FROM small_games_2013 WHERE "nation" = 'iceland' AND "total" < 87

Question: What is the least amount of bronze Andorra, who has more than 6 total medals, has?
SQL: SELECT MIN("bronze") FROM small_games_2013 WHERE "nation" = 'andorra' AND "total" > 6

Question: What is the lowest amount of bronze Liechtenstein, who has more than 11 gold, has?
SQL: SELECT MIN("bronze") FROM small_games_2013 WHERE "nation" = 'liechtenstein' AND "gold" > 11

Question: What is the average amount of silver medals Montenegro, who has less than 15 bronze and more than 11 total medals, has?
SQL: SELECT AVG("silver") FROM small_games_2013 WHERE "bronze" < 15 AND "nation" = 'montenegro' AND "total" > 11