Table: canoe_world_champs_2011_2
Columns: rank
nation
gold
silver
bronze
total

Question: Can you tell me the Gold that has the Total larger than 2, and the Bronze smaller than 1?
SQL: SELECT "gold" FROM canoe_world_champs_2011_2 WHERE "total" > 2 AND "bronze" < 1

Question: Can you tell me the Nation that has the Bronze of 1, and the Gold of 0?
SQL: SELECT "nation" FROM canoe_world_champs_2011_2 WHERE "bronze" = 1 AND "gold" = 0

Question: Can you tell me the average Total that has the Silver larger than 1, and the Bronze smaller than 8?
SQL: SELECT AVG("total") FROM canoe_world_champs_2011_2 WHERE "silver" > 1 AND "bronze" < 8