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 = 16 and p_type like '%BRASS' and s_nationkey = n_nationkey and n_regionkey = r_regionkey and r_name = 'AMERICA' 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 = 'AMERICA' ) 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.18 | Supplier#000024066 | PERU | 524065 | Manufacturer#4 | CaiBTBTvHdFo3EwYUXSXMWmr9VgCzKka6sM1EWl9 | 27-188-860-4114 | efully regular requests. dependencies are carefully slyly pending foxes. f 9994.83 | Supplier#000052301 | CANADA | 427296 | Manufacturer#5 | tEE5cTg1Xv3tOKaAhfMfCDfybQFISdtt8V | 13-437-784-3548 | re always instructions. ideas must have to detec 9993.93 | Supplier#000097117 | BRAZIL | 372113 | Manufacturer#1 | xnJNle1uJWuSfdDbOH1KACKrCaO1RBcguiR | 12-331-393-6337 | ss the special deposits. pinto beans along the even requests cajo 9993.11 | Supplier#000048114 | CANADA | 1773062 | Manufacturer#2 | GviL7PxU8q1htWmn9u2oKxDV | 13-761-118-8413 | quickly unusual ideas. regular requests 9987.12 | Supplier#000010499 | CANADA | 1385485 | Manufacturer#5 | AmZQ39jp9jb1Ji87VMNGPqi | 13-674-654-2335 | ckly quickly express requests. carefully regular dependen 9987.04 | Supplier#000015601 | PERU | 465592 | Manufacturer#2 | 2UvlYtOSEoYOCYrgeWxjeIn7NLnx | 27-993-727-8949 | ronic platelets. final asymptotes affix. silent packages ca 9984.78 | Supplier#000066482 | CANADA | 641475 | Manufacturer#3 | S37cy4w3iqLE | 13-662-729-6570 | lose ideas around the final, pending requests thrash instead of the blit 9984.53 | Supplier#000022901 | BRAZIL | 1297888 | Manufacturer#1 | WpwlX9aQLO5ASnsZVD40 | 12-240-545-3477 | silent, even ideas sleep above the slyly bold 9981.32 | Supplier#000023706 | ARGENTINA | 1248669 | Manufacturer#1 | xUfWLcF8cnBxYQOWAZKvvzluL | 11-352-425-1666 | y unusual platelets haggle quickly above the attainments. fluffily unusu 9980.74 | Supplier#000099272 | BRAZIL | 1199271 | Manufacturer#4 | Inuon6nxfsjvR1LPl | 12-154-201-7725 | t carefully blithely final deposits. idly final pinto b 9978.74 | Supplier#000039340 | PERU | 1189317 | Manufacturer#4 | tmlKrifVfGql27v4o0RLmzJsRPi35N | 27-618-115-9428 | le carefully brave packages. quickly pending ideas in place of 9973.18 | Supplier#000091752 | BRAZIL | 416739 | Manufacturer#1 | 80KVvLK6dUkoABwNGiyPFX op5CMe5bm96GQSs | 12-711-877-1254 | re about the quickly even foxes. regular requests 9973.18 | Supplier#000091752 | BRAZIL | 1566736 | Manufacturer#2 | 80KVvLK6dUkoABwNGiyPFX op5CMe5bm96GQSs | 12-711-877-1254 | re about the quickly even foxes. regular requests 9968.32 | Supplier#000014067 | ARGENTINA | 1114066 | Manufacturer#2 | MJJhDdlV68Yii0f | 11-279-553-5167 | l dugouts boost. blithely pending platelets are slyly along the regular pint 9968.18 | Supplier#000099805 | UNITED STATES | 374801 | Manufacturer#5 | 0BbkqHXBLEcpa4sBkr59wmW9LH9f1,P, | 34-256-507-3314 | for the regular ideas. slyly regular asymptotes sle 9967.59 | Supplier#000018870 | PERU | 743848 | Manufacturer#2 | hwB04ilx,UFt | 27-404-186-6388 | y pending packages. deposits haggle b 9967.59 | Supplier#000018870 | PERU | 1493855 | Manufacturer#3 | hwB04ilx,UFt | 27-404-186-6388 | y pending packages. deposits haggle b 9967.59 | Supplier#000018870 | PERU | 1543824 | Manufacturer#3 | hwB04ilx,UFt | 27-404-186-6388 | y pending packages. deposits haggle b 9966.66 | Supplier#000090941 | ARGENTINA | 165939 | Manufacturer#4 | rk97okEewX1X2BObhudcaNG7BICYVGXI2c9POE | 11-433-145-1954 | usly sly theodolites against the carefully pend 9964.95 | Supplier#000050887 | UNITED STATES | 1450886 | Manufacturer#5 | TxMfdIdOnEINgaEhlL,5nHuIEjuinBHnfPIdWiLM | 34-192-506-6272 | nag even, special packages. careful 9962.7 | Supplier#000092269 | CANADA | 367265 | Manufacturer#1 | 6OtjVGtiRdkwHFGvVodp1g | 13-590-410-4638 | s. slyly regular packages are alongside of the carefully exp 9962.19 | Supplier#000031326 | UNITED STATES | 181323 | Manufacturer#5 | UOJ5g9oU7hk3MHLOps5X3oVAUHJ05jF8z29RsPoX | 34-753-267-7829 | carefully regular accounts ar 9961.16 | Supplier#000066536 | PERU | 1191502 | Manufacturer#5 | ngShViXD5EZGI28 | 27-704-250-5277 | beans cajole carefully. even packages wake blithely slyly final asymptotes. exp 9961.1 | Supplier#000025076 | BRAZIL | 1600059 | Manufacturer#2 | W8mEhSu,P0WWZasaRBl8B6kc | 12-990-509-5364 | the furiously regular accounts use slyly 9960.06 | Supplier#000055916 | UNITED STATES | 1205891 | Manufacturer#4 | pIRvOiz7oN2L1CrhfEXAC0AMo | 34-678-188-6184 | beans. instructions sleep even, unusual instructions. furiously even dep 9960.06 | Supplier#000055916 | UNITED STATES | 1255915 | Manufacturer#2 | pIRvOiz7oN2L1CrhfEXAC0AMo | 34-678-188-6184 | beans. instructions sleep even, unusual instructions. furiously even dep 9960.06 | Supplier#000055916 | UNITED STATES | 1805879 | Manufacturer#5 | pIRvOiz7oN2L1CrhfEXAC0AMo | 34-678-188-6184 | beans. instructions sleep even, unusual instructions. furiously even dep 9959.88 | Supplier#000005696 | BRAZIL | 1305695 | Manufacturer#1 | a8mRYpNQHaBi0x5TYejuHPn,cb | 12-622-757-1711 | ages. furiously final courts boost slyly slyly ironic accounts. unusual packages cajole. stealth 9957.74 | Supplier#000014310 | ARGENTINA | 289307 | Manufacturer#4 | Qi7TWRjx3dpxwwnbpvXpl68 | 11-342-931-8479 | lly. unusual, express requests haggle. 9957.74 | Supplier#000014310 | ARGENTINA | 1289297 | Manufacturer#1 | Qi7TWRjx3dpxwwnbpvXpl68 | 11-342-931-8479 | lly. unusual, express requests haggle. 9956.17 | Supplier#000047022 | CANADA | 1671973 | Manufacturer#2 | KKs59GGS,QHk | 13-242-301-2776 | le blithely over the furiously express requests: excuses boost. caref 9954.99 | Supplier#000050830 | CANADA | 425825 | Manufacturer#2 | 1oQ8iygPTdCBtz3Mf4Ol,N4wlVzAbqt | 13-121-628-3805 | nding theodolites. carefully express inst 9950.25 | Supplier#000087016 | CANADA | 112012 | Manufacturer#1 | 9bCwRJhsfJj | 13-491-176-9052 | he carefully special packag 9947.62 | Supplier#000059045 | ARGENTINA | 9044 | Manufacturer#3 | hdi5zKHmL0UDWoqA3Jl9qUGMB7CKZ1 | 11-984-172-1001 | xpress, ironic foxes around the accounts wake slyly according to the ironic accounts 9946.62 | Supplier#000026894 | BRAZIL | 76893 | Manufacturer#3 | zsuYhA9n6CathESYr,BSZu5twMC4b | 12-208-934-3709 | quickly. blithely silent ideas hinder slyly. ironic 9936.46 | Supplier#000088013 | CANADA | 38012 | Manufacturer#3 | 9J8MLXqaES8JAKq9CL | 13-890-644-8924 | ording to the blithely special requests grow fluffily agai 9935.3 | Supplier#000036589 | PERU | 286584 | Manufacturer#2 | xk3tq6p,i3PRi5L2MSqZ,0IF2 | 27-141-194-4187 | ld frets. carefully bold requests sleep carefully silent pinto beans. 9930.72 | Supplier#000036543 | UNITED STATES | 1511527 | Manufacturer#3 | FdfESt,aqJBPsXqQnPPTAgtARfhHBB36xOV | 34-789-417-1136 | ar, final requests. ironic, final theodolites boost carefully above the 9930.72 | Supplier#000036543 | UNITED STATES | 1936542 | Manufacturer#2 | FdfESt,aqJBPsXqQnPPTAgtARfhHBB36xOV | 34-789-417-1136 | ar, final requests. ironic, final theodolites boost carefully above the 9930.61 | Supplier#000041647 | CANADA | 41646 | Manufacturer#4 | a1oNcKXj118mJt,NdPQm2Md | 13-839-115-6488 | fluffily special dinos. enticingly final forges sleep quickly? car 9930.61 | Supplier#000041647 | CANADA | 1816628 | Manufacturer#3 | a1oNcKXj118mJt,NdPQm2Md | 13-839-115-6488 | fluffily special dinos. enticingly final forges sleep quickly? car 9930.22 | Supplier#000087804 | BRAZIL | 887803 | Manufacturer#2 | yCMclCR0Vd0l3RYiGYzYGWJpKSOQOej82TfS | 12-484-756-8982 | foxes boost around the sly pinto 9929.34 | Supplier#000057849 | PERU | 1157848 | Manufacturer#2 | 2FPHR9w9TPG4n75q,9XfXuBzZCr6fSv9Vxu | 27-243-309-5348 | fix accounts. theodolites are blithely ac 9928.55 | Supplier#000035413 | CANADA | 635412 | Manufacturer#4 | w87qbjs57RjI9BZqik,kjeF | 13-476-871-5150 | etect blithely. slyly unusual requests mold qu 9926.57 | Supplier#000017817 | UNITED STATES | 792809 | Manufacturer#3 | XBkbJIJVgvZ WJ | 34-183-673-3948 | efully bold deposits. final notornis nag. slyly express platelets among the ironic warhorses 9923.4 | Supplier#000058097 | ARGENTINA | 1383057 | Manufacturer#4 | aIF4uckQFrNg7ndAi6PLqjTv1kdHVq7OqKFF | 11-366-468-1405 | onic pinto beans after the carefully pending grouches wake express platelets. quickly even foxes 9922.73 | Supplier#000036806 | ARGENTINA | 1261769 | Manufacturer#1 | UXZUe1TB2tU6,Jn8gEZOec938LYAy | 11-712-312-9745 | ironic requests. slyly unusual deposits affi 9919.06 | Supplier#000028426 | ARGENTINA | 303422 | Manufacturer#1 | AIupyQiigh6UaPbBGloMbFFAJH7BAAlV | 11-151-721-3599 | osits among the blithely pending deposits are deposits. blithely final 9919 | Supplier#000039578 | PERU | 964550 | Manufacturer#4 | UBRvsVUtYLccfTtkt8tre 8o,YjtMqOGx8NE1P | 27-479-198-8486 | cial requests. accounts are furiously carefully idle dolphins. asymptotes haggle aga 9918.27 | Supplier#000099441 | PERU | 624422 | Manufacturer#5 | ,hPBeodx0uvl06cWVbxdxdvzexcnkNKEouh4 | 27-860-110-9649 | l foxes haggle fluffily according to the pending, unusual requests. pending deposits use carefull 9912.79 | Supplier#000048773 | UNITED STATES | 973745 | Manufacturer#3 | BAPuzmwU3OTms | 34-954-369-3706 | losely furiously pending orbits. instructions sleep 9909.83 | Supplier#000067061 | ARGENTINA | 567060 | Manufacturer#5 | 4JxTgNW5vH9sj | 11-712-439-2302 | ully packages. blithely regular deposits ha 9904.08 | Supplier#000068454 | CANADA | 218449 | Manufacturer#4 | xVOhuDC8on3Bs,2nt7Jz09JDzP X | 13-576-746-2524 | ecial waters despite the unusual, final instructions are carefully fluffily ironic reque 9904.08 | Supplier#000068454 | CANADA | 1468453 | Manufacturer#5 | xVOhuDC8on3Bs,2nt7Jz09JDzP X | 13-576-746-2524 | ecial waters despite the unusual, final instructions are carefully fluffily ironic reque 9903.08 | Supplier#000006832 | UNITED STATES | 156829 | Manufacturer#3 | UgadmHfm2qXtLvuyK2MABgd7NGe0G2p0b9G | 34-323-820-1126 | the blithely pending deposits: blithely ironic instructions 9899.65 | Supplier#000052109 | CANADA | 202104 | Manufacturer#1 | 4d,02ZiWlh4TL6lsahdz04bmMEV4OQLc1gTn1 | 13-566-901-7567 | nent deposits. carefully special requests nag slyly special requests. requests accor 9899.27 | Supplier#000085097 | ARGENTINA | 435088 | Manufacturer#2 | EZu6rjQiM3JhB861dOWWZQs3lGkvbYryI | 11-339-368-8275 | ial deposits wake blithely alongside of the even excuses. deposits alongside of the pint 9895.04 | Supplier#000050003 | UNITED STATES | 1099982 | Manufacturer#1 | KtkCrHj9KN | 34-814-241-5884 | e pending, regular foxes wake blithely among the special theodolites. quickly careful excuse 9894.37 | Supplier#000099813 | BRAZIL | 124809 | Manufacturer#4 | JaojtzGzKb89,2RaXNja | 12-999-201-3567 | . furiously pending courts haggle gifts. slyly iron 9894.04 | Supplier#000021054 | BRAZIL | 1796036 | Manufacturer#4 | SN llHJ Mk9cv B1oFVSKq6eee3 | 12-179-107-6781 | along the deposits haggle 9894 | Supplier#000060795 | BRAZIL | 1210770 | Manufacturer#4 | IpX1n4xZs,lwsAilaFwCgrWvM0ELJS3JuCoK1 | 12-330-177-7100 | uctions haggle blithely according to the carefully even requests. quickly express warthogs afte 9888.89 | Supplier#000096338 | ARGENTINA | 921310 | Manufacturer#5 | A9fPxDlrRshOa | 11-318-897-9174 | e ironic, regular packages. fluffily fluf 9884.55 | Supplier#000012014 | CANADA | 1061993 | Manufacturer#4 | HGLILugwb16N04PbIyE9dP2pXeSoNkT bvXWB0 | 13-178-354-1792 | gular dependencies cajole around the braids. ironic deposits above the quick, careful acc 9879.23 | Supplier#000041120 | PERU | 641119 | Manufacturer#5 | HjQ78cl301MYHFPkPd6VNwymRo | 27-752-249-5407 | eas print alongside of the even ideas. slyly ironic forges na 9877.06 | Supplier#000094445 | PERU | 1344418 | Manufacturer#4 | SeidVE1XJRGvglwfkHuJdbQ7ZMWetVwQLXiN | 27-701-846-7537 | cajole blithely. regular, bol 9872.08 | Supplier#000008998 | PERU | 1983978 | Manufacturer#4 | cTCn79ziEcQz66KkdD Gil,VvaDHdXli | 27-988-387-1160 | deposits. even, fluffy theodolites believe above the carefully regular instructions. foxes sleep. f 9868.7 | Supplier#000030727 | PERU | 980708 | Manufacturer#1 | MZDjvvKSJuEMlLBdiuBwdgWqnGNqZvxTKI0 | 27-378-939-2999 | , regular deposits. ironic ac 9867.16 | Supplier#000016090 | ARGENTINA | 16089 | Manufacturer#2 | 7wzzJvF40WmAJ8gVed1 XC4VT1Kj | 11-992-721-8617 | as x-ray carefully regular sauternes. slyly final pinto beans along the bold pinto beans wa 9864.13 | Supplier#000077240 | UNITED STATES | 1852221 | Manufacturer#5 | pba1MwOPnC,A,GxV1d9D7NHX81onkX4Cz6 | 34-335-357-3467 | ly final asymptotes. unusual 9863.74 | Supplier#000025482 | UNITED STATES | 275477 | Manufacturer#4 | yxrtVns2C6iBzNQJDnyKhB5IFob1pBNjf4P0njg5 | 34-330-324-9357 | . furiously special accounts after the bold instructions are furiously according to the pin 9863.4 | Supplier#000035776 | PERU | 735775 | Manufacturer#1 | oXVoaEk3vmP5w | 27-235-619-5547 | old depths affix around the furiously special reque 9863.4 | Supplier#000035776 | PERU | 1210763 | Manufacturer#1 | oXVoaEk3vmP5w | 27-235-619-5547 | old depths affix around the furiously special reque 9861.67 | Supplier#000091630 | PERU | 1391629 | Manufacturer#2 | FjoaUAHhQkHceVNFozB | 27-256-681-2466 | cial dependencies doubt slyly according to the dolphins. blithely final accounts unwind 9856.01 | Supplier#000040367 | CANADA | 1540366 | Manufacturer#4 | 1avBjyMY,vMinSmuI,5A6FXt9vqe nEH95 | 13-653-551-8341 | sly regular dependencies wake blithely after the r 9855.7 | Supplier#000038050 | CANADA | 88049 | Manufacturer#2 | BbudH ,QL5uf5OtP5uAhuW617oeE2 | 13-291-416-8064 | even, ironic accounts. fl 9849.41 | Supplier#000037517 | ARGENTINA | 1162483 | Manufacturer#3 | U6WAmOdd51H7uhZiLPXtPYK1gh0grW, | 11-810-498-5884 | iments sleep about the ironic asymptotes. unusual accounts wake quickly accor 9845.83 | Supplier#000091004 | PERU | 965994 | Manufacturer#1 | zoewWP2exbJ | 27-142-136-9166 | regular, regular theodolites nod according to the caref 9845.83 | Supplier#000091004 | PERU | 1615955 | Manufacturer#3 | zoewWP2exbJ | 27-142-136-9166 | regular, regular theodolites nod according to the caref 9836.44 | Supplier#000095037 | UNITED STATES | 745022 | Manufacturer#2 | UuuiRxO,2J,RJ1lWZATUqGJZXFN8kYNFHgOm | 34-797-997-9674 | deposits cajole. furiously bold deposits cajole slyly bold, regular instructions 9831.07 | Supplier#000039959 | UNITED STATES | 139958 | Manufacturer#1 | XGmDQ,0FtTXgD4POwQEG24QzSVnQ3yW2oQsPbBY4 | 34-212-997-9110 | nts. carefully regular deposits against the quietly final ideas c 9822.2 | Supplier#000015448 | UNITED STATES | 1615447 | Manufacturer#1 | jfvwHjrCG7KzIZe5C1JRIWVDLW6kcahZxP | 34-375-321-7835 | even asymptotes wake slyly along the slyly brave foxes. finally unusual dependencies 9817.53 | Supplier#000005510 | UNITED STATES | 405509 | Manufacturer#3 | f 0PMKZD0h | 34-332-810-7526 | warhorses. furiously regular packages boost above the quickly unusual acco 9816.88 | Supplier#000037376 | ARGENTINA | 1662327 | Manufacturer#5 | WnLOLOCp CFcv48SRNsiM4xK7tHDmfA | 11-446-910-3895 | pending ideas are. quickly ironic excuses cajole a 9814.17 | Supplier#000032850 | UNITED STATES | 232849 | Manufacturer#4 | xjbvrdPLhosLrFwu5avC | 34-683-330-1497 | ess deposits wake furiously 9811.15 | Supplier#000074333 | ARGENTINA | 774332 | Manufacturer#1 | f0eB04xtCP6alTBQRaXizT07S6t1Ui7RY | 11-696-477-2522 | quests sleep blithely quickly final platelets-- quiet epitaphs affix slyly furiously even idea 9809.85 | Supplier#000077335 | CANADA | 1327308 | Manufacturer#3 | TIiJg9HbQHS4Ng2S8oe5XFX 2zPITP | 13-415-324-2646 | re according to the regular, bold courts. express reque 9806.83 | Supplier#000020603 | CANADA | 370596 | Manufacturer#2 | 03oUnrvTpssy22hq3uDJWUdH52VxSuYrbE8 | 13-333-408-4005 | as eat blithely quickly silent fo 9806.69 | Supplier#000028830 | ARGENTINA | 1028829 | Manufacturer#4 | DAcagW5EKA6jhg2,d | 11-720-268-7507 | hely. blithely unusual dolphins are. express, unusual deposits against the fluffily unu 9801.91 | Supplier#000041182 | BRAZIL | 566166 | Manufacturer#5 | 44yIRpzocKtkO3t04,ph7UK,ZVnXUm3HDtaHm | 12-798-897-1785 | multipliers. fluffily pe 9799.5 | Supplier#000086256 | ARGENTINA | 1636223 | Manufacturer#5 | kz GS88QbjXgCH749fWkMth5g cu | 11-499-416-3775 | es wake furiously final, regular requests. express, bold deposits are s 9796.32 | Supplier#000011064 | ARGENTINA | 1886045 | Manufacturer#3 | i,,2sV20NnRVUEbe | 11-230-949-2847 | sleep carefully furiously regular deposits. furiously silent 9794.41 | Supplier#000049024 | ARGENTINA | 1998985 | Manufacturer#4 | M6p77SQWhBt6VUKn5N8gxQpoNbhP | 11-218-991-1980 | s cajole. slyly regular requests sleep carefully along the even pinto beans. c 9793.05 | Supplier#000089712 | ARGENTINA | 139709 | Manufacturer#2 | 9xLVFfnerH,WRoxBu137 | 11-840-600-4301 | d the accounts. deposits affix. quickly regular instructions p 9791.49 | Supplier#000048309 | PERU | 373299 | Manufacturer#3 | 144WVdoVCHTiCjA4RaP1SkUbG | 27-283-367-7286 | eposits haggle carefully regular multipliers. packages cajole slyly bold pin 9791.49 | Supplier#000098817 | UNITED STATES | 1323777 | Manufacturer#2 | GUkw3ObMgu Qd 549GIEr8msp3oV | 34-871-650-6502 | re after the final multipliers. re 9789.58 | Supplier#000028987 | UNITED STATES | 1603970 | Manufacturer#1 | bX8mLj9K56u | 34-854-531-4374 | even decoys. instructions engage car 9787.45 | Supplier#000014829 | BRAZIL | 1364802 | Manufacturer#5 | kqgBRBzGvTM0gC7cgStkIyToJ0 | 12-207-435-8867 | gainst the accounts. carefully final requests about the slyly regular packages sleep quickl 9783.76 | Supplier#000064329 | CANADA | 764328 | Manufacturer#1 | SMCC,Kxm,YyUPP7bpH | 13-269-796-9658 | t the carefully ironic pinto beans are after the pinto beans. furiously unusual foxes use quickly. p 9781 | Supplier#000061153 | UNITED STATES | 761152 | Manufacturer#1 | gWV90KTvhj6WGckZLHy | 34-802-642-8676 | regular accounts. bravely even requests integrate furiously agains 9778 | Supplier#000089416 | UNITED STATES | 1614367 | Manufacturer#2 | rq6Met33b0KMYelCic1d | 34-422-386-9938 | s boost slyly express account (100 rows) COMMIT; COMMIT