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 = 19 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 -----------+---------------------------+---------------------------+-----------+---------------------------+------------------------------------------+-----------------+------------------------------------------------------------------------------------------------------ 9996.34 | Supplier#000076971 | PERU | 1151959 | Manufacturer#5 | cRtt6ZfY8 lBEcHTDd0JVx | 27-649-362-5733 | ndencies. packages are about the furiously bold dependencies. final, fina 9993.25 | Supplier#000044614 | PERU | 719606 | Manufacturer#5 | ccerhM3xG37YxRoYDQeoBpkDww6a5XaNJvJcXP | 27-432-652-3792 | the carefully regular epitaphs. carefully ironic pinto beans sleep quickly atop the bold theodo 9993.11 | Supplier#000048114 | CANADA | 1173080 | Manufacturer#3 | GviL7PxU8q1htWmn9u2oKxDV | 13-761-118-8413 | quickly unusual ideas. regular requests 9989.47 | Supplier#000078905 | UNITED STATES | 353901 | Manufacturer#2 | bo LpYu4xxlzpwOb6cm1bNB2 | 34-205-955-4242 | poach sometimes against the re 9989.47 | Supplier#000078905 | UNITED STATES | 1853886 | Manufacturer#4 | bo LpYu4xxlzpwOb6cm1bNB2 | 34-205-955-4242 | poach sometimes against the re 9984.78 | Supplier#000066482 | CANADA | 1916443 | Manufacturer#1 | S37cy4w3iqLE | 13-662-729-6570 | lose ideas around the final, pending requests thrash instead of the blit 9981.67 | Supplier#000062678 | CANADA | 837669 | Manufacturer#5 | bp0JRn1gEGhlkJtKpptJFxPUEhKMgfo | 13-177-391-2348 | ers. slyly even accounts wake blithely. furiously even ac 9980.74 | Supplier#000099272 | BRAZIL | 999271 | Manufacturer#5 | Inuon6nxfsjvR1LPl | 12-154-201-7725 | t carefully blithely final deposits. idly final pinto b 9975.1 | Supplier#000072118 | PERU | 172117 | Manufacturer#2 | a4skJxR4mUu68kknjnrMQrq49j7ZUA3 | 27-768-646-5732 | idle theodolites. slyly unusual accounts affix slyly above the furiously express ideas. f 9971.6 | Supplier#000041975 | BRAZIL | 141974 | Manufacturer#2 | s6WAPGbn3jHERXnFfXOI,QLhzbQIMdn | 12-894-926-2782 | s. hockey players along the bold deposits eat silently fluffi 9969.88 | Supplier#000068471 | ARGENTINA | 618458 | Manufacturer#5 | CJv4cfp7DL | 11-207-990-1153 | c, final realms sleep carefully. special, even accounts are carefully agains 9967.59 | Supplier#000018870 | PERU | 418869 | Manufacturer#1 | hwB04ilx,UFt | 27-404-186-6388 | y pending packages. deposits haggle b 9966.66 | Supplier#000090941 | ARGENTINA | 465936 | Manufacturer#5 | rk97okEewX1X2BObhudcaNG7BICYVGXI2c9POE | 11-433-145-1954 | usly sly theodolites against the carefully pend 9964.23 | Supplier#000079103 | CANADA | 4102 | Manufacturer#4 | 4BCifx0Wryaq1AiVqVkTCAK | 13-140-810-9525 | ously. quickly bold asymptotes cajole quickly fluffily bold asymptotes. fox 9961.16 | Supplier#000066536 | PERU | 741528 | Manufacturer#1 | ngShViXD5EZGI28 | 27-704-250-5277 | beans cajole carefully. even packages wake blithely slyly final asymptotes. exp 9959.38 | Supplier#000067942 | UNITED STATES | 992914 | Manufacturer#3 | OV3q1nz1WynMGkVo3KNdDHty6w6L 4i0Sj | 34-377-267-9892 | xpress deposits. quickly ironic dugouts sleep blithely. regularly final requests alo 9957 | Supplier#000000234 | UNITED STATES | 850217 | Manufacturer#5 | iMrk7HUD87at3IIh4rBi | 34-187-193-2209 | nag furiously pending dependencies. unusual deposits integrate fur 9953.38 | Supplier#000008442 | BRAZIL | 258437 | Manufacturer#1 | So5,Vf93wcvoHpP7thm7KxK1F g3DKmXMKZR | 12-926-257-2326 | ains cajole furiously special deposits. quietly ironic foxes slee 9953.38 | Supplier#000008442 | BRAZIL | 833417 | Manufacturer#4 | So5,Vf93wcvoHpP7thm7KxK1F g3DKmXMKZR | 12-926-257-2326 | ains cajole furiously special deposits. quietly ironic foxes slee 9952.9 | Supplier#000051720 | PERU | 201715 | Manufacturer#4 | zmyFF lez8cKZ9qoCmVNuMW8VhMW80m 48FywzC | 27-785-509-6468 | ending dolphins boost slyly regular, regul 9952.19 | Supplier#000021234 | UNITED STATES | 896225 | Manufacturer#4 | uTp8g5HV4fHLbgkMlr0BfZI | 34-875-257-9915 | slyly bold accounts cajole fluffily instructions. expr 9947.62 | Supplier#000059045 | ARGENTINA | 859044 | Manufacturer#1 | hdi5zKHmL0UDWoqA3Jl9qUGMB7CKZ1 | 11-984-172-1001 | xpress, ironic foxes around the accounts wake slyly according to the ironic accounts 9947.62 | Supplier#000059045 | ARGENTINA | 1934025 | Manufacturer#4 | hdi5zKHmL0UDWoqA3Jl9qUGMB7CKZ1 | 11-984-172-1001 | xpress, ironic foxes around the accounts wake slyly according to the ironic accounts 9947.25 | Supplier#000051552 | BRAZIL | 1476509 | Manufacturer#2 | 7T0RytVdwmz0LABVKs | 12-185-140-2361 | bout the silent, bold excuses. carefully 9944.37 | Supplier#000010860 | PERU | 1135826 | Manufacturer#1 | MXAMvLAS oo | 27-713-326-9083 | bold accounts. express, bold instructions are bli 9940.75 | Supplier#000057959 | CANADA | 707944 | Manufacturer#3 | 3rnf15LYfF81q | 13-700-281-7343 | usly along the furiously silent reques 9938.1 | Supplier#000083357 | ARGENTINA | 583356 | Manufacturer#3 | 7wb6iOHpRkgE,mqyrDzcckkexToZTR94 | 11-501-299-4731 | silent dinos across the blithely pending ideas will have to wake carefully across the furiousl 9935.3 | Supplier#000036589 | PERU | 1936588 | Manufacturer#2 | xk3tq6p,i3PRi5L2MSqZ,0IF2 | 27-141-194-4187 | ld frets. carefully bold requests sleep carefully silent pinto beans. 9932.72 | Supplier#000008833 | BRAZIL | 1708832 | Manufacturer#1 | ERwMW1YFF73uW | 12-292-851-6826 | silent packages cajole pending pinto beans. unusual, regular platelets cajole blithely care 9930.22 | Supplier#000087804 | BRAZIL | 487803 | Manufacturer#4 | yCMclCR0Vd0l3RYiGYzYGWJpKSOQOej82TfS | 12-484-756-8982 | foxes boost around the sly pinto 9923.4 | Supplier#000058097 | ARGENTINA | 683078 | Manufacturer#2 | aIF4uckQFrNg7ndAi6PLqjTv1kdHVq7OqKFF | 11-366-468-1405 | onic pinto beans after the carefully pending grouches wake express platelets. quickly even foxes 9923.4 | Supplier#000058097 | ARGENTINA | 858096 | Manufacturer#4 | aIF4uckQFrNg7ndAi6PLqjTv1kdHVq7OqKFF | 11-366-468-1405 | onic pinto beans after the carefully pending grouches wake express platelets. quickly even foxes 9920.18 | Supplier#000070909 | CANADA | 395899 | Manufacturer#1 | p9nPJ,wyFTmM3e | 13-303-587-1177 | fluffily ironic requests. 9919.2 | Supplier#000032764 | ARGENTINA | 507758 | Manufacturer#5 | rlHCrxnFGkg243mouCoZkI | 11-460-618-5311 | bold waters! carefully unusual instructions according to the boldly special depo 9919 | Supplier#000039578 | PERU | 1439577 | Manufacturer#3 | UBRvsVUtYLccfTtkt8tre 8o,YjtMqOGx8NE1P | 27-479-198-8486 | cial requests. accounts are furiously carefully idle dolphins. asymptotes haggle aga 9918.01 | Supplier#000038247 | PERU | 1763195 | Manufacturer#4 | Ry22MdPbFeIsT4D3UR3qHMW3GSJP6mAnX | 27-491-787-2475 | e blithely. regular foxes use carefully above 9916.92 | Supplier#000068336 | ARGENTINA | 1593290 | Manufacturer#3 | JEaUCAYgslfDp | 11-511-395-1475 | instructions. pending packages are. final, regular Tiresias cajol 9912.79 | Supplier#000048773 | UNITED STATES | 548772 | Manufacturer#4 | BAPuzmwU3OTms | 34-954-369-3706 | losely furiously pending orbits. instructions sleep 9908.7 | Supplier#000067544 | PERU | 1592498 | Manufacturer#5 | KJILJilbUVcs,eYEd3R | 27-764-167-7772 | es sleep furiously silent dinos. fluffily pending requests alongside of the ironic, iron 9906.28 | Supplier#000068707 | PERU | 1593661 | Manufacturer#3 | lUc43vUum4x18cHuo5f lQre | 27-176-762-6388 | egular dependencies haggle alongside of the carefully ironic packages 9902.11 | Supplier#000029640 | CANADA | 729639 | Manufacturer#5 | 4mjz11M2ItgSkMvE8TtihBx0 X07S5jl5jb | 13-706-632-3658 | ly pending requests. platelets along the unusual ideas are furiously even dependenc 9902.11 | Supplier#000029640 | CANADA | 1779605 | Manufacturer#3 | 4mjz11M2ItgSkMvE8TtihBx0 X07S5jl5jb | 13-706-632-3658 | ly pending requests. platelets along the unusual ideas are furiously even dependenc 9902.11 | Supplier#000029640 | CANADA | 1904620 | Manufacturer#4 | 4mjz11M2ItgSkMvE8TtihBx0 X07S5jl5jb | 13-706-632-3658 | ly pending requests. platelets along the unusual ideas are furiously even dependenc 9901.92 | Supplier#000038016 | CANADA | 338015 | Manufacturer#1 | 9R0CMFk7fXTp1cA8a | 13-482-992-4457 | uickly pending requests are carefully. dependencies use. slyly regular packages around t 9900.08 | Supplier#000003941 | CANADA | 478936 | Manufacturer#4 | Pmb05mQfBMS618O7WKqZJ 9vyv | 13-668-659-3631 | ithely quickly bold accounts. bold pinto beans about the furious dependencies cajole qu 9899.65 | Supplier#000052109 | CANADA | 1202084 | Manufacturer#5 | 4d,02ZiWlh4TL6lsahdz04bmMEV4OQLc1gTn1 | 13-566-901-7567 | nent deposits. carefully special requests nag slyly special requests. requests accor 9898.37 | Supplier#000028538 | BRAZIL | 178535 | Manufacturer#3 | EKVeeAeM KSPF | 12-940-777-7761 | y regular platelets haggle carefully pending waters. theodolites haggle furiously 9897.88 | Supplier#000067602 | BRAZIL | 1067601 | Manufacturer#2 | EWaamaRNX8S7Dclqx XB9XYqHlSW,tLyW | 12-675-340-3599 | iously ironic foxes. special pinto beans maintain blithely express pinto beans 9895.97 | Supplier#000098935 | ARGENTINA | 973925 | Manufacturer#1 | LycMdd4TkNAilf8RXYvNeIP5Ef5ckT5jLLYaZvr | 11-207-135-5078 | es. carefully unusual packages cajole carefully bold orbits. deposits wake. q 9892.39 | Supplier#000095266 | BRAZIL | 1045245 | Manufacturer#1 | a0YL8NgNzK | 12-606-558-5332 | ove the furiously unusual packages. slyly bold pinto beans sleep furiously 9892.33 | Supplier#000027695 | UNITED STATES | 152691 | Manufacturer#3 | XHGp3X0yzd5AyUICrPCxtwY | 34-572-509-4919 | le instructions nag quickly-- final accounts above the ironic dolphins are carefully pending dep 9891.83 | Supplier#000057239 | PERU | 1282202 | Manufacturer#2 | lL3OmZ25vVbpcBSb3 0fUlUVsMzyDJfQt | 27-380-512-6878 | even requests. carefully furious foxes cajole. carefully bold deposits 9890.37 | Supplier#000095610 | ARGENTINA | 1495609 | Manufacturer#4 | M03Gi zVzBLegBxUwgL4UrE0tFao1l80jMsjE2Q | 11-700-164-6592 | ect regular requests. unusual foxes breach over t 9888.89 | Supplier#000096338 | ARGENTINA | 871329 | Manufacturer#3 | A9fPxDlrRshOa | 11-318-897-9174 | e ironic, regular packages. fluffily fluf 9888.02 | Supplier#000060316 | ARGENTINA | 1085285 | Manufacturer#3 | R5WdU0qWoS2xBoOmVGF1yC M | 11-715-977-7408 | ckages: furiously express excuses cajol 9887.18 | Supplier#000017765 | UNITED STATES | 1217764 | Manufacturer#2 | cc,JaKNlkUE3XBcgnsA5VNrWGbPk05GWe | 34-156-805-1624 | the carefully dogged platelets. carefully final accounts sleep slyly furiously slow deposits. bli 9886.31 | Supplier#000086775 | ARGENTINA | 1611726 | Manufacturer#5 | OSKwH7aAWb96ZqbDUXDnixYg34 | 11-615-808-6235 | fluffily express deposits nag quickly quickly fi 9885.58 | Supplier#000060595 | CANADA | 760594 | Manufacturer#2 | ltrDWyEL2RjbFQeJ5WmIOcqSuOtj1EXcQu | 13-981-305-5634 | nusual deposits. quickly regular sauternes cajole blithely regular pinto beans. carefully silent 9884.46 | Supplier#000094748 | PERU | 1094747 | Manufacturer#5 | wuuxYrwraygluYwMprDKi | 27-579-368-7335 | ges-- idle requests wake fluffily. carefully express deposits th 9884.05 | Supplier#000028600 | ARGENTINA | 303596 | Manufacturer#5 | ziDEaAPqjV hzD105 | 11-208-404-1314 | final accounts cajole furiously. slyly ironic ideas above the slow patt 9884.05 | Supplier#000028600 | ARGENTINA | 403595 | Manufacturer#3 | ziDEaAPqjV hzD105 | 11-208-404-1314 | final accounts cajole furiously. slyly ironic ideas above the slow patt 9883.14 | Supplier#000002473 | BRAZIL | 1827418 | Manufacturer#5 | VPqdi7aT,1MMyPIhiT | 12-215-170-2967 | pinto beans. furiously regular pint 9882.69 | Supplier#000016645 | ARGENTINA | 216644 | Manufacturer#2 | IMtGc9SAoFRHLZvWjdCqYqCoJKxko2f, R0 | 11-195-261-7722 | dencies would cajole. slyly even theodolites detect according to the carefully regular de 9879.57 | Supplier#000076138 | CANADA | 726123 | Manufacturer#4 | pmdlgstM Mu6ETKffxM3iIzf1eh6Fs2GikO | 13-407-520-9284 | y silently pending requests; slyly 9877.06 | Supplier#000094445 | PERU | 1119411 | Manufacturer#1 | SeidVE1XJRGvglwfkHuJdbQ7ZMWetVwQLXiN | 27-701-846-7537 | cajole blithely. regular, bol 9874.77 | Supplier#000080055 | PERU | 1805000 | Manufacturer#4 | NxfKw2eImmNpZX ,xzC8NQKz | 27-133-567-7867 | eodolites haggle slyly. fluffily f 9872.08 | Supplier#000008998 | PERU | 8997 | Manufacturer#5 | cTCn79ziEcQz66KkdD Gil,VvaDHdXli | 27-988-387-1160 | deposits. even, fluffy theodolites believe above the carefully regular instructions. foxes sleep. f 9868.15 | Supplier#000025864 | ARGENTINA | 400859 | Manufacturer#5 | 0dzQaXdEKPbI8MbzTcAkgm | 11-648-744-3905 | dolites sleep slyly-- ideas nag 9865.54 | Supplier#000006750 | BRAZIL | 1481735 | Manufacturer#2 | nYQx9ZK0xmoFMbSf | 12-128-392-9206 | ans. even forges cajole carefully ironic dep 9861.67 | Supplier#000091630 | PERU | 566624 | Manufacturer#2 | FjoaUAHhQkHceVNFozB | 27-256-681-2466 | cial dependencies doubt slyly according to the dolphins. blithely final accounts unwind 9859.2 | Supplier#000077781 | PERU | 902753 | Manufacturer#1 | mqYkqPRdbRyYPzWCyaEYXF6f51 | 27-672-780-4665 | the instructions. furiously regular requests sleep. 9857.68 | Supplier#000060235 | PERU | 1835216 | Manufacturer#1 | nSrLfKizATsAcn | 27-923-516-3267 | s haggle. ironic, even waters are fluffily 9857.03 | Supplier#000084110 | UNITED STATES | 1409067 | Manufacturer#5 | qMSxmMdeYoMJ, | 34-622-943-2069 | s. furiously final dependencies against the even sentiments are fluffily among the fur 9855.71 | Supplier#000048410 | CANADA | 1523394 | Manufacturer#3 | htvxsAiYbvfKocY53qP,Hlu rN7er76 ppYlul8p | 13-781-458-3487 | to beans. stealthily final packages doubt along 9855.7 | Supplier#000038050 | CANADA | 1163016 | Manufacturer#3 | BbudH ,QL5uf5OtP5uAhuW617oeE2 | 13-291-416-8064 | even, ironic accounts. fl 9849.41 | Supplier#000037517 | ARGENTINA | 1612500 | Manufacturer#3 | U6WAmOdd51H7uhZiLPXtPYK1gh0grW, | 11-810-498-5884 | iments sleep about the ironic asymptotes. unusual accounts wake quickly accor 9849.41 | Supplier#000037517 | ARGENTINA | 1712499 | Manufacturer#3 | U6WAmOdd51H7uhZiLPXtPYK1gh0grW, | 11-810-498-5884 | iments sleep about the ironic asymptotes. unusual accounts wake quickly accor 9846.08 | Supplier#000046083 | ARGENTINA | 821074 | Manufacturer#4 | v469PAg3p0LuNBNuLBiDEA10J4d3x8CzpgvBjlC | 11-993-757-6987 | eep slyly. carefully final requests wake blithely regular ideas. furiously p 9842.82 | Supplier#000087109 | BRAZIL | 1737074 | Manufacturer#3 | xdk9PvUBqVsL1txqamTdJ | 12-738-785-4575 | le quickly foxes. slyly express deposits again 9840.61 | Supplier#000032156 | ARGENTINA | 307152 | Manufacturer#3 | PvJ0C8qxNKk6h | 11-656-662-1711 | e furiously. final courts haggle. blithely pending excuses cajole always. 9840.61 | Supplier#000032156 | ARGENTINA | 457143 | Manufacturer#1 | PvJ0C8qxNKk6h | 11-656-662-1711 | e furiously. final courts haggle. blithely pending excuses cajole always. 9837.98 | Supplier#000085780 | UNITED STATES | 1010749 | Manufacturer#1 | tiTmmgDPniRwNYICscsYeYF8S3iL868rh, anCTz | 34-654-401-7507 | xes. furiously final packa 9837.26 | Supplier#000015876 | ARGENTINA | 1115875 | Manufacturer#2 | PKLY2b0ocECmiO | 11-905-564-6763 | pinto beans. quickly final packages wake slyly special deposits 9826.92 | Supplier#000013620 | PERU | 1938562 | Manufacturer#5 | 1aqQVJZUCvks | 27-541-425-9639 | nts detect fluffily blithely even ideas; furiously regular dependencies wake 9826.53 | Supplier#000003668 | PERU | 528652 | Manufacturer#1 | U7HrMSGbwuwLC | 27-539-572-9175 | . regular, regular warhorses wake carefully silent accounts. slyly unusual 9825.42 | Supplier#000044514 | PERU | 1219501 | Manufacturer#5 | NWMIe4v6koJZ3O6HH9qbDCN | 27-326-783-1681 | nal pinto beans. unusual, pending packages are slyly bold requests. fluffily ironic accounts pri 9824.74 | Supplier#000058907 | BRAZIL | 1958906 | Manufacturer#5 | 4p9z4bHgSE,bY,JxFlttgUe 3Msq | 12-354-499-6292 | ully special packages boost bl 9823.88 | Supplier#000040005 | UNITED STATES | 864980 | Manufacturer#3 | W3FIPPzG02eF5K0sYdSddt,N | 34-993-730-2019 | are slyly. regular accounts doubt bl 9822.37 | Supplier#000063644 | PERU | 163643 | Manufacturer#5 | Npw,qgafmrgx9CH,8VPsXcaga0 | 27-487-590-7763 | to beans haggle furiously regular, pending deposits. regular somas sleep blithely along the carefu 9822.37 | Supplier#000063644 | PERU | 1513613 | Manufacturer#3 | Npw,qgafmrgx9CH,8VPsXcaga0 | 27-487-590-7763 | to beans haggle furiously regular, pending deposits. regular somas sleep blithely along the carefu 9822.2 | Supplier#000015448 | UNITED STATES | 1590432 | Manufacturer#2 | jfvwHjrCG7KzIZe5C1JRIWVDLW6kcahZxP | 34-375-321-7835 | even asymptotes wake slyly along the slyly brave foxes. finally unusual dependencies 9821.11 | Supplier#000005987 | ARGENTINA | 1480972 | Manufacturer#5 | TzZR8IiWBt tEspR9hcNACKHOk | 11-688-883-4586 | kly ironic packages alongside of the packages are quickly bold deposits 9815.05 | Supplier#000043767 | BRAZIL | 193764 | Manufacturer#4 | r9iXXcbD1WPJftD6BbeoLsY6P A6OfLFJ6QB9q9 | 12-566-739-4060 | ld excuses affix slyly above the 9814.17 | Supplier#000032850 | UNITED STATES | 482841 | Manufacturer#5 | xjbvrdPLhosLrFwu5avC | 34-683-330-1497 | ess deposits wake furiously 9813.79 | Supplier#000057162 | UNITED STATES | 32161 | Manufacturer#5 | hNbYQtRVxmB LAA,0pRu5peztoEqodNQ | 34-968-694-1830 | ets wake among the quickly regular cou 9811.33 | Supplier#000039569 | PERU | 514563 | Manufacturer#4 | d5rPms4NOw5lFxZJd3OUku7hd7JC1ay1 | 27-283-801-3052 | sts haggle furiously against the requests. evenly final 9811.15 | Supplier#000074333 | ARGENTINA | 1049322 | Manufacturer#1 | f0eB04xtCP6alTBQRaXizT07S6t1Ui7RY | 11-696-477-2522 | quests sleep blithely quickly final platelets-- quiet epitaphs affix slyly furiously even idea 9807.75 | Supplier#000084994 | PERU | 534983 | Manufacturer#1 | uJvoQwNzOOvoyWD | 27-120-900-6805 | inal deposits nod quickly. blithely b 9807.57 | Supplier#000081578 | BRAZIL | 881577 | Manufacturer#3 | vFOVz,QmlDz,Sx0PVcS,7FBxUH3VJCKyrgfmY | 12-185-293-5619 | egular packages alongside of the bold request 9807.57 | Supplier#000081578 | BRAZIL | 1681577 | Manufacturer#3 | vFOVz,QmlDz,Sx0PVcS,7FBxUH3VJCKyrgfmY | 12-185-293-5619 | egular packages alongside of the bold request (100 rows) COMMIT; COMMIT