When The Total one less than 1, and Bronze is 0, how many Gold medal are there?
Rank Nation Gold Silver Bronze Total
Bobsleigh at the 1998 Winter Olympics
1158514
real text real real real real
2-1158514-3
Medal table
Medal table
1 Germany 1 0 1 2
2 Canada 1 0 0 1
2 Italy 1 0 0 1
4 Switzerland 0 1 0 1
5 France 0 0 1 1
5 Great Britain 0 0 1 1
SELECT SUM Gold FROM table WHERE Bronze = 0 AND Total < 1
0 1