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 = 15 and p_type like '%COPPER' 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 -----------+---------------------------+---------------------------+-----------+---------------------------+------------------------------------------+-----------------+------------------------------------------------------------------------------------------------------ 9994.73 | Supplier#000014730 | MOROCCO | 389726 | Manufacturer#5 | FXKdUoDvF9a7yoR4X2B e6Fd | 25-297-632-7978 | . furiously regular requests cajole above the fluffily final dependencies. blithely even packa 9994.73 | Supplier#000014730 | MOROCCO | 1839675 | Manufacturer#5 | FXKdUoDvF9a7yoR4X2B e6Fd | 25-297-632-7978 | . furiously regular requests cajole above the fluffily final dependencies. blithely even packa 9993.7 | Supplier#000074593 | MOZAMBIQUE | 424584 | Manufacturer#1 | CSdt06t2ATs | 26-527-926-8226 | accounts haggle blithely even, special instructions. furiously 9990.19 | Supplier#000034607 | ALGERIA | 159603 | Manufacturer#2 | kEtGViTbRGliBEyi9k5qc8gIEimjBFM | 10-106-301-1430 | across the even theodolites. even, final packages haggle. packages boost 9990.09 | Supplier#000079263 | ETHIOPIA | 1804208 | Manufacturer#2 | f26m8ZZNayibOi1lzlYKBWIBkQrUC3s,Try7i | 15-533-754-4046 | ts integrate carefully; furiously special dolphins among the a 9990.09 | Supplier#000079263 | ETHIOPIA | 1854244 | Manufacturer#4 | f26m8ZZNayibOi1lzlYKBWIBkQrUC3s,Try7i | 15-533-754-4046 | ts integrate carefully; furiously special dolphins among the a 9989.77 | Supplier#000086226 | MOZAMBIQUE | 1361212 | Manufacturer#2 | HxaMUKpi3uHXwlMKDw,8OtCjuFOZwMAU | 26-245-102-5044 | es. ironic, pending packages among the unusual dependencies haggle requ 9989.09 | Supplier#000054955 | MOZAMBIQUE | 1204930 | Manufacturer#5 | rvxRIW20l9OzYZECQ0ol | 26-934-366-6971 | theodolites. ironic packages are car 9988.55 | Supplier#000048089 | ALGERIA | 348088 | Manufacturer#1 | zA2R0t5exKSwUUXb5 J8kq85XRJOzCMPh | 10-568-747-4121 | requests. accounts wake. even the 9987.25 | Supplier#000028957 | KENYA | 1753905 | Manufacturer#3 | 8k4ng9v,IpYA | 24-148-253-6843 | nts haggle slyly slyly unusual dependencies. ironic requests integrate. pl 9984.81 | Supplier#000018659 | ALGERIA | 1693642 | Manufacturer#1 | B2pXToSQjW1RwBnsF5W2tu7cG | 10-972-177-8024 | ual instructions haggle furiously along the slyly regular accounts. deposits wake slyly; furiously 9983.07 | Supplier#000059865 | ALGERIA | 559864 | Manufacturer#2 | ls6aCyoRxdbxygPDSPozoGTzc625Uz0XCo | 10-575-899-9108 | unts. furiously even pinto beans cajole carefully. ironic requests after the foxes boost ru 9982.09 | Supplier#000077347 | ALGERIA | 1202310 | Manufacturer#5 | mExwT31LzAi1 | 10-430-975-5645 | ep carefully express deposits. accounts cajole about the sile 9978.85 | Supplier#000068570 | KENYA | 418561 | Manufacturer#2 | NjcKftct9NhSLhhdJYRfaQJaGnF8gf1qFimKzi | 24-354-801-2738 | ular deposits hinder blithely according to the fluffily express packages. furiously bold excu 9978.85 | Supplier#000068570 | KENYA | 593554 | Manufacturer#4 | NjcKftct9NhSLhhdJYRfaQJaGnF8gf1qFimKzi | 24-354-801-2738 | ular deposits hinder blithely according to the fluffily express packages. furiously bold excu 9978.7 | Supplier#000096908 | ALGERIA | 1846871 | Manufacturer#5 | TQQ2fHwl9OtDVKo | 10-909-210-4116 | le idly-- ironic platelets boost carefully carefully final deposits. blithely 9976.45 | Supplier#000019491 | ETHIOPIA | 1244454 | Manufacturer#3 | 3v1wWC30BmxuLo | 15-476-916-1303 | efully special requests along the furiously even request 9964.05 | Supplier#000039468 | MOROCCO | 889451 | Manufacturer#4 | C DM8b9ylyz | 25-844-737-2036 | sleep slyly bold foxes. unusual deposits are slyly fluffily regular 9963.04 | Supplier#000069390 | MOROCCO | 244387 | Manufacturer#2 | X4qqmXf3RLvRdf2T4rZEYwsT7KXd8Twa87RW1WL9 | 25-383-612-3991 | . slyly regular foxes alongside 9956.65 | Supplier#000093532 | ALGERIA | 1193531 | Manufacturer#1 | zZr9pk63iYDDJGeU | 10-421-177-4603 | around the warhorses: furi 9954.35 | Supplier#000078133 | ALGERIA | 1153121 | Manufacturer#5 | kPQRQ5oVJkiL7 G3tnLqrNbvj9Q gybeX | 10-307-164-5028 | y among the even requests. regular, stealthy excuses above 9954.06 | Supplier#000050193 | ALGERIA | 875168 | Manufacturer#5 | qcZjMquEMOM K2OiAvrlE2R2CvBHYrZcIbC | 10-915-340-9660 | quiet theodolites. carefully expr 9954.06 | Supplier#000050193 | ALGERIA | 1050192 | Manufacturer#5 | qcZjMquEMOM K2OiAvrlE2R2CvBHYrZcIbC | 10-915-340-9660 | quiet theodolites. carefully expr 9953.48 | Supplier#000090316 | ETHIOPIA | 190315 | Manufacturer#3 | otI8elzWphd0UALkRzsJcqbaeMr6 | 15-335-665-4995 | slyly regular ideas. blithely express pinto beans h 9953.46 | Supplier#000070113 | MOZAMBIQUE | 1545097 | Manufacturer#5 | vChCzn0l3v8he1z8d | 26-487-566-4993 | refully careful ideas are permanently across the furiously ironic foxes. carefully regular pinto 9952.84 | Supplier#000043979 | KENYA | 1618962 | Manufacturer#2 | teeNqllPQVWKa2b,ZFkBJt1 ZNkxX | 24-646-253-3579 | e regular deposits. carefully brave instructions sublate q 9952.16 | Supplier#000092274 | ETHIOPIA | 1717222 | Manufacturer#4 | zlBj0FnyTqtaM9Q | 15-282-366-3649 | ect slyly carefully special deposits. carefully regular dependencies against the carefully bold 9949.19 | Supplier#000012568 | ETHIOPIA | 1612567 | Manufacturer#4 | lithuC3SxVgDi1i8w43hgMcjYVnnZX9 | 15-638-122-2843 | y even platelets boost furiously 9943.77 | Supplier#000025828 | MOROCCO | 827 | Manufacturer#1 | AiQlDIZutYem N9k7 | 25-977-402-6562 | ithely bold packages haggle 9932.21 | Supplier#000009347 | MOROCCO | 1234310 | Manufacturer#3 | ZtUTsLXGWxAzti | 25-779-427-4737 | c packages nag around the furiously regular packages. ironic reque 9929.81 | Supplier#000078763 | KENYA | 878762 | Manufacturer#4 | jbzdTjnEgJcq ul5JnGeSY3yvVOD,EdnmR6GxAF | 24-121-246-9886 | c accounts. foxes across the final packages cajol 9929.5 | Supplier#000031671 | MOZAMBIQUE | 1456628 | Manufacturer#1 | XNUOFOWHe Ph8VgNaVjhpIxg3k0j4E9 | 26-805-525-4526 | ronic deposits. blithely express foxes kindle s 9927.51 | Supplier#000013429 | ALGERIA | 1063408 | Manufacturer#1 | ,P9wWS,RPTPQWm1TBHXIOjiBugJ9ioi | 10-633-217-5141 | posits against the furiously final accounts cajole carefully even ac 9927.23 | Supplier#000098618 | ALGERIA | 1723566 | Manufacturer#5 | 9,LuwQjkiKItwjOpVnN7C4zA | 10-487-128-2007 | luffily even instructions nag carefully after the final 9924.4 | Supplier#000081622 | ETHIOPIA | 1031601 | Manufacturer#3 | zAbjFPtL7jDBz8qp | 15-663-418-6409 | ly express packages cajole behind the 9920 | Supplier#000027369 | ETHIOPIA | 727368 | Manufacturer#4 | oLfspesAI87K | 15-304-864-4664 | es are along the quickly final deposits. blithely even instructions 9918.5 | Supplier#000055639 | MOROCCO | 605626 | Manufacturer#1 | zmHxSEHi6Mr 8oGR0iNeX,poRRhAj36X | 25-560-781-9389 | onic, unusual accounts nag blithely. furious 9917.42 | Supplier#000061210 | MOROCCO | 1186176 | Manufacturer#1 | 5NQhd0nL28 | 25-366-558-2380 | quests across the bold dependencies cajole around the quickly ironic accoun 9916.96 | Supplier#000048110 | ALGERIA | 1323096 | Manufacturer#2 | a kbrzNx5VdUwH175c | 10-972-687-6611 | le carefully across the regular, ironic dependencies. pearls cajole. slyl 9916.94 | Supplier#000088427 | MOROCCO | 1213390 | Manufacturer#4 | 23nVjNCrV2RVCGZVPb0NlbLxekiIN1h,viG | 25-674-621-9672 | careful packages boost after the ideas. furiously 9916.72 | Supplier#000013830 | ETHIOPIA | 1963791 | Manufacturer#1 | bL0iTT8F323GZJeMWocj | 15-518-608-3909 | jole among the carefully brave asymptotes. 9916.56 | Supplier#000082856 | KENYA | 1682855 | Manufacturer#4 | UF BuWmTCzs | 24-178-360-7616 | sual requests. carefully regular pin 9914.55 | Supplier#000091909 | KENYA | 391908 | Manufacturer#4 | 4T0CF R1nGjVsCHxDe | 24-939-279-4420 | , regular theodolites. furiously even deposi 9914.55 | Supplier#000091909 | KENYA | 1716857 | Manufacturer#2 | 4T0CF R1nGjVsCHxDe | 24-939-279-4420 | , regular theodolites. furiously even deposi 9912.09 | Supplier#000047897 | ALGERIA | 1847896 | Manufacturer#3 | tkL9q2Z9LS0GZ97pocEdDylNXvHQR6F | 10-846-987-1780 | c packages. furiously regular packages haggle blithely. silent dinos haggle slyly above the f 9905.7 | Supplier#000035333 | MOROCCO | 635332 | Manufacturer#2 | n7QUZuztG4AxbuMLtu H6YjXuyGdsLPdyc1 | 25-395-622-7146 | eas. furiously final deposits haggle slyly final, dogged platelets. busily iro 9905.28 | Supplier#000010223 | MOZAMBIQUE | 210222 | Manufacturer#3 | owaZu STTmBV5uQ WtzM0a29piReljl | 26-576-566-6222 | to the regular pinto beans. 9904.65 | Supplier#000023743 | MOROCCO | 848718 | Manufacturer#4 | MX,ksorGAehmwK8HlOnOVW3G | 25-718-289-8508 | leep furiously. carefully special theodolites boost fu 9902.06 | Supplier#000026017 | ETHIOPIA | 1350977 | Manufacturer#5 | AK4,v oCRHFJywVlca0T | 15-179-992-6701 | s. regular packages hang furiously furiously fluffy requests. final, unusual instructions x-r 9901.68 | Supplier#000092232 | KENYA | 267229 | Manufacturer#5 | EQxvyayaK5hQbS p8e4o08VqXFLa | 24-866-169-1752 | e permanently. final, ironic instructions integrate requests. quickly final e 9899.72 | Supplier#000011199 | MOROCCO | 1811198 | Manufacturer#2 | JAOwXUbRbb5RD2 | 25-640-858-8688 | eposits haggle blithely. blithely ironic excuses across the furiously final dep 9899.59 | Supplier#000066800 | MOZAMBIQUE | 341796 | Manufacturer#5 | 1oZTCRUh4zzoHUTM0yR | 26-361-203-8914 | blithely express excuses haggle alongside of the final instructions. furiously special accounts w 9897.16 | Supplier#000015483 | MOROCCO | 15482 | Manufacturer#3 | mIUH 7MKBbuR5aHAny6ecfsGmf0l4FaRK | 25-828-399-7045 | hin pinto beans wake carefully. blithely final deposits use furiously. furiously ironic notornis 9896.78 | Supplier#000019605 | MOZAMBIQUE | 744583 | Manufacturer#5 | XHVH4C3GGK, | 26-990-457-6496 | blithely final deposits. final sentiments after the flu 9896.78 | Supplier#000019605 | MOZAMBIQUE | 1319604 | Manufacturer#3 | XHVH4C3GGK, | 26-990-457-6496 | blithely final deposits. final sentiments after the flu 9895.88 | Supplier#000037121 | MOROCCO | 187118 | Manufacturer#5 | gUeTZtmsfxAqbuuuyI77 | 25-317-550-7308 | arefully even deposits sleep quickly 9893.91 | Supplier#000013328 | KENYA | 13327 | Manufacturer#2 | C9nEu2ppZ,bsXYqK09b1LQtGkoScEy | 24-414-817-6884 | lyly pending accounts: accounts will have to snooze. ruthlessly unusual requests 9893.66 | Supplier#000064757 | ETHIOPIA | 814740 | Manufacturer#3 | asobTLN7,P | 15-549-962-4924 | gular theodolites. express theodolites along the pinto be 9893.3 | Supplier#000074133 | KENYA | 424124 | Manufacturer#4 | 6sETCcVfad1YSnZZaRBKaZU | 24-338-747-8912 | t ironic requests. unusual, u 9891.83 | Supplier#000070557 | MOROCCO | 645550 | Manufacturer#2 | TTFgk6tVJAu | 25-726-653-7994 | cording to the packages. carefully 9891.83 | Supplier#000070557 | MOROCCO | 1370556 | Manufacturer#3 | TTFgk6tVJAu | 25-726-653-7994 | cording to the packages. carefully 9891.58 | Supplier#000019193 | ALGERIA | 69192 | Manufacturer#5 | FCykn9OqfjF F6RjY,lgPBTe1W | 10-936-993-1956 | nst the express, regular packages. busily ironic accou 9890.88 | Supplier#000077585 | MOROCCO | 1602536 | Manufacturer#2 | J6Acp874 ReKDOTvO5f | 25-572-298-8566 | y final ideas wake. decoys according to the pinto beans cajole s 9888.95 | Supplier#000016314 | KENYA | 1191302 | Manufacturer#1 | oEDTKhU6V1,vBD2colmPrv28lcg66NOy4kvJTaQf | 24-486-521-7274 | s along the carefully final asymptotes doze furiously after the accounts. re 9888.02 | Supplier#000089136 | MOZAMBIQUE | 1664119 | Manufacturer#5 | DfM0aDyX3gJgAfXlo92weMiIjG | 26-521-634-1913 | r, bold courts. bold accounts sleep furiously quickly bo 9886.05 | Supplier#000086403 | ETHIOPIA | 1536372 | Manufacturer#1 | gMSOs oAVUa6jK7GTO,l2eBiDAZING6Yb8kFonW | 15-869-923-3344 | . stealthily final packages solve. fur 9880.29 | Supplier#000025356 | MOROCCO | 275351 | Manufacturer#1 | HkQwQ0m9j1op | 25-613-568-1878 | iously blithely unusual depths. furiously regular hockey players cajo 9876.7 | Supplier#000036995 | KENYA | 186992 | Manufacturer#5 | gTLNV5C32EDv82rzQC4dz | 24-423-227-5948 | regular accounts boost. requests nag quickly carefully even requests. furiously regular d 9874.02 | Supplier#000070524 | ALGERIA | 120521 | Manufacturer#5 | 25nE8FuDGACM9jAHZ,G8mzAJqEmx70WAZ7SLm | 10-157-855-3413 | inal foxes cajole fluffily. furiously even requests doze ironically furiously unusual acc 9873.84 | Supplier#000093581 | MOROCCO | 1218544 | Manufacturer#2 | IAJRdgyG4vVgH46dQ74Vtpy g4F65Gylfn9lw | 25-340-843-4812 | iously regular packages above the slyly 9872.62 | Supplier#000013751 | ALGERIA | 1163728 | Manufacturer#2 | bRHEIMp30y1iw | 10-413-751-3960 | ckages after the regular, unusual platelets are blithely after the unusual asymp 9872.1 | Supplier#000004823 | ALGERIA | 1529777 | Manufacturer#1 | cOflLbPaDr6F9LhuG9TWQaRQmSfk mx | 10-102-116-6785 | yly deposits. careful, regular requests mold slyly. pending deposits cajole blithe 9870.04 | Supplier#000034425 | KENYA | 1084404 | Manufacturer#3 | b6bN2PMY,5InyTwiCW9vB 76ET4oJ5hj P | 24-860-339-9082 | he regular, silent accounts. carefully unusual packages cajole. carefully special r 9862.25 | Supplier#000076943 | ETHIOPIA | 176942 | Manufacturer#2 | 4ZLkL,DS7tyID YLRc,viNV8eoGB58 | 15-463-850-5655 | es. blithely regular requests through the blithely ironic accounts 9862.25 | Supplier#000076943 | ETHIOPIA | 1201906 | Manufacturer#4 | 4ZLkL,DS7tyID YLRc,viNV8eoGB58 | 15-463-850-5655 | es. blithely regular requests through the blithely ironic accounts 9856.55 | Supplier#000009878 | MOZAMBIQUE | 1959839 | Manufacturer#1 | 2kwsctKFEhB9inlp,hvlJ | 26-864-214-4496 | quickly. unusual, final ideas nag slowly at the ironic accounts. slyly ironic instructions according 9851.79 | Supplier#000020404 | ALGERIA | 45403 | Manufacturer#3 | uVL1eMQ8kMsQstv06 | 10-578-758-5112 | . carefully ironic instructions are slyly slyly ironic deposits. never even d 9847.54 | Supplier#000041942 | MOZAMBIQUE | 466929 | Manufacturer#1 | HcjRl2tAGBi4FT,sf8KSPIbtUZxEKugpk3OcuN | 26-325-540-5392 | accounts use. ironic, final deposits boost quietly quickly pending packages; un 9843.18 | Supplier#000066713 | MOROCCO | 1341699 | Manufacturer#3 | cndPPoU3xV5,d60YR | 25-456-899-6483 | express ideas. final, pending asymptotes sleep fluffily. slyly regular p 9842.17 | Supplier#000013917 | ALGERIA | 1113916 | Manufacturer#1 | xU3yjUIOIlHUkDL,JR8JtVE | 10-887-345-9076 | furiously regular packages are carefully pending dependencies. special d 9842.17 | Supplier#000013917 | ALGERIA | 1513916 | Manufacturer#4 | xU3yjUIOIlHUkDL,JR8JtVE | 10-887-345-9076 | furiously regular packages are carefully pending dependencies. special d 9842 | Supplier#000034381 | MOZAMBIQUE | 584370 | Manufacturer#3 | uB4ncmBgUZRl3RJqMqCPwb Cr N4eOrJSbQ | 26-779-861-7066 | structions toward the carefully quick excuses kindle slyly against the ironic ideas; reques 9841.04 | Supplier#000050445 | MOROCCO | 550444 | Manufacturer#1 | jTSB5NdvszUar9euo7Zcj2C4cLt8CeD,Tv6 | 25-424-348-4347 | al instructions cajole slyly carefully regular asymptotes. depo 9838.16 | Supplier#000003348 | MOROCCO | 128344 | Manufacturer#1 | ngwfUSRAvm4dBe2JmJi7picb6CHK7 | 25-267-444-9017 | lar packages use blithely ironic accounts. pinto beans wake quickly final, ironic instructions 9838.16 | Supplier#000003348 | MOROCCO | 1053327 | Manufacturer#3 | ngwfUSRAvm4dBe2JmJi7picb6CHK7 | 25-267-444-9017 | lar packages use blithely ironic accounts. pinto beans wake quickly final, ironic instructions 9837.37 | Supplier#000011153 | MOROCCO | 1261128 | Manufacturer#4 | zu9X3WcSss5zy K3D | 25-434-239-1361 | bout the quickly bold instructions are blithely 9835.49 | Supplier#000029383 | ALGERIA | 1529382 | Manufacturer#2 | 7 sR4CIa7Rv8fek5GWCB0VHC0GgK | 10-776-306-6683 | ndencies sleep slyly bold, special excuses. regular accoun 9832.79 | Supplier#000048736 | KENYA | 1098715 | Manufacturer#3 | uGqBPVWcDk4w4t9yaZ8 | 24-585-592-3303 | uickly regular excuses haggle furio 9831.79 | Supplier#000016052 | MOZAMBIQUE | 416051 | Manufacturer#3 | sllIhO9IYnEq sditev9QJ | 26-516-353-6986 | usly? regular, unusual instructions engage quickly ironic, unusual accounts. blithely silent foxes 9831.05 | Supplier#000003978 | MOROCCO | 328968 | Manufacturer#1 | OwxlJz9EjmwI6r0MDi,dhQdSCzeshloJHbnB93 | 25-425-505-1375 | slyly doggedly regular pinto beans. platelets snooze against the idly 9831.05 | Supplier#000003978 | MOROCCO | 1653945 | Manufacturer#1 | OwxlJz9EjmwI6r0MDi,dhQdSCzeshloJHbnB93 | 25-425-505-1375 | slyly doggedly regular pinto beans. platelets snooze against the idly 9830.39 | Supplier#000045155 | ETHIOPIA | 1595124 | Manufacturer#1 | mwbGa14pqhK,EGE utx7M814 z2 6rEEnyoJUPL | 15-468-867-5131 | ully bold instructions. carefully pending foxes along the sly 9828.06 | Supplier#000068656 | MOROCCO | 168655 | Manufacturer#2 | vuFW 4 DfLPNjApTB3MkszkFun | 25-867-823-5872 | ronic ideas sleep slyly above the carefully regular asympto 9825.4 | Supplier#000002258 | ALGERIA | 652245 | Manufacturer#1 | bXE2ygKSjCOsmijmUy5TbL | 10-205-637-5432 | eposits are fluffily carefully silent theodolites. fluffily silent packages 9823.78 | Supplier#000017870 | ALGERIA | 517869 | Manufacturer#1 | csivE9ACzne8 | 10-199-631-9671 | usly alongside of the carefully even sentiments. pinto beans wa 9823.6 | Supplier#000025700 | MOZAMBIQUE | 1000689 | Manufacturer#5 | Bbcv5PHPS1fcyLFh8TyKj302LQh | 26-107-926-2721 | itaphs. express, final excuses cajole. unusual, idle packages 9818.83 | Supplier#000028638 | ALGERIA | 603631 | Manufacturer#3 | k7nxiAPYXR0eVe45 JqCDF | 10-590-939-1141 | he pending pinto beans. som 9818.83 | Supplier#000028638 | ALGERIA | 828637 | Manufacturer#5 | k7nxiAPYXR0eVe45 JqCDF | 10-590-939-1141 | he pending pinto beans. som 9818.83 | Supplier#000028638 | ALGERIA | 1003627 | Manufacturer#4 | k7nxiAPYXR0eVe45 JqCDF | 10-590-939-1141 | he pending pinto beans. som 9817.87 | Supplier#000047660 | MOZAMBIQUE | 1522644 | Manufacturer#2 | zRyofBYwDREKc | 26-241-846-3986 | le against the bravely final requests. ironic requests are according to the carefully bo (100 rows) COMMIT; COMMIT