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 = 2 and p_type like '%NICKEL' 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.55 | Supplier#000071147 | PERU | 1071146 | Manufacturer#5 | UzOIXI3k,wwrlHizjCKTtYYVv 5iARkq | 27-163-345-7998 | ke at the slyly regular packages. stealthy requests serve. blithely regular accounts acro 9996.34 | Supplier#000076971 | PERU | 626958 | Manufacturer#2 | cRtt6ZfY8 lBEcHTDd0JVx | 27-649-362-5733 | ndencies. packages are about the furiously bold dependencies. final, fina 9996.34 | Supplier#000076971 | PERU | 1401928 | Manufacturer#3 | cRtt6ZfY8 lBEcHTDd0JVx | 27-649-362-5733 | ndencies. packages are about the furiously bold dependencies. final, fina 9994.95 | Supplier#000036836 | BRAZIL | 1286811 | Manufacturer#3 | HJF6WNqa,jTyW8LiX0dU2dmN8YmR tg | 12-420-313-3017 | eful, special instructions. ironic, blithe theodolites nag quickly pending requests. quiet, even ac 9994.83 | Supplier#000052301 | CANADA | 1252300 | Manufacturer#1 | tEE5cTg1Xv3tOKaAhfMfCDfybQFISdtt8V | 13-437-784-3548 | re always instructions. ideas must have to detec 9994.83 | Supplier#000052301 | CANADA | 1627284 | Manufacturer#2 | tEE5cTg1Xv3tOKaAhfMfCDfybQFISdtt8V | 13-437-784-3548 | re always instructions. ideas must have to detec 9993.93 | Supplier#000097117 | BRAZIL | 1772099 | Manufacturer#3 | xnJNle1uJWuSfdDbOH1KACKrCaO1RBcguiR | 12-331-393-6337 | ss the special deposits. pinto beans along the even requests cajo 9993.77 | Supplier#000041194 | ARGENTINA | 716186 | Manufacturer#5 | V,BYX8iocnS | 11-135-288-1964 | regular deposits. fluffily ironic deposits cajole. furiously ironic requests are carefully 9993.25 | Supplier#000044614 | PERU | 819605 | Manufacturer#3 | ccerhM3xG37YxRoYDQeoBpkDww6a5XaNJvJcXP | 27-432-652-3792 | the carefully regular epitaphs. carefully ironic pinto beans sleep quickly atop the bold theodo 9990.87 | Supplier#000035958 | UNITED STATES | 1835957 | Manufacturer#5 | Lf7T,I2SRDE4 LuOBYgzQskyWRlsD | 34-984-820-5775 | ts believe against the pending i 9989.47 | Supplier#000078905 | UNITED STATES | 878904 | Manufacturer#3 | bo LpYu4xxlzpwOb6cm1bNB2 | 34-205-955-4242 | poach sometimes against the re 9989.46 | Supplier#000037658 | UNITED STATES | 987639 | Manufacturer#1 | SEh9v7C6WXZo855C5hu6sbkpRni72No | 34-919-304-8360 | the instructions are furiously even requests. 9987.04 | Supplier#000015601 | PERU | 665588 | Manufacturer#4 | 2UvlYtOSEoYOCYrgeWxjeIn7NLnx | 27-993-727-8949 | ronic platelets. final asymptotes affix. silent packages ca 9987.04 | Supplier#000015601 | PERU | 990591 | Manufacturer#3 | 2UvlYtOSEoYOCYrgeWxjeIn7NLnx | 27-993-727-8949 | ronic platelets. final asymptotes affix. silent packages ca 9984.2 | Supplier#000002331 | CANADA | 652318 | Manufacturer#4 | WRh2w5WFvRg7Z0S1AvSvHCL | 13-753-341-2617 | the final theodolites. quickly even de 9984.2 | Supplier#000002331 | CANADA | 1127297 | Manufacturer#2 | WRh2w5WFvRg7Z0S1AvSvHCL | 13-753-341-2617 | the final theodolites. quickly even de 9983.46 | Supplier#000032463 | CANADA | 1057432 | Manufacturer#1 | I9yi4Wdw6vu | 13-749-630-9030 | hely ironic packages wake blithely. furiously bold theodolites haggle above the slyly final foxes 9982.51 | Supplier#000017576 | ARGENTINA | 1992556 | Manufacturer#1 | CuKHjAQbDa3qxXZG7,D7AUQnstqybUHCgV4B | 11-152-450-4535 | sleep slyly above the special, special pinto beans-- final accounts 9981.67 | Supplier#000062678 | CANADA | 812661 | Manufacturer#3 | bp0JRn1gEGhlkJtKpptJFxPUEhKMgfo | 13-177-391-2348 | ers. slyly even accounts wake blithely. furiously even ac 9966.64 | Supplier#000022877 | PERU | 897868 | Manufacturer#2 | O0Mg bo7SJzdsNbeSCeGDfj6dEADCMvk | 27-913-724-2629 | p carefully regular foxes. furiously regula 9964.95 | Supplier#000050887 | UNITED STATES | 1625870 | Manufacturer#5 | TxMfdIdOnEINgaEhlL,5nHuIEjuinBHnfPIdWiLM | 34-192-506-6272 | nag even, special packages. careful 9959.67 | Supplier#000085329 | UNITED STATES | 460324 | Manufacturer#5 | x4nGOypwS,aHet9U2F | 34-889-863-5113 | g the theodolites. unusual foxes detect blithely furiously final packages. slyly pen 9957.74 | Supplier#000014310 | ARGENTINA | 189308 | Manufacturer#5 | Qi7TWRjx3dpxwwnbpvXpl68 | 11-342-931-8479 | lly. unusual, express requests haggle. 9956.17 | Supplier#000047022 | CANADA | 222019 | Manufacturer#2 | KKs59GGS,QHk | 13-242-301-2776 | le blithely over the furiously express requests: excuses boost. caref 9955.15 | Supplier#000039730 | CANADA | 189727 | Manufacturer#5 | dhNXUet1Q96lsh35uABpZwVUz90CQY4Sl | 13-174-394-7431 | ly even dinos are furiously fluffily even requ 9954.99 | Supplier#000050830 | CANADA | 950829 | Manufacturer#3 | 1oQ8iygPTdCBtz3Mf4Ol,N4wlVzAbqt | 13-121-628-3805 | nding theodolites. carefully express inst 9954.99 | Supplier#000050830 | CANADA | 1125818 | Manufacturer#4 | 1oQ8iygPTdCBtz3Mf4Ol,N4wlVzAbqt | 13-121-628-3805 | nding theodolites. carefully express inst 9954.63 | Supplier#000040621 | CANADA | 1140620 | Manufacturer#1 | FQNUNKdDlCLWGOwYRkmAwmF,9IZTaIOPpU6X | 13-232-692-5960 | packages. carefully final dolphins against the 9950.4 | Supplier#000096761 | UNITED STATES | 1896760 | Manufacturer#4 | OdBpL5HL2iMR50jzxK1YX gCkgHgN | 34-278-142-3655 | . even packages engage across the furiously even foxes 9947.62 | Supplier#000059045 | ARGENTINA | 1609012 | Manufacturer#5 | hdi5zKHmL0UDWoqA3Jl9qUGMB7CKZ1 | 11-984-172-1001 | xpress, ironic foxes around the accounts wake slyly according to the ironic accounts 9946.62 | Supplier#000026894 | BRAZIL | 851869 | Manufacturer#1 | zsuYhA9n6CathESYr,BSZu5twMC4b | 12-208-934-3709 | quickly. blithely silent ideas hinder slyly. ironic 9944.37 | Supplier#000010860 | PERU | 535844 | Manufacturer#5 | MXAMvLAS oo | 27-713-326-9083 | bold accounts. express, bold instructions are bli 9941.92 | Supplier#000086114 | UNITED STATES | 236109 | Manufacturer#2 | 6t7MBUuDsHDy7bjrqkEcOWyKRNS2,,t | 34-891-935-5945 | l dependencies cajole at the fluffily even pinto b 9936.39 | Supplier#000048167 | PERU | 198164 | Manufacturer#5 | BzGk6QpeVwxIvsq4D | 27-275-437-9728 | s haggle. blithely ironic 9936.39 | Supplier#000048167 | PERU | 1823148 | Manufacturer#5 | BzGk6QpeVwxIvsq4D | 27-275-437-9728 | s haggle. blithely ironic 9935.88 | Supplier#000029533 | CANADA | 1904513 | Manufacturer#1 | YvAD4oiDfZ2pMsVydy | 13-860-998-5191 | to beans sleep blithely among the packages; blithely regular accounts affix. silent ideas 9932.72 | Supplier#000008833 | BRAZIL | 1058812 | Manufacturer#1 | ERwMW1YFF73uW | 12-292-851-6826 | silent packages cajole pending pinto beans. unusual, regular platelets cajole blithely care 9931.84 | Supplier#000047696 | CANADA | 1172662 | Manufacturer#3 | q3yAz BGhl,sohmNeyHJZ8nhMAOOj6U,E | 13-510-308-4082 | y slow packages-- quickly bold deposits haggle quic 9931.84 | Supplier#000047696 | CANADA | 1597665 | Manufacturer#1 | q3yAz BGhl,sohmNeyHJZ8nhMAOOj6U,E | 13-510-308-4082 | y slow packages-- quickly bold deposits haggle quic 9931.84 | Supplier#000047696 | CANADA | 1847695 | Manufacturer#1 | q3yAz BGhl,sohmNeyHJZ8nhMAOOj6U,E | 13-510-308-4082 | y slow packages-- quickly bold deposits haggle quic 9928.55 | Supplier#000035413 | CANADA | 1935412 | Manufacturer#4 | w87qbjs57RjI9BZqik,kjeF | 13-476-871-5150 | etect blithely. slyly unusual requests mold qu 9928.04 | Supplier#000084044 | ARGENTINA | 884043 | Manufacturer#2 | 1CWccmd1VnaVlj5Gvpuqe8bU WsqpyedwM,5nK0 | 11-730-404-1953 | the slyly regular foxes. blithely regular packages wake. sl 9926.57 | Supplier#000017817 | UNITED STATES | 1792799 | Manufacturer#4 | XBkbJIJVgvZ WJ | 34-183-673-3948 | efully bold deposits. final notornis nag. slyly express platelets among the ironic warhorses 9919.2 | Supplier#000032764 | ARGENTINA | 1507748 | Manufacturer#4 | rlHCrxnFGkg243mouCoZkI | 11-460-618-5311 | bold waters! carefully unusual instructions according to the boldly special depo 9918.27 | Supplier#000099441 | PERU | 424428 | Manufacturer#4 | ,hPBeodx0uvl06cWVbxdxdvzexcnkNKEouh4 | 27-860-110-9649 | l foxes haggle fluffily according to the pending, unusual requests. pending deposits use carefull 9914.09 | Supplier#000042992 | BRAZIL | 1467949 | Manufacturer#2 | kTc49cokiJGfpAcJWw8Lvcy0cfRVjw | 12-380-641-2845 | sits according to the express ideas 9906.28 | Supplier#000068707 | PERU | 793685 | Manufacturer#4 | lUc43vUum4x18cHuo5f lQre | 27-176-762-6388 | egular dependencies haggle alongside of the carefully ironic packages 9903.86 | Supplier#000019730 | BRAZIL | 19729 | Manufacturer#4 | yu96t7GKyU2Jxlji | 12-378-687-6860 | slyly final foxes maintain fluffily court 9902.11 | Supplier#000029640 | CANADA | 54639 | Manufacturer#5 | 4mjz11M2ItgSkMvE8TtihBx0 X07S5jl5jb | 13-706-632-3658 | ly pending requests. platelets along the unusual ideas are furiously even dependenc 9901.92 | Supplier#000038016 | CANADA | 188013 | Manufacturer#5 | 9R0CMFk7fXTp1cA8a | 13-482-992-4457 | uickly pending requests are carefully. dependencies use. slyly regular packages around t 9897.88 | Supplier#000067602 | BRAZIL | 1442587 | Manufacturer#3 | EWaamaRNX8S7Dclqx XB9XYqHlSW,tLyW | 12-675-340-3599 | iously ironic foxes. special pinto beans maintain blithely express pinto beans 9894.3 | Supplier#000083171 | ARGENTINA | 258168 | Manufacturer#2 | mtj,PxyXesKZaXoxovCxv0s | 11-880-431-2342 | ly even accounts. blithely final instru 9894.3 | Supplier#000083171 | ARGENTINA | 1208134 | Manufacturer#5 | mtj,PxyXesKZaXoxovCxv0s | 11-880-431-2342 | ly even accounts. blithely final instru 9894.04 | Supplier#000021054 | BRAZIL | 1446011 | Manufacturer#1 | SN llHJ Mk9cv B1oFVSKq6eee3 | 12-179-107-6781 | along the deposits haggle 9894.04 | Supplier#000021054 | BRAZIL | 1971015 | Manufacturer#5 | SN llHJ Mk9cv B1oFVSKq6eee3 | 12-179-107-6781 | along the deposits haggle 9892.39 | Supplier#000095266 | BRAZIL | 1520220 | Manufacturer#2 | a0YL8NgNzK | 12-606-558-5332 | ove the furiously unusual packages. slyly bold pinto beans sleep furiously 9888.88 | Supplier#000048900 | ARGENTINA | 223897 | Manufacturer#2 | QXeg5u646Fm3ZuuF1vUmZ D2iwS2JMVjVN | 11-162-494-3254 | ncies. furiously ironic instructions use alongside of the deposits; quickly even foxes 9888.83 | Supplier#000048717 | BRAZIL | 1173683 | Manufacturer#5 | MXt5jJb,W0Frsd9c2xAElK4 | 12-991-466-8612 | ts after the slyly even accounts wake 9887.43 | Supplier#000071961 | BRAZIL | 1871960 | Manufacturer#4 | OyWa46hMq4Td0 | 12-679-125-8634 | to beans are. quickly unusual packages are slyly. blithely final accounts impress. blithely fi 9884.97 | Supplier#000090078 | BRAZIL | 565072 | Manufacturer#5 | lARq6GS2PQ0ACtRsfA4snTSfSMaKrEhoM,N | 12-386-407-5412 | o beans use. deposits cajole furiously about the packages. fluffily special accounts after 9884.97 | Supplier#000090078 | BRAZIL | 1165066 | Manufacturer#2 | lARq6GS2PQ0ACtRsfA4snTSfSMaKrEhoM,N | 12-386-407-5412 | o beans use. deposits cajole furiously about the packages. fluffily special accounts after 9884.05 | Supplier#000028600 | ARGENTINA | 1753548 | Manufacturer#2 | ziDEaAPqjV hzD105 | 11-208-404-1314 | final accounts cajole furiously. slyly ironic ideas above the slow patt 9882.69 | Supplier#000016645 | ARGENTINA | 1391631 | Manufacturer#4 | IMtGc9SAoFRHLZvWjdCqYqCoJKxko2f, R0 | 11-195-261-7722 | dencies would cajole. slyly even theodolites detect according to the carefully regular de 9882.69 | Supplier#000016645 | ARGENTINA | 1441602 | Manufacturer#1 | IMtGc9SAoFRHLZvWjdCqYqCoJKxko2f, R0 | 11-195-261-7722 | dencies would cajole. slyly even theodolites detect according to the carefully regular de 9879.23 | Supplier#000041120 | PERU | 1491091 | Manufacturer#4 | HjQ78cl301MYHFPkPd6VNwymRo | 27-752-249-5407 | eas print alongside of the even ideas. slyly ironic forges na 9877.07 | Supplier#000075946 | UNITED STATES | 200939 | Manufacturer#5 | HEh80urmjYLt7C 4Lkpsp | 34-472-745-1260 | press theodolites. accounts sleep. furious, brave deposits wake. furiously regular 9877.06 | Supplier#000094445 | PERU | 244440 | Manufacturer#5 | SeidVE1XJRGvglwfkHuJdbQ7ZMWetVwQLXiN | 27-701-846-7537 | cajole blithely. regular, bol 9872.94 | Supplier#000033170 | UNITED STATES | 708162 | Manufacturer#1 | HroMgDrb7ogg0b5MtCKcq2R HHeKF,9 | 34-220-732-9869 | nusual ideas are carefully blithely ironic accounts. express i 9869.88 | Supplier#000027525 | BRAZIL | 1977486 | Manufacturer#3 | ic2VRlTBl2,gelTG0eldYLei | 12-872-282-5117 | ly atop the fluffily unusual courts. fluff 9869.77 | Supplier#000040712 | BRAZIL | 1665663 | Manufacturer#1 | kav,22dbgJxw8JpiDfXx0eoHj773cGhh | 12-670-682-1819 | integrate blithely. never ironic packages along the ironic 9865.54 | Supplier#000006750 | BRAZIL | 281747 | Manufacturer#1 | nYQx9ZK0xmoFMbSf | 12-128-392-9206 | ans. even forges cajole carefully ironic dep 9861.67 | Supplier#000091630 | PERU | 1191629 | Manufacturer#4 | FjoaUAHhQkHceVNFozB | 27-256-681-2466 | cial dependencies doubt slyly according to the dolphins. blithely final accounts unwind 9861.36 | Supplier#000019597 | PERU | 194595 | Manufacturer#3 | 7uENaOfuDV5f6 | 27-172-151-5967 | theodolites sleep carefully at the quickly regular ideas. unusual p 9858.75 | Supplier#000099917 | BRAZIL | 549906 | Manufacturer#4 | 0gvYP3mwp,CHYX2e | 12-928-418-1965 | counts cajole quickly regular foxes. bold accounts haggle carefully around the ironic pa 9856.01 | Supplier#000040367 | CANADA | 390360 | Manufacturer#4 | 1avBjyMY,vMinSmuI,5A6FXt9vqe nEH95 | 13-653-551-8341 | sly regular dependencies wake blithely after the r 9855.71 | Supplier#000048410 | CANADA | 23409 | Manufacturer#1 | htvxsAiYbvfKocY53qP,Hlu rN7er76 ppYlul8p | 13-781-458-3487 | to beans. stealthily final packages doubt along 9855.71 | Supplier#000048410 | CANADA | 1348409 | Manufacturer#2 | htvxsAiYbvfKocY53qP,Hlu rN7er76 ppYlul8p | 13-781-458-3487 | to beans. stealthily final packages doubt along 9854.14 | Supplier#000058453 | UNITED STATES | 133451 | Manufacturer#3 | tq2dsfHKPzmt8oL4pflhp | 34-976-558-1196 | ies. ironic dependencies above the pack 9848.15 | Supplier#000061793 | BRAZIL | 136791 | Manufacturer#3 | 4Zot05ag8B,M5b1dj5r7z3NcpKc0IGItd | 12-477-729-1485 | al instructions are slyly 9846.08 | Supplier#000046083 | ARGENTINA | 446082 | Manufacturer#1 | v469PAg3p0LuNBNuLBiDEA10J4d3x8CzpgvBjlC | 11-993-757-6987 | eep slyly. carefully final requests wake blithely regular ideas. furiously p 9837.98 | Supplier#000085780 | UNITED STATES | 1560764 | Manufacturer#1 | tiTmmgDPniRwNYICscsYeYF8S3iL868rh, anCTz | 34-654-401-7507 | xes. furiously final packa 9828.44 | Supplier#000017169 | PERU | 792161 | Manufacturer#3 | f4aT8LaqrjPCWP2 | 27-369-730-1411 | ar, pending requests after the slyly ironic accounts 9823.99 | Supplier#000099791 | ARGENTINA | 249786 | Manufacturer#1 | f0JFkX6XmuzM03qugi0dGdxV5Ks9Da | 11-721-736-4408 | nts about the ironic accounts are quickly between the blithely ironic decoys. pending, fi 9823.88 | Supplier#000040005 | UNITED STATES | 15004 | Manufacturer#5 | W3FIPPzG02eF5K0sYdSddt,N | 34-993-730-2019 | are slyly. regular accounts doubt bl 9823.54 | Supplier#000055917 | CANADA | 5916 | Manufacturer#5 | hcr R1MMwnzFYHw8dKQ,gH | 13-692-259-4588 | foxes. final, regular fret 9823.54 | Supplier#000055917 | CANADA | 30916 | Manufacturer#2 | hcr R1MMwnzFYHw8dKQ,gH | 13-692-259-4588 | foxes. final, regular fret 9823.21 | Supplier#000004851 | CANADA | 1154828 | Manufacturer#2 | Rj,x6IgLT7kBL99nqp | 13-913-167-7389 | final deposits integrate slyly quickly ironic deposits. deposits hinder quickly 9822.37 | Supplier#000063103 | UNITED STATES | 338099 | Manufacturer#4 | 6g5r9HC30CywFR,8Y2lHek,VaEWk99trTnLkUJzf | 34-664-526-3230 | aggle quickly. slyly bold deposits promise. sl 9819.15 | Supplier#000096297 | CANADA | 1321257 | Manufacturer#4 | NvnFS4Ko0nmKIvBN2E iiWnmk7ndA,rJK | 13-876-736-7069 | fluffily ironic accounts sleep quickly abou 9817.53 | Supplier#000005510 | UNITED STATES | 480505 | Manufacturer#4 | f 0PMKZD0h | 34-332-810-7526 | warhorses. furiously regular packages boost above the quickly unusual acco 9817.47 | Supplier#000055742 | PERU | 605729 | Manufacturer#2 | uAk 6aLSpHBB40Z | 27-366-524-7077 | ons. final gifts cajole carefully pending, spec 9817.47 | Supplier#000055742 | PERU | 705727 | Manufacturer#1 | uAk 6aLSpHBB40Z | 27-366-524-7077 | ons. final gifts cajole carefully pending, spec 9817.47 | Supplier#000055742 | PERU | 905723 | Manufacturer#1 | uAk 6aLSpHBB40Z | 27-366-524-7077 | ons. final gifts cajole carefully pending, spec 9816.88 | Supplier#000037376 | ARGENTINA | 437375 | Manufacturer#5 | WnLOLOCp CFcv48SRNsiM4xK7tHDmfA | 11-446-910-3895 | pending ideas are. quickly ironic excuses cajole a 9816.09 | Supplier#000065952 | BRAZIL | 390942 | Manufacturer#1 | 5YGOFA0PrG471SkDfy4Xl9QXaFUwDHTs4o3tRRTA | 12-806-962-1292 | ce the bold deposits. busy, spec 9807.39 | Supplier#000067891 | PERU | 567890 | Manufacturer#3 | RVLQ c3H1zT8Tmgp8xL | 27-507-607-9957 | usly ironic requests sublate slyly sly packages. slyly regular requests be 9806.83 | Supplier#000020603 | CANADA | 145599 | Manufacturer#2 | 03oUnrvTpssy22hq3uDJWUdH52VxSuYrbE8 | 13-333-408-4005 | as eat blithely quickly silent fo 9801.7 | Supplier#000068262 | ARGENTINA | 1593216 | Manufacturer#1 | hIQs12b0sXWNgMtrqEMOofp | 11-694-655-1951 | pending accounts; ironically spec 9799.46 | Supplier#000063556 | UNITED STATES | 938546 | Manufacturer#2 | OjTrCp0kwacPJAG9e8E1 tS | 34-656-433-6457 | blithely even requests. final 9796.32 | Supplier#000011064 | ARGENTINA | 911063 | Manufacturer#5 | i,,2sV20NnRVUEbe | 11-230-949-2847 | sleep carefully furiously regular deposits. furiously silent (100 rows) COMMIT; COMMIT