what is the average total when silver more than 2, bronze one 12 and gold less than 12?
Rank Nation Gold Silver Bronze Total
Shooting at the 2008 Summer Paralympics
18403457
text text real real real real
2-18403457-1
Medal table
Medal table
1 South Korea (KOR) 4 3 2 9
2 Sweden (SWE) 3 0 1 4
3 Russia (RUS) 2 1 3 6
4 China (CHN) 1 3 3 7
5 Great Britain (GBR) 1 0 0 1
5 Slovakia (SVK) 1 0 0 1
7 France (FRA) 0 2 0 2
7 Germany (GER) 0 2 0 2
9 Israel (ISR) 0 1 0 1
10 New Zealand (NZL) 0 0 1 1
10 Puerto Rico (PUR) 0 0 1 1
10 Slovenia (SLO) 0 0 1 1
Total Total 12 12 12 36
SELECT AVG Total FROM table WHERE Silver > 2 AND Bronze = 12 AND Gold < 12
2 12 12