How many total have a Gold larger 0, and Bronze smaller 0?
Rank Nation Gold Silver Bronze Total
FIBT World Championships 2012
17873606
real text real real real real
2-17873606-7
Medal table
Medal table
1 United States 4 0 1 5
2 Canada 1 2 1 4
3 Latvia 1 0 0 1
4 Germany 0 4 2 6
5 New Zealand 0 0 1 1
5 United Kingdom 0 0 1 1
SELECT COUNT Total FROM table WHERE Gold > 0 AND Bronze < 0
0 0