Table: rifle_300m
Columns: rank
nation
gold
silver
bronze
total

Question: How many silver medals did Estonia, which won more than 1 gold and less than 97 medals total, win?
SQL: SELECT "silver" FROM rifle_300m WHERE "gold" > 1 AND "total" < 97 AND "nation" = 'estonia'

Question: How many gold medals did Denmark win?
SQL: SELECT MIN("gold") FROM rifle_300m WHERE "nation" = 'denmark'

Question: What is the total number of gold medals won among nations that won more than 27 bronze and less than 305 medals total?
SQL: SELECT COUNT("gold") FROM rifle_300m WHERE "bronze" > 27 AND "total" < 305

Question: How many gold medals were won by the nation that won over 4 silver medals, over 14 bronze, and 97 medals total?
SQL: SELECT COUNT("gold") FROM rifle_300m WHERE "silver" > 4 AND "bronze" > 14 AND "total" = 97