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

5 Afghanistan 14.28 555 Afghanistan - CELL 19.00 13 Albania 10.08 415 Albania - CELL 25.00 621 Albania - Tirana 15.28 10 Algeria 5.48 556 Algeria - CELL 39.53 11 Amer. Samoa 2.58 416 Amer. Samoan - CELL 2.98 12 Andorra 2.68 547 Andorra - CELL 17.88 18 Angola 8.08 557 Angola - CELL 14.38 235 Anguilla 9.68 558 Anguilla - CELL 15.40 6 Antarctica 58.92 559 Antarctica - CELL 180.00 14 Antigua 10.38 475 Antigua - CELL 18.37 15 Argentina 1.18 244 Argentina - Buenos Aires 0.38 287 Argentina - CELL 7.58 649 Argentina - Cordoba 0.78 650 Argentina - La Plata 3.53 652 Argentina - Mendoza 3.10 723 Argentina - Pilar 4.47 715 Argentina - Santa Fe 4.03 719 Argentina - Tucuman 4.26 950 Argentina - Zarate 3.55 16 Armenia 8.80 289 Armenia - CELL 13.28 285 Armenia - Yerevan 15.51 17 Aruba 8.57 417 Aruba - CELL 17.28 245 Ascension Isl. 57.10 560 Ascension Isl. - CELL 290.00 7 Australia 1.28 246 Australia - CELL 3.90 645 Australia - Sydney 2.21 8 Austria 4.00 290 Austria - CELL 18.00 654 Austria - Vienna 2.30 9 Azerbaijan 16.50 291 Azerbaijan - CELL 22.71 236 Bahamas 6.38 418 Bahamas - CELL 13.90 21 Bahrain 2.58 561 Bahrain - CELL 5.58 19 Bangladesh 3.28 297 Bangladesh - CELL 3.20 292 Bangladesh - Chittagong 3.58 294 Bangladesh - Dhaka 3.50 296 Bangladesh - Sylhet 2.80 237 Barbados 12.08 554 Barbados - CELL 16.38 22 Belarus 24.58 419 Belarus - CELL 22.78 23 Belgium 4.50 655 Belgium - Brussels 5.12 420 Belgium - CELL 2.48 24 Belize 17.28 562 Belize - CELL 19.30 25 Benin 13.70 476 Benin - CELL 15.78 27 Bermuda 3.48 421 Bermuda - CELL 3.60 36 Bhutan 6.48 563 Bhutan - CELL 6.88 28 Bolivia 5.98 477 Bolivia - CELL 11.08 564 Bolivia - Cochabamba 5.88 565 Bolivia - La Paz 5.88 566 Bolivia - Santa Cruz 5.88 30 Bosnia&Herz. 10.38 422 Bosnia&Herz. - CELL 24.00 31 Botswana 6.88 478 Botswana - CELL 16.78 32 Brazil 1.28 303 Brazil - Belo Horizonte 1.38 747 Brazil - Brasilia 1.38 305 Brazil - CELL 3.08 657 Brazil - Florianopolis 1.38 952 Brazil - Governado Valeres 8.06 744 Brazil - Porto Alegre 1.58 301 Brazil - Rio de Janeiro 1.17 298 Brazil - Sao Paulo 1.17 1005 Brazil - Vitoria 1.08 238 British V.I. 9.98 424 British V.I. - CELL 16.00 33 Brunei 3.08 567 Brunei - CELL 3.08 29 Bulgaria 2.00 425 Bulgaria - CELL 13.68 404 Bulgaria - Sofia 1.40 34 Burkina Faso 18.28 568 Burkina Faso - CELL 26.78 35 Burundi 19.58 479 Burundi - CELL 31.88 83 Cambodia 4.18 452 Cambodia - CELL 4.18 84 Cameroon 10.18 480 Cameroon - CELL 21.98 569 Cameroon - Douala 8.88 85 Canada 0.58 682 Canada - CELL 0.70 949 Canada - Yukon 8.08 150 Cape Verde 12.78 481 Cape Verde - CELL 19.68 234 CAR 22.00 570 CAR - CELL 28.00 224 Cayman Isl. 5.58 426 Cayman Isl. - CELL 12.58 208 Chad Rep. 11.00 482 Chad Rep. - CELL 45.00 209 Chile 1.28 483 Chile - CELL 3.90 90 China 1.08 306 China - Beijing 1.28 307 China - CELL 1.08 309 China - Shanghai 2.60 692 China - Tianjin 2.78 141 Christmas Isl. 2.30 571 Christmas Isl. - CELL 10.71 92 Colombia 2.58 954 Colombia - Armenia 10.15 320 Colombia - Barranquilla 1.58 314 Colombia - Bogota 1.58 955 Colombia - Bucaramanga 10.70 956 Colombia - Buga 7.62 315 Colombia - Cali 1.58 957 Colombia - Cali Region 10.67 958 Colombia - Cartegna 10.54 313 Colombia - CELL 2.40 961 Colombia - Manizales 8.42 317 Colombia - Medellin 1.58 962 Colombia - Palmira 8.46 947 Colombia - Pereira 1.58 93 Comoros 26.58 572 Comoros - CELL 31.68 94 Congo 24.00 548 Congo - CELL 29.98 145 Cook Isl. 64.12 484 Cook Isl. - CELL 54.42 95 Costa Rica 1.58 324 Costa Rica - CELL 4.58 207 Croatia 3.48 325 Croatia - CELL 15.50 96 Cuba 70.00 573 Cuba - CELL 69.68 37 Cuba Guantanamo 70.00 88 Cyprus 1.10 326 Cyprus - CELL 2.18 241 Czech Rep. 1.56 273 Czech Rep. - CELL 6.28 261 Czech Rep. - Prague 2.72 67 Dem. Rep. Congo 26.00 544 Dem. Rep. Congo - CELL 24.30 992 Dem. Rep. Congo - Kinshasa 34.29 62 Denmark 0.88 327 Denmark - CELL 1.98 64 Diego Garcia 55.00 574 Diego Garcia - CELL 21.58 63 Djibouti 34.00 328 Djibouti - CELL 33.55 228 Dominica 7.48 485 Dominica - CELL 17.95 65 Dominican Rep. 2.78 329 Dominican Rep. - CELL 6.58 784 Dominican Rep. - Santo Domingo 4.58 453 East Timor 57.08 575 East Timor - CELL 58.88 213 Ecuador 8.18 330 Ecuador - CELL 15.48 696 Ecuador - Cuenca 10.46 332 Ecuador - Guayaquil 9.10 333 Ecuador - Quito 9.27 66 Egypt 7.00 965 Egypt - Alexandria 8.78 640 Egypt - Cairo 8.68 334 Egypt - CELL 4.50 164 El Salvador 10.28 335 El Salvador - CELL 13.98 214 Equator. Guinea 19.98 576 Equator. Guinea - CELL 19.98 215 Eritrea 21.00 577 Eritrea - CELL 21.98 216 Estonia 1.95 336 Estonia - CELL 14.28 993 Estonia - Tallin 5.91 217 Ethiopia 17.23 994 Ethiopia - Addis Ababa 44.35 486 Ethiopia - CELL 19.30 199 Faeroe Isl. 2.28 578 Faeroe Isl. - CELL 10.68 203 Falkland Isl. 9.58 579 Falkland Isl. - CELL 74.40 200 Fiji Isl. 20.08 487 Fiji Isl. - CELL 21.08 202 Finland 2.73 337 Finland - CELL 3.18 787 Finland - Helsinki 6.65 204 France 0.48 265 France - CELL 3.48 227 French Antilles 2.48 580 French Antilles - CELL 10.08 205 French Guiana 2.98 581 French Guiana - CELL 5.18 206 French Polynesia 15.78 582 French Polynesia - CELL 22.97 44 Gabon Rep. 18.08 488 Gabon Rep. - CELL 30.00 47 Gambia 28.18 583 Gambia - CELL 43.30 60 Georgia 9.00 338 Georgia - CELL 19.50 454 Georgia - Tbilisi 19.08 53 Germany 0.94 665 Germany - Berlin 2.08 255 Germany - CELL 3.08 668 Germany - Frankfurt 2.09 48 Ghana 17.58 624 Ghana - Accra 17.32 489 Ghana - CELL 18.88 967 Ghana - Tema 11.27 54 Gibraltar 3.80 490 Gibraltar - CELL 4.26 59 Greece 1.18 339 Greece - Athens 1.08 343 Greece - CELL 3.88 58 Greenland 24.50 491 Greenland - CELL 46.70 57 Grenada 9.80 492 Grenada - CELL 18.44 49 Guadeloupe 1.10 493 Guadeloupe - CELL 4.38 61 Guam 1.88 584 Guam - CELL 5.00 50 Guatemala 7.38 494 Guatemala - CELL 11.15 51 Guinea 18.45 495 Guinea - CELL 32.44 52 Guinea Bissau 32.38 496 Guinea Bissau - CELL 36.08 46 Guyana 18.38 497 Guyana - CELL 16.58 45 Haiti 21.08 498 Haiti - CELL 23.38 969 Haiti - Port-au-Prince 16.15 55 Honduras 9.35 499 Honduras - CELL 13.25 56 Hong Kong 1.08 345 Hong Kong - CELL 0.78 41 Hungary 1.40 270 Hungary - Budapest 2.73 346 Hungary - CELL 5.18 78 Iceland 1.56 500 Iceland - CELL 2.78 72 India 1.33 455 India - Ahmadabad 1.98 351 India - Bangalore 1.98 348 India - Bombay 1.98 1007 India - Calcutta 1.98 347 India - CELL 1.33 1009 India - Gujarat 1.98 352 India - Hyderabad 1.98 706 India - Kolkata 5.30 350 India - Madras 1.98 349 India - New Delhi 1.98 707 India - Pune 1.98 1013 India - Punjab 1.88 73 Indonesia 2.60 356 Indonesia - CELL 2.60 353 Indonesia - Jakarta 1.98 948 Indonesia - Surabaya 1.98 1 Inmarsat 648.37 76 Iran 11.53 456 Iran - CELL 13.28 457 Iran - Tehran 7.50 75 Iraq 4.68 632 Iraq - Baghdad 2.73 585 Iraq - CELL 14.80 77 Ireland 0.68 358 Ireland - CELL 4.38 357 Ireland - Dublin 4.73 71 Israel 1.00 254 Israel - CELL 2.58 630 Israel-Palestine 17.15 80 Italy 0.78 267 Italy - CELL 6.68 26 Ivory Coast 15.90 458 Ivory Coast - Abidjan 22.02 501 Ivory Coast - CELL 22.28 221 Jamaica 12.50 459 Jamaica - CELL 17.87 222 Japan 1.88 359 Japan - CELL 6.98 693 Japan - Osaka 1.68 74 Jordan 8.08 460 Jordan - Amman 16.18 461 Jordan - CELL 10.78 82 Kazakhstan 1.48 620 Kazakhstan - Almaty 1.38 428 Kazakhstan - CELL 7.50 637 Kazakhstan - Karaganda 0.68 87 Kenya 6.58 502 Kenya - CELL 9.00 995 Kenya - Mombasa 15.18 586 Kenya - Nairobi 17.17 160 Kiribati 60.08 503 Kiribati - CELL 85.88 409 Korea North 44.70 429 Korea North - CELL 190.00 407 Korea South 1.08 364 Korea South - CELL 1.80 638 Korea South - Seoul 1.38 97 Kuwait 4.50 504 Kuwait - CELL 4.58 89 Kyrgyzstan 8.18 278 Kyrgyzstan - CELL 10.50 98 Laos 5.07 587 Laos - CELL 5.07 99 Latvia 12.60 249 Latvia - CELL 23.86 102 Lebanon 7.28 505 Lebanon - CELL 11.69 100 Lesotho 17.58 588 Lesotho - CELL 18.68 101 Liberia 16.00 549 Liberia - CELL 30.88 103 Libya 17.88 589 Libya - CELL 30.00 229 Liechtenstein 6.00 432 Liechtenstein - CELL 9.68 104 Lithuania 10.18 365 Lithuania - CELL 27.08 105 Luxembourg 1.56 433 Luxembourg - CELL 2.48 110 Macau 3.48 506 Macau - CELL 3.48 225 Macedonia 9.38 473 Macedonia - CELL 24.62 109 Madagascar 30.06 507 Madagascar - CELL 45.00 111 Malawi 9.45 590 Malawi - CELL 9.73 112 Malaysia 0.78 366 Malaysia - CELL 2.38 367 Malaysia - Kuala Lumpur 2.55 113 Maldives 50.00 591 Maldives - CELL 50.00 108 Mali 16.30 695 Mali - Bamako 18.91 592 Mali - CELL 19.90 114 Malta 0.88 474 Malta - CELL 1.88 117 Marshall Isl. 22.58 508 Marshall Isl. - CELL 21.48 116 Martinique 4.25 683 Martinique - CELL 9.45 107 Mauritania 25.58 594 Mauritania - CELL 33.30 106 Mauritius 12.84 509 Mauritius - CELL 13.08 138 Mayotte Isl. 15.68 595 Mayotte Isl. - CELL 24.53 118 Mexico 0.58 633 Mexico - Acapulco 1.68 702 Mexico - Aguascalientes 1.68 701 Mexico - Celaya 1.68 434 Mexico - CELL 0.78 462 Mexico - Guadalajara 0.48 925 Mexico - Irapuato 1.68 634 Mexico - Leon 1.68 369 Mexico - MexicoCity 0.48 370 Mexico - Monterrey 0.48 818 Mexico - Morelia 2.48 675 Mexico - Puebla 1.68 703 Mexico - Queretaro 1.68 699 Mexico - San Luis Potosi 1.68 684 Mexico - Tijuana 1.68 676 Mexico - Toluca 1.68 700 Mexico - Torreon 1.68 119 Micronesia 41.22 596 Micronesia - CELL 44.78 121 Moldova 14.62 371 Moldova - CELL 17.18 122 Monaco 2.34 510 Monaco - CELL 24.00 123 Mongolia 2.20 597 Mongolia - CELL 2.48 647 Montenegro 11.38 648 Montenegro - CELL 24.60 124 Montserrat 12.80 598 Montserrat - CELL 12.80 115 Morocco 1.80 625 Morocco - Casablanca 10.77 511 Morocco - CELL 29.90 626 Morocco - Rabat 25.87 120 Mozambique 7.48 512 Mozambique - CELL 13.28 125 Myanmar (Burma) 24.18 599 Myanmar (Burma) - CELL 21.18 126 Namibia 4.88 513 Namibia - CELL 4.88 127 Nauru 48.90 514 Nauru - CELL 53.80 129 Nepal 11.68 515 Nepal - CELL 12.50 617 Nepal - Katmandu 9.90 131 Nether. Antilles 8.38 516 Nether. Antilles - CELL 10.28 977 Nether. Antilles - St. Martin 20.29 132 Netherlands 1.17 372 Netherlands - CELL 3.28 643 Nevis 12.41 644 Nevis - CELL 19.30 136 New Caledonia 16.68 436 New Caledonia - CELL 16.68 135 New Zealand 1.38 437 New Zealand - CELL 4.28 133 Nicaragua 10.68 517 Nicaragua - CELL 18.85 979 Nicaragua - Managua 21.40 230 Niger 14.50 600 Niger - CELL 17.68 130 Nigeria 6.66 518 Nigeria - CELL 6.66 996 Nigeria - Ilorin 33.40 627 Nigeria - Lagos 7.71 697 Nigeria - Owerri 12.68 134 Niue Isl. 40.00 519 Niue Isl. - CELL 70.88 139 Norfolk Isl. 50.00 520 Norfolk Isl. - CELL 81.86 142 Northern Mariana Islands 2.88 137 Norway 1.18 373 Norway - CELL 1.78 149 Oman 10.08 521 Oman - CELL 21.88 151 Pakistan 3.00 466 Pakistan - CELL 3.00 464 Pakistan - Karachi 33.29 465 Pakistan - Lahore 36.59 152 Palau 22.38 601 Palau - CELL 22.38 618 Palestine 12.00 619 Palestine - CELL 16.78 153 Panama 2.20 522 Panama - CELL 9.35 636 Panama - Panama-City 2.08 154 Papua New Guinea 45.08 523 Papua New Guinea - CELL 57.32 155 Paraguay 3.18 467 Paraguay - Asuncion 3.58 550 Paraguay - CELL 7.00 156 Peru 1.28 524 Peru - CELL 3.18 468 Peru - Lima 0.88 201 Philippines 9.90 981 Philippines - Cebu 20.19 375 Philippines - CELL 9.90 374 Philippines - Manila 12.48 157 Poland 0.98 260 Poland - CELL 6.98 259 Poland - Warsaw 1.01 158 Portugal 1.08 438 Portugal - CELL 4.68 159 Puerto Rico 1.08 439 Puerto Rico - CELL 1.40 86 Qatar 15.48 525 Qatar - CELL 15.58 140 Reunion Isl. 1.58 526 Reunion Isl. - CELL 10.08 163 Romania 1.10 271 Romania - Bucharest 1.28 274 Romania - CELL 1.88 161 Russia 2.30 279 Russia - CELL 3.58 247 Russia - Moscow 1.50 982 Russia - Rostovdon 7.44 248 Russia - S.Peter 1.20 162 Rwanda 22.63 602 Rwanda - CELL 22.88 165 San Marino 2.08 551 San Marino - CELL 3.08 166 Sao Tome 70.18 603 Sao Tome - CELL 70.18 168 Saudi Arabia 7.72 470 Saudi Arabia - CELL 11.08 604 Saudi Arabia - Dhahran 8.50 469 Saudi Arabia - Jeddah 6.00 410 Saudi Arabia - Riyadh 6.00 174 Senegal 21.04 527 Senegal - CELL 30.00 376 Senegal - Dakar 22.09 218 Serbia 9.58 635 Serbia - Belgrade 11.33 451 Serbia - CELL 24.00 171 Seychelles Isl. 22.00 605 Seychelles Isl. - CELL 22.00 233 Sierra Leone 30.00 528 Sierra Leone - CELL 32.81 983 Sierra Leone - Freetown 23.43 175 Singapore 1.08 377 Singapore - CELL 1.10 240 Slovakia 1.58 411 Slovakia - Bratislava 5.20 440 Slovakia - CELL 3.98 177 Slovenia 1.87 441 Slovenia - CELL 22.18 178 Solomon Isl. 55.90 529 Solomon Isl. - CELL 61.49 179 Somalia 39.36 606 Somalia - CELL 34.08 219 South Africa 2.50 380 South Africa - CELL 5.00 1030 South Sudan 23.68 1033 South Sudan - CELL 20.48 79 Spain 0.78 386 Spain - Barcelona 2.13 381 Spain - CELL 2.88 212 Sri Lanka 9.08 442 Sri Lanka - CELL 10.78 984 Sri Lanka - Colombo 19.17 231 St. Helena 70.00 607 St. Helena - CELL 625.00 242 St. Kitts 10.88 530 St. Kitts - CELL 22.20 167 St. Lucia 10.28 531 St. Lucia - CELL 18.20 172 St. Vincent 10.08 532 St. Vincent - CELL 18.50 173 St.Pierre&Miquel 10.40 608 St.Pierre&Miquel - CELL 16.90 180 Sudan 11.70 609 Sudan - CELL 11.70 181 Suriname 12.28 533 Suriname - CELL 16.68 169 Swaziland 3.88 534 Swaziland - CELL 14.88 211 Sweden 0.78 387 Sweden - CELL 1.88 210 Switzerland 1.18 389 Switzerland - CELL 17.20 176 Syria 10.98 610 Syria - CELL 15.60 184 Taiwan 1.08 390 Taiwan - CELL 0.99 639 Taiwan - Taipei 1.09 183 Tajikistan 6.63 443 Tajikistan - CELL 7.01 186 Tanzania 12.50 535 Tanzania - CELL 22.68 611 Tanzania - Dar Es Salaam 19.47 185 Thailand 1.00 412 Thailand - Bangkok 1.58 445 Thailand - CELL 1.00 187 Togo 26.80 612 Togo - CELL 24.80 188 Tokelau 96.50 613 Tokelau - CELL 160.00 189 Tonga 32.48 553 Tonga - CELL 49.22 190 Trinidad&Tobago 6.50 536 Trinidad&Tobago - CELL 16.88 192 Tunisia 28.72 537 Tunisia - CELL 35.00 194 Turkey 1.87 628 Turkey - Ankara 2.88 1022 Turkey - Antalya 2.78 1023 Turkey - Bursa 2.68 391 Turkey - CELL 10.98 392 Turkey - Istanbul 1.38 985 Turkey - Izmir 2.78 193 Turkmenistan 9.35 446 Turkmenistan - CELL 9.88 146 Turks&Caicos 11.18 614 Turks&Caicos - CELL 15.59 191 Tuvalu 85.00 538 Tuvalu - CELL 86.58 148 UAE 13.20 447 UAE - CELL 13.21 195 Uganda 6.40 539 Uganda - CELL 18.40 286 UK 0.38 262 UK - CELL 1.48 272 UK - London 0.48 197 Ukraine 7.98 393 Ukraine - CELL 12.48 472 Ukraine - Dnepropetrovsk 13.06 685 Ukraine - Kharkov 12.48 250 Ukraine - Kiev 12.18 471 Ukraine - Lvov 12.18 251 Ukraine - Odessa 12.48 198 Uruguay 4.98 540 Uruguay - CELL 13.25 1025 Uruguay - Montevideo 4.28 239 US Virgin Isl. 1.68 448 US Virgin Isl. - CELL 3.30 283 USA - Alaska 2.50 182 USA - Continental 0.80 284 USA - Hawaii 1.38 196 Uzbekistan 4.29 449 Uzbekistan - CELL 4.68 710 Uzbekistan - Tashkent 5.01 38 Vanuatu 43.58 541 Vanuatu - CELL 56.58 39 Vatican 2.21 42 Venezuela 2.08 413 Venezuela - Caracas 1.56 450 Venezuela - CELL 5.38 414 Venezuela - Maracaibo 2.48 43 Vietnam 4.30 396 Vietnam - CELL 4.30 688 Vietnam - Ho Chi Minh 5.07 147 Wallis&Fortuna 30.40 616 Wallis&Fortuna - CELL 720.00 69 Western Samoa 27.50 542 Western Samoa - CELL 48.80 223 Yemen 11.73 543 Yemen - CELL 11.99 689 Zaire 155.00 691 Zaire - CELL 135.00 68 Zambia 6.00 545 Zambia - CELL 30.00 989 Zambia - Lusaka 9.90 629 Zanzibar 12.50 70 Zimbabwe 8.33 546 Zimbabwe - CELL 32.22