Table: fibt_1997_medals
Columns: rank
nation
gold
silver
bronze
total

Question: What is the total when silver is less than 1 and rank larger than 3?
SQL: SELECT COUNT("total") FROM fibt_1997_medals WHERE "silver" < 1 AND "rank" > 3

Question: What is the number of bronze for Canada and silver is less than 0?
SQL: SELECT SUM("bronze") FROM fibt_1997_medals WHERE "nation" = 'canada' AND "silver" < 0

Question: What is the largest gold when silver is less than 1 for Canada and bronze is less than 0?
SQL: SELECT MAX("gold") FROM fibt_1997_medals WHERE "silver" < 1 AND "nation" = 'canada' AND "bronze" < 0

Question: What is the silver for Germany and less than 2?
SQL: SELECT AVG("silver") FROM fibt_1997_medals WHERE "nation" = 'germany' AND "rank" < 2