Table: icf_1950_canoe_sprint
Columns: rank
nation
gold
silver
bronze
total

Question: Which Bronze has a Nation of austria, and a Total larger than 6?
SQL: SELECT MAX("bronze") FROM icf_1950_canoe_sprint WHERE "nation" = 'austria' AND "total" > 6

Question: Which Rank has a Silver of 1, and a Gold of 0, and a Nation of austria?
SQL: SELECT "rank" FROM icf_1950_canoe_sprint WHERE "silver" = 1 AND "gold" = 0 AND "nation" = 'austria'

Question: Which Total has a Rank of 5, and a Bronze smaller than 0?
SQL: SELECT AVG("total") FROM icf_1950_canoe_sprint WHERE "rank" = '5' AND "bronze" < 0

Question: Which Total has a Bronze of 5, and a Silver smaller than 1?
SQL: SELECT MIN("total") FROM icf_1950_canoe_sprint WHERE "bronze" = 5 AND "silver" < 1