What-all is the sum of Gold, when is greater to 6, when Rank is 1, and when Bronze is less than 61?
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 SUM Gold FROM table WHERE Silver > 6 AND Rank = 1 AND Bronze < 61
6 1 61