Table: olympic_medals_1984
Columns: rank
nation
gold
silver
bronze
total

Question: What is the mean number of totals with no silvers and a bronze number less than 0?
SQL: SELECT AVG("total") FROM olympic_medals_1984 WHERE "silver" = 0 AND "bronze" < 0

Question: What is the least number of Silvers with a ranking of less than 4 where the bronze number was larger than 9?
SQL: SELECT MIN("silver") FROM olympic_medals_1984 WHERE "rank" < 4 AND "bronze" > 9

Question: Which mean rank had a silver number smaller than 0?
SQL: SELECT AVG("rank") FROM olympic_medals_1984 WHERE "silver" < 0

Question: What is the least total number with a rank of 4 and a total silver number bigger than 3?
SQL: SELECT MIN("total") FROM olympic_medals_1984 WHERE "rank" = 4 AND "silver" > 3