Table: canoe_sprint_1948
Columns: rank
nation
gold
silver
bronze
total

Question: What is the fewest bronzes for ranks of 3 with totals under 2?
SQL: SELECT MIN("bronze") FROM canoe_sprint_1948 WHERE "rank" = '3' AND "total" < 2

Question: Which rank is Austria?
SQL: SELECT "rank" FROM canoe_sprint_1948 WHERE "nation" = 'austria'

Question: What is the sum of bronzes for countries with 1 gold and under 1 silver?
SQL: SELECT SUM("bronze") FROM canoe_sprint_1948 WHERE "gold" = 1 AND "silver" < 1

Question: What is the total number of totals for nations with 1 silver and more than 1 bronze?
SQL: SELECT COUNT("total") FROM canoe_sprint_1948 WHERE "bronze" > 1 AND "silver" = 1