BEGIN; BEGIN select s_acctbal, s_name, n_name, p_partkey, p_mfgr, s_address, s_phone, s_comment from part, supplier, partsupp, nation, region where p_partkey = ps_partkey and s_suppkey = ps_suppkey and p_size = 33 and p_type like '%TIN' and s_nationkey = n_nationkey and n_regionkey = r_regionkey and r_name = 'AFRICA' and ps_supplycost = ( select min(ps_supplycost) from partsupp, supplier, nation, region where p_partkey = ps_partkey and s_suppkey = ps_suppkey and s_nationkey = n_nationkey and n_regionkey = r_regionkey and r_name = 'AFRICA' ) order by s_acctbal desc, n_name, s_name, p_partkey LIMIT 100; s_acctbal | s_name | n_name | p_partkey | p_mfgr | s_address | s_phone | s_comment -----------+---------------------------+---------------------------+-----------+---------------------------+------------------------------------------+-----------------+------------------------------------------------------------------------------------------------------ 9992.7 | Supplier#000002543 | KENYA | 302542 | Manufacturer#1 | WKxIzDMHU82botDW9TRVqqQkxWyDmB3XCM1TP5K | 24-355-893-5866 | toward the special, final excuses wake ironic deposits. regular requests play. bold requests wak 9992.7 | Supplier#000002543 | KENYA | 1952504 | Manufacturer#1 | WKxIzDMHU82botDW9TRVqqQkxWyDmB3XCM1TP5K | 24-355-893-5866 | toward the special, final excuses wake ironic deposits. regular requests play. bold requests wak 9991.82 | Supplier#000013431 | MOROCCO | 1563400 | Manufacturer#1 | ja7Y 6cwzHMj7qv0BmQ2xcj09iY | 25-449-471-6608 | oost blithely slyly unusual requests. quickly even theodolites sleep. slyly regular 9987.73 | Supplier#000013186 | ALGERIA | 263181 | Manufacturer#5 | JUt9l87vbEMj5n7nM5OZg9zLqnXgt3wXmcVB | 10-716-279-8103 | ly bold accounts. carefully ironic courts wake care 9987.73 | Supplier#000013186 | ALGERIA | 1463157 | Manufacturer#5 | JUt9l87vbEMj5n7nM5OZg9zLqnXgt3wXmcVB | 10-716-279-8103 | ly bold accounts. carefully ironic courts wake care 9984.81 | Supplier#000018659 | ALGERIA | 93658 | Manufacturer#5 | B2pXToSQjW1RwBnsF5W2tu7cG | 10-972-177-8024 | ual instructions haggle furiously along the slyly regular accounts. deposits wake slyly; furiously 9984.6 | Supplier#000039918 | MOZAMBIQUE | 1914898 | Manufacturer#5 | Mq8cZaRHRz3,ZVMYfuNT5aIAeH1LQfIz7nH9mL1 | 26-229-107-3801 | ironic ideas above the furiously final frets must boost slyly p 9982.85 | Supplier#000090106 | ETHIOPIA | 1640073 | Manufacturer#2 | ifYxblkRo2qoiwbR 3Wb5 | 15-207-423-7347 | ide of the bold platelets. fluff 9981.31 | Supplier#000010734 | KENYA | 910733 | Manufacturer#2 | BeO3FRHV1cjJkubxg6k8Tn | 24-342-840-3453 | . theodolites wake about the express ideas. fluffily 9981.14 | Supplier#000078627 | ALGERIA | 478626 | Manufacturer#1 | YV67lTdwFYmDrN iJXQSX rtTOQZPT4ivyxYp,4 | 10-626-965-9538 | silent ideas boost! ironic, ironic accounts outside the permanently even requests 9981.14 | Supplier#000078627 | ALGERIA | 1203590 | Manufacturer#3 | YV67lTdwFYmDrN iJXQSX rtTOQZPT4ivyxYp,4 | 10-626-965-9538 | silent ideas boost! ironic, ironic accounts outside the permanently even requests 9978.89 | Supplier#000079128 | MOROCCO | 1104094 | Manufacturer#1 | mm,XQwj2wzKVbYMyHF | 25-431-663-6083 | packages boost carefully about the final, even theodolites. slyly final requests maintain carefu 9978.85 | Supplier#000068570 | KENYA | 618557 | Manufacturer#3 | NjcKftct9NhSLhhdJYRfaQJaGnF8gf1qFimKzi | 24-354-801-2738 | ular deposits hinder blithely according to the fluffily express packages. furiously bold excu 9973.22 | Supplier#000083438 | ETHIOPIA | 1483437 | Manufacturer#3 | ,yCO0LcimO0Pf5xh | 15-741-448-6845 | y. slyly special packages along the furiously final pinto beans 9970.97 | Supplier#000034901 | MOROCCO | 1534900 | Manufacturer#1 | 6z1F9S9zXVa0NONKz4gXF | 25-869-917-3767 | dolites. slyly unusual foxes above the blithely ironi 9967.6 | Supplier#000075320 | MOROCCO | 625307 | Manufacturer#4 | aGx6eKDaQjJLbXJ2tBPZPQhuC5Q7v0sJ, | 25-709-297-7984 | ependencies haggle blithely across the silent, bold instructions! 9967.6 | Supplier#000075320 | MOROCCO | 1000289 | Manufacturer#3 | aGx6eKDaQjJLbXJ2tBPZPQhuC5Q7v0sJ, | 25-709-297-7984 | ependencies haggle blithely across the silent, bold instructions! 9967.6 | Supplier#000075320 | MOROCCO | 1275319 | Manufacturer#4 | aGx6eKDaQjJLbXJ2tBPZPQhuC5Q7v0sJ, | 25-709-297-7984 | ependencies haggle blithely across the silent, bold instructions! 9960.55 | Supplier#000079832 | KENYA | 454827 | Manufacturer#2 | ese OJ3icJw0eqrs8 | 24-964-405-9207 | ts inside the even, even warthogs haggle carefully among the regular courts. ruthless packa 9956.65 | Supplier#000093532 | ALGERIA | 943513 | Manufacturer#3 | zZr9pk63iYDDJGeU | 10-421-177-4603 | around the warhorses: furi 9952.33 | Supplier#000025262 | MOROCCO | 1450219 | Manufacturer#1 | Z8pARuZ1Il | 25-338-890-5189 | unusual deposits above the slyly pending theo 9952.16 | Supplier#000092274 | ETHIOPIA | 592273 | Manufacturer#2 | zlBj0FnyTqtaM9Q | 15-282-366-3649 | ect slyly carefully special deposits. carefully regular dependencies against the carefully bold 9950.11 | Supplier#000050711 | MOROCCO | 175707 | Manufacturer#3 | 51PH 3g6gPrDt | 25-197-657-2547 | ss the deposits. unusual ideas after the final requests cajole blithely alo 9948.02 | Supplier#000084909 | MOROCCO | 1634876 | Manufacturer#5 | SWuvbvUQPTbIaRXftsQPfS04,e2 | 25-728-621-6700 | its should haggle after the ironic, pending deposits. slyly bold do 9946.12 | Supplier#000095760 | ALGERIA | 1795759 | Manufacturer#1 | 3EWiyBilHphC2b | 10-442-421-2903 | the slyly unusual theodolit 9945.69 | Supplier#000008146 | ETHIOPIA | 1483131 | Manufacturer#5 | P4Lt0mMYW4ffCqv | 15-526-243-1532 | uriously ironic theodolites haggle blithely ironic deposits. even Tiresias doubt carefully. th 9942.91 | Supplier#000040734 | KENYA | 590723 | Manufacturer#1 | Lxh1AB9OxMuXr,yNJz312 | 24-375-894-1104 | quickly silent packages play always a 9940.66 | Supplier#000096564 | KENYA | 1846527 | Manufacturer#4 | LYtWJXx0V2WicxfwwWz | 24-846-279-8460 | pecial, even platelets. special pint 9938.29 | Supplier#000021933 | KENYA | 1846878 | Manufacturer#5 | am6s9SDw6NIz7AbUiKz0iM5p | 24-824-372-7787 | oxes. carefully even pains use slyly. even grouches wake court 9938.29 | Supplier#000021933 | KENYA | 1946875 | Manufacturer#1 | am6s9SDw6NIz7AbUiKz0iM5p | 24-824-372-7787 | oxes. carefully even pains use slyly. even grouches wake court 9937.79 | Supplier#000036644 | KENYA | 1361604 | Manufacturer#2 | yjwFKVwB93xy9xejv3gzjTc4d6tiiaaxiH8 | 24-814-751-4756 | y furiously final packages. carefully even 9937.4 | Supplier#000020456 | MOROCCO | 1345416 | Manufacturer#2 | 1Mwa6Y6ByN xG | 25-833-379-7137 | s. closely ironic ideas mold alo 9934.76 | Supplier#000071142 | MOROCCO | 496129 | Manufacturer#1 | b4qmTJhWm4o9 | 25-310-453-4084 | ithely bold orbits sleep fluffily about the even accounts. pinto b 9934.76 | Supplier#000071142 | MOROCCO | 1196108 | Manufacturer#2 | b4qmTJhWm4o9 | 25-310-453-4084 | ithely bold orbits sleep fluffily about the even accounts. pinto b 9934.5 | Supplier#000069099 | KENYA | 1669098 | Manufacturer#3 | 9zcGfmIuHoNrkP8YN7yzNRkIlqFV,MQMj68k | 24-982-466-7084 | ully dogged frets wake regular packages. special deposits wake about the regularly pending idea 9932.3 | Supplier#000098275 | ETHIOPIA | 998274 | Manufacturer#2 | Kb20M 1lY,Skds2eUuKYV64q0TBKHXn | 15-242-221-5003 | ep ironic, regular theodolites. blithe accounts affix silently slyly express ideas. even 9932.21 | Supplier#000009347 | MOROCCO | 309346 | Manufacturer#5 | ZtUTsLXGWxAzti | 25-779-427-4737 | c packages nag around the furiously regular packages. ironic reque 9931.03 | Supplier#000014328 | MOROCCO | 814327 | Manufacturer#4 | VxQYJ6woPLxDjecU7O51G8rPpT512m2vHHGhp6 | 25-106-589-4727 | the warhorses. quickly final foxes use packages. special, bold gifts wake blithely slyly bl 9931.03 | Supplier#000014328 | MOROCCO | 1889309 | Manufacturer#2 | VxQYJ6woPLxDjecU7O51G8rPpT512m2vHHGhp6 | 25-106-589-4727 | the warhorses. quickly final foxes use packages. special, bold gifts wake blithely slyly bl 9929.82 | Supplier#000084807 | MOROCCO | 359803 | Manufacturer#1 | bRyoX,SYBheyS2gaDU5xpntwkI9B, | 25-406-490-8393 | beans are pending ideas. blithely regular instr 9929.67 | Supplier#000060573 | MOZAMBIQUE | 1310546 | Manufacturer#2 | vqVt4M8,mb cju1F163XwPs | 26-932-989-5981 | ily above the quickly final requests. furious 9925.17 | Supplier#000029604 | ETHIOPIA | 379597 | Manufacturer#5 | cewfHv5Gmrq1Fc | 15-462-290-9144 | itaphs by the fluffily express somas breach furiously regular epitaphs! carefully even account 9925.17 | Supplier#000029604 | ETHIOPIA | 1054573 | Manufacturer#5 | cewfHv5Gmrq1Fc | 15-462-290-9144 | itaphs by the fluffily express somas breach furiously regular epitaphs! carefully even account 9925.17 | Supplier#000029604 | ETHIOPIA | 1104592 | Manufacturer#5 | cewfHv5Gmrq1Fc | 15-462-290-9144 | itaphs by the fluffily express somas breach furiously regular epitaphs! carefully even account 9925.17 | Supplier#000029604 | ETHIOPIA | 1879567 | Manufacturer#5 | cewfHv5Gmrq1Fc | 15-462-290-9144 | itaphs by the fluffily express somas breach furiously regular epitaphs! carefully even account 9923.19 | Supplier#000076449 | ALGERIA | 501433 | Manufacturer#5 | n fyGj5cC0bJ5m1n9wTfTVU1LG3lhwFkVLzq | 10-996-702-6944 | its. requests wake across 9922.43 | Supplier#000012213 | MOZAMBIQUE | 1237176 | Manufacturer#5 | c32eDeggXXh6jgOVXf7Yr | 26-389-912-3207 | uses. regular deposits sleep after the furious 9921.89 | Supplier#000053183 | KENYA | 353182 | Manufacturer#4 | 0FXNcYXSmnOzB | 24-123-788-1917 | y furious packages use bold, special foxes 9918.37 | Supplier#000076013 | MOZAMBIQUE | 1850994 | Manufacturer#3 | xwkofnmAMWnEi7q,5DMLa4 | 26-593-115-4871 | accounts wake. stealthily unusual packages use. fox 9918.23 | Supplier#000044036 | MOZAMBIQUE | 419031 | Manufacturer#5 | 6E 8s5tyef,C0VNyR3VvUo | 26-168-400-5419 | ly regular dolphins. carefully regular packages hang unusual pinto beans-- slyly ironic deposi 9917.42 | Supplier#000061210 | MOROCCO | 1661209 | Manufacturer#1 | 5NQhd0nL28 | 25-366-558-2380 | quests across the bold dependencies cajole around the quickly ironic accoun 9912.82 | Supplier#000092241 | MOROCCO | 1867222 | Manufacturer#2 | 4mgVtdGeqIvUL33TZ5uhn1,PQaFY | 25-392-189-2998 | r theodolites. idly bold acc 9910.45 | Supplier#000057901 | MOZAMBIQUE | 1457900 | Manufacturer#5 | XKqfQcswUzGp9RihbMu9xI34K4fzFis6 | 26-472-973-4158 | ffily bold deposits boost blithely fluffily regular instructions. requests use slyly. slyly regul 9910.45 | Supplier#000057901 | MOZAMBIQUE | 1532885 | Manufacturer#3 | XKqfQcswUzGp9RihbMu9xI34K4fzFis6 | 26-472-973-4158 | ffily bold deposits boost blithely fluffily regular instructions. requests use slyly. slyly regul 9909.82 | Supplier#000044898 | ALGERIA | 944897 | Manufacturer#1 | xoTjaFgFWFoqWmpn5ackRY1H4W | 10-109-527-3452 | ly ironic packages. blithely unusual instructions integrate express requests. care 9899.72 | Supplier#000011199 | MOROCCO | 436186 | Manufacturer#5 | JAOwXUbRbb5RD2 | 25-640-858-8688 | eposits haggle blithely. blithely ironic excuses across the furiously final dep 9899.72 | Supplier#000011199 | MOROCCO | 536183 | Manufacturer#4 | JAOwXUbRbb5RD2 | 25-640-858-8688 | eposits haggle blithely. blithely ironic excuses across the furiously final dep 9899.52 | Supplier#000092724 | KENYA | 542713 | Manufacturer#1 | 68pzCdFpr,tSnKPi6x 4LzPKh4LkjAn | 24-459-222-4423 | arefully ironic packages could have to 9899.17 | Supplier#000054348 | KENYA | 1404319 | Manufacturer#1 | O8g6iCCNSCZY | 24-930-712-7245 | e carefully furious deposits 9899.17 | Supplier#000054348 | KENYA | 1854347 | Manufacturer#5 | O8g6iCCNSCZY | 24-930-712-7245 | e carefully furious deposits 9898.76 | Supplier#000023313 | ETHIOPIA | 1348273 | Manufacturer#2 | CAQO55FzYKaBZuedzi8E0Xp,,,z | 15-743-306-9839 | quickly silent deposits. quickly even dep 9898.76 | Supplier#000023313 | ETHIOPIA | 1923312 | Manufacturer#4 | CAQO55FzYKaBZuedzi8E0Xp,,,z | 15-743-306-9839 | quickly silent deposits. quickly even dep 9892.44 | Supplier#000015379 | MOROCCO | 1240342 | Manufacturer#5 | qjFVEfwbWG | 25-354-137-1048 | hang carefully according to the carefully ironic requests. furiously regular foxes 9891.58 | Supplier#000019193 | ALGERIA | 119192 | Manufacturer#3 | FCykn9OqfjF F6RjY,lgPBTe1W | 10-936-993-1956 | nst the express, regular packages. busily ironic accou 9888.93 | Supplier#000062341 | ETHIOPIA | 1112318 | Manufacturer#1 | P1GpAP4BNTV UHJ k84 | 15-384-796-3190 | old accounts use blithely above the sauternes. quickly unusual noto 9888.26 | Supplier#000002580 | ETHIOPIA | 1652547 | Manufacturer#3 | qrs2ub3wSjbzv1kc0a4k | 15-284-495-3109 | sias. carefully even orbits wake blithe 9885.57 | Supplier#000007289 | KENYA | 1032258 | Manufacturer#2 | GoYBOvCn2XuN,7i | 24-296-865-2694 | riously ironic excuses. furiously bold accounts doubt above the dependencies. id 9882.29 | Supplier#000050996 | MOZAMBIQUE | 550995 | Manufacturer#3 | l xf3R67Tx7hlimHKZeD4rs,QCv41 | 26-443-207-5363 | nts affix about the blithely regular foxes. ironic accounts cajo 9880.29 | Supplier#000025356 | MOROCCO | 1325355 | Manufacturer#3 | HkQwQ0m9j1op | 25-613-568-1878 | iously blithely unusual depths. furiously regular hockey players cajo 9878.29 | Supplier#000078001 | ETHIOPIA | 53000 | Manufacturer#3 | HoLcMaEwRcSkkRZSMKjFJNbDCKoML | 15-920-317-9052 | dependencies. never unusual pinto beans cajole blithel 9875.27 | Supplier#000005802 | MOZAMBIQUE | 555791 | Manufacturer#4 | 1oI3h0bV0AEQtHh,2LfPimvikjSiB3FyQzYBZ | 26-526-396-6060 | s. slyly careful instructions detect slyly among the regular asympto 9871.51 | Supplier#000048913 | MOROCCO | 1848912 | Manufacturer#5 | hioqxkHxvmKvT8MSdjHjk8p | 25-576-388-1605 | pending platelets should have to sleep furiously ironic deposits. furiously final 9870.35 | Supplier#000052772 | KENYA | 1627755 | Manufacturer#2 | leVrLTc8nMO FFLlFyikQjmchZv | 24-588-467-7078 | . final courts cajole furiously final warhorses; thin 9869.42 | Supplier#000031207 | ALGERIA | 631206 | Manufacturer#4 | oPNw9znk13WCKbfPir7lqVAgh | 10-429-948-6641 | around the asymptotes sleep blithely above the always final dependencies. unusual 9862.25 | Supplier#000076943 | ETHIOPIA | 326936 | Manufacturer#4 | 4ZLkL,DS7tyID YLRc,viNV8eoGB58 | 15-463-850-5655 | es. blithely regular requests through the blithely ironic accounts 9860.71 | Supplier#000054998 | KENYA | 1204973 | Manufacturer#3 | iXIgm32Jg0MrnDBx | 24-850-287-3755 | bove the carefully ironic reques 9856.55 | Supplier#000009878 | MOZAMBIQUE | 909877 | Manufacturer#5 | 2kwsctKFEhB9inlp,hvlJ | 26-864-214-4496 | quickly. unusual, final ideas nag slowly at the ironic accounts. slyly ironic instructions according 9855.54 | Supplier#000075044 | MOROCCO | 375043 | Manufacturer#1 | 9wgE5MzBHl52U1PcjeDsLGf37rlDbA9Ged | 25-979-563-2836 | ccording to the blithely unusual deposits. thinly pendin 9852.36 | Supplier#000043723 | ALGERIA | 618716 | Manufacturer#2 | aeN6fvXvJZ,F27AWbz | 10-116-286-5670 | packages cajole furiously about the carefully ironic requ 9845.02 | Supplier#000063091 | MOROCCO | 1838072 | Manufacturer#4 | DprNRb1 UPXoKxTXxW | 25-346-887-3650 | ackages. deposits wake furiously. furiousl 9845.02 | Supplier#000063091 | MOROCCO | 1938071 | Manufacturer#4 | DprNRb1 UPXoKxTXxW | 25-346-887-3650 | ackages. deposits wake furiously. furiousl 9844 | Supplier#000000236 | MOROCCO | 1350209 | Manufacturer#2 | dZExtd1dlMyrPdSqDC3 | 25-250-525-2436 | lar platelets. blithely ironic packages cajole blithely special ins 9843.18 | Supplier#000066713 | MOROCCO | 1166712 | Manufacturer#3 | cndPPoU3xV5,d60YR | 25-456-899-6483 | express ideas. final, pending asymptotes sleep fluffily. slyly regular p 9839.12 | Supplier#000098285 | ETHIOPIA | 898284 | Manufacturer#4 | Hl5ZjvW0Hk2M3DNND0QQCdlVOGwBo | 15-519-907-8695 | silent foxes. quickly regular pinto beans about the blithely bold instructions dou 9837.37 | Supplier#000011153 | MOROCCO | 661140 | Manufacturer#1 | zu9X3WcSss5zy K3D | 25-434-239-1361 | bout the quickly bold instructions are blithely 9835.99 | Supplier#000084536 | MOZAMBIQUE | 1284535 | Manufacturer#3 | PVjXD5WRiR9akliOzMwrerJRW2MIpwq | 26-528-386-7477 | ithely. blithely unusual packages are carefully ironic multipliers. quickly final pinto beans 9833.64 | Supplier#000018585 | ALGERIA | 193583 | Manufacturer#1 | sIP2UO58wkRVDH03U | 10-755-145-9724 | gged, final excuses. careful 9833.62 | Supplier#000056142 | MOROCCO | 1856141 | Manufacturer#4 | t4xdhHWmCPa5iSb9q6Iy5NSIMLx,j5Sb | 25-547-943-6598 | even pinto beans are carefully deposits. even, expr 9831.49 | Supplier#000073685 | ALGERIA | 1923646 | Manufacturer#3 | 7vjfO6de6T | 10-177-441-8672 | regular, even deposits was blithely against the ironic theod 9830.14 | Supplier#000099249 | MOROCCO | 199248 | Manufacturer#5 | yBpNDOSixbr6Uyk0021nWGcPf7LwKk | 25-358-931-1981 | ate furiously. regularly bold excus 9824.93 | Supplier#000096848 | ALGERIA | 846831 | Manufacturer#2 | HOCpOZdR dmIcq70Qj,LeP | 10-191-404-9083 | ng to the furiously final foxes; always fi 9823.78 | Supplier#000017870 | ALGERIA | 1667837 | Manufacturer#3 | csivE9ACzne8 | 10-199-631-9671 | usly alongside of the carefully even sentiments. pinto beans wa 9821.29 | Supplier#000061300 | MOROCCO | 636293 | Manufacturer#3 | 3irOCUst1NMsbt | 25-247-606-4166 | ymptotes. packages wake carefully quickly final 9813.03 | Supplier#000085349 | KENYA | 285348 | Manufacturer#4 | Rdm5c6N9dgCz04JGJ4JuDmUrl4bzNgiz | 24-281-922-5621 | requests. fluffily express dinos for the fur 9810.94 | Supplier#000081152 | ETHIOPIA | 1756134 | Manufacturer#4 | XSa0kjjBCTsjlWBDFynCRWBgnleHwa4, YeReGWc | 15-873-933-7936 | ironic packages. quickly regular instructions must cajole even package 9810.37 | Supplier#000001211 | MOROCCO | 476206 | Manufacturer#1 | g lldwVuium jP79qGZT6ztUjTuCZmZKrNlcHglK | 25-752-441-6583 | ong the idly even packages. furiously special acco 9810.37 | Supplier#000001211 | MOROCCO | 1051190 | Manufacturer#2 | g lldwVuium jP79qGZT6ztUjTuCZmZKrNlcHglK | 25-752-441-6583 | ong the idly even packages. furiously special acco 9803.13 | Supplier#000034855 | MOZAMBIQUE | 34854 | Manufacturer#1 | FEu0YuedM8GOe8Nt | 26-610-128-1275 | nic deposits breach deposits. carefully ironic dolphins are carefully final packages. special pack 9799.45 | Supplier#000037943 | ETHIOPIA | 712935 | Manufacturer#5 | OhDvb4UlavM2UVkvU3qQSyFQeFPBSJtudPcG | 15-546-826-1597 | ar pinto beans. regular requests cajole blith 9798.64 | Supplier#000058299 | ETHIOPIA | 1658298 | Manufacturer#3 | OPWvhHt npgWH | 15-648-110-1366 | . carefully express accounts haggle thin, pending accounts. ironic, special requests wake quickly (100 rows) COMMIT; COMMIT