Table: olympic_gymnastics_medals_2
Columns: rank
nation
gold
silver
bronze
total

Question: What is the lowest total that has a rank less than 8, a silver greater than 6, and 20 as the bronze?
SQL: SELECT MIN("total") FROM olympic_gymnastics_medals_2 WHERE "rank" < 8 AND "silver" > 6 AND "bronze" = 20

Question: What is the average silver that has a gold greater than 3, with soviet union (urs) as the nation, and a bronze greater than 26?
SQL: SELECT AVG("silver") FROM olympic_gymnastics_medals_2 WHERE "gold" > 3 AND "nation" = 'soviet union (urs)' AND "bronze" > 26

Question: What is the highest silver that has 57 as the total, with a bronze greater than 20?
SQL: SELECT MAX("silver") FROM olympic_gymnastics_medals_2 WHERE "total" = 57 AND "bronze" > 20

Question: What rank has a gold greater than 0, 0 as the bronze, with germany (ger) as the nation?
SQL: SELECT "rank" FROM olympic_gymnastics_medals_2 WHERE "gold" > 0 AND "bronze" = 0 AND "nation" = 'germany (ger)'

Question: How many bronzes have 1 as the total, with spain (esp) as the nation, and a gold greater than 0?
SQL: SELECT COUNT("bronze") FROM olympic_gymnastics_medals_2 WHERE "total" = 1 AND "nation" = 'spain (esp)' AND "gold" > 0