Table: euro_weight_2006
Columns: nation
gold
silver
bronze
total

Question: I want to know the highest silver for total of 4 for poland and gold less than 1
SQL: SELECT MAX("silver") FROM euro_weight_2006 WHERE "total" = 4 AND "nation" = 'poland' AND "gold" < 1

Question: Tell me the average silver for total more than 1 with bronze of 2 for france and gold more than 0
SQL: SELECT AVG("silver") FROM euro_weight_2006 WHERE "total" > 1 AND "bronze" = 2 AND "nation" = 'france' AND "gold" > 0

Question: Tell me the number of gold for albania with a silver of 1 and total less than 1
SQL: SELECT COUNT("gold") FROM euro_weight_2006 WHERE "silver" = 1 AND "nation" = 'albania' AND "total" < 1

Question: Tell me the average gold for moldova and bronze less than 1
SQL: SELECT AVG("gold") FROM euro_weight_2006 WHERE "nation" = 'moldova' AND "bronze" < 1

Question: Tell me the sum of gold for bronze less than 0
SQL: SELECT SUM("gold") FROM euro_weight_2006 WHERE "bronze" < 0