What-all is the average Bronze, when is greater than 6, when is Italy (ITA), and so when Total is less than 1?
Rank Nation Gold Silver Bronze Total
Art competitions at the 1928 Summer Olympics
16574447
real text real real real real
2-16574447-6
Medal table
Medal table
1 Netherlands (NED) 2 1 1 4
2 Germany (GER) 1 2 5 8
3 France (FRA) 1 2 1 4
4 Great Britain (GBR) 1 1 0 2
5 Poland (POL) 1 0 1 2
6 Austria (AUT) 1 0 0 1
6 Hungary (HUN) 1 0 0 1
6 Luxembourg (LUX) 1 0 0 1
9 Switzerland (SUI) 0 2 0 2
10 Denmark (DEN) 0 1 2 3
11 Italy (ITA) 0 1 0 1
SELECT AVG Bronze FROM table WHERE Rank > 6 AND Nation = italy (ita) AND Total < 1
6 italy (ita) 1