Table: euro_aquatics_1985
Columns: rank
nation
gold
silver
bronze
total

Question: What is the average Total, when the value for Silver is less than 1, when the value for Gold is 0, when the Nation is Switzerland, and when the value for Bronze is 2?
SQL: SELECT AVG("total") FROM euro_aquatics_1985 WHERE "silver" < 1 AND "gold" = 0 AND "nation" = 'switzerland' AND "bronze" < 2

Question: What is the average Total, when the Nation is Sweden, and when the value for Bronze is less than 3?
SQL: SELECT AVG("total") FROM euro_aquatics_1985 WHERE "nation" = 'sweden' AND "bronze" < 3

Question: What is the average value for Gold, when the value for Silver is greater than 2, and when the Nation is West Germany?
SQL: SELECT AVG("gold") FROM euro_aquatics_1985 WHERE "silver" > 2 AND "nation" = 'west germany'

Question: What is the value for Gold, when the value for Bronze is less than 0?
SQL: SELECT COUNT("gold") FROM euro_aquatics_1985 WHERE "bronze" < 0