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 = 17 and p_type like '%BRASS' and s_nationkey = n_nationkey and n_regionkey = r_regionkey and r_name = 'MIDDLE EAST' 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 = 'MIDDLE EAST' ) 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 -----------+---------------------------+---------------------------+-----------+---------------------------+------------------------------------------+-----------------+------------------------------------------------------------------------------------------------------ 9995.05 | Supplier#000077755 | EGYPT | 1952735 | Manufacturer#3 | 3TjudTLvQibyoDu | 14-493-852-4671 | uctions: blithely regular deposits run carefully blithely unus 9991.53 | Supplier#000030467 | IRAQ | 255460 | Manufacturer#5 | xQ3 5fQoG0X | 21-373-974-1547 | yly pending pinto beans: furiously ironic dolphins haggle sly 9990.72 | Supplier#000074797 | JORDAN | 374796 | Manufacturer#4 | seYLdILmuOrsdGDC6ynG9Z | 23-572-612-7116 | egrate blithely. fluffily ironic accounts boost carefully? blithely ev 9989.94 | Supplier#000068635 | IRAN | 1993577 | Manufacturer#5 | o1BfGLnL9cAgEYlke,tKZ056HYL0f | 20-968-531-6322 | o beans. ironic requests cajole fluffily above 9987.61 | Supplier#000059450 | IRAN | 859449 | Manufacturer#4 | GP2rTGTl26,Eh1h1,B3B5CGNYyd | 20-840-179-9811 | equests wake quickly against the c 9987.37 | Supplier#000008390 | SAUDI ARABIA | 158387 | Manufacturer#5 | S5fj7UR7wc6 | 30-478-369-1888 | as boost slyly during the final, ironic ideas. slyl 9987.2 | Supplier#000011534 | IRAQ | 286531 | Manufacturer#3 | 2HEGpCNDgm9a18Gn | 21-542-157-2961 | nto beans are carefully! furiously express packages boost slyly above the even depos 9983.21 | Supplier#000029246 | IRAN | 1204233 | Manufacturer#5 | 72yajiwmKNMWRZL4y8cbOoAkvKNfBmI | 20-967-937-2499 | deposits. pinto beans sleep ironic, ironic accounts. blithely busy dependencies 9983.12 | Supplier#000012035 | IRAN | 1836980 | Manufacturer#1 | 0GhmqM,MVfWRsvlsA | 20-510-461-9152 | y regular packages. carefully express accounts nag. requests cajole blithely express 9977.54 | Supplier#000085114 | IRAQ | 85113 | Manufacturer#3 | AS69nrZEFoMj6QE5T | 21-182-958-6958 | s boost blithely against the carefully final accounts. 9977.54 | Supplier#000085114 | IRAQ | 1710062 | Manufacturer#1 | AS69nrZEFoMj6QE5T | 21-182-958-6958 | s boost blithely against the carefully final accounts. 9977.38 | Supplier#000021030 | JORDAN | 321029 | Manufacturer#2 | 0qV0JOd,EMFJ,n9yCOwXh7gjbglyHHRMSG | 23-739-192-7141 | ely ironic packages wake quickly about the final in 9977.38 | Supplier#000021030 | JORDAN | 496025 | Manufacturer#1 | 0qV0JOd,EMFJ,n9yCOwXh7gjbglyHHRMSG | 23-739-192-7141 | ely ironic packages wake quickly about the final in 9975.89 | Supplier#000006892 | SAUDI ARABIA | 956873 | Manufacturer#4 | 9DEMqP3EF CkC4VC1lNhY9oKSfxtLV6s0 | 30-564-583-9703 | packages sublate furiously. slyly final asymptotes doze ironic packages. regular, special 9974.72 | Supplier#000051277 | JORDAN | 1276240 | Manufacturer#2 | 6TxPJrchH 8binAfGBA5kTxfme | 23-537-201-3556 | ular instructions. never final accounts wake fluffily e 9972.08 | Supplier#000015107 | IRAN | 1840052 | Manufacturer#1 | amW3SM9SlD2Ky655VDbU4EGzvUmGpjXO49Xm6xeO | 20-972-735-1382 | ual accounts sleep alongside 9972.04 | Supplier#000012927 | IRAN | 237920 | Manufacturer#3 | DRK,7vfLKQ YKAflicm217tPh Qp8BTb0UDrHGvh | 20-377-510-1047 | usual excuses across the even accounts are slyly 9971.78 | Supplier#000077982 | JORDAN | 1627949 | Manufacturer#5 | X5bmwlb1WuEL2NssjLNpocYFvkLW | 23-439-640-7681 | instructions. blithely daring accounts nag bli 9969.01 | Supplier#000070568 | EGYPT | 1495525 | Manufacturer#3 | xPkZsgZEdOy1q97Nf | 14-107-414-1807 | he quickly final requests-- carefully express accounts above the depo 9967.71 | Supplier#000066532 | IRAN | 316525 | Manufacturer#4 | 364T28YbWgjvv | 20-856-879-7268 | hins across the blithely unusual deposits are slyly across the carefully furious requests. forg 9966.1 | Supplier#000011444 | SAUDI ARABIA | 1911443 | Manufacturer#5 | b3 TpxKW2lHCSmQHVkD8W3XcmVx | 30-370-109-9306 | o beans alongside of the ironic courts are fluffily about the quickl 9965.65 | Supplier#000068492 | IRAQ | 1968491 | Manufacturer#4 | 535b9 AEqXB97v | 21-545-859-7070 | yly. unusual ideas affix carefully. regular, sp 9954.88 | Supplier#000062508 | IRAQ | 1362507 | Manufacturer#3 | x8DvMnPj DEgognqGTi | 21-937-593-7894 | the unusual requests. quickly final requests wake carefully 9948.63 | Supplier#000049511 | IRAQ | 899494 | Manufacturer#5 | Mlv19M29dB | 21-128-885-8453 | ckly along the carefully unus 9944.4 | Supplier#000073152 | IRAQ | 1098121 | Manufacturer#3 | f YJVmkRE2zvmSWSn | 21-162-697-5635 | c foxes. thinly final dependencie 9936.7 | Supplier#000058484 | IRAQ | 1683435 | Manufacturer#3 | IJtGTqsjcuvF76MkkA6ZjcUMNuRbycp | 21-185-967-1082 | final warhorses. carefully ironic deposits wake blithely iron 9935.51 | Supplier#000024897 | SAUDI ARABIA | 174894 | Manufacturer#5 | w8d9a1tMnSCsTW3zav yFI7Pr4zzlk i9FD | 30-595-773-2958 | pending packages nag furiously above the ironic, final packages. 9932.59 | Supplier#000064675 | SAUDI ARABIA | 1139663 | Manufacturer#3 | 1sRVBanRIDl | 30-538-171-2278 | ithely ironic deposits. even dependencies wake blithely ironic 9932.22 | Supplier#000055514 | SAUDI ARABIA | 1055513 | Manufacturer#1 | FsnY5xy oRp | 30-697-247-8038 | ss ideas according to the silently even theodolites are about the final theodolites. ironic, 9931.82 | Supplier#000007052 | IRAQ | 1757017 | Manufacturer#4 | EvvMY80H5gifhB5a82U4Q0FtttnZ3npEYJ | 21-562-180-1409 | he furiously even theodolites. blithely ironic theodo 9931.71 | Supplier#000096309 | EGYPT | 1671292 | Manufacturer#5 | 7b03z syyE | 14-208-104-6810 | at the regular accounts are blithely p 9925.82 | Supplier#000020368 | IRAQ | 870351 | Manufacturer#2 | rWSkdw7kG 9EVKFUe9hdFNzf | 21-755-629-5383 | xes solve furiously. blithely even excuses wake quickly 9920.12 | Supplier#000015213 | IRAN | 565202 | Manufacturer#3 | 1zrJakJ64C2jG1C,Zh | 20-657-510-8963 | packages are blithely furio 9916.61 | Supplier#000083743 | IRAQ | 633730 | Manufacturer#2 | c9zBk,hZmnJwxYhiJjGOpss8Nv9 | 21-267-889-6018 | s. carefully ironic requests wake blithely across the courts-- special, 9914.65 | Supplier#000098348 | IRAQ | 573342 | Manufacturer#5 | YmVRpWuwnzetnjN8DSPWk | 21-357-591-3985 | yly express ideas are evenly. ironic accounts haggl 9913.61 | Supplier#000042219 | JORDAN | 417214 | Manufacturer#1 | i6AT9EJgmExy73l0LSLATmr056ji | 23-338-799-1347 | even packages. blithely regular pinto beans 9911.23 | Supplier#000038763 | EGYPT | 913753 | Manufacturer#1 | cP10zxXHssbQ6vQ96QVWPptdm | 14-882-340-6441 | wake. instructions sleep blithely. depo 9910.86 | Supplier#000036295 | EGYPT | 111293 | Manufacturer#3 | 4qx6G A2KYjcmgcrCQOo4j | 14-156-232-1610 | re slyly quickly regular pin 9910.86 | Supplier#000036295 | EGYPT | 161291 | Manufacturer#2 | 4qx6G A2KYjcmgcrCQOo4j | 14-156-232-1610 | re slyly quickly regular pin 9907.22 | Supplier#000015843 | SAUDI ARABIA | 1990823 | Manufacturer#2 | 62lTbr7lrQ | 30-605-874-3471 | the regular foxes haggle carefully ironic, express deposits. silently even requests will 9906.91 | Supplier#000011551 | JORDAN | 1361524 | Manufacturer#2 | u7DH4Dt,qztQUf5Rm0tje | 23-279-528-6091 | after the carefully express instruct 9901.27 | Supplier#000071849 | SAUDI ARABIA | 1221824 | Manufacturer#2 | l 5ZirF5DJxM4Cxuf msR2n7F16GPNiiRwBoYSfX | 30-181-680-9490 | ts haggle. quickly regular deposits integrate across the foxes. theodolites us 9901.27 | Supplier#000071849 | SAUDI ARABIA | 1946829 | Manufacturer#1 | l 5ZirF5DJxM4Cxuf msR2n7F16GPNiiRwBoYSfX | 30-181-680-9490 | ts haggle. quickly regular deposits integrate across the foxes. theodolites us 9899.72 | Supplier#000061913 | JORDAN | 1111890 | Manufacturer#2 | L4 9BEpYwbSRqsJwhYgeHz1bSzK36m6JZ08 | 23-880-361-4405 | xes. slyly regular deposits integrate fluffily. quickly final accoun 9899.4 | Supplier#000067294 | JORDAN | 1492251 | Manufacturer#2 | Cv9srMKa1Ysz3IYn9f03TUw9OM6 | 23-249-905-2061 | use blithely fluffily special re 9897.51 | Supplier#000046149 | SAUDI ARABIA | 1671100 | Manufacturer#4 | zNM0iHzdjam6jdWiJ | 30-372-862-6563 | al escapades cajole idly against the carefully even excuses. final deposits are furiously slyly sp 9895.79 | Supplier#000015939 | IRAN | 15938 | Manufacturer#5 | e15UKvy2lR4CIdf3 E4 | 20-298-628-9571 | eas breach. pinto beans sleep about the fluffily final dependencies. excuses wake busil 9895.14 | Supplier#000006716 | JORDAN | 1856679 | Manufacturer#3 | BJaPDjafIrQQlD4cP | 23-153-259-3388 | ng requests against the slyly specia 9893.28 | Supplier#000090220 | JORDAN | 1140197 | Manufacturer#2 | 7VJ71h3sKlGesK | 23-500-838-1172 | ld accounts. blithely bold theodoli 9893.28 | Supplier#000090220 | JORDAN | 1665203 | Manufacturer#4 | 7VJ71h3sKlGesK | 23-500-838-1172 | ld accounts. blithely bold theodoli 9888.02 | Supplier#000083938 | EGYPT | 1858919 | Manufacturer#2 | HpMkaI3fUkH2ix2HNY8N5x7rgt6Zi1KAcNs6e682 | 14-708-296-9312 | s across the even ideas eat quickly between the ironic instructio 9886.96 | Supplier#000033769 | JORDAN | 1708751 | Manufacturer#1 | VOBDOGC6DHuArynZi9ViiWivzbRazKYwnQXHHe | 23-111-595-8432 | riously even accounts integrate furiously against the packages. quic 9884.88 | Supplier#000052939 | IRAQ | 1602906 | Manufacturer#2 | GbsOUcUVIO8A,4w5jGk,G4v | 21-804-246-2607 | ly careful theodolites haggle 9884.43 | Supplier#000058041 | SAUDI ARABIA | 58040 | Manufacturer#3 | KGKycMm2oTeeDiLkuI0HTELAJqd4cZ9zsAi1Lc | 30-515-597-6045 | usly furious platelets use. furiously final dependencies at the regul 9883.32 | Supplier#000044275 | SAUDI ARABIA | 919265 | Manufacturer#3 | ClAV1pQbz,kSMTLc6PJefk3OCwYQG | 30-785-751-7722 | totes nag blithely permanently special requests. special depos 9878.32 | Supplier#000061879 | IRAQ | 1861878 | Manufacturer#3 | tUhx2zL4zMomBRMCr | 21-721-870-7696 | ccounts detect slyly quickly e 9877.98 | Supplier#000059429 | IRAN | 734421 | Manufacturer#5 | SJOlcf0j4Ok5wqIMtgvaNYPsmW | 20-384-747-6936 | ole slyly. slyly pending ideas are slyly blithely regular dolphins. carefully regular depos 9877.13 | Supplier#000015239 | EGYPT | 15238 | Manufacturer#1 | Tzrn1D6D6LMhzdsshdGFk tF | 14-856-702-5090 | inside the ironic accounts. ironic packages do are carefully. furiously regular packa 9866.14 | Supplier#000027555 | JORDAN | 27554 | Manufacturer#1 | L57 vJYQ14IXu20V6jdcNWR | 23-385-543-6565 | cuses cajole fluffily. furiously special requests cajole slyly. final 9865.48 | Supplier#000034930 | IRAQ | 1609913 | Manufacturer#2 | YWRzlOQRKWnrEFk8seA | 21-367-464-7947 | he silently regular asymptotes. furiously daring excuses sleep. even a 9863.68 | Supplier#000053016 | EGYPT | 953015 | Manufacturer#2 | 7ItSbkuKpiET,1BJx | 14-972-874-7456 | ets sleep slyly into the blithely iro 9859.76 | Supplier#000045940 | IRAN | 445939 | Manufacturer#3 | yNPvV8L,vWFWRufLGDGLQFT8jhDQp20a | 20-103-818-9298 | requests. excuses use furiously 9859.23 | Supplier#000084867 | IRAQ | 1484866 | Manufacturer#1 | 3y5hxv,H3e8XfsJS | 21-607-371-5799 | oost furiously alongside of the ironic depo 9851.78 | Supplier#000075267 | JORDAN | 1025246 | Manufacturer#5 | q3h2YunjcuDZPML | 23-824-557-3466 | xes wake furiously slyly pending packages. express, brave accounts are slyly idle deposi 9850.07 | Supplier#000025131 | SAUDI ARABIA | 1975092 | Manufacturer#5 | iwXaH,FZmJdy9 kPFO3xeZJQJ2Di2xpybEwV | 30-966-604-5023 | blithely at the ironic, ironic pinto beans. unusual requests use never after the ironic acc 9850.03 | Supplier#000011846 | JORDAN | 586840 | Manufacturer#1 | nfowJ8YDYTtMbe3HR | 23-448-271-6042 | hely even packages. slyly ironic dependencies around 9850.03 | Supplier#000011846 | JORDAN | 1561815 | Manufacturer#2 | nfowJ8YDYTtMbe3HR | 23-448-271-6042 | hely even packages. slyly ironic dependencies around 9848.82 | Supplier#000005190 | IRAN | 130186 | Manufacturer#5 | Ho GIXxcwcCBwVqH,U7W | 20-266-562-4864 | atelets cajole slyly among the final ideas. carefully thin accounts integrate fu 9848.26 | Supplier#000026505 | IRAQ | 326504 | Manufacturer#1 | g4bApDO5YLxJS,Vzem3ryY42c71U QAXfU | 21-487-871-6805 | osely. furiously final theodolites nag alongside of the pending theodolites. furiously final package 9847.43 | Supplier#000078630 | SAUDI ARABIA | 828613 | Manufacturer#5 | O 0jO2OZW4Ll7DzKNtvWqbR84KqEbKR6EEr | 30-624-751-3644 | c accounts. doggedly regular d 9839.74 | Supplier#000045305 | IRAN | 170301 | Manufacturer#3 | pOIM8XTgOSL3ooShtZlyxuR4UVt7ZD7WYqgn6FW | 20-360-753-5633 | usly final ideas. bold, regular packages sleep quickly. quickly even platelets boost 9833.34 | Supplier#000079699 | JORDAN | 504683 | Manufacturer#5 | iS9sAcuhy41 a | 23-839-870-5773 | packages. carefully dogged requests wake quickly-- regular, ironic pack 9832.1 | Supplier#000064990 | IRAN | 1014969 | Manufacturer#4 | ObMjtCOdpNzCETWUfgUp OWpa,4wDw3XW,G | 20-247-225-7267 | wake carefully. carefully regular deposits solve quickly furiousl 9823.82 | Supplier#000059239 | IRAN | 634232 | Manufacturer#3 | pURfPQTmpL,2z9joiziLqXILn,UeMV | 20-739-471-3428 | ng, ironic requests wake quickly along the requests. busily ironic ideas nag fluffily. slyly ironi 9821.4 | Supplier#000035393 | JORDAN | 1410378 | Manufacturer#5 | YXHIzRUSSR | 23-180-842-7578 | eposits. carefully final instructi 9818.15 | Supplier#000056161 | IRAN | 1181127 | Manufacturer#2 | Mmj3hfVWfVmIUYJu9NY11BiX7C | 20-423-361-3830 | s ideas. blithely ironic accounts against th 9805.06 | Supplier#000015556 | SAUDI ARABIA | 215555 | Manufacturer#1 | 4TC4loaN3MG20FovpXLYkn85042wn3LDUsgqL | 30-454-206-9924 | he ironic, even deposits? even ideas boost furiously about the qu 9805.06 | Supplier#000015556 | SAUDI ARABIA | 1515555 | Manufacturer#1 | 4TC4loaN3MG20FovpXLYkn85042wn3LDUsgqL | 30-454-206-9924 | he ironic, even deposits? even ideas boost furiously about the qu 9800.5 | Supplier#000023040 | IRAQ | 1947982 | Manufacturer#2 | iI5q5MpPg6qsoMFj4bae | 21-953-629-4160 | ackages wake quickly accordin 9799.07 | Supplier#000072426 | SAUDI ARABIA | 1197392 | Manufacturer#1 | vVRWzkEShX W1HTEoZJNuoR0eK7i91H6GQHxADa | 30-279-325-6249 | s. carefully final asympt 9798.85 | Supplier#000007362 | IRAN | 1232325 | Manufacturer#4 | 8PAZ3synXExRh9H5D0KT | 20-999-975-5790 | ly unusual pains according to the furiously regular requests sleep above 9794.89 | Supplier#000017192 | SAUDI ARABIA | 717191 | Manufacturer#1 | 3,W,CjTBx7re6EaHzMxJGggtCzm7pO | 30-102-765-9561 | ar deposits against the ruthless ins 9793.28 | Supplier#000004818 | EGYPT | 79817 | Manufacturer#1 | pq 8W7GgiPQEHo4qMvREULChRuKqxSP9GQm2ox | 14-584-467-9693 | ieve across the dolphins. asymptotes b 9784.56 | Supplier#000092583 | EGYPT | 492582 | Manufacturer#4 | TnTrsbF4MtbArZ1tHX | 14-235-120-6411 | iresias cajole. slyly bold packages after the carefully express theo 9783.01 | Supplier#000022299 | IRAN | 572288 | Manufacturer#3 | rQV M wmmwkw3 | 20-759-818-9488 | e slyly pending patterns. quickly silent accounts sleep boldly final pinto bean 9781.61 | Supplier#000031113 | JORDAN | 56112 | Manufacturer#3 | GcOGGe32iWS7roXOMFVMUCTSAQLL | 23-910-191-4358 | oost quickly after the even accounts. a 9778.47 | Supplier#000015099 | JORDAN | 165096 | Manufacturer#2 | u4Rgb6RdCP07R Bz | 23-735-938-5014 | y. furiously special deposits wake after the blithely final theodolites. silent dependenc 9776.93 | Supplier#000042285 | IRAQ | 1592254 | Manufacturer#2 | VpkFaCtrkKzaXStlCPodFg0xMU | 21-420-242-8957 | use. special theodolites wake regular requests. quickly ironic attainments nod b 9767.34 | Supplier#000070384 | JORDAN | 1495341 | Manufacturer#1 | 9hqg0Jf9ylCuWEUt3x2NKkfRNn bN1okSWwVF | 23-147-338-7546 | ironic epitaphs; slyly even requests accordin 9765.92 | Supplier#000020115 | IRAN | 270110 | Manufacturer#3 | 1fqwTXXq97WWR4WSTMRT x8 | 20-395-110-1655 | er special ideas. carefully pending ideas are. deposits haggle furiously pending reques 9765.34 | Supplier#000063145 | JORDAN | 88144 | Manufacturer#1 | cc5jjj40TSW8 | 23-148-180-1001 | - furiously final accounts impress. blithely express ideas nod. pendi 9765.08 | Supplier#000041675 | IRAN | 916665 | Manufacturer#3 | 1DNxZmMHQnr4m08K | 20-402-783-7477 | bove the fluffily dogged theodolites. final, eve 9758.23 | Supplier#000036128 | SAUDI ARABIA | 1361088 | Manufacturer#3 | DjkylhmH2CS | 30-629-932-7957 | ep. express, special pinto beans 9753.96 | Supplier#000017279 | JORDAN | 1392265 | Manufacturer#3 | 4VOtV6AkFFArm2gaKygpkoai7Q | 23-426-387-7295 | lly about the slyly regular theodolites. blithely even deposits cajole c 9750.4 | Supplier#000096591 | IRAN | 371587 | Manufacturer#2 | 413QKZs9Gjz,i,CMbGkv | 20-120-997-4933 | nstructions. ironic pinto bean 9745.3 | Supplier#000017175 | JORDAN | 1167152 | Manufacturer#3 | PGTNSSjU3koRc,aTGp7raL | 23-568-217-3636 | express, daring packages run 9745.28 | Supplier#000000655 | EGYPT | 1425612 | Manufacturer#2 | j8ga9M1KhzXKSk6g,bXi0zbLWjckDEpwBeqs | 14-708-916-3581 | stealthily slyly special deposits. final packages behind the regular requests na 9745.28 | Supplier#000000655 | EGYPT | 1850618 | Manufacturer#5 | j8ga9M1KhzXKSk6g,bXi0zbLWjckDEpwBeqs | 14-708-916-3581 | stealthily slyly special deposits. final packages behind the regular requests na 9735.21 | Supplier#000030641 | EGYPT | 380634 | Manufacturer#3 | L1flHVWjtXNMmuQADDKRhRQnnIjVYQRUbrl X1jm | 14-930-502-4217 | foxes cajole slyly even, even foxes. regular, regular accounts among the stealthily fina 9730.47 | Supplier#000010689 | SAUDI ARABIA | 1085678 | Manufacturer#1 | TaTlUbCIhwlQ6xbQJq9zOxXaZlkftHIJyxNNfmC | 30-832-526-4302 | blithely. platelets haggle bravely s (100 rows) COMMIT; COMMIT