Table: icf_1998_canoe_sprint
Columns: rank
nation
gold
silver
bronze
total

Question: Name the Gold which has a Nation of australia, and a Bronze smaller than 1?
SQL: SELECT MIN("gold") FROM icf_1998_canoe_sprint WHERE "nation" = 'australia' AND "bronze" < 1

Question: Which the highest Bronze of czech republic with a Total smaller than 4?
SQL: SELECT MAX("bronze") FROM icf_1998_canoe_sprint WHERE "nation" = 'czech republic' AND "total" < 4

Question: Name the highest Bronze which has a Gold larger than 2 and a Rank of total?
SQL: SELECT MAX("bronze") FROM icf_1998_canoe_sprint WHERE "gold" > 2 AND "rank" = 'total'

Question: Count the average Gold which has a Nation of sweden, and a Silver larger than 1?
SQL: SELECT AVG("gold") FROM icf_1998_canoe_sprint WHERE "nation" = 'sweden' AND "silver" > 1