Table: olympic_medals
Columns: rank
nation
gold
silver
bronze
total

Question: Which Rank has a Total larger than 30, and a Bronze of 14?
SQL: SELECT AVG("rank") FROM olympic_medals WHERE "total" > 30 AND "bronze" = 14

Question: How much Gold has a Silver smaller than 3, and a Total of 9, and a Bronze smaller than 1?
SQL: SELECT COUNT("gold") FROM olympic_medals WHERE "silver" < 3 AND "total" = 9 AND "bronze" < 1

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

Question: How much Bronze has a Silver larger than 2, and a Nation of mixed team, and a Rank larger than 4?
SQL: SELECT COUNT("bronze") FROM olympic_medals WHERE "silver" > 2 AND "nation" = 'mixed team' AND "rank" > 4