Table: icf_canoe_2010
Columns: rank
nation
gold
silver
bronze
total

Question: What is the least amount of silver for Italy with a total less than 5?
SQL: SELECT MIN("silver") FROM icf_canoe_2010 WHERE "nation" = 'italy' AND "total" < 5

Question: What is the total for Austria when there is less than 1 bronze?
SQL: SELECT AVG("total") FROM icf_canoe_2010 WHERE "nation" = 'austria' AND "bronze" < 1

Question: What is the total when silver is more than 3, and rank is 2?
SQL: SELECT MAX("total") FROM icf_canoe_2010 WHERE "silver" > 3 AND "rank" = '2'

Question: What is the gold number when total is more than 1, and bronze is 0, and rank is 5?
SQL: SELECT SUM("gold") FROM icf_canoe_2010 WHERE "total" > 1 AND "bronze" = 0 AND "rank" = '5'