Table: olympic_medals_5
Columns: rank
gold
silver
bronze
total

Question: Which Bronze has a Total smaller than 1?
SQL: SELECT AVG("bronze") FROM olympic_medals_5 WHERE "total" < 1

Question: How much Silver has a Bronze larger than 1, and a Gold of 0, and a Rank smaller than 4?
SQL: SELECT COUNT("silver") FROM olympic_medals_5 WHERE "bronze" > 1 AND "gold" = 0 AND "rank" < 4

Question: Which Bronze has a Rank of 4, and a Gold smaller than 0?
SQL: SELECT MAX("bronze") FROM olympic_medals_5 WHERE "rank" = 4 AND "gold" < 0

Question: How much Gold has a Bronze smaller than 2, and a Silver of 0, and a Rank larger than 3?
SQL: SELECT SUM("gold") FROM olympic_medals_5 WHERE "bronze" < 2 AND "silver" = 0 AND "rank" > 3