Table: olympic_medals_1980_2
Columns: rank
nation
gold
silver
bronze
total

Question: What shows for gold when bronze is 1?
SQL: SELECT "gold" FROM olympic_medals_1980_2 WHERE "bronze" = 1

Question: What is the gold number when the total is less than 8, silver less than 1 and the rank is more than 7?
SQL: SELECT COUNT("gold") FROM olympic_medals_1980_2 WHERE "total" < 8 AND "silver" < 1 AND "rank" > 7

Question: What is the average Total for the Rank of 6, when Silver is smaller than 0?
SQL: SELECT AVG("total") FROM olympic_medals_1980_2 WHERE "rank" = 6 AND "silver" < 0