Might Can it is me the Gold that has the Total larger than 2 , and the Bronze smaller than 1 that you telling ?
Rank Nation Gold Silver Bronze Total
2011 ICF Canoe Sprint World Championships
18771517
text text real real real real
2-18771517-7
Paracanoe
Paracanoe
1 Canada 2 1 0 3
2 Brazil 2 0 1 3
3 Great Britain 1 1 1 3
4 Hungary 1 0 1 2
5 Austria 1 0 0 1
5 Romania 1 0 0 1
7 Germany 0 1 1 2
7 Italy 0 1 1 2
7 Poland 0 1 1 2
7 Spain 0 1 1 2
7 United States 0 1 1 2
12 Russia 0 1 0 1
Total Total 8 8 8 24
SELECT Gold FROM table WHERE Total > 2 AND Bronze < 1
2 1