SELECT t.id_country, country, truncate( min(t.rate+o.rate) ,2) rate
                     FROM bell.origination o
                    INNER join bell.termination t on t.id_cc=o.id_cc
                    INNER join bell.card_company cc on cc.id_card_company=o.id_cc
                    inner join bell.country c on c.id_country=t.id_country
                    WHERE o.id_country='182'
                      AND cc.active='y'
                    group by t.id_country
                    ORDER by country

0 1 2 5 Afghanistan 17.90 555 Afghanistan - CELL 15.20 13 Albania 17.20 415 Albania - CELL 30.60 10 Algeria 6.70 556 Algeria - CELL 55.55 11 Amer. Samoa 2.60 12 Andorra 2.80 547 Andorra - CELL 18.20 18 Angola 5.30 557 Angola - CELL 12.20 235 Anguilla 19.70 558 Anguilla - CELL 25.30 6 Antarctica 66.90 14 Antigua 22.20 475 Antigua - CELL 35.30 15 Argentina 1.10 244 Argentina - Buenos Aires 1.00 287 Argentina - CELL 12.60 649 Argentina - Cordoba 7.20 650 Argentina - La Plata 7.00 652 Argentina - Mendoza 7.30 16 Armenia 13.00 289 Armenia - CELL 22.40 17 Aruba 11.30 417 Aruba - CELL 21.10 245 Ascension Isl. 100.20 7 Australia 1.40 246 Australia - CELL 2.90 8 Austria 1.40 290 Austria - CELL 3.50 9 Azerbaijan 19.40 291 Azerbaijan - CELL 31.30 236 Bahamas 17.30 418 Bahamas - CELL 25.60 21 Bahrain 10.30 561 Bahrain - CELL 12.20 19 Bangladesh 1.90 297 Bangladesh - CELL 2.00 294 Bangladesh - Dhaka 16.35 237 Barbados 7.50 554 Barbados - CELL 19.70 22 Belarus 35.00 419 Belarus - CELL 35.00 23 Belgium 4.50 420 Belgium - CELL 24.00 24 Belize 25.90 562 Belize - CELL 25.90 25 Benin 26.90 476 Benin - CELL 33.60 27 Bermuda 3.80 421 Bermuda - CELL 2.10 36 Bhutan 5.20 563 Bhutan - CELL 5.20 28 Bolivia 10.10 477 Bolivia - CELL 17.60 564 Bolivia - Cochabamba 13.80 565 Bolivia - La Paz 17.00 566 Bolivia - Santa Cruz 14.70 30 Bosnia&Herz. 18.30 422 Bosnia&Herz. - CELL 35.00 31 Botswana 12.00 478 Botswana - CELL 25.30 32 Brazil 1.00 305 Brazil - CELL 2.20 238 British V.I. 18.80 424 British V.I. - CELL 22.80 33 Brunei 4.00 567 Brunei - CELL 14.40 29 Bulgaria 1.00 425 Bulgaria - CELL 7.90 404 Bulgaria - Sofia 7.50 34 Burkina Faso 28.70 568 Burkina Faso - CELL 35.90 35 Burundi 23.60 479 Burundi - CELL 51.90 83 Cambodia 6.00 452 Cambodia - CELL 5.50 84 Cameroon 13.00 480 Cameroon - CELL 25.00 569 Cameroon - Douala 22.70 85 Canada 1.00 150 Cape Verde 13.70 481 Cape Verde - CELL 26.20 234 CAR 35.10 570 CAR - CELL 53.10 224 Cayman Isl. 5.80 426 Cayman Isl. - CELL 16.10 208 Chad Rep. 43.90 482 Chad Rep. - CELL 46.60 209 Chile 1.20 483 Chile - CELL 1.40 90 China 4.00 307 China - CELL 4.00 141 Christmas Isl. 7.00 92 Colombia 2.50 954 Colombia - Armenia 14.90 320 Colombia - Barranquilla 12.90 314 Colombia - Bogota 2.50 955 Colombia - Bucaramanga 14.80 956 Colombia - Buga 11.00 315 Colombia - Cali 11.50 958 Colombia - Cartegna 16.30 313 Colombia - CELL 2.50 961 Colombia - Manizales 14.50 317 Colombia - Medellin 14.30 962 Colombia - Palmira 12.40 947 Colombia - Pereira 15.30 93 Comoros 37.80 572 Comoros - CELL 40.40 94 Congo 46.40 548 Congo - CELL 41.80 145 Cook Isl. 52.30 95 Costa Rica 2.90 324 Costa Rica - CELL 6.10 207 Croatia 2.30 325 Croatia - CELL 3.50 96 Cuba 64.50 37 Cuba Guantanamo 63.10 88 Cyprus 1.70 326 Cyprus - CELL 5.90 241 Czech Rep. 3.20 273 Czech Rep. - CELL 6.50 67 Dem. Rep. Congo 40.00 544 Dem. Rep. Congo - CELL 38.70 62 Denmark 1.90 327 Denmark - CELL 2.50 64 Diego Garcia 110.00 63 Djibouti 32.50 228 Dominica 18.90 485 Dominica - CELL 25.40 65 Dominican Rep. 3.50 329 Dominican Rep. - CELL 10.10 453 East Timor 27.50 213 Ecuador 11.60 330 Ecuador - CELL 16.90 696 Ecuador - Cuenca 20.00 332 Ecuador - Guayaquil 28.00 66 Egypt 8.40 334 Egypt - CELL 10.10 164 El Salvador 12.70 335 El Salvador - CELL 19.70 214 Equator. Guinea 38.70 576 Equator. Guinea - CELL 48.40 215 Eritrea 24.70 577 Eritrea - CELL 25.90 216 Estonia 1.80 336 Estonia - CELL 35.00 217 Ethiopia 17.50 486 Ethiopia - CELL 19.30 199 Faeroe Isl. 21.30 578 Faeroe Isl. - CELL 2.90 203 Falkland Isl. 77.40 200 Fiji Isl. 27.70 487 Fiji Isl. - CELL 26.30 202 Finland 8.30 337 Finland - CELL 12.00 204 France 1.40 265 France - CELL 6.50 205 French Guiana 1.30 581 French Guiana - CELL 4.20 206 French Polynesia 29.80 44 Gabon Rep. 27.70 488 Gabon Rep. - CELL 55.55 47 Gambia 39.80 583 Gambia - CELL 46.50 60 Georgia 9.00 338 Georgia - CELL 22.00 53 Germany 1.00 255 Germany - CELL 3.20 48 Ghana 23.10 489 Ghana - CELL 24.60 967 Ghana - Tema 25.00 54 Gibraltar 3.50 490 Gibraltar - CELL 13.90 59 Greece 1.60 343 Greece - CELL 1.30 58 Greenland 5.50 57 Grenada 9.90 492 Grenada - CELL 24.20 49 Guadeloupe 1.30 493 Guadeloupe - CELL 6.70 61 Guam 2.10 50 Guatemala 8.20 494 Guatemala - CELL 14.70 51 Guinea 23.20 495 Guinea - CELL 45.50 52 Guinea Bissau 53.30 496 Guinea Bissau - CELL 55.90 46 Guyana 23.50 497 Guyana - CELL 18.60 45 Haiti 24.40 498 Haiti - CELL 27.20 969 Haiti - Port-au-Prince 21.10 55 Honduras 12.60 499 Honduras - CELL 14.00 56 Hong Kong 2.40 345 Hong Kong - CELL 3.50 41 Hungary 3.60 346 Hungary - CELL 4.50 78 Iceland 1.00 500 Iceland - CELL 1.90 72 India 1.50 455 India - Ahmadabad 30.40 347 India - CELL 1.70 352 India - Hyderabad 20.90 349 India - New Delhi 24.00 73 Indonesia 3.20 356 Indonesia - CELL 3.90 353 Indonesia - Jakarta 11.50 76 Iran 12.60 456 Iran - CELL 17.10 75 Iraq 14.60 585 Iraq - CELL 19.10 77 Ireland 1.00 358 Ireland - CELL 1.20 71 Israel 3.99 254 Israel - CELL 9.90 630 Israel-Palestine 18.10 80 Italy 1.00 267 Italy - CELL 3.90 26 Ivory Coast 30.60 458 Ivory Coast - Abidjan 23.00 501 Ivory Coast - CELL 31.10 221 Jamaica 21.60 459 Jamaica - CELL 20.00 222 Japan 1.90 359 Japan - CELL 3.50 74 Jordan 15.60 461 Jordan - CELL 18.70 82 Kazakhstan 3.70 428 Kazakhstan - CELL 16.30 87 Kenya 13.70 502 Kenya - CELL 10.20 586 Kenya - Nairobi 22.10 160 Kiribati 92.10 409 Korea North 39.20 407 Korea South 1.50 364 Korea South - CELL 3.30 638 Korea South - Seoul 7.40 97 Kuwait 4.10 504 Kuwait - CELL 3.80 89 Kyrgyzstan 10.20 278 Kyrgyzstan - CELL 16.90 98 Laos 8.30 99 Latvia 16.10 249 Latvia - CELL 28.00 102 Lebanon 10.50 505 Lebanon - CELL 15.70 100 Lesotho 27.77 588 Lesotho - CELL 30.00 101 Liberia 44.40 549 Liberia - CELL 42.90 103 Libya 26.90 589 Libya - CELL 29.10 229 Liechtenstein 6.60 104 Lithuania 14.90 365 Lithuania - CELL 27.77 105 Luxembourg 1.60 433 Luxembourg - CELL 3.50 110 Macau 15.00 506 Macau - CELL 16.70 225 Macedonia 16.90 473 Macedonia - CELL 41.20 109 Madagascar 43.80 507 Madagascar - CELL 58.40 111 Malawi 14.90 590 Malawi - CELL 14.90 112 Malaysia 1.10 366 Malaysia - CELL 1.30 113 Maldives 90.50 591 Maldives - CELL 85.30 108 Mali 25.00 592 Mali - CELL 38.40 114 Malta 13.70 474 Malta - CELL 23.20 117 Marshall Isl. 25.30 116 Martinique 1.30 683 Martinique - CELL 15.00 107 Mauritania 49.00 594 Mauritania - CELL 58.50 106 Mauritius 12.30 509 Mauritius - CELL 10.50 138 Mayotte Isl. 3.50 595 Mayotte Isl. - CELL 7.60 118 Mexico 1.00 434 Mexico - CELL 1.00 462 Mexico - Guadalajara 8.30 369 Mexico - MexicoCity 7.40 370 Mexico - Monterrey 11.20 675 Mexico - Puebla 9.20 119 Micronesia 53.60 121 Moldova 30.00 371 Moldova - CELL 22.90 122 Monaco 7.20 510 Monaco - CELL 33.60 123 Mongolia 1.80 597 Mongolia - CELL 1.80 647 Montenegro 19.50 648 Montenegro - CELL 54.90 124 Montserrat 23.40 598 Montserrat - CELL 44.40 115 Morocco 2.10 625 Morocco - Casablanca 36.50 511 Morocco - CELL 49.70 120 Mozambique 12.90 512 Mozambique - CELL 28.40 125 Myanmar (Burma) 19.20 599 Myanmar (Burma) - CELL 14.20 126 Namibia 7.30 513 Namibia - CELL 4.90 127 Nauru 126.70 129 Nepal 11.20 515 Nepal - CELL 15.20 131 Nether. Antilles 8.70 516 Nether. Antilles - CELL 27.50 975 Nether. Antilles - Curacao 5.60 978 Nether. Antilles - St. Martin CELL 19.90 132 Netherlands 1.20 372 Netherlands - CELL 4.50 643 Nevis 40.50 136 New Caledonia 19.60 135 New Zealand 1.40 437 New Zealand - CELL 7.00 133 Nicaragua 13.70 517 Nicaragua - CELL 21.80 230 Niger 28.60 600 Niger - CELL 28.60 130 Nigeria 8.40 518 Nigeria - CELL 7.10 996 Nigeria - Ilorin 33.40 134 Niue Isl. 64.60 139 Norfolk Isl. 50.00 142 Northern Mariana Islands 3.60 137 Norway 1.00 373 Norway - CELL 1.20 149 Oman 10.80 521 Oman - CELL 18.80 151 Pakistan 6.50 466 Pakistan - CELL 6.50 465 Pakistan - Lahore 59.80 152 Palau 25.10 601 Palau - CELL 40.00 618 Palestine 16.90 619 Palestine - CELL 19.30 153 Panama 2.50 522 Panama - CELL 10.90 636 Panama - Panama-City 27.30 154 Papua New Guinea 69.00 523 Papua New Guinea - CELL 103.20 155 Paraguay 5.00 467 Paraguay - Asuncion 5.00 550 Paraguay - CELL 5.50 156 Peru 1.00 524 Peru - CELL 1.00 468 Peru - Lima 8.00 201 Philippines 11.70 375 Philippines - CELL 12.60 374 Philippines - Manila 27.70 157 Poland 1.40 260 Poland - CELL 2.20 158 Portugal 1.00 438 Portugal - CELL 2.00 159 Puerto Rico 1.00 86 Qatar 16.30 525 Qatar - CELL 17.30 140 Reunion Isl. 1.60 526 Reunion Isl. - CELL 9.00 163 Romania 1.50 271 Romania - Bucharest 12.00 274 Romania - CELL 3.00 161 Russia 2.50 279 Russia - CELL 4.90 247 Russia - Moscow 3.60 248 Russia - S.Peter 2.40 162 Rwanda 29.10 602 Rwanda - CELL 30.60 165 San Marino 8.80 166 Sao Tome 82.50 168 Saudi Arabia 9.50 470 Saudi Arabia - CELL 13.80 410 Saudi Arabia - Riyadh 13.80 174 Senegal 31.00 527 Senegal - CELL 21.80 376 Senegal - Dakar 34.10 218 Serbia 16.90 451 Serbia - CELL 44.10 171 Seychelles Isl. 40.20 605 Seychelles Isl. - CELL 40.20 233 Sierra Leone 44.80 528 Sierra Leone - CELL 48.30 175 Singapore 1.20 377 Singapore - CELL 1.20 1044 Sint Maarten 11.90 240 Slovakia 1.00 440 Slovakia - CELL 6.80 177 Slovenia 8.30 441 Slovenia - CELL 41.66 178 Solomon Island 82.70 179 Somalia 37.90 606 Somalia - CELL 25.50 219 South Africa 5.10 380 South Africa - CELL 6.10 1030 South Sudan 35.00 79 Spain 1.00 381 Spain - CELL 1.60 4 Special Services 8.60 212 Sri Lanka 15.30 442 Sri Lanka - CELL 14.80 231 St. Helena 177.30 242 St. Kitts 17.60 530 St. Kitts - CELL 18.70 167 St. Lucia 15.10 531 St. Lucia - CELL 25.40 172 St. Vincent 15.00 532 St. Vincent - CELL 22.00 173 St.Pierre&Miquel 35.80 180 Sudan 16.20 609 Sudan - CELL 16.80 181 Suriname 13.90 533 Suriname - CELL 18.30 169 Swaziland 7.60 534 Swaziland - CELL 19.00 211 Sweden 1.00 387 Sweden - CELL 1.30 210 Switzerland 2.00 389 Switzerland - CELL 12.00 176 Syria 21.40 610 Syria - CELL 24.30 184 Taiwan 2.20 390 Taiwan - CELL 14.00 639 Taiwan - Taipei 7.20 183 Tajikistan 14.20 443 Tajikistan - CELL 19.90 186 Tanzania 30.00 535 Tanzania - CELL 31.80 185 Thailand 1.30 412 Thailand - Bangkok 10.60 445 Thailand - CELL 1.40 187 Togo 28.60 612 Togo - CELL 34.40 188 Tokelau 86.20 189 Tonga 59.30 553 Tonga - CELL 74.80 190 Trinidad&Tobago 5.50 536 Trinidad&Tobago - CELL 19.00 192 Tunisia 38.60 537 Tunisia - CELL 71.42 194 Turkey 3.50 628 Turkey - Ankara 16.70 391 Turkey - CELL 15.60 392 Turkey - Istanbul 14.10 985 Turkey - Izmir 16.70 193 Turkmenistan 10.20 446 Turkmenistan - CELL 13.50 146 Turks&Caicos 32.90 614 Turks&Caicos - CELL 21.60 191 Tuvalu 79.70 148 UAE 15.50 447 UAE - CELL 18.00 195 Uganda 24.40 539 Uganda - CELL 24.40 286 UK 1.00 262 UK - CELL 3.00 197 Ukraine 14.40 393 Ukraine - CELL 13.40 198 Uruguay 5.50 540 Uruguay - CELL 12.70 1025 Uruguay - Montevideo 6.00 239 US Virgin Isl. 1.80 182 USA 1.00 283 USA - Alaska 1.90 284 USA - Hawaii 1.10 1056 USA - Toll Free 1.00 196 Uzbekistan 7.90 449 Uzbekistan - CELL 8.90 38 Vanuatu 105.90 541 Vanuatu - CELL 104.00 42 Venezuela 1.00 413 Venezuela - Caracas 11.60 450 Venezuela - CELL 5.40 414 Venezuela - Maracaibo 15.00 43 Vietnam 7.10 396 Vietnam - CELL 10.30 147 Wallis&Fortuna 33.40 69 Western Samoa 57.10 542 Western Samoa - CELL 101.30 223 Yemen 13.60 543 Yemen - CELL 15.50 68 Zambia 22.00 545 Zambia - CELL 44.80 70 Zimbabwe 20.00 546 Zimbabwe - CELL 48.80