1
0
mirror of https://github.com/mariadb-corporation/mariadb-columnstore-engine.git synced 2025-07-29 08:21:15 +03:00
Files
mariadb-columnstore-engine/mysql-test/columnstore/autopilot/r/mcs6891_outerjoin_devTestCases.result
Daniel Lee 4c9d6e39ac Dlee mtr restructure (#2494)
* Restructured test suites and added autopilot and extended suites

* Updated autopilot with correct branch - develop

* Moved setup test case to a 'setup' directory, for consistency

* Fixed a path issue

* Updated some tests cases to keep up with development

Co-authored-by: root <root@rocky8.localdomain>
2022-08-09 21:20:56 +03:00

1030 lines
44 KiB
Plaintext

USE outerjoin;
select count(*) from lineitem join supplier on s_suppkey = l_suppkey right join nation on s_nationkey = n_nationkey;
count(*)
6027
select l_orderkey, sum(l_extendedprice * (1-l_discount)) as revenue, o_orderdate, o_shippriority
from customer right join orders on c_custkey = o_custkey right join lineitem on l_orderkey = o_orderkey
where c_mktsegment = 'BUILDING' and
o_orderdate < date '1995-03-03' and
l_shipdate > date '1995-03-03'
group by l_orderkey, o_orderdate, o_shippriority
order by revenue desc, o_orderdate;
l_orderkey revenue o_orderdate o_shippriority
1637 164224.9253 1995-02-08 0
742 87980.7840 1994-12-23 0
2883 64345.2012 1995-01-23 0
3492 50611.5988 1994-11-24 0
5191 49378.3094 1994-12-11 0
3430 26678.9588 1994-12-12 0
998 11785.5486 1994-11-26 0
4423 4841.6481 1995-02-17 0
select n_name, sum(l_extendedprice * (1-l_discount)) as revenue
from customer left join orders on c_custkey = o_custkey left join lineitem on l_orderkey = o_orderkey join supplier on l_suppkey = s_suppkey join nation on s_nationkey = n_nationkey right join region on n_regionkey = r_regionkey
where c_nationkey = s_nationkey + 0 and
r_name = 'AFRICA' and
o_orderdate >= date '1997-01-01' and
o_orderdate < date '1997-01-01' + interval '1' year
group by n_name
order by revenue desc;
n_name revenue
MOROCCO 153293.6484
ETHIOPIA 129160.0743
select c_count, count(*) as custdist
from ( select c_custkey, count(o_orderkey) c_count
from customer left outer join orders on c_custkey = o_custkey
and o_comment not like '%special%requests%'
group by c_custkey ) c_orders
group by c_count
order by custdist desc, c_count desc;
c_count custdist
0 70
16 8
17 7
20 6
13 6
12 6
9 6
23 5
14 5
10 5
21 4
18 4
11 4
8 4
7 4
26 3
22 3
6 3
5 3
4 3
29 2
24 2
19 2
15 2
28 1
25 1
3 1
2 1
select supp_nation, cust_nation, l_year, sum(volume) as revenue
from
(select n1.n_name as supp_nation, n2.n_name as cust_nation,
date_format(o_orderdate,'%Y') as l_year, l_extendedprice * (1 - l_discount) as volume
from supplier join lineitem on s_suppkey = l_suppkey join orders on o_orderkey = l_orderkey join customer on c_custkey = o_custkey right join nation n1 on s_nationkey = n1.n_nationkey left join nation n2 on c_nationkey = n2.n_nationkey
where
l_shipdate between date '1995-01-01' and date '2011-12-31') as shipping
group by supp_nation, cust_nation, l_year
order by supp_nation, cust_nation, l_year;
supp_nation cust_nation l_year revenue
ALGERIA NULL NULL NULL
ARGENTINA NULL NULL NULL
ARGENTINA ALGERIA 1995 254136.6865
ARGENTINA ALGERIA 1996 82726.0327
ARGENTINA ALGERIA 1997 224331.0921
ARGENTINA ALGERIA 1998 49408.3864
ARGENTINA ARGENTINA 1995 69817.1451
ARGENTINA ARGENTINA 1996 4284.2250
ARGENTINA ARGENTINA 1998 76147.7507
ARGENTINA BRAZIL 1995 21429.5400
ARGENTINA BRAZIL 1996 36081.2088
ARGENTINA BRAZIL 1997 71006.5950
ARGENTINA CANADA 1994 2705.6757
ARGENTINA CANADA 1995 94610.1932
ARGENTINA CANADA 1996 188209.0755
ARGENTINA CANADA 1997 331088.5240
ARGENTINA CANADA 1998 106337.5812
ARGENTINA CHINA 1994 1832.0200
ARGENTINA CHINA 1995 14874.1362
ARGENTINA CHINA 1996 101867.8726
ARGENTINA CHINA 1997 17793.7682
ARGENTINA CHINA 1998 14817.1320
ARGENTINA EGYPT 1995 60747.9602
ARGENTINA EGYPT 1996 20913.7964
ARGENTINA EGYPT 1997 66376.4334
ARGENTINA EGYPT 1998 71285.4874
ARGENTINA ETHIOPIA 1995 23997.7944
ARGENTINA ETHIOPIA 1996 42315.7680
ARGENTINA ETHIOPIA 1997 96847.7242
ARGENTINA ETHIOPIA 1998 42766.5260
ARGENTINA FRANCE 1995 36554.0010
ARGENTINA FRANCE 1996 64102.9664
ARGENTINA FRANCE 1997 31735.5150
ARGENTINA FRANCE 1998 45164.6428
ARGENTINA GERMANY 1995 63729.8624
ARGENTINA GERMANY 1996 1801.8198
ARGENTINA GERMANY 1997 76294.0700
ARGENTINA GERMANY 1998 9642.2238
ARGENTINA INDIA 1995 25814.5890
ARGENTINA INDIA 1996 29141.5566
ARGENTINA INDIA 1997 19501.2400
ARGENTINA INDIA 1998 43135.2985
ARGENTINA INDONESIA 1994 44252.7360
ARGENTINA INDONESIA 1995 104138.6878
ARGENTINA INDONESIA 1996 160360.6837
ARGENTINA INDONESIA 1997 90775.4820
ARGENTINA INDONESIA 1998 137237.4612
ARGENTINA IRAN 1995 156252.0819
ARGENTINA IRAN 1996 141433.3909
ARGENTINA IRAN 1997 94318.7080
ARGENTINA IRAN 1998 74994.0767
ARGENTINA IRAQ 1994 46919.7456
ARGENTINA IRAQ 1995 111671.8798
ARGENTINA IRAQ 1996 114090.8757
ARGENTINA IRAQ 1997 156105.0932
ARGENTINA JAPAN 1995 116201.5549
ARGENTINA JAPAN 1996 118230.1393
ARGENTINA JAPAN 1997 156594.5269
ARGENTINA JORDAN 1995 75652.3699
ARGENTINA JORDAN 1996 6301.2558
ARGENTINA JORDAN 1997 41765.0660
ARGENTINA JORDAN 1998 149078.5370
ARGENTINA KENYA 1997 18864.5292
ARGENTINA MOROCCO 1994 62864.1220
ARGENTINA MOROCCO 1995 74639.6748
ARGENTINA MOROCCO 1996 124885.9045
ARGENTINA MOROCCO 1997 72464.2670
ARGENTINA MOROCCO 1998 49495.7008
ARGENTINA MOZAMBIQUE 1994 45964.4006
ARGENTINA MOZAMBIQUE 1995 160216.7568
ARGENTINA MOZAMBIQUE 1996 85490.4888
ARGENTINA MOZAMBIQUE 1997 100581.0192
ARGENTINA MOZAMBIQUE 1998 5128.0758
ARGENTINA PERU 1994 34061.3856
ARGENTINA PERU 1995 242274.3603
ARGENTINA PERU 1996 210146.1487
ARGENTINA PERU 1997 112384.6124
ARGENTINA PERU 1998 119612.0551
ARGENTINA ROMANIA 1995 41823.5789
ARGENTINA ROMANIA 1996 189590.7508
ARGENTINA ROMANIA 1997 29948.7980
ARGENTINA ROMANIA 1998 85942.4730
ARGENTINA RUSSIA 1995 97673.5984
ARGENTINA RUSSIA 1996 124050.7436
ARGENTINA RUSSIA 1997 52079.9130
ARGENTINA RUSSIA 1998 112034.1244
ARGENTINA SAUDI ARABIA 1994 46388.7744
ARGENTINA SAUDI ARABIA 1995 42786.9950
ARGENTINA SAUDI ARABIA 1996 7305.1026
ARGENTINA SAUDI ARABIA 1998 6836.0929
ARGENTINA UNITED KINGDOM 1995 43073.8143
ARGENTINA UNITED KINGDOM 1996 86258.2435
ARGENTINA UNITED KINGDOM 1997 5172.4056
ARGENTINA UNITED KINGDOM 1998 40577.0826
BRAZIL NULL NULL NULL
CANADA NULL NULL NULL
CHINA NULL NULL NULL
EGYPT NULL NULL NULL
ETHIOPIA ALGERIA 1995 128701.0650
ETHIOPIA ALGERIA 1996 105893.5744
ETHIOPIA ALGERIA 1997 78095.0517
ETHIOPIA ALGERIA 1998 999.3529
ETHIOPIA ARGENTINA 1995 95577.2594
ETHIOPIA ARGENTINA 1996 39186.0036
ETHIOPIA ARGENTINA 1997 16321.0200
ETHIOPIA ARGENTINA 1998 20263.0479
ETHIOPIA BRAZIL 1997 111110.1735
ETHIOPIA BRAZIL 1998 27506.1730
ETHIOPIA CANADA 1995 44157.1086
ETHIOPIA CANADA 1996 281973.8212
ETHIOPIA CANADA 1997 192627.0781
ETHIOPIA CANADA 1998 107898.6200
ETHIOPIA CHINA 1995 159955.0282
ETHIOPIA CHINA 1996 155702.2534
ETHIOPIA CHINA 1997 34925.8020
ETHIOPIA CHINA 1998 50821.1024
ETHIOPIA EGYPT 1995 80260.1748
ETHIOPIA EGYPT 1996 83699.4258
ETHIOPIA EGYPT 1997 63536.9807
ETHIOPIA EGYPT 1998 13990.9406
ETHIOPIA ETHIOPIA 1995 12728.4066
ETHIOPIA ETHIOPIA 1996 58323.2012
ETHIOPIA ETHIOPIA 1997 129160.0743
ETHIOPIA ETHIOPIA 1998 22063.3595
ETHIOPIA FRANCE 1995 45000.8334
ETHIOPIA FRANCE 1996 36802.5840
ETHIOPIA FRANCE 1997 84838.9215
ETHIOPIA FRANCE 1998 80512.6950
ETHIOPIA GERMANY 1994 69329.6720
ETHIOPIA GERMANY 1996 42017.4360
ETHIOPIA GERMANY 1997 133254.2433
ETHIOPIA GERMANY 1998 53069.9445
ETHIOPIA INDIA 1994 18124.1964
ETHIOPIA INDIA 1995 74563.3198
ETHIOPIA INDIA 1996 18762.8848
ETHIOPIA INDIA 1997 22384.1860
ETHIOPIA INDIA 1998 16228.5840
ETHIOPIA INDONESIA 1994 41186.7999
ETHIOPIA INDONESIA 1995 199618.2140
ETHIOPIA INDONESIA 1996 307285.0310
ETHIOPIA INDONESIA 1997 116190.6508
ETHIOPIA INDONESIA 1998 247218.5091
ETHIOPIA IRAN 1994 22731.2492
ETHIOPIA IRAN 1995 133602.1083
ETHIOPIA IRAN 1996 56303.9534
ETHIOPIA IRAN 1997 145484.8541
ETHIOPIA IRAN 1998 152620.2726
ETHIOPIA IRAQ 1994 93027.9024
ETHIOPIA IRAQ 1995 64828.0881
ETHIOPIA IRAQ 1996 199921.1492
ETHIOPIA IRAQ 1997 150551.6583
ETHIOPIA JAPAN 1994 28882.9952
ETHIOPIA JAPAN 1995 340013.5325
ETHIOPIA JAPAN 1996 864.9600
ETHIOPIA JAPAN 1997 30677.2710
ETHIOPIA JORDAN 1995 166340.5850
ETHIOPIA JORDAN 1996 71611.3404
ETHIOPIA JORDAN 1997 97184.5792
ETHIOPIA JORDAN 1998 56901.1968
ETHIOPIA MOROCCO 1994 50074.2568
ETHIOPIA MOROCCO 1995 140988.0114
ETHIOPIA MOROCCO 1996 145294.9585
ETHIOPIA MOROCCO 1997 166537.7473
ETHIOPIA MOROCCO 1998 184477.1439
ETHIOPIA MOZAMBIQUE 1994 78293.7031
ETHIOPIA MOZAMBIQUE 1995 246797.1524
ETHIOPIA MOZAMBIQUE 1996 111827.1300
ETHIOPIA MOZAMBIQUE 1997 75902.8622
ETHIOPIA MOZAMBIQUE 1998 11223.4892
ETHIOPIA PERU 1994 30585.2328
ETHIOPIA PERU 1995 101940.5467
ETHIOPIA PERU 1996 260619.3718
ETHIOPIA PERU 1997 80344.9279
ETHIOPIA PERU 1998 115461.4701
ETHIOPIA ROMANIA 1994 35213.4486
ETHIOPIA ROMANIA 1995 40374.0300
ETHIOPIA ROMANIA 1996 118006.0691
ETHIOPIA ROMANIA 1997 77207.2046
ETHIOPIA ROMANIA 1998 15107.6160
ETHIOPIA RUSSIA 1994 27740.7600
ETHIOPIA RUSSIA 1995 66333.8460
ETHIOPIA RUSSIA 1996 43231.4940
ETHIOPIA RUSSIA 1997 47707.2000
ETHIOPIA RUSSIA 1998 114033.0302
ETHIOPIA SAUDI ARABIA 1995 11579.3635
ETHIOPIA UNITED KINGDOM 1995 89546.3730
ETHIOPIA UNITED KINGDOM 1996 5977.1286
ETHIOPIA UNITED KINGDOM 1997 1934.1160
ETHIOPIA UNITED KINGDOM 1998 47342.1150
ETHIOPIA VIETNAM 1995 37152.5154
ETHIOPIA VIETNAM 1996 45682.3080
FRANCE NULL NULL NULL
GERMANY NULL NULL NULL
INDIA NULL NULL NULL
INDONESIA NULL NULL NULL
IRAN ALGERIA 1995 162547.6270
IRAN ALGERIA 1996 146628.0775
IRAN ALGERIA 1997 135999.4245
IRAN ALGERIA 1998 18508.6740
IRAN ARGENTINA 1995 34824.8910
IRAN ARGENTINA 1996 92470.9044
IRAN ARGENTINA 1997 69579.3544
IRAN ARGENTINA 1998 203673.8374
IRAN BRAZIL 1995 75458.9121
IRAN BRAZIL 1996 37076.0754
IRAN BRAZIL 1997 44186.2692
IRAN BRAZIL 1998 80756.2770
IRAN CANADA 1995 232692.2495
IRAN CANADA 1996 234301.9749
IRAN CANADA 1997 125238.2103
IRAN CANADA 1998 132265.8308
IRAN CHINA 1995 67560.3522
IRAN CHINA 1996 123833.1597
IRAN CHINA 1997 74706.6425
IRAN EGYPT 1995 184379.1137
IRAN EGYPT 1996 180642.2801
IRAN EGYPT 1997 86353.2143
IRAN EGYPT 1998 76284.7344
IRAN ETHIOPIA 1995 13126.1368
IRAN ETHIOPIA 1996 114648.5235
IRAN ETHIOPIA 1997 31483.6500
IRAN ETHIOPIA 1998 124895.4312
IRAN FRANCE 1995 91583.0498
IRAN FRANCE 1997 74661.9819
IRAN GERMANY 1994 3534.1860
IRAN GERMANY 1995 5572.7712
IRAN GERMANY 1997 40062.1130
IRAN GERMANY 1998 31517.6268
IRAN INDIA 1994 46367.9895
IRAN INDIA 1995 154909.9506
IRAN INDIA 1996 311383.9948
IRAN INDIA 1997 58458.6456
IRAN INDIA 1998 91496.0982
IRAN INDONESIA 1994 6895.5264
IRAN INDONESIA 1995 150520.3368
IRAN INDONESIA 1996 216606.5970
IRAN INDONESIA 1997 203979.4037
IRAN INDONESIA 1998 76164.5776
IRAN IRAN 1995 64854.8802
IRAN IRAN 1996 71310.4570
IRAN IRAN 1997 126956.9220
IRAN IRAN 1998 53071.6896
IRAN IRAQ 1994 72593.2368
IRAN IRAQ 1995 106998.1401
IRAN IRAQ 1996 175289.3140
IRAN IRAQ 1997 129649.0017
IRAN JAPAN 1994 27150.2855
IRAN JAPAN 1995 84487.1902
IRAN JAPAN 1996 72257.1410
IRAN JAPAN 1997 251114.8049
IRAN JORDAN 1994 25254.2760
IRAN JORDAN 1995 7715.3076
IRAN JORDAN 1996 133999.9402
IRAN JORDAN 1997 36170.6280
IRAN JORDAN 1998 48335.3328
IRAN KENYA 1997 67807.1408
IRAN MOROCCO 1994 16416.1800
IRAN MOROCCO 1995 99330.7526
IRAN MOROCCO 1996 174853.2256
IRAN MOROCCO 1997 157824.6131
IRAN MOROCCO 1998 30360.2220
IRAN MOZAMBIQUE 1995 58201.4247
IRAN MOZAMBIQUE 1996 56522.4495
IRAN MOZAMBIQUE 1997 116330.1648
IRAN MOZAMBIQUE 1998 161393.4898
IRAN PERU 1994 15978.6645
IRAN PERU 1995 138389.0233
IRAN PERU 1996 196586.4502
IRAN PERU 1997 178976.0677
IRAN PERU 1998 39956.4031
IRAN ROMANIA 1995 84411.4801
IRAN ROMANIA 1996 142296.4245
IRAN ROMANIA 1997 148996.0933
IRAN ROMANIA 1998 65580.7259
IRAN RUSSIA 1994 4990.0800
IRAN RUSSIA 1995 108075.3016
IRAN RUSSIA 1996 90816.2061
IRAN RUSSIA 1997 70771.7927
IRAN RUSSIA 1998 53505.3306
IRAN SAUDI ARABIA 1995 64286.0730
IRAN SAUDI ARABIA 1997 1958.7240
IRAN SAUDI ARABIA 1998 105403.3434
IRAN UNITED KINGDOM 1995 12914.0544
IRAN UNITED KINGDOM 1996 35837.3562
IRAN UNITED KINGDOM 1997 5034.9305
IRAN UNITED KINGDOM 1998 81854.0596
IRAN VIETNAM 1996 61851.0656
IRAN VIETNAM 1997 23221.7612
IRAQ ALGERIA 1995 279288.7764
IRAQ ALGERIA 1996 174202.9100
IRAQ ALGERIA 1997 137212.8783
IRAQ ALGERIA 1998 63961.7763
IRAQ ARGENTINA 1995 60911.8767
IRAQ ARGENTINA 1996 32103.9055
IRAQ ARGENTINA 1997 44549.0516
IRAQ ARGENTINA 1998 66118.3984
IRAQ BRAZIL 1995 41449.9332
IRAQ BRAZIL 1997 154919.1934
IRAQ BRAZIL 1998 25747.0112
IRAQ CANADA 1994 35517.7368
IRAQ CANADA 1995 130673.6525
IRAQ CANADA 1996 201758.0409
IRAQ CANADA 1997 265442.7116
IRAQ CANADA 1998 132598.4638
IRAQ CHINA 1994 41634.4428
IRAQ CHINA 1995 103291.5732
IRAQ CHINA 1996 169509.7004
IRAQ CHINA 1997 122463.5274
IRAQ CHINA 1998 78432.0570
IRAQ EGYPT 1995 47622.4242
IRAQ EGYPT 1996 38906.8236
IRAQ EGYPT 1997 205960.2394
IRAQ EGYPT 1998 28194.9548
IRAQ ETHIOPIA 1995 30882.3273
IRAQ ETHIOPIA 1996 84701.9680
IRAQ ETHIOPIA 1997 48113.9712
IRAQ FRANCE 1994 19003.3480
IRAQ FRANCE 1995 14024.7534
IRAQ FRANCE 1996 8588.6244
IRAQ FRANCE 1997 61754.9374
IRAQ GERMANY 1995 66380.2488
IRAQ GERMANY 1996 36124.8776
IRAQ GERMANY 1997 130393.1951
IRAQ GERMANY 1998 45868.6228
IRAQ INDIA 1994 15131.2860
IRAQ INDIA 1995 36106.9258
IRAQ INDIA 1996 170032.2384
IRAQ INDIA 1997 135706.4168
IRAQ INDIA 1998 153241.1365
IRAQ INDONESIA 1994 22126.3680
IRAQ INDONESIA 1995 140514.4472
IRAQ INDONESIA 1996 166262.8690
IRAQ INDONESIA 1997 226123.0232
IRAQ INDONESIA 1998 171676.6766
IRAQ IRAN 1994 28282.8422
IRAQ IRAN 1995 110256.1052
IRAQ IRAN 1996 109128.1063
IRAQ IRAN 1997 225979.5358
IRAQ IRAN 1998 188267.5470
IRAQ IRAQ 1994 18793.6980
IRAQ IRAQ 1995 28957.4409
IRAQ IRAQ 1996 229050.3331
IRAQ IRAQ 1997 86138.4770
IRAQ IRAQ 1998 41600.6325
IRAQ JAPAN 1995 75700.3915
IRAQ JAPAN 1996 63407.5110
IRAQ JAPAN 1997 174395.2693
IRAQ JAPAN 1998 5587.5492
IRAQ JORDAN 1994 30663.6000
IRAQ JORDAN 1995 45645.3638
IRAQ JORDAN 1996 89234.3074
IRAQ JORDAN 1997 44502.7300
IRAQ JORDAN 1998 54554.5861
IRAQ KENYA 1997 7076.6640
IRAQ KENYA 1998 34590.4120
IRAQ MOROCCO 1994 54862.4538
IRAQ MOROCCO 1995 224532.0382
IRAQ MOROCCO 1996 166579.4782
IRAQ MOROCCO 1997 244041.7469
IRAQ MOROCCO 1998 173259.8683
IRAQ MOZAMBIQUE 1994 40374.8632
IRAQ MOZAMBIQUE 1995 109369.3028
IRAQ MOZAMBIQUE 1996 223064.5804
IRAQ MOZAMBIQUE 1997 113061.9068
IRAQ PERU 1994 18344.3256
IRAQ PERU 1995 164007.8408
IRAQ PERU 1996 176737.4684
IRAQ PERU 1997 122382.9981
IRAQ PERU 1998 14396.9728
IRAQ ROMANIA 1995 6166.5422
IRAQ ROMANIA 1996 417374.0169
IRAQ ROMANIA 1997 218091.5786
IRAQ ROMANIA 1998 94915.8608
IRAQ RUSSIA 1995 82774.3141
IRAQ RUSSIA 1996 42764.8243
IRAQ RUSSIA 1997 13069.0644
IRAQ RUSSIA 1998 23795.0544
IRAQ SAUDI ARABIA 1995 32347.5864
IRAQ SAUDI ARABIA 1997 20279.3700
IRAQ SAUDI ARABIA 1998 52172.9631
IRAQ UNITED KINGDOM 1995 158311.1900
IRAQ UNITED KINGDOM 1996 113219.2840
IRAQ UNITED KINGDOM 1997 78868.6008
IRAQ VIETNAM 1995 25811.6385
IRAQ VIETNAM 1996 971.0140
IRAQ VIETNAM 1997 23775.0678
JAPAN NULL NULL NULL
JORDAN NULL NULL NULL
KENYA ALGERIA 1995 112182.0708
KENYA ALGERIA 1996 149076.3464
KENYA ALGERIA 1997 142083.5532
KENYA ALGERIA 1998 125324.1515
KENYA ARGENTINA 1997 7988.0373
KENYA ARGENTINA 1998 25642.8900
KENYA BRAZIL 1995 25260.8797
KENYA BRAZIL 1996 56395.8304
KENYA BRAZIL 1998 37074.7752
KENYA CANADA 1995 87554.7997
KENYA CANADA 1996 118419.8650
KENYA CANADA 1997 233230.0770
KENYA CANADA 1998 153192.8435
KENYA CHINA 1994 17438.7513
KENYA CHINA 1995 2146.5724
KENYA CHINA 1996 135085.7175
KENYA CHINA 1998 29564.3040
KENYA EGYPT 1995 42657.6505
KENYA EGYPT 1996 70109.1325
KENYA EGYPT 1997 121340.1374
KENYA EGYPT 1998 3058.8465
KENYA ETHIOPIA 1995 21254.3100
KENYA ETHIOPIA 1996 13062.5924
KENYA ETHIOPIA 1997 118440.6910
KENYA ETHIOPIA 1998 49864.0745
KENYA FRANCE 1994 7864.3040
KENYA FRANCE 1995 121803.3331
KENYA FRANCE 1996 17195.0000
KENYA GERMANY 1994 37851.3090
KENYA GERMANY 1996 72894.9240
KENYA INDIA 1995 156223.0690
KENYA INDIA 1996 56749.0208
KENYA INDIA 1997 54194.8477
KENYA INDIA 1998 52221.8940
KENYA INDONESIA 1994 83232.8798
KENYA INDONESIA 1995 230670.7139
KENYA INDONESIA 1996 131096.1041
KENYA INDONESIA 1997 80441.8953
KENYA INDONESIA 1998 76890.5026
KENYA IRAN 1994 37966.2632
KENYA IRAN 1995 92587.9268
KENYA IRAN 1996 44118.7164
KENYA IRAN 1997 339068.5316
KENYA IRAN 1998 113452.4035
KENYA IRAQ 1994 52789.2328
KENYA IRAQ 1995 5253.1776
KENYA IRAQ 1996 120423.0415
KENYA IRAQ 1997 9528.9740
KENYA IRAQ 1998 79993.1825
KENYA JAPAN 1995 11669.2458
KENYA JAPAN 1996 69110.5882
KENYA JAPAN 1997 44737.2607
KENYA JAPAN 1998 14529.3600
KENYA JORDAN 1994 1711.8900
KENYA JORDAN 1995 20886.1863
KENYA JORDAN 1996 41748.1344
KENYA JORDAN 1997 41366.6567
KENYA JORDAN 1998 49504.0116
KENYA MOROCCO 1994 106743.7379
KENYA MOROCCO 1995 47655.1040
KENYA MOROCCO 1996 77181.4400
KENYA MOROCCO 1997 134262.2093
KENYA MOROCCO 1998 134410.4827
KENYA MOZAMBIQUE 1994 36914.5686
KENYA MOZAMBIQUE 1995 63810.1524
KENYA MOZAMBIQUE 1996 43311.0726
KENYA MOZAMBIQUE 1997 127276.6348
KENYA MOZAMBIQUE 1998 66222.2352
KENYA PERU 1994 41619.5100
KENYA PERU 1995 187783.7946
KENYA PERU 1996 119586.5127
KENYA PERU 1997 237040.0684
KENYA PERU 1998 71293.9942
KENYA ROMANIA 1995 174764.0237
KENYA ROMANIA 1996 198755.8771
KENYA ROMANIA 1997 189521.4707
KENYA ROMANIA 1998 51634.5363
KENYA RUSSIA 1995 112330.0037
KENYA RUSSIA 1996 152595.9829
KENYA RUSSIA 1997 107379.2780
KENYA RUSSIA 1998 114439.5181
KENYA SAUDI ARABIA 1996 44817.4090
KENYA UNITED KINGDOM 1995 100085.3722
KENYA UNITED KINGDOM 1996 61689.0744
KENYA UNITED KINGDOM 1998 20994.8830
KENYA VIETNAM 1995 36410.1868
KENYA VIETNAM 1996 22038.8982
MOROCCO ALGERIA 1995 211201.6912
MOROCCO ALGERIA 1996 103371.5874
MOROCCO ALGERIA 1997 98609.3424
MOROCCO ALGERIA 1998 74260.6088
MOROCCO ARGENTINA 1995 60413.8382
MOROCCO ARGENTINA 1996 88441.5862
MOROCCO ARGENTINA 1997 15796.1340
MOROCCO ARGENTINA 1998 100692.4132
MOROCCO BRAZIL 1995 24525.4800
MOROCCO BRAZIL 1996 76977.1628
MOROCCO BRAZIL 1997 127990.5890
MOROCCO BRAZIL 1998 44236.7100
MOROCCO CANADA 1994 26657.5428
MOROCCO CANADA 1995 125450.6246
MOROCCO CANADA 1996 156325.8309
MOROCCO CANADA 1997 243794.4373
MOROCCO CANADA 1998 91113.0818
MOROCCO CHINA 1994 51677.6834
MOROCCO CHINA 1995 74697.3590
MOROCCO CHINA 1996 179875.9016
MOROCCO CHINA 1997 30291.2750
MOROCCO CHINA 1998 117748.3767
MOROCCO EGYPT 1994 1920.1920
MOROCCO EGYPT 1995 101693.6592
MOROCCO EGYPT 1996 165955.6182
MOROCCO EGYPT 1997 182578.2926
MOROCCO EGYPT 1998 81135.5373
MOROCCO ETHIOPIA 1996 105995.5609
MOROCCO ETHIOPIA 1997 85790.6644
MOROCCO FRANCE 1995 12598.1046
MOROCCO FRANCE 1996 52491.3111
MOROCCO FRANCE 1997 128928.9916
MOROCCO GERMANY 1994 31860.2097
MOROCCO GERMANY 1995 5309.6400
MOROCCO GERMANY 1997 45938.9754
MOROCCO GERMANY 1998 29249.1045
MOROCCO INDIA 1994 39019.2075
MOROCCO INDIA 1995 51155.0361
MOROCCO INDIA 1996 65486.2152
MOROCCO INDIA 1997 53268.6396
MOROCCO INDIA 1998 105852.4726
MOROCCO INDONESIA 1994 61028.3376
MOROCCO INDONESIA 1995 176257.0457
MOROCCO INDONESIA 1996 143699.8987
MOROCCO INDONESIA 1997 38752.2966
MOROCCO INDONESIA 1998 132000.8405
MOROCCO IRAN 1994 11028.0960
MOROCCO IRAN 1995 59126.0319
MOROCCO IRAN 1996 130115.5064
MOROCCO IRAN 1997 156334.2838
MOROCCO IRAN 1998 157472.9934
MOROCCO IRAQ 1994 85236.1410
MOROCCO IRAQ 1995 51632.5188
MOROCCO IRAQ 1996 268888.1818
MOROCCO IRAQ 1997 38680.2894
MOROCCO IRAQ 1998 68143.9776
MOROCCO JAPAN 1995 215532.0276
MOROCCO JAPAN 1996 74571.8680
MOROCCO JAPAN 1997 131668.4770
MOROCCO JAPAN 1998 82340.8866
MOROCCO JORDAN 1995 55760.2162
MOROCCO JORDAN 1996 5209.7245
MOROCCO JORDAN 1997 125934.9076
MOROCCO JORDAN 1998 25454.7300
MOROCCO KENYA 1995 32176.9770
MOROCCO KENYA 1997 25314.3792
MOROCCO MOROCCO 1994 164651.1992
MOROCCO MOROCCO 1995 194786.5612
MOROCCO MOROCCO 1996 127381.7510
MOROCCO MOROCCO 1997 153293.6484
MOROCCO MOROCCO 1998 124692.4605
MOROCCO MOZAMBIQUE 1995 94016.3014
MOROCCO MOZAMBIQUE 1996 153560.7428
MOROCCO MOZAMBIQUE 1997 63772.3354
MOROCCO MOZAMBIQUE 1998 81695.1078
MOROCCO PERU 1994 10973.4534
MOROCCO PERU 1995 236446.5344
MOROCCO PERU 1996 201699.5438
MOROCCO PERU 1997 18867.0798
MOROCCO PERU 1998 24922.8480
MOROCCO ROMANIA 1995 49303.1630
MOROCCO ROMANIA 1996 163725.7082
MOROCCO ROMANIA 1997 131327.6443
MOROCCO ROMANIA 1998 49134.1992
MOROCCO RUSSIA 1995 67569.0242
MOROCCO RUSSIA 1996 48079.3719
MOROCCO RUSSIA 1997 50412.3500
MOROCCO RUSSIA 1998 69466.4400
MOROCCO SAUDI ARABIA 1994 38994.4800
MOROCCO SAUDI ARABIA 1995 48335.3328
MOROCCO SAUDI ARABIA 1998 80140.2840
MOROCCO UNITED KINGDOM 1996 21850.7470
MOROCCO UNITED KINGDOM 1997 92421.8705
MOROCCO UNITED KINGDOM 1998 12196.2330
MOROCCO VIETNAM 1995 19167.1788
MOROCCO VIETNAM 1996 32660.5824
MOZAMBIQUE NULL NULL NULL
PERU ALGERIA 1994 40247.7000
PERU ALGERIA 1995 256139.9920
PERU ALGERIA 1996 323986.2421
PERU ALGERIA 1997 298324.7498
PERU ALGERIA 1998 126192.7948
PERU ARGENTINA 1995 124968.9930
PERU ARGENTINA 1996 222911.5774
PERU ARGENTINA 1997 128804.8473
PERU ARGENTINA 1998 232683.2578
PERU BRAZIL 1996 92475.2784
PERU BRAZIL 1997 199727.1309
PERU BRAZIL 1998 22091.0032
PERU CANADA 1994 30323.0976
PERU CANADA 1995 421705.3392
PERU CANADA 1996 488497.5942
PERU CANADA 1997 697192.2980
PERU CANADA 1998 198452.9501
PERU CHINA 1994 18353.3700
PERU CHINA 1995 430995.8759
PERU CHINA 1996 382570.7066
PERU CHINA 1997 30082.0768
PERU CHINA 1998 37178.8252
PERU EGYPT 1995 174577.7315
PERU EGYPT 1996 153271.3828
PERU EGYPT 1997 205344.4034
PERU EGYPT 1998 78985.8900
PERU ETHIOPIA 1995 19244.1880
PERU ETHIOPIA 1996 184621.3399
PERU ETHIOPIA 1997 123364.0868
PERU ETHIOPIA 1998 42524.3455
PERU FRANCE 1995 46226.3480
PERU FRANCE 1996 60971.0436
PERU FRANCE 1997 227151.3069
PERU FRANCE 1998 15653.4860
PERU GERMANY 1994 52968.9424
PERU GERMANY 1996 14078.8530
PERU GERMANY 1997 143713.6323
PERU GERMANY 1998 45592.4216
PERU INDIA 1994 83357.2307
PERU INDIA 1995 302207.7242
PERU INDIA 1996 332264.1965
PERU INDIA 1997 92566.3489
PERU INDIA 1998 247837.9041
PERU INDONESIA 1994 157310.4718
PERU INDONESIA 1995 312152.3458
PERU INDONESIA 1996 414760.4269
PERU INDONESIA 1997 304579.4895
PERU INDONESIA 1998 283872.0340
PERU IRAN 1994 47888.9992
PERU IRAN 1995 285671.6528
PERU IRAN 1996 234811.6534
PERU IRAN 1997 280968.9138
PERU IRAN 1998 130813.3952
PERU IRAQ 1994 101172.9112
PERU IRAQ 1995 161978.7374
PERU IRAQ 1996 260015.9719
PERU IRAQ 1997 361400.5272
PERU JAPAN 1994 38427.8486
PERU JAPAN 1995 169661.2715
PERU JAPAN 1996 160749.6307
PERU JAPAN 1997 125692.1481
PERU JORDAN 1994 26255.0160
PERU JORDAN 1995 178647.8509
PERU JORDAN 1997 13656.9985
PERU JORDAN 1998 66479.4960
PERU KENYA 1995 83390.9358
PERU KENYA 1997 1967.3734
PERU MOROCCO 1994 88512.3125
PERU MOROCCO 1995 237263.9112
PERU MOROCCO 1996 184480.4760
PERU MOROCCO 1997 475258.2635
PERU MOROCCO 1998 70116.6623
PERU MOZAMBIQUE 1994 15312.6690
PERU MOZAMBIQUE 1995 190708.4528
PERU MOZAMBIQUE 1996 129739.7772
PERU MOZAMBIQUE 1997 255447.2605
PERU MOZAMBIQUE 1998 134382.1176
PERU PERU 1994 24333.6960
PERU PERU 1995 321915.8715
PERU PERU 1996 258810.4605
PERU PERU 1997 204636.8883
PERU PERU 1998 296036.3328
PERU ROMANIA 1994 13021.8088
PERU ROMANIA 1995 136774.1956
PERU ROMANIA 1996 339147.2593
PERU ROMANIA 1997 260543.8792
PERU ROMANIA 1998 244778.2209
PERU RUSSIA 1994 17652.5048
PERU RUSSIA 1995 135753.4582
PERU RUSSIA 1996 183361.7920
PERU RUSSIA 1997 101440.6773
PERU SAUDI ARABIA 1995 21987.5493
PERU SAUDI ARABIA 1996 91301.7902
PERU SAUDI ARABIA 1997 120548.3176
PERU SAUDI ARABIA 1998 78773.4924
PERU UNITED KINGDOM 1995 160217.0254
PERU UNITED KINGDOM 1996 180577.3382
PERU UNITED KINGDOM 1997 45097.3025
PERU UNITED KINGDOM 1998 61622.5316
PERU VIETNAM 1995 11250.8352
PERU VIETNAM 1996 17274.7890
PERU VIETNAM 1998 45148.6136
ROMANIA NULL NULL NULL
RUSSIA NULL NULL NULL
SAUDI ARABIA NULL NULL NULL
UNITED KINGDOM ALGERIA 1995 205940.3007
UNITED KINGDOM ALGERIA 1996 153217.4991
UNITED KINGDOM ALGERIA 1997 55352.7023
UNITED KINGDOM ALGERIA 1998 30307.2000
UNITED KINGDOM ARGENTINA 1995 36307.9196
UNITED KINGDOM ARGENTINA 1996 144896.6322
UNITED KINGDOM ARGENTINA 1997 25889.4384
UNITED KINGDOM BRAZIL 1996 197041.7634
UNITED KINGDOM BRAZIL 1997 64054.8160
UNITED KINGDOM BRAZIL 1998 109722.1304
UNITED KINGDOM CANADA 1994 21204.4360
UNITED KINGDOM CANADA 1995 90266.0003
UNITED KINGDOM CANADA 1996 164444.2782
UNITED KINGDOM CANADA 1997 161027.1863
UNITED KINGDOM CANADA 1998 231144.0590
UNITED KINGDOM CHINA 1994 51805.7135
UNITED KINGDOM CHINA 1995 112760.1322
UNITED KINGDOM CHINA 1996 102883.1645
UNITED KINGDOM CHINA 1997 47656.6944
UNITED KINGDOM CHINA 1998 91570.8963
UNITED KINGDOM EGYPT 1995 109913.8124
UNITED KINGDOM EGYPT 1996 229960.5342
UNITED KINGDOM EGYPT 1997 67172.5490
UNITED KINGDOM EGYPT 1998 77490.6019
UNITED KINGDOM ETHIOPIA 1995 9421.9230
UNITED KINGDOM ETHIOPIA 1996 45289.2423
UNITED KINGDOM ETHIOPIA 1997 15804.9408
UNITED KINGDOM ETHIOPIA 1998 37656.5982
UNITED KINGDOM FRANCE 1994 1006.6548
UNITED KINGDOM FRANCE 1996 111976.4848
UNITED KINGDOM FRANCE 1997 86494.0114
UNITED KINGDOM FRANCE 1998 43310.2340
UNITED KINGDOM GERMANY 1996 66103.7120
UNITED KINGDOM GERMANY 1997 26668.6256
UNITED KINGDOM GERMANY 1998 6292.5996
UNITED KINGDOM INDIA 1994 40160.8980
UNITED KINGDOM INDIA 1995 149249.0560
UNITED KINGDOM INDIA 1996 59921.3178
UNITED KINGDOM INDIA 1997 103293.5536
UNITED KINGDOM INDIA 1998 185944.3021
UNITED KINGDOM INDONESIA 1995 111407.3820
UNITED KINGDOM INDONESIA 1996 227676.8665
UNITED KINGDOM INDONESIA 1997 307143.8050
UNITED KINGDOM INDONESIA 1998 238065.4632
UNITED KINGDOM IRAN 1995 164454.5252
UNITED KINGDOM IRAN 1996 130422.2495
UNITED KINGDOM IRAN 1997 244885.4387
UNITED KINGDOM IRAN 1998 75853.9922
UNITED KINGDOM IRAQ 1994 32926.9600
UNITED KINGDOM IRAQ 1995 206677.3192
UNITED KINGDOM IRAQ 1996 272866.7740
UNITED KINGDOM IRAQ 1997 69713.9370
UNITED KINGDOM IRAQ 1998 33612.9255
UNITED KINGDOM JAPAN 1994 45172.7705
UNITED KINGDOM JAPAN 1995 159811.8764
UNITED KINGDOM JAPAN 1996 69497.7075
UNITED KINGDOM JAPAN 1997 124718.6319
UNITED KINGDOM JAPAN 1998 25564.2800
UNITED KINGDOM JORDAN 1995 36505.1700
UNITED KINGDOM JORDAN 1996 78390.9252
UNITED KINGDOM JORDAN 1997 57430.2982
UNITED KINGDOM JORDAN 1998 82858.7088
UNITED KINGDOM MOROCCO 1994 83427.5946
UNITED KINGDOM MOROCCO 1995 192807.4741
UNITED KINGDOM MOROCCO 1996 52932.3156
UNITED KINGDOM MOROCCO 1997 142250.0485
UNITED KINGDOM MOROCCO 1998 122584.4549
UNITED KINGDOM MOZAMBIQUE 1995 27199.9600
UNITED KINGDOM MOZAMBIQUE 1996 123807.0044
UNITED KINGDOM MOZAMBIQUE 1997 103637.7197
UNITED KINGDOM MOZAMBIQUE 1998 58760.7214
UNITED KINGDOM PERU 1994 41871.8720
UNITED KINGDOM PERU 1995 299498.7841
UNITED KINGDOM PERU 1996 207603.1046
UNITED KINGDOM PERU 1997 78388.6253
UNITED KINGDOM PERU 1998 19183.0723
UNITED KINGDOM ROMANIA 1995 77972.6142
UNITED KINGDOM ROMANIA 1996 239917.7874
UNITED KINGDOM ROMANIA 1997 156484.4746
UNITED KINGDOM ROMANIA 1998 88339.9368
UNITED KINGDOM RUSSIA 1995 48206.1543
UNITED KINGDOM RUSSIA 1996 40788.5482
UNITED KINGDOM RUSSIA 1997 23156.5696
UNITED KINGDOM RUSSIA 1998 20564.2800
UNITED KINGDOM SAUDI ARABIA 1995 13484.1420
UNITED KINGDOM SAUDI ARABIA 1996 27576.0030
UNITED KINGDOM SAUDI ARABIA 1998 23044.4760
UNITED KINGDOM UNITED KINGDOM 1995 46102.2768
UNITED KINGDOM UNITED KINGDOM 1996 122323.9312
UNITED KINGDOM UNITED KINGDOM 1997 49763.4004
UNITED KINGDOM UNITED KINGDOM 1998 20816.6280
UNITED KINGDOM VIETNAM 1995 34295.7620
UNITED KINGDOM VIETNAM 1996 8594.1296
UNITED STATES ALGERIA 1995 128868.6069
UNITED STATES ALGERIA 1996 130279.0795
UNITED STATES ALGERIA 1997 26359.2144
UNITED STATES ARGENTINA 1994 15853.4496
UNITED STATES ARGENTINA 1996 108246.3789
UNITED STATES ARGENTINA 1997 15815.0592
UNITED STATES ARGENTINA 1998 41928.5872
UNITED STATES BRAZIL 1995 2605.6620
UNITED STATES BRAZIL 1996 50783.1744
UNITED STATES BRAZIL 1997 67976.4544
UNITED STATES BRAZIL 1998 42443.7030
UNITED STATES CANADA 1994 19425.0600
UNITED STATES CANADA 1995 337665.6898
UNITED STATES CANADA 1996 163862.7083
UNITED STATES CANADA 1997 222748.1792
UNITED STATES CANADA 1998 84871.5348
UNITED STATES CHINA 1994 49830.9560
UNITED STATES CHINA 1995 154162.2241
UNITED STATES CHINA 1996 168190.5963
UNITED STATES CHINA 1997 39331.4576
UNITED STATES CHINA 1998 40889.8680
UNITED STATES EGYPT 1995 79349.0460
UNITED STATES EGYPT 1996 129836.1404
UNITED STATES EGYPT 1997 111295.7630
UNITED STATES EGYPT 1998 72965.5304
UNITED STATES ETHIOPIA 1996 28372.7640
UNITED STATES FRANCE 1995 39114.3576
UNITED STATES FRANCE 1996 14245.4685
UNITED STATES FRANCE 1997 26694.3074
UNITED STATES FRANCE 1998 55876.9260
UNITED STATES GERMANY 1994 13267.6115
UNITED STATES GERMANY 1995 67222.0880
UNITED STATES GERMANY 1997 45384.1920
UNITED STATES GERMANY 1998 12858.0400
UNITED STATES INDIA 1995 89754.4773
UNITED STATES INDIA 1996 82189.8988
UNITED STATES INDIA 1997 99308.4492
UNITED STATES INDIA 1998 15155.0220
UNITED STATES INDONESIA 1994 35657.5880
UNITED STATES INDONESIA 1995 187075.7989
UNITED STATES INDONESIA 1996 249916.0996
UNITED STATES INDONESIA 1997 161906.7184
UNITED STATES INDONESIA 1998 70815.7596
UNITED STATES IRAN 1995 93992.6389
UNITED STATES IRAN 1996 77220.0132
UNITED STATES IRAN 1997 134543.1722
UNITED STATES IRAN 1998 137478.8476
UNITED STATES IRAQ 1994 30602.3785
UNITED STATES IRAQ 1995 138816.9082
UNITED STATES IRAQ 1996 161121.7069
UNITED STATES IRAQ 1997 118771.7214
UNITED STATES IRAQ 1998 34712.0548
UNITED STATES JAPAN 1994 16808.0208
UNITED STATES JAPAN 1995 35797.0800
UNITED STATES JAPAN 1996 72845.3640
UNITED STATES JAPAN 1997 109533.6188
UNITED STATES JAPAN 1998 35699.5200
UNITED STATES JORDAN 1994 99107.6010
UNITED STATES JORDAN 1995 69414.1700
UNITED STATES JORDAN 1996 30619.2624
UNITED STATES JORDAN 1997 63595.2123
UNITED STATES JORDAN 1998 89227.9269
UNITED STATES KENYA 1995 4173.1220
UNITED STATES KENYA 1997 48993.5616
UNITED STATES MOROCCO 1994 89362.0116
UNITED STATES MOROCCO 1995 249519.1487
UNITED STATES MOROCCO 1996 28815.0165
UNITED STATES MOROCCO 1997 176452.2352
UNITED STATES MOROCCO 1998 2675.5776
UNITED STATES MOZAMBIQUE 1994 66406.4684
UNITED STATES MOZAMBIQUE 1995 58746.1474
UNITED STATES MOZAMBIQUE 1996 111416.0547
UNITED STATES MOZAMBIQUE 1997 92484.5832
UNITED STATES MOZAMBIQUE 1998 65292.8811
UNITED STATES PERU 1994 42294.1050
UNITED STATES PERU 1995 358721.7180
UNITED STATES PERU 1996 98297.7549
UNITED STATES PERU 1997 144111.0631
UNITED STATES ROMANIA 1995 46069.4857
UNITED STATES ROMANIA 1996 260064.7869
UNITED STATES ROMANIA 1997 252963.3266
UNITED STATES ROMANIA 1998 95554.4030
UNITED STATES RUSSIA 1995 39120.9000
UNITED STATES RUSSIA 1996 140883.0159
UNITED STATES RUSSIA 1997 28194.2235
UNITED STATES RUSSIA 1998 19700.2710
UNITED STATES SAUDI ARABIA 1995 43975.9816
UNITED STATES SAUDI ARABIA 1996 39308.9136
UNITED STATES SAUDI ARABIA 1998 41537.5100
UNITED STATES UNITED KINGDOM 1995 81913.8712
UNITED STATES UNITED KINGDOM 1996 100420.9984
UNITED STATES UNITED KINGDOM 1997 89088.2172
UNITED STATES VIETNAM 1995 25532.9175
UNITED STATES VIETNAM 1996 76721.3430
UNITED STATES VIETNAM 1998 10423.7748
VIETNAM NULL NULL NULL
select s_acctbal, s_name, n_name, p_partkey, p_mfgr, s_address, s_phone, s_comment
from part right join partsupp pso on p_partkey = pso.ps_partkey left join supplier on s_suppkey = pso.ps_suppkey left join nation on s_nationkey = n_nationkey left join region on n_regionkey = r_regionkey
where
# p_size = 15
pso.ps_supplycost = (select min(psi.ps_supplycost)
from partsupp psi, supplier, nation, region
where pso.ps_partkey = psi.ps_partkey
and s_suppkey = psi.ps_suppkey
and s_nationkey = n_nationkey
and n_regionkey = r_regionkey
and r_name = 'EUROPE')
order by s_acctbal desc,
n_name,
s_name,
p_partkey;
s_acctbal s_name n_name p_partkey p_mfgr s_address s_phone s_comment
6820.35 Supplier#000000007 UNITED KINGDOM 2 Manufacturer#1 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 4 Manufacturer#3 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 6 Manufacturer#2 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 10 Manufacturer#5 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 13 Manufacturer#5 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 16 Manufacturer#3 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 17 Manufacturer#4 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 20 Manufacturer#1 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 22 Manufacturer#4 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 24 Manufacturer#5 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 26 Manufacturer#3 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 28 Manufacturer#4 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 31 Manufacturer#5 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 36 Manufacturer#2 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 44 Manufacturer#4 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 46 Manufacturer#1 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 48 Manufacturer#5 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 50 Manufacturer#3 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 52 Manufacturer#3 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 55 Manufacturer#2 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 56 Manufacturer#1 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 59 Manufacturer#5 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 62 Manufacturer#3 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 66 Manufacturer#3 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 68 Manufacturer#1 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 70 Manufacturer#1 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 76 Manufacturer#3 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 77 Manufacturer#5 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 78 Manufacturer#1 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 79 Manufacturer#4 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 86 Manufacturer#4 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 93 Manufacturer#2 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 94 Manufacturer#3 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 95 Manufacturer#3 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 96 Manufacturer#5 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 102 Manufacturer#3 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 104 Manufacturer#1 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 106 Manufacturer#3 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 110 Manufacturer#3 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 113 Manufacturer#3 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 116 Manufacturer#5 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 117 Manufacturer#1 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 120 Manufacturer#1 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 122 Manufacturer#2 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 124 Manufacturer#3 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 126 Manufacturer#4 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 128 Manufacturer#2 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 131 Manufacturer#5 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 136 Manufacturer#2 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 144 Manufacturer#1 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 146 Manufacturer#3 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 148 Manufacturer#3 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 150 Manufacturer#3 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 152 Manufacturer#5 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 155 Manufacturer#2 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 156 Manufacturer#4 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 159 Manufacturer#4 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 162 Manufacturer#3 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 166 Manufacturer#5 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 168 Manufacturer#1 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 170 Manufacturer#3 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 176 Manufacturer#2 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 177 Manufacturer#2 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 178 Manufacturer#1 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 179 Manufacturer#4 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 186 Manufacturer#2 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 193 Manufacturer#4 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 194 Manufacturer#5 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 195 Manufacturer#4 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit
6820.35 Supplier#000000007 UNITED KINGDOM 196 Manufacturer#3 s,4TicNGB4uO6PaSqNBUq 33-990-965-2201 s unwind silently furiously regular courts. final requests are deposits. requests wake quietly blit