How many gold values have totals over 30, are bronzing over 35, and are in Swimming?
Sport Gold Silver Bronze Total
New Zealand at the Commonwealth Games
16455340
text real real real real
2-16455340-2
By sport
By sport
Athletics 32 42 49 125
Cycling 16 34 32 82
Swimming 13 29 35 77
Lawn bowls 11 10 14 35
Weightlifting 10 11 15 36
Rowing 9 14 7 30
Boxing 5 5 20 30
Rugby sevens 4 0 0 4
Wrestling 3 9 15 27
Squash 3 3 2 8
Netball 2 2 0 4
Gymnastics 2 0 8 10
Fencing 1 2 3 6
Judo 1 2 3 6
Table tennis 1 1 2 4
Archery 1 0 0 1
Badminton 0 2 8 10
Hockey 0 2 2 4
Triathlon 0 2 2 4
Basketball 0 2 0 2
Water polo 0 1 0 1
Diving 0 0 4 4
Synchronised swimming 0 0 2 2
Cricket 0 0 1 1
SELECT COUNT Gold FROM table WHERE Total > 30 AND Sport = swimming AND Bronze > 35
30 swimming 35