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 = 8 and p_type like '%STEEL' 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 -----------+---------------------------+---------------------------+-----------+---------------------------+------------------------------------------+-----------------+----------------------------------------------------------------------------------------------------- 9997.98 | Supplier#000078004 | ETHIOPIA | 978003 | Manufacturer#1 | 7K83zTraGcQAs1rsQgWoVW,1OsuaYhCHY9l qaE | 15-533-414-6562 | c requests cajole slyly according to t 9995.38 | Supplier#000020360 | MOROCCO | 1220359 | Manufacturer#3 | p4dmVmNU1tn gJuLfW06jfz6tHW2gzyx5Naz | 25-995-683-3624 | ake at the blithely ironic packages. quickly even theodolites integra 9992.26 | Supplier#000001833 | MOZAMBIQUE | 401832 | Manufacturer#2 | 5Jw0JRVxg8g5wWHl20BY gxj6AC23Lx | 26-441-871-5201 | onic deposits. furiously pending tithes sleep. regular excuses sleep a 9991.71 | Supplier#000039886 | ETHIOPIA | 1189863 | Manufacturer#1 | rH7D0s wXCJ30d3kDeabv | 15-585-638-2423 | uests nag furiously. express, final dolphins wake carefully across the blithely regular ac 9988.57 | Supplier#000096429 | KENYA | 1596428 | Manufacturer#3 | ZViewjGTaaRoJEL8FWktsgLZzAKGNP 6rYErC | 24-815-949-5778 | ccounts breach across the si 9984.81 | Supplier#000018659 | ALGERIA | 1743607 | Manufacturer#4 | B2pXToSQjW1RwBnsF5W2tu7cG | 10-972-177-8024 | ual instructions haggle furiously along the slyly regular accounts. deposits wake slyly; furiously 9980.01 | Supplier#000010952 | MOROCCO | 160949 | Manufacturer#2 | 8PkGBWH3CWYL9YdwXkfRvzr5O6417nMKoDO | 25-821-172-7309 | furiously regular theodolites. regular, special asymptotes haggle slyly among the 9978.89 | Supplier#000079128 | MOROCCO | 1629095 | Manufacturer#5 | mm,XQwj2wzKVbYMyHF | 25-431-663-6083 | packages boost carefully about the final, even theodolites. slyly final requests maintain carefu 9976.45 | Supplier#000019491 | ETHIOPIA | 594485 | Manufacturer#5 | 3v1wWC30BmxuLo | 15-476-916-1303 | efully special requests along the furiously even request 9969.31 | Supplier#000023129 | ETHIOPIA | 848104 | Manufacturer#5 | eGL2hU5yXGBi | 15-216-793-1574 | ests haggle blithely carefully silent requests. furiously ironic 9964.88 | Supplier#000035063 | ALGERIA | 1160029 | Manufacturer#4 | ,T51xQDRMAx0r37,xwEj69UtUhU29pmc9 | 10-929-580-5173 | riously carefully pending requests. carefully regular accounts sleep carefully after th 9963.11 | Supplier#000033668 | ETHIOPIA | 283663 | Manufacturer#3 | p e T,hRIM6qH9,DoR | 15-453-728-8137 | . deposits boost along the pending ideas. pending pinto beans sleep 9961.49 | Supplier#000023936 | ETHIOPIA | 1998916 | Manufacturer#2 | S3kjQh7,TyE5c6z | 15-808-991-6102 | ld pinto beans. express deposits acc 9959.96 | Supplier#000075774 | ETHIOPIA | 350770 | Manufacturer#1 | KIhccnC,,GHsRqN | 15-608-896-2042 | are furiously about the carefully bold platelets. carefull 9954.35 | Supplier#000065038 | ETHIOPIA | 465037 | Manufacturer#3 | VHlzQWt3oj7izRhjaAGc0nKG8ecYxmaogc | 15-750-871-6158 | ly bold packages. fluffily 9954.35 | Supplier#000065038 | ETHIOPIA | 1965037 | Manufacturer#2 | VHlzQWt3oj7izRhjaAGc0nKG8ecYxmaogc | 15-750-871-6158 | ly bold packages. fluffily 9952.16 | Supplier#000092274 | ETHIOPIA | 1167262 | Manufacturer#4 | zlBj0FnyTqtaM9Q | 15-282-366-3649 | ect slyly carefully special deposits. carefully regular dependencies against the carefully bold 9952.16 | Supplier#000092274 | ETHIOPIA | 1342247 | Manufacturer#5 | zlBj0FnyTqtaM9Q | 15-282-366-3649 | ect slyly carefully special deposits. carefully regular dependencies against the carefully bold 9950.11 | Supplier#000050711 | MOROCCO | 775689 | Manufacturer#4 | 51PH 3g6gPrDt | 25-197-657-2547 | ss the deposits. unusual ideas after the final requests cajole blithely alo 9949.19 | Supplier#000012568 | ETHIOPIA | 512567 | Manufacturer#1 | lithuC3SxVgDi1i8w43hgMcjYVnnZX9 | 15-638-122-2843 | y even platelets boost furiously 9943.06 | Supplier#000077706 | MOROCCO | 527695 | Manufacturer#5 | MOaWlzNujAhbEVucmajVkq62ZaRCxpbI | 25-348-647-2126 | ully special requests. regular theodolites across the carefully 9941.84 | Supplier#000094142 | ALGERIA | 1994141 | Manufacturer#3 | 1kaSCOtbQ6v3 | 10-787-930-9469 | regular accounts sleep fluffily of the bold orbits. fluffily close theodolites nag ironic ideas 9935.09 | Supplier#000079635 | ALGERIA | 929616 | Manufacturer#3 | jFEGcjVw9r,7HxvuGxa8 | 10-314-163-8268 | instructions. ironic ideas along the regular deposits run blithely final accounts. blithely regul 9932.21 | Supplier#000009347 | MOROCCO | 484342 | Manufacturer#5 | ZtUTsLXGWxAzti | 25-779-427-4737 | c packages nag around the furiously regular packages. ironic reque 9931.03 | Supplier#000014328 | MOROCCO | 539312 | Manufacturer#1 | VxQYJ6woPLxDjecU7O51G8rPpT512m2vHHGhp6 | 25-106-589-4727 | the warhorses. quickly final foxes use packages. special, bold gifts wake blithely slyly bl 9929.87 | Supplier#000070039 | MOZAMBIQUE | 1120016 | Manufacturer#2 | P7z4R1hmz jAdHZVtYycvY | 26-196-888-3536 | slyly special pinto beans according to the carefully bold 9929.82 | Supplier#000084807 | MOROCCO | 1884806 | Manufacturer#3 | bRyoX,SYBheyS2gaDU5xpntwkI9B, | 25-406-490-8393 | beans are pending ideas. blithely regular instr 9929.81 | Supplier#000078763 | KENYA | 1378762 | Manufacturer#2 | jbzdTjnEgJcq ul5JnGeSY3yvVOD,EdnmR6GxAF | 24-121-246-9886 | c accounts. foxes across the final packages cajol 9929.5 | Supplier#000031671 | MOZAMBIQUE | 806662 | Manufacturer#2 | XNUOFOWHe Ph8VgNaVjhpIxg3k0j4E9 | 26-805-525-4526 | ronic deposits. blithely express foxes kindle s 9928.43 | Supplier#000069094 | ETHIOPIA | 919075 | Manufacturer#5 | 28QWqcUeXlJ 8GXeAyozy1px1f4t | 15-205-630-3629 | wake. carefully express pains are about the bold accounts. bli 9925.05 | Supplier#000021788 | ALGERIA | 896779 | Manufacturer#4 | P SB5UrycyBo9CaD | 10-463-431-9598 | ecial asymptotes nag slyly quietly special patterns. furiously un 9924.87 | Supplier#000073670 | ALGERIA | 1423641 | Manufacturer#2 | 7QEnDOgUEreOBXm1ah | 10-828-276-5774 | ultipliers sleep furiously caref 9923.83 | Supplier#000035866 | ETHIOPIA | 1385839 | Manufacturer#1 | Cv8qtwLxHUhj5lscc5z HC0DTH4RVily7er | 15-779-219-1868 | dolphins use slyly even deposi 9922.43 | Supplier#000012213 | MOZAMBIQUE | 587207 | Manufacturer#4 | c32eDeggXXh6jgOVXf7Yr | 26-389-912-3207 | uses. regular deposits sleep after the furious 9922.43 | Supplier#000012213 | MOZAMBIQUE | 1562182 | Manufacturer#5 | c32eDeggXXh6jgOVXf7Yr | 26-389-912-3207 | uses. regular deposits sleep after the furious 9921.89 | Supplier#000053183 | KENYA | 803166 | Manufacturer#2 | 0FXNcYXSmnOzB | 24-123-788-1917 | y furious packages use bold, special foxes 9921.89 | Supplier#000053183 | KENYA | 1428168 | Manufacturer#4 | 0FXNcYXSmnOzB | 24-123-788-1917 | y furious packages use bold, special foxes 9918.23 | Supplier#000044036 | MOZAMBIQUE | 1219023 | Manufacturer#1 | 6E 8s5tyef,C0VNyR3VvUo | 26-168-400-5419 | ly regular dolphins. carefully regular packages hang unusual pinto beans-- slyly ironic deposi 9913.21 | Supplier#000020627 | MOROCCO | 1045596 | Manufacturer#2 | Hz8kY0KhjNVcdm knQ 3e9WUYfSMqRvLvsN61Qnp | 25-838-317-4448 | unwind according to the regular, final gro 9912.71 | Supplier#000013682 | ETHIOPIA | 1988662 | Manufacturer#2 | ppJhDh0bK6UVLNds | 15-777-839-3030 | the blithely final requests. blithely express ideas cajole against the instructions-- doggedly b 9912.09 | Supplier#000047897 | ALGERIA | 797882 | Manufacturer#3 | tkL9q2Z9LS0GZ97pocEdDylNXvHQR6F | 10-846-987-1780 | c packages. furiously regular packages haggle blithely. silent dinos haggle slyly above the f 9909.86 | Supplier#000025537 | ETHIOPIA | 500531 | Manufacturer#3 | AdqiZKDxxktQe8LPJPK1 | 15-328-963-8864 | ly final packages across the slyly pending decoys are blithe 9909.82 | Supplier#000044898 | ALGERIA | 1394871 | Manufacturer#3 | xoTjaFgFWFoqWmpn5ackRY1H4W | 10-109-527-3452 | ly ironic packages. blithely unusual instructions integrate express requests. care 9904.76 | Supplier#000064168 | MOROCCO | 1839149 | Manufacturer#1 | 7ACL5sy4F4TVKdmWmezojU | 25-324-456-6547 | final accounts wake quickly ab 9904.76 | Supplier#000064168 | MOROCCO | 1989110 | Manufacturer#2 | 7ACL5sy4F4TVKdmWmezojU | 25-324-456-6547 | final accounts wake quickly ab 9903.48 | Supplier#000073140 | ETHIOPIA | 623127 | Manufacturer#1 | NQ1WDQFfwAEa | 15-650-318-7270 | bold packages affix; regularly regular deposits doze sl 9902.9 | Supplier#000049816 | KENYA | 324812 | Manufacturer#1 | izadhZGQdoblHdqUFDP1Trj ABlVGwWIW G | 24-310-122-4880 | notornis wake carefully. furiously pending theodolites wake slyly after the permanently regular req 9899.52 | Supplier#000092724 | KENYA | 442715 | Manufacturer#5 | 68pzCdFpr,tSnKPi6x 4LzPKh4LkjAn | 24-459-222-4423 | arefully ironic packages could have to 9899.52 | Supplier#000092724 | KENYA | 1392723 | Manufacturer#2 | 68pzCdFpr,tSnKPi6x 4LzPKh4LkjAn | 24-459-222-4423 | arefully ironic packages could have to 9896.62 | Supplier#000034508 | MOROCCO | 909498 | Manufacturer#4 | 4A9sPryxncyRkDQ92VWLBF754WyZvs8G3yhzyL | 25-483-244-7428 | rding to the pending, final instructions. slyly even courts sleep. even, pe 9895.88 | Supplier#000037121 | MOROCCO | 1562075 | Manufacturer#2 | gUeTZtmsfxAqbuuuyI77 | 25-317-550-7308 | arefully even deposits sleep quickly 9891.75 | Supplier#000077660 | ETHIOPIA | 502644 | Manufacturer#5 | K0xxEf55 w | 15-753-886-7734 | posits. fluffily pending instructions sleep. fin 9891.48 | Supplier#000070463 | ETHIOPIA | 720448 | Manufacturer#1 | D nRv7,fDZt46ZWqjWG | 15-489-629-3067 | ly requests along the express, ironi 9886.32 | Supplier#000076868 | KENYA | 851859 | Manufacturer#3 | 0M4LIhetOGDAa,lcltQ | 24-940-721-7422 | ending deposits. packages wake after the bold, regular instructions: furiously bold foxes 9883.07 | Supplier#000037350 | ETHIOPIA | 1487321 | Manufacturer#4 | h9FSUv, s7TM | 15-672-555-8887 | special packages. dependencies wake permanently pending theodolites! carefully ironic pa 9879.31 | Supplier#000058398 | MOROCCO | 383388 | Manufacturer#2 | CSk9nFbk7iaxY4,V3cSKXfj06AuXZTaT1Xp1X0 | 25-675-462-4197 | o beans sleep quickly according to the quickly ironic orbits. accounts haggle according to the pen 9876.7 | Supplier#000036995 | KENYA | 1261958 | Manufacturer#4 | gTLNV5C32EDv82rzQC4dz | 24-423-227-5948 | regular accounts boost. requests nag quickly carefully even requests. furiously regular d 9876.56 | Supplier#000089798 | KENYA | 1189797 | Manufacturer#2 | XG0NjRZgiNNVBEqzgjG ZrreCY3d7Zk | 24-528-989-8496 | ges around the final pinto beans affi 9870.03 | Supplier#000045664 | MOROCCO | 20663 | Manufacturer#1 | 3w1s5pT2e2cGymRe5UGpXg8r | 25-585-594-7341 | ggle blithely across the carefully 9870.03 | Supplier#000045664 | MOROCCO | 1695631 | Manufacturer#4 | 3w1s5pT2e2cGymRe5UGpXg8r | 25-585-594-7341 | ggle blithely across the carefully 9869.03 | Supplier#000063304 | MOROCCO | 1363303 | Manufacturer#5 | 5VWSxgUflDU 01 lWmZ4IePRjSL,dwkVR | 25-273-623-8491 | about the ruthlessly regular accounts detect about the furiousl 9868.81 | Supplier#000081718 | MOROCCO | 56717 | Manufacturer#3 | 2QYEiU,IGan zXuVcuwLhLcr | 25-678-917-7405 | e deposits. furiously special ideas above the even dependencies haggle carefully against the furiou 9859.43 | Supplier#000067204 | MOZAMBIQUE | 1392164 | Manufacturer#3 | D9b1unu9n6 | 26-361-506-8640 | whithout the even accounts. blithely 9858.45 | Supplier#000009622 | ETHIOPIA | 659609 | Manufacturer#2 | nEfWHUKQ9VsiM1JdiwRi0P8oCcR | 15-676-570-3786 | fully ironic courts haggle final packages. ideas 9851.79 | Supplier#000020404 | ALGERIA | 1620403 | Manufacturer#1 | uVL1eMQ8kMsQstv06 | 10-578-758-5112 | . carefully ironic instructions are slyly slyly ironic deposits. never even d 9851.27 | Supplier#000004933 | MOZAMBIQUE | 1579917 | Manufacturer#4 | yCGb3EhmGL 6NB7Xw | 26-701-611-1882 | iously silent deposits are express deposits. slyly final deposits wake bold, daring depos 9849.98 | Supplier#000055020 | ALGERIA | 1130008 | Manufacturer#3 | pTSeFA0UPCY26CNI5M Tctgn,1Uw | 10-440-802-4726 | special pinto beans affix blithely a 9847.54 | Supplier#000041942 | MOZAMBIQUE | 216939 | Manufacturer#4 | HcjRl2tAGBi4FT,sf8KSPIbtUZxEKugpk3OcuN | 26-325-540-5392 | accounts use. ironic, final deposits boost quietly quickly pending packages; un 9847.54 | Supplier#000041942 | MOZAMBIQUE | 541941 | Manufacturer#5 | HcjRl2tAGBi4FT,sf8KSPIbtUZxEKugpk3OcuN | 26-325-540-5392 | accounts use. ironic, final deposits boost quietly quickly pending packages; un 9843.48 | Supplier#000066882 | ETHIOPIA | 1266881 | Manufacturer#2 | uVDcmy6hchpC6vHVFf2sho9xhIQ,AneBHvWj | 15-832-228-8246 | e slyly final accounts. slyly regular requests against the carefully unusual pint 9842.69 | Supplier#000050718 | MOROCCO | 500707 | Manufacturer#1 | me0EV7APUAKrXuOGRkg3imtkPIQ | 25-814-853-9163 | ily ironic requests cajole. slyly express ide 9840.51 | Supplier#000079567 | MOROCCO | 504551 | Manufacturer#3 | qpK4ilpQVqrabsgUmsSm3WWSUZ0 | 25-521-610-3779 | tes cajole according to the quickly express accounts. evenly 9840.49 | Supplier#000017326 | MOROCCO | 1992306 | Manufacturer#5 | MvoF3MYU6KdHawZS6unMdPozaZgM9jNItDFlRujD | 25-458-272-6727 | eans. carefully even dolphins sleep car 9836.65 | Supplier#000055280 | MOROCCO | 1005259 | Manufacturer#5 | T62MZjmpwZehHwI | 25-301-884-8105 | . furiously even foxes print carefully unusu 9831.79 | Supplier#000016052 | MOZAMBIQUE | 1391038 | Manufacturer#2 | sllIhO9IYnEq sditev9QJ | 26-516-353-6986 | usly? regular, unusual instructions engage quickly ironic, unusual accounts. blithely silent foxes 9830.39 | Supplier#000045155 | ETHIOPIA | 1395128 | Manufacturer#1 | mwbGa14pqhK,EGE utx7M814 z2 6rEEnyoJUPL | 15-468-867-5131 | ully bold instructions. carefully pending foxes along the sly 9823.56 | Supplier#000009597 | ALGERIA | 484592 | Manufacturer#2 | NzBmqXeWCAaQcPnn,nldM5XeD7md6G5qBqGQ | 10-525-491-6656 | refully ironic dependencies. blithely ironic pinto beans can nag slyly above the permanent dolphi 9821.86 | Supplier#000058434 | MOROCCO | 1933414 | Manufacturer#4 | 7WEm3zGtrNclkfa1k6 X bNQ | 25-181-336-2375 | silent foxes. carefully special packages detect 9821.29 | Supplier#000061300 | MOROCCO | 1836281 | Manufacturer#1 | 3irOCUst1NMsbt | 25-247-606-4166 | ymptotes. packages wake carefully quickly final 9813.03 | Supplier#000085349 | KENYA | 235344 | Manufacturer#3 | Rdm5c6N9dgCz04JGJ4JuDmUrl4bzNgiz | 24-281-922-5621 | requests. fluffily express dinos for the fur 9808.1 | Supplier#000094922 | MOROCCO | 1444893 | Manufacturer#5 | MR uUcICwcoY7 | 25-766-845-9012 | ilent, regular instructions doubt carefully fluffily ironic ac 9803.28 | Supplier#000095421 | MOROCCO | 495420 | Manufacturer#4 | WXZnRoXNkiPugeDU | 25-120-228-9874 | ubt slyly furiously enticing accounts. requests wake. blithely special instructions cajol 9803.13 | Supplier#000034855 | MOZAMBIQUE | 1159821 | Manufacturer#4 | FEu0YuedM8GOe8Nt | 26-610-128-1275 | nic deposits breach deposits. carefully ironic dolphins are carefully final packages. special pack 9799.81 | Supplier#000015370 | MOROCCO | 1415369 | Manufacturer#1 | v5W9tq8sWoHjyox09vpN73P03Ryo ajA | 25-197-531-7551 | ully regular foxes above 9799.67 | Supplier#000090746 | KENYA | 1890745 | Manufacturer#3 | pbUpVM6uRAWP,r3q | 24-734-594-1310 | y express packages affix after the blithely pending patterns. deposits sleep sl 9798.21 | Supplier#000061478 | MOROCCO | 1261477 | Manufacturer#1 | CDsLbiGDKvO1Yym2zx | 25-337-878-4370 | ts. even foxes among the blithely pending realms haggle against the express braids 9795.98 | Supplier#000099906 | ALGERIA | 1949867 | Manufacturer#5 | 50QFSFcA4gh7t4z16uUBPUVdZK,xCUg,AgX | 10-160-878-8131 | . quickly daring requests nag among the unusual epitaphs 9794.6 | Supplier#000057405 | ETHIOPIA | 57404 | Manufacturer#4 | e,in3QQjWqgArndAxfc4zYR0GZ3qxJXF737rV | 15-776-316-2111 | g to the express requests. quickly 9787.85 | Supplier#000038832 | KENYA | 513826 | Manufacturer#3 | ,03053 Onf4HYAP3SYFt6G,qZrMd7zcJ | 24-250-550-4693 | l requests. slyly final excuses use. packages nag furiously special pinto beans. slyly 9786.55 | Supplier#000096122 | MOROCCO | 1496121 | Manufacturer#2 | D,3f92MSxiDzEWX6nauk3cONXhxww0 | 25-426-504-5166 | unts. fluffily bold packages doubt furiously after the furiously ironic tithes. carefully reg 9784.29 | Supplier#000007482 | KENYA | 1282469 | Manufacturer#4 | 7MSkjk6Z0e | 24-502-520-4698 | the quickly special deposits. ideas among the slyly regular deposits are amon 9784.07 | Supplier#000071866 | ALGERIA | 846857 | Manufacturer#4 | UJu4oxADy0WVhg7zC6i4xqS7J9DhEj | 10-421-439-1192 | ar accounts. regular platelets maintain about the requests. quickly final d 9780.88 | Supplier#000069043 | MOZAMBIQUE | 394033 | Manufacturer#1 | o7,g1DGAJjgSvEKVAzJVfkQ4oXphdtUgKl8gOT | 26-474-233-4181 | quickly excuses. fluffily regular pains cajole qu 9777.9 | Supplier#000098183 | ETHIOPIA | 998182 | Manufacturer#3 | STz72hM xfC02,U8NGDn40S1Ymk | 15-514-788-7435 | wake carefully theodolites. special requ 9775.91 | Supplier#000035872 | MOZAMBIQUE | 860847 | Manufacturer#1 | n1UZO4zhL86ZcgY2 | 26-960-274-6198 | egular deposits integrate against the 9775.72 | Supplier#000006960 | KENYA | 581954 | Manufacturer#4 | 29pZoSofXDVw6IzjAF9pTgCd | 24-894-676-4904 | s. pending, fluffy pinto beans sleep carefully bold accounts-- slyly ironi 9771.33 | Supplier#000077002 | MOZAMBIQUE | 1101968 | Manufacturer#2 | HCOnp 4VPVl,3ZrUpF97OfMuVMe | 26-462-962-8201 | ackages are furiously ironic foxes. sentiments along the fluffily final packages run blit 9761.11 | Supplier#000074732 | ALGERIA | 199728 | Manufacturer#2 | 51ML6DigoL2z8uM71Amwmk5j9cIvpN | 10-166-751-7835 | ular deposits. carefully even deposits boost carefully ideas. quickly idle pinto beans cajole slyly 9754.33 | Supplier#000056369 | ETHIOPIA | 781347 | Manufacturer#1 | t9WM,WqIzfAoSHFzIk4Hsp | 15-509-582-4902 | ts. furiously ruthless ideas across the even theodolites cajole slyly about the express r 9753.65 | Supplier#000031716 | MOROCCO | 1531715 | Manufacturer#5 | mlj16td8X, V4g7ec | 25-331-867-4043 | unts are. bold, even packages cajole fluffily furious theo (100 rows) COMMIT; COMMIT