How much Bronze one have one Golds more larger 0, and one Total more smaller 1?
Rank Nation Gold Silver Bronze Total
Football at the 2012 Summer Olympics
14244631
text text real real real real
2-14244631-6
Medal table
Medal table
1 Mexico 1 0 0 1
1 United States 1 0 0 1
3 Brazil 0 1 0 1
3 Japan 0 1 0 1
5 Canada 0 0 1 1
5 South Korea 0 0 1 1
Total Total 2 2 2 6
SELECT COUNT Bronze FROM table WHERE Gold > 0 AND Total < 1
0 1