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 = 40 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 -----------+---------------------------+---------------------------+-----------+---------------------------+------------------------------------------+-----------------+------------------------------------------------------------------------------------------------------ 9999.01 | Supplier#000022107 | PERU | 1747055 | Manufacturer#3 | P85QDawcob9ReWZ,KESPhKQP2 obc2Qjr1cGoNFa | 27-888-324-2213 | integrate enticingly. carefully bold 9996.34 | Supplier#000076971 | PERU | 951961 | Manufacturer#3 | cRtt6ZfY8 lBEcHTDd0JVx | 27-649-362-5733 | ndencies. packages are about the furiously bold dependencies. final, fina 9995.18 | Supplier#000024066 | PERU | 1774031 | Manufacturer#3 | CaiBTBTvHdFo3EwYUXSXMWmr9VgCzKka6sM1EWl9 | 27-188-860-4114 | efully regular requests. dependencies are carefully slyly pending foxes. f 9994.46 | Supplier#000074320 | CANADA | 424311 | Manufacturer#4 | pHqby4sZe byTJoaBk | 13-793-901-6289 | special courts. dolphins w 9992.28 | Supplier#000060858 | ARGENTINA | 1835839 | Manufacturer#1 | JY6ikmxTyvQlWD1nhvSygO6QptwWc9YG3vylw | 11-719-537-8037 | ithely idle deposits detect furiously about the even package 9989.9 | Supplier#000011269 | BRAZIL | 311268 | Manufacturer#5 | V,4bksZDdE1Ux3YhH1UE0SeGZjudbbVvb,H3eA 3 | 12-917-310-3275 | egular accounts after the furiously express requests doubt above the slyly 9987.28 | Supplier#000020625 | CANADA | 670612 | Manufacturer#3 | Wcm,pG8ovarBbWQOCmz81dE9XJUoz8iIrw5Zp | 13-843-674-8326 | ideas solve quietly slyly even deposits. carefully final dependencies use furiously slyly bold re 9987.04 | Supplier#000015601 | PERU | 940573 | Manufacturer#2 | 2UvlYtOSEoYOCYrgeWxjeIn7NLnx | 27-993-727-8949 | ronic platelets. final asymptotes affix. silent packages ca 9984.2 | Supplier#000002331 | CANADA | 952312 | Manufacturer#1 | WRh2w5WFvRg7Z0S1AvSvHCL | 13-753-341-2617 | the final theodolites. quickly even de 9982.51 | Supplier#000017576 | ARGENTINA | 1692559 | Manufacturer#5 | CuKHjAQbDa3qxXZG7,D7AUQnstqybUHCgV4B | 11-152-450-4535 | sleep slyly above the special, special pinto beans-- final accounts 9981.32 | Supplier#000023706 | ARGENTINA | 923705 | Manufacturer#5 | xUfWLcF8cnBxYQOWAZKvvzluL | 11-352-425-1666 | y unusual platelets haggle quickly above the attainments. fluffily unusu 9980.74 | Supplier#000099272 | BRAZIL | 1949233 | Manufacturer#4 | Inuon6nxfsjvR1LPl | 12-154-201-7725 | t carefully blithely final deposits. idly final pinto b 9980.69 | Supplier#000091469 | BRAZIL | 1191468 | Manufacturer#2 | K,qH2 ejAvsdksXuEi,K9x | 12-971-490-2210 | sits? requests breach. regular accounts 9980.04 | Supplier#000074041 | CANADA | 1649024 | Manufacturer#3 | 1CgOqjGPeblukGxirAdSY1vvgqlRdXNjI | 13-349-270-8179 | ts. requests dazzle furiously silent instr 9979.62 | Supplier#000094261 | BRAZIL | 469256 | Manufacturer#2 | J5kVLNgCMxaU YG,7tzS4wrQ,7V09D1g | 12-578-700-2233 | the carefully even packages. 9979.62 | Supplier#000094261 | BRAZIL | 544250 | Manufacturer#4 | J5kVLNgCMxaU YG,7tzS4wrQ,7V09D1g | 12-578-700-2233 | the carefully even packages. 9979.62 | Supplier#000094261 | BRAZIL | 1919203 | Manufacturer#5 | J5kVLNgCMxaU YG,7tzS4wrQ,7V09D1g | 12-578-700-2233 | the carefully even packages. 9979.52 | Supplier#000004634 | UNITED STATES | 429621 | Manufacturer#1 | ukp63mlcz4saSWQr | 34-196-553-2719 | uriously. slyly ironic ideas affix slyly! blithely pending theodolites mainta 9978.74 | Supplier#000039340 | PERU | 1564294 | Manufacturer#1 | tmlKrifVfGql27v4o0RLmzJsRPi35N | 27-618-115-9428 | le carefully brave packages. quickly pending ideas in place of 9978.37 | Supplier#000017396 | CANADA | 1892377 | Manufacturer#2 | spIK1m8MVncS4X96ZPw,GouR5C9tA eA3aDD | 13-373-848-9889 | onic platelets affix quickly regular accounts. silent foxes print slyly about th 9975.1 | Supplier#000072118 | PERU | 1147106 | Manufacturer#4 | a4skJxR4mUu68kknjnrMQrq49j7ZUA3 | 27-768-646-5732 | idle theodolites. slyly unusual accounts affix slyly above the furiously express ideas. f 9964.42 | Supplier#000079009 | CANADA | 854000 | Manufacturer#4 | oBINUBoR Pr8N5U,o,KtQZRKA9nFfWsKwYd7T5x | 13-841-791-1451 | s around the fluffily ironic 9957.39 | Supplier#000024454 | BRAZIL | 1899435 | Manufacturer#5 | iNb,PoZ0LXZ9XfA | 12-487-845-7399 | e slyly ironic accounts; carefully express packages detect slyly above the silent, express 9957.09 | Supplier#000059635 | PERU | 1534619 | Manufacturer#5 | PebMPFyuXtrVrT | 27-402-829-9991 | ic platelets. carefully pending warhorses nag 9956.75 | Supplier#000027460 | ARGENTINA | 1277435 | Manufacturer#4 | vqHP,f,sWBq5vU | 11-261-295-6739 | s are. slyly express accounts along the furiously expr 9944.37 | Supplier#000010860 | PERU | 860843 | Manufacturer#2 | MXAMvLAS oo | 27-713-326-9083 | bold accounts. express, bold instructions are bli 9935.88 | Supplier#000029533 | CANADA | 29532 | Manufacturer#3 | YvAD4oiDfZ2pMsVydy | 13-860-998-5191 | to beans sleep blithely among the packages; blithely regular accounts affix. silent ideas 9933.78 | Supplier#000027684 | PERU | 1377657 | Manufacturer#2 | fRG4tvlJmUhNbyZ48W4 | 27-904-825-3267 | s. enticingly final theodolites use regular requests. furiously regular dependencies cajo 9923.64 | Supplier#000095530 | UNITED STATES | 170528 | Manufacturer#1 | SMHglRaovkme44X2DgMfi2,4hqxH | 34-429-175-4747 | ve the waters. silent escapades according to the carefully special packages haggle 9923.08 | Supplier#000004282 | ARGENTINA | 1079271 | Manufacturer#5 | 4n7vK UT5kS2jxmr ig2NKoX3hTE6C,1Pv4kd | 11-776-775-8792 | asymptotes sleep busily unusual Tiresias. regular, 9919.2 | Supplier#000032764 | ARGENTINA | 1457721 | Manufacturer#5 | rlHCrxnFGkg243mouCoZkI | 11-460-618-5311 | bold waters! carefully unusual instructions according to the boldly special depo 9912.79 | Supplier#000048773 | UNITED STATES | 598762 | Manufacturer#5 | BAPuzmwU3OTms | 34-954-369-3706 | losely furiously pending orbits. instructions sleep 9912.02 | Supplier#000064858 | ARGENTINA | 839849 | Manufacturer#4 | pojdU0XCskFaXWD,DfQkysguFgQMLKsrmJNQVZ3 | 11-265-995-8690 | d dinos. quickly ironic packages sleep furiously regular deposits. iro 9910.18 | Supplier#000046198 | BRAZIL | 996179 | Manufacturer#5 | 00qeaHhPddledrC5SFIpwO | 12-268-516-2305 | nst the slyly brave packa 9907.8 | Supplier#000046851 | ARGENTINA | 121849 | Manufacturer#4 | 8,waF5xwsK66evC4svJSud22i,ytikqMa | 11-276-217-5707 | ke carefully against the carefully ironic deposits. regular, special instructions boost q 9906.28 | Supplier#000068707 | PERU | 1743689 | Manufacturer#2 | lUc43vUum4x18cHuo5f lQre | 27-176-762-6388 | egular dependencies haggle alongside of the carefully ironic packages 9906.28 | Supplier#000068707 | PERU | 1968706 | Manufacturer#1 | lUc43vUum4x18cHuo5f lQre | 27-176-762-6388 | egular dependencies haggle alongside of the carefully ironic packages 9901.92 | Supplier#000038016 | CANADA | 513010 | Manufacturer#4 | 9R0CMFk7fXTp1cA8a | 13-482-992-4457 | uickly pending requests are carefully. dependencies use. slyly regular packages around t 9900.18 | Supplier#000079278 | PERU | 654271 | Manufacturer#1 | yG7LSwpRLYCqwtCr5G | 27-493-597-6576 | al foxes. instructions serve quickly speci 9900.08 | Supplier#000003941 | CANADA | 628922 | Manufacturer#5 | Pmb05mQfBMS618O7WKqZJ 9vyv | 13-668-659-3631 | ithely quickly bold accounts. bold pinto beans about the furious dependencies cajole qu 9899.65 | Supplier#000052109 | CANADA | 1827090 | Manufacturer#4 | 4d,02ZiWlh4TL6lsahdz04bmMEV4OQLc1gTn1 | 13-566-901-7567 | nent deposits. carefully special requests nag slyly special requests. requests accor 9896.86 | Supplier#000060914 | UNITED STATES | 860913 | Manufacturer#5 | Oo2PLDmWuMj1LPL92yJHYxvGKpQ | 34-116-998-1488 | regular forges haggle against the carefully pending theodolites. fluffily bold accou 9895.02 | Supplier#000000735 | PERU | 775727 | Manufacturer#2 | 7FqUrdaC732vBX3J7ruv0W4 Jfpx84 | 27-984-128-6691 | kages. furiously ironic depths unwind permanently slyly regular requests. carefully bold 9893.13 | Supplier#000066244 | CANADA | 1841225 | Manufacturer#2 | jMOCPgtmc2EintUA,vfeb Iq8ofNOufwweMyxJU | 13-771-768-6214 | he accounts. fluffily ironic deposits along the slyly regular the 9891.83 | Supplier#000057239 | PERU | 482226 | Manufacturer#5 | lL3OmZ25vVbpcBSb3 0fUlUVsMzyDJfQt | 27-380-512-6878 | even requests. carefully furious foxes cajole. carefully bold deposits 9890.37 | Supplier#000095610 | ARGENTINA | 270607 | Manufacturer#4 | M03Gi zVzBLegBxUwgL4UrE0tFao1l80jMsjE2Q | 11-700-164-6592 | ect regular requests. unusual foxes breach over t 9888.88 | Supplier#000048900 | ARGENTINA | 123898 | Manufacturer#2 | QXeg5u646Fm3ZuuF1vUmZ D2iwS2JMVjVN | 11-162-494-3254 | ncies. furiously ironic instructions use alongside of the deposits; quickly even foxes 9886.73 | Supplier#000008497 | BRAZIL | 1083486 | Manufacturer#3 | xef7AF1FKfjml5HrGfEHtkhk3Tbeg0ms | 12-748-918-9360 | . foxes nag slyly express, regular multipliers. requests after the carefully ironic accounts grow re 9886.73 | Supplier#000008497 | BRAZIL | 1133463 | Manufacturer#2 | xef7AF1FKfjml5HrGfEHtkhk3Tbeg0ms | 12-748-918-9360 | . foxes nag slyly express, regular multipliers. requests after the carefully ironic accounts grow re 9886.31 | Supplier#000086775 | ARGENTINA | 1336748 | Manufacturer#1 | OSKwH7aAWb96ZqbDUXDnixYg34 | 11-615-808-6235 | fluffily express deposits nag quickly quickly fi 9884.05 | Supplier#000028600 | ARGENTINA | 528599 | Manufacturer#1 | ziDEaAPqjV hzD105 | 11-208-404-1314 | final accounts cajole furiously. slyly ironic ideas above the slow patt 9879.57 | Supplier#000076138 | CANADA | 51137 | Manufacturer#3 | pmdlgstM Mu6ETKffxM3iIzf1eh6Fs2GikO | 13-407-520-9284 | y silently pending requests; slyly 9879.23 | Supplier#000041120 | PERU | 1991081 | Manufacturer#3 | HjQ78cl301MYHFPkPd6VNwymRo | 27-752-249-5407 | eas print alongside of the even ideas. slyly ironic forges na 9874.77 | Supplier#000016666 | UNITED STATES | 41665 | Manufacturer#4 | kF4Yb7X,ij R0lyMCQiXYEr,RI,ASbbk | 34-253-305-9611 | ts sleep about the slyly regular excuses. bold packages use 9874.77 | Supplier#000016666 | UNITED STATES | 166663 | Manufacturer#4 | kF4Yb7X,ij R0lyMCQiXYEr,RI,ASbbk | 34-253-305-9611 | ts sleep about the slyly regular excuses. bold packages use 9874.77 | Supplier#000016666 | UNITED STATES | 1491651 | Manufacturer#5 | kF4Yb7X,ij R0lyMCQiXYEr,RI,ASbbk | 34-253-305-9611 | ts sleep about the slyly regular excuses. bold packages use 9870.19 | Supplier#000062690 | BRAZIL | 712675 | Manufacturer#3 | MZGnx2SJujAfNzGDjo | 12-818-686-5219 | tipliers after the fluffily bold platelets are up the blithe 9868.7 | Supplier#000030727 | PERU | 1055696 | Manufacturer#1 | MZDjvvKSJuEMlLBdiuBwdgWqnGNqZvxTKI0 | 27-378-939-2999 | , regular deposits. ironic ac 9866.58 | Supplier#000066827 | ARGENTINA | 966826 | Manufacturer#5 | nP81MiAINx0sowcnqvMbTy1LMB,FAVL5wYVWQ5 | 11-650-324-3679 | ld requests nod at the express, final asymptotes. furiously pending att 9865.54 | Supplier#000006750 | BRAZIL | 1631701 | Manufacturer#5 | nYQx9ZK0xmoFMbSf | 12-128-392-9206 | ans. even forges cajole carefully ironic dep 9864.24 | Supplier#000030606 | PERU | 1055575 | Manufacturer#4 | U3lMNjfJhTsOL5RsBhjzU42Oq | 27-792-195-5185 | furiously pending instructions. asympt 9855.71 | Supplier#000048410 | CANADA | 1498381 | Manufacturer#2 | htvxsAiYbvfKocY53qP,Hlu rN7er76 ppYlul8p | 13-781-458-3487 | to beans. stealthily final packages doubt along 9855.7 | Supplier#000038050 | CANADA | 1113038 | Manufacturer#5 | BbudH ,QL5uf5OtP5uAhuW617oeE2 | 13-291-416-8064 | even, ironic accounts. fl 9854.14 | Supplier#000058453 | UNITED STATES | 758452 | Manufacturer#4 | tq2dsfHKPzmt8oL4pflhp | 34-976-558-1196 | ies. ironic dependencies above the pack 9853.22 | Supplier#000084474 | ARGENTINA | 459469 | Manufacturer#2 | ACrXSJhPTu73oDqjjl3x6zYeN7t85 | 11-568-771-3466 | ole. fluffily ironic deposits wake quickly quickly silent excuses! slyly even instructions 9852.58 | Supplier#000061256 | UNITED STATES | 1811219 | Manufacturer#4 | lgOxqDF1rypJtiCzP0Xxni WmtZ | 34-758-715-1231 | olites. special, regular accounts hang carefully express foxes 9849.41 | Supplier#000037517 | ARGENTINA | 562501 | Manufacturer#1 | U6WAmOdd51H7uhZiLPXtPYK1gh0grW, | 11-810-498-5884 | iments sleep about the ironic asymptotes. unusual accounts wake quickly accor 9848.15 | Supplier#000061793 | BRAZIL | 1886738 | Manufacturer#3 | 4Zot05ag8B,M5b1dj5r7z3NcpKc0IGItd | 12-477-729-1485 | al instructions are slyly 9846.08 | Supplier#000046083 | ARGENTINA | 1671034 | Manufacturer#4 | v469PAg3p0LuNBNuLBiDEA10J4d3x8CzpgvBjlC | 11-993-757-6987 | eep slyly. carefully final requests wake blithely regular ideas. furiously p 9845.78 | Supplier#000097352 | BRAZIL | 1922294 | Manufacturer#1 | nIxCPnoc5TNKgRr0 | 12-974-499-4951 | dependencies. fluffily even grouches ab 9838.81 | Supplier#000089876 | CANADA | 489875 | Manufacturer#1 | f0o1,9xA62w3wBfeAQG7I8Y39qIPGIix,uf | 13-579-960-6948 | lets boost about the requests. bold requests sleep fluffily alongsid 9836.44 | Supplier#000095037 | UNITED STATES | 1495036 | Manufacturer#2 | UuuiRxO,2J,RJ1lWZATUqGJZXFN8kYNFHgOm | 34-797-997-9674 | deposits cajole. furiously bold deposits cajole slyly bold, regular instructions 9827.43 | Supplier#000072361 | PERU | 97360 | Manufacturer#3 | ae67FUOHNI5lHltXciHG | 27-394-720-5434 | . blithely ironic requests kindle blithely. carefu 9826.53 | Supplier#000003668 | PERU | 1778650 | Manufacturer#2 | U7HrMSGbwuwLC | 27-539-572-9175 | . regular, regular warhorses wake carefully silent accounts. slyly unusual 9823.88 | Supplier#000040005 | UNITED STATES | 540004 | Manufacturer#1 | W3FIPPzG02eF5K0sYdSddt,N | 34-993-730-2019 | are slyly. regular accounts doubt bl 9823.54 | Supplier#000055917 | CANADA | 205912 | Manufacturer#2 | hcr R1MMwnzFYHw8dKQ,gH | 13-692-259-4588 | foxes. final, regular fret 9817.06 | Supplier#000016361 | UNITED STATES | 1191349 | Manufacturer#3 | 8n,vpUBgTvR0khKi,BuGTAOgOISss | 34-764-918-8025 | engage blithely even foxes: blithely unusua 9810.82 | Supplier#000009549 | CANADA | 1884530 | Manufacturer#3 | h3RVchUf8MzY46IzbZ0ng09 | 13-892-235-6781 | arefully express dependencies inside the even instructions sl 9807.57 | Supplier#000081578 | BRAZIL | 1356564 | Manufacturer#4 | vFOVz,QmlDz,Sx0PVcS,7FBxUH3VJCKyrgfmY | 12-185-293-5619 | egular packages alongside of the bold request 9806.69 | Supplier#000028830 | ARGENTINA | 1103818 | Manufacturer#2 | DAcagW5EKA6jhg2,d | 11-720-268-7507 | hely. blithely unusual dolphins are. express, unusual deposits against the fluffily unu 9806.17 | Supplier#000023465 | CANADA | 1998445 | Manufacturer#2 | nQRRA5NOUD | 13-584-741-9628 | cuses. silent, pending pearls caj 9803.42 | Supplier#000043566 | CANADA | 18565 | Manufacturer#5 | U,azwuyit,qPrKqPpzNhXghKKJ | 13-959-837-4409 | ng requests cajole quickl 9803.42 | Supplier#000043566 | CANADA | 143565 | Manufacturer#4 | U,azwuyit,qPrKqPpzNhXghKKJ | 13-959-837-4409 | ng requests cajole quickl 9801.7 | Supplier#000068262 | ARGENTINA | 1493219 | Manufacturer#3 | hIQs12b0sXWNgMtrqEMOofp | 11-694-655-1951 | pending accounts; ironically spec 9801.44 | Supplier#000027287 | UNITED STATES | 427286 | Manufacturer#3 | DUzozoUJW6 | 34-717-998-7477 | es haggle fluffily. ironic platelets sleep furiously. bli 9797.8 | Supplier#000082045 | PERU | 182044 | Manufacturer#1 | A6,VT2goha0foSpuS7Yt9uPsun5knyWq8r | 27-983-370-9142 | ronic dolphins wake carefully across the ironic, final foxe 9797.8 | Supplier#000082045 | PERU | 1882044 | Manufacturer#4 | A6,VT2goha0foSpuS7Yt9uPsun5knyWq8r | 27-983-370-9142 | ronic dolphins wake carefully across the ironic, final foxe 9794.41 | Supplier#000049024 | ARGENTINA | 1524008 | Manufacturer#2 | M6p77SQWhBt6VUKn5N8gxQpoNbhP | 11-218-991-1980 | s cajole. slyly regular requests sleep carefully along the even pinto beans. c 9791.49 | Supplier#000048309 | PERU | 1723291 | Manufacturer#4 | 144WVdoVCHTiCjA4RaP1SkUbG | 27-283-367-7286 | eposits haggle carefully regular multipliers. packages cajole slyly bold pin 9791.18 | Supplier#000058622 | ARGENTINA | 108619 | Manufacturer#1 | GTz947BOJFEcsKE | 11-775-439-1044 | gle furiously. furiously final ideas wake. ironic, even req 9789.53 | Supplier#000011353 | PERU | 1236316 | Manufacturer#1 | DGIL6YvpHyLcjsUw0SQRqYx0 | 27-838-723-6798 | sits according to the regular packages wake after 9788.63 | Supplier#000069402 | ARGENTINA | 619389 | Manufacturer#1 | 3KK6RyDGxAq2w9LlpnXeaQVzeGKrJV5S1T | 11-596-596-5644 | ronic, ironic accounts. bold, regular instructions are b 9785.34 | Supplier#000005611 | UNITED STATES | 880602 | Manufacturer#5 | pSGcoAPtjG6R | 34-290-191-3031 | eodolites. doggedly final accounts boost among the 9784.06 | Supplier#000078916 | CANADA | 1053905 | Manufacturer#2 | Cnp9WJk9A dGzO7cPDtNWmx9qkEdnTwFt | 13-338-720-9993 | se accounts. thinly unusual ideas haggle carefu 9781.43 | Supplier#000059501 | ARGENTINA | 1909462 | Manufacturer#5 | GZkbLLIlNJEMu AucWdfVN3PhiWEgZqLeN7x881 | 11-481-811-1494 | pinto beans. busily special foxes cajole fluffily even foxes. carefully even pinto beans are 9779.85 | Supplier#000008265 | UNITED STATES | 1058244 | Manufacturer#4 | Ig x7 AsU,sda27UWa | 34-831-958-1126 | ally special ideas are according to the furiously 9778.03 | Supplier#000035184 | CANADA | 1085163 | Manufacturer#2 | 0VTxxwn6CaGz1Ux9LW76th | 13-296-875-3970 | long the deposits solve blithely blithely idle instructions 9777.39 | Supplier#000052089 | UNITED STATES | 452088 | Manufacturer#1 | HYDWh0cs253rhT | 34-140-203-9557 | ongside of the quickly special requests. 9777.09 | Supplier#000095607 | ARGENTINA | 770599 | Manufacturer#2 | YwSRcY6GHstMGHnHw4rn | 11-529-496-9692 | ent theodolites above the daring, regular packages wake furiously after the carefully ironic 9776.74 | Supplier#000074919 | ARGENTINA | 624906 | Manufacturer#5 | XGWyJtNcDnRakRYwBGF2Gv9wm50rtkr4JtVO,8 | 11-825-307-8254 | platelets integrate furiously. slyly (100 rows) COMMIT; COMMIT