What-all is the average Total, when the value for Silver is less than 1, when the value for Golds is 0, when the Nation is Switzerland, and when the value for Bronze is 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