Are Naming the sum of rank for bronze less than 1 and gold of 1 with total less than 1
Rank Nation Gold Silver Bronze Total
2005 Jeux de la Francophonie
12402019
real text real real real real
2-12402019-5
Cultural events
Cultural events
1 Lebanon 2 1 0 3
2 French Community of Belgium 1 0 1 2
3 Benin 1 0 0 1
3 Canada 1 0 0 1
3 Lithuania 1 0 0 1
3 Madagascar 1 0 0 1
7 France 0 1 1 2
7 Niger 0 1 1 2
9 New Brunswick 0 1 0 1
9 Quebec 0 1 0 1
9 Cape Verde 0 1 0 1
9 Morocco 0 1 0 1
13 Burkina Faso 0 0 1 1
13 Republic of the Congo 0 0 1 1
13 Ivory Coast 0 0 1 1
13 Macedonia 0 0 1 1
SELECT SUM Rank FROM table WHERE Bronze < 1 AND Gold = 1 AND Total < 1
1 1 1