Table: swimming_champs_2010
Columns: nation
gold
silver
bronze
total

Question: Which country has the highest bronze amount and a silver amount bigger than 41?
SQL: SELECT MAX("bronze") FROM swimming_champs_2010 WHERE "silver" > 41

Question: What is the lowest amount of medals Russia has if they have more than 2 silver medals and less than 4 gold medals?
SQL: SELECT MIN("total") FROM swimming_champs_2010 WHERE "silver" > 2 AND "nation" = 'russia' AND "gold" < 4