Table: icf_canoe_sprint_1999
Columns: rank
nation
gold
silver
bronze
total

Question: What is the average total value for Spain?
SQL: SELECT AVG("total") FROM icf_canoe_sprint_1999 WHERE "nation" = 'spain'

Question: What is the sum of silvers for countries in rank 8 with totals over 3?
SQL: SELECT SUM("silver") FROM icf_canoe_sprint_1999 WHERE "rank" = '8' AND "total" > 3

Question: What is the average total for countries with under 3 golds and 0 silvers?
SQL: SELECT AVG("total") FROM icf_canoe_sprint_1999 WHERE "gold" < 3 AND "silver" < 0