What that average Gold, when Silver less than 107, when Bronze is more greater 42, and when Rank 3?
Rank Gold Silver Bronze Total
2011 Pacific Games
16777236
text real real real real
2-16777236-1
Medal Table
Medal Table
1 120 107 61 288
2 60 42 42 144
3 48 25 48 121
4 33 44 53 130
5 22 17 34 73
6 8 10 10 28
7 4 6 10 20
8 3 0 0 3
9 2 6 4 12
10 2 3 7 12
11 1 8 8 17
12 1 6 6 13
13 1 0 0 1
14 0 6 5 11
15 0 5 17 22
16 0 3 3 6
17 0 2 1 3
18 0 1 3 4
19 0 0 0 0
Total 305 291 312 908
SELECT AVG Gold FROM table WHERE Silver < 107 AND Bronze > 42 AND Rank = 3
107 42 3