What the average total number medal when it was 4 bronze, more than 2 silver, and less than 7 gold medal?
Rank Gold Silver Bronze Total
2008 Summer Olympics medal table
17273204
text real real real real
2-17273204-1
Medal table
2008 Summer Olympics medal table
1 51 21 28 100
2 36 38 36 110
3 23 21 29 73
4 19 13 15 47
5 16 10 15 41
6 14 15 17 46
7 13 10 8 31
8 9 6 10 25
9 8 9 10 27
10 7 16 18 41
11 7 5 15 27
12 7 5 4 16
13 6 4 4 14
14 6 3 2 11
15 5 10 3 18
16 4 5 10 19
17 4 1 3 8
18 4 1 2 7
19 3 9 6 18
20 3 6 1 10
21 3 5 2 10
22 3 5 1 9
23 3 4 8 15
24 3 3 0 6
25 3 2 4 9
26 3 2 1 6
27 3 0 3 6
28 2 11 11 24
29 2 4 7 13
30 2 2 3 7
31 2 2 0 4
31 2 2 0 4
33 2 1 4 7
34 2 1 3 6
35 2 0 4 6
36 2 0 1 3
37 1 4 3 8
38 1 3 0 4
39 1 2 4 7
40 1 2 3 6
41 1 2 2 5
42 1 1 3 5
42 1 1 3 5
44 1 1 2 4
45 1 1 1 3
46 1 1 0 2
46 1 1 0 2
46 1 1 0 2
46 1 1 0 2
50 1 0 2 3
51 1 0 1 2
52 1 0 0 1
52 1 0 0 1
52 1 0 0 1
55 0 4 1 5
56 0 2 3 5
56 0 2 3 5
58 0 2 2 4
59 0 2 0 2
60 0 1 3 4
61 0 1 2 3
61 0 1 2 3
61 0 1 2 3
64 0 1 1 2
64 0 1 1 2
64 0 1 1 2
64 0 1 1 2
64 0 1 1 2
64 0 1 1 2
70 0 1 0 1
70 0 1 0 1
70 0 1 0 1
70 0 1 0 1
70 0 1 0 1
70 0 1 0 1
70 0 1 0 1
70 0 1 0 1
78 0 0 6 6
79 0 0 4 4
80 0 0 1 1
80 0 0 1 1
80 0 0 1 1
80 0 0 1 1
80 0 0 1 1
80 0 0 1 1
80 0 0 1 1
Total (86 NOCs) 302 303 353 958
SELECT AVG Total FROM table WHERE Bronze = 4 AND Silver > 2 AND Gold < 7
4 2 7