Table: icf_1983_canoe_sprint
Columns: rank
nation
gold
silver
bronze
total

Question: What nation has more than 0 silver medals and is ranked 1?
SQL: SELECT "nation" FROM icf_1983_canoe_sprint WHERE "silver" > 0 AND "rank" = '1'

Question: What is the rank of the country with total more than 3 and more than 6 silver?
SQL: SELECT "rank" FROM icf_1983_canoe_sprint WHERE "total" > 3 AND "silver" > 6

Question: What is the most silver won by the country with more than 1 gold, 3 bronze, ranked 1, and less than 12 as the total?
SQL: SELECT MAX("silver") FROM icf_1983_canoe_sprint WHERE "gold" > 1 AND "bronze" = 3 AND "rank" = '1' AND "total" < 12

Question: What nation has a total less than 11, more than 1 silver and less than 1 bronze?
SQL: SELECT "nation" FROM icf_1983_canoe_sprint WHERE "total" < 11 AND "silver" < 1 AND "bronze" < 1

Question: What is the most silver won by Norway?
SQL: SELECT MAX("silver") FROM icf_1983_canoe_sprint WHERE "nation" = 'norway'