Table: icf_1995_canoe_sprint
Columns: rank
nation
gold
silver
bronze
total

Question: What nation has 0 as the silver, 1 as the bronze, with 18 as the rank?
SQL: SELECT "nation" FROM icf_1995_canoe_sprint WHERE "silver" = 0 AND "bronze" = 1 AND "rank" = '18'

Question: How many golds have 3 as the rank, with a total greater than 7?
SQL: SELECT COUNT("gold") FROM icf_1995_canoe_sprint WHERE "rank" = '3' AND "total" > 7

Question: What average silver has belarus as the nation, with a total less than 1?
SQL: SELECT AVG("silver") FROM icf_1995_canoe_sprint WHERE "nation" = 'belarus' AND "total" < 1

Question: What average total has 0 as the gold, with 6 as the rank?
SQL: SELECT AVG("total") FROM icf_1995_canoe_sprint WHERE "gold" = 0 AND "rank" = '6'