What the average Total, when value Silver less than 1, when value Gold 0, when Nation Switzerland, and when value Bronze 2?
Rank Nation Gold Silver Bronze Total
1985 European Aquatics Championships
13045569
text text real real real real
2-13045569-1
Medal table
Medal table
1 East Germany 17 17 6 40
2 Soviet Union 7 4 6 17
3 West Germany 6 4 7 17
4 Great Britain 2 3 1 6
5 France 2 2 0 4
6 Hungary 2 1 0 3
7 Bulgaria 1 2 4 7
8 Netherlands 1 1 6 8
9 Austria 1 0 1 2
10 Sweden 0 1 3 4
11 Czechoslovakia 0 1 1 2
12 Denmark 0 1 0 1
12 Portugal 0 1 0 1
12 Yugoslavia 0 1 0 1
15 Italy 0 0 2 2
15 Switzerland 0 0 2 2
Total Total 39 39 39 117
SELECT AVG Total FROM table WHERE Silver < 1 AND Gold = 0 AND Nation = switzerland AND Bronze < 2
1 0 switzerland 2