Table: olympic_rifle_prone
Columns: rank
nation
gold
silver
bronze
total

Question: How many silver medals for germany with a bronze count more than 0?
SQL: SELECT MAX("silver") FROM olympic_rifle_prone WHERE "nation" = 'germany' AND "bronze" > 0

Question: How many gold medals when the total is more than 1 and 18 silver?
SQL: SELECT MIN("gold") FROM olympic_rifle_prone WHERE "total" > 1 AND "silver" = 18

Question: How many bronze medals has a total less than 3 with a silver less than 1 and gold more than 1?
SQL: SELECT AVG("bronze") FROM olympic_rifle_prone WHERE "total" < 3 AND "silver" < 1 AND "gold" > 1