Skip to content

完成 TPCH 测试

TPC Benchmark™H(TPC-H)是决策支持基准。它由一套面向业务的即时查询(ad-hoc)和并发数据修改组成。选择查询和填充数据库的数据具有广泛的行业相关性。该基准测试解释说明了决策支持系统,该系统可检查大量数据,执行高度复杂的查询并为关键业务问题提供答案。TPC-H 是 OLAP 数据库广泛使用的基准测试。

通过阅读本教程,您将学习如何使用 MatrixOne 完成 TPC-H 测试。

开始前准备

确保你已经完成了单机部署 MatrixOne

1. 编译 dbgen

默认情况下,TPCH dbgen 实用程序是用来生成测试数据集表格的工具,它根据比例因子 Scale Factor(SF) 的大小确定数据集的大小,并生成一组平面文件(Flat File),这些文件适合加载到 tpch 模式中。

当使用 -s 1dbgen 命令会产生 1GB 的完整数据集,当使用 -s 10 时会产生大约 10GB 的数据集,以此类推。

git clone https://github.com/electrum/tpch-dbgen.git
或者
git clone https://githubfast.com/electrum/tpch-dbgen.git
cd tpch-dbgen
make

2. 生成数据

运行 dbgen,获得适当的数据库大小因子 (在示例中为 1GB)。

./dbgen -s 1

生成完整数据集可能需要一段时间。完成后,您可以看到结果文件。

total 2150000
-rw-r--r--  1 deister  staff   24346144 13 may 12:05 customer.tbl
-rw-r--r--  1 deister  staff  759863287 13 may 12:05 lineitem.tbl
-rw-r--r--  1 deister  staff       2224 13 may 12:05 nation.tbl
-rw-r--r--  1 deister  staff  171952161 13 may 12:05 orders.tbl
-rw-r--r--  1 deister  staff   24135125 13 may 12:05 part.tbl
-rw-r--r--  1 deister  staff  118984616 13 may 12:05 partsupp.tbl
-rw-r--r--  1 deister  staff        389 13 may 12:05 region.tbl
-rw-r--r--  1 deister  staff    1409184 13 may 12:05 supplier.tbl

我们同时也准备了 1GB 的数据集供您下载。您可以在以下链接中直接获取数据文件:

https://community-shared-data-1308875761.cos.ap-beijing.myqcloud.com/tpch/tpch-1g.zip

3. 在 MatrixOne 中建表

MatrixOne 暂不支持分区加速,LINEITEM 表的创建代码有以下修改:

  • 移除了 LINEITEM 表的 PARTITION BY KEY()
drop database if exists TPCH;
create database if not exists TPCH;
use tpch;
CREATE TABLE NATION(
N_NATIONKEY  INTEGER NOT NULL,
N_NAME       CHAR(25) NOT NULL,
N_REGIONKEY  INTEGER NOT NULL,
N_COMMENT    VARCHAR(152),
PRIMARY KEY (N_NATIONKEY)
);

CREATE TABLE REGION(
R_REGIONKEY  INTEGER NOT NULL,
R_NAME       CHAR(25) NOT NULL,
R_COMMENT    VARCHAR(152),
PRIMARY KEY (R_REGIONKEY)
);

CREATE TABLE PART(
P_PARTKEY     INTEGER NOT NULL,
P_NAME        VARCHAR(55) NOT NULL,
P_MFGR        CHAR(25) NOT NULL,
P_BRAND       CHAR(10) NOT NULL,
P_TYPE        VARCHAR(25) NOT NULL,
P_SIZE        INTEGER NOT NULL,
P_CONTAINER   CHAR(10) NOT NULL,
P_RETAILPRICE DECIMAL(15,2) NOT NULL,
P_COMMENT     VARCHAR(23) NOT NULL,
PRIMARY KEY (P_PARTKEY)
);

CREATE TABLE SUPPLIER(
S_SUPPKEY     INTEGER NOT NULL,
S_NAME        CHAR(25) NOT NULL,
S_ADDRESS     VARCHAR(40) NOT NULL,
S_NATIONKEY   INTEGER NOT NULL,
S_PHONE       CHAR(15) NOT NULL,
S_ACCTBAL     DECIMAL(15,2) NOT NULL,
S_COMMENT     VARCHAR(101) NOT NULL,
PRIMARY KEY (S_SUPPKEY)
);

CREATE TABLE PARTSUPP (
PS_PARTKEY INTEGER NOT NULL,
PS_SUPPKEY INTEGER NOT NULL,
PS_AVAILQTY INTEGER NOT NULL,
PS_SUPPLYCOST DECIMAL(15,2) NOT NULL,
PS_COMMENT VARCHAR(199) NOT NULL,
PRIMARY KEY (PS_PARTKEY, PS_SUPPKEY)
);

CREATE TABLE CUSTOMER(
C_CUSTKEY     INTEGER NOT NULL,
C_NAME        VARCHAR(25) NOT NULL,
C_ADDRESS     VARCHAR(40) NOT NULL,
C_NATIONKEY   INTEGER NOT NULL,
C_PHONE       CHAR(15) NOT NULL,
C_ACCTBAL     DECIMAL(15,2)   NOT NULL,
C_MKTSEGMENT  CHAR(10) NOT NULL,
C_COMMENT     VARCHAR(117) NOT NULL,
PRIMARY KEY (C_CUSTKEY)
);

CREATE TABLE ORDERS(
O_ORDERKEY       BIGINT NOT NULL,
O_CUSTKEY        INTEGER NOT NULL,
O_ORDERSTATUS    CHAR(1) NOT NULL,
O_TOTALPRICE     DECIMAL(15,2) NOT NULL,
O_ORDERDATE      DATE NOT NULL,
O_ORDERPRIORITY  CHAR(15) NOT NULL,
O_CLERK          CHAR(15) NOT NULL,
O_SHIPPRIORITY   INTEGER NOT NULL,
O_COMMENT        VARCHAR(79) NOT NULL,
PRIMARY KEY (O_ORDERKEY)
);

CREATE TABLE LINEITEM (
L_ORDERKEY BIGINT NOT NULL,
L_PARTKEY INTEGER NOT NULL,
L_SUPPKEY INTEGER NOT NULL,
L_LINENUMBER INTEGER NOT NULL,
L_QUANTITY DECIMAL(15,2) NOT NULL,
L_EXTENDEDPRICE DECIMAL(15,2) NOT NULL,
L_DISCOUNT DECIMAL(15,2) NOT NULL,
L_TAX DECIMAL(15,2) NOT NULL,
L_RETURNFLAG CHAR(1) NOT NULL,
L_LINESTATUS CHAR(1) NOT NULL,
L_SHIPDATE DATE NOT NULL,
L_COMMITDATE DATE NOT NULL,
L_RECEIPTDATE DATE NOT NULL,
L_SHIPINSTRUCT CHAR(25) NOT NULL,
L_SHIPMODE CHAR(10) NOT NULL,
L_COMMENT VARCHAR(44) NOT NULL,
PRIMARY KEY (L_ORDERKEY, L_LINENUMBER)
);

4. 导入数据

在 MatrixOne 中使用以下命令将数据加载到相关的表中。

load data infile '/YOUR_TPCH_DATA_PATH/nation.tbl' into table NATION FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';

load data infile '/YOUR_TPCH_DATA_PATH/region.tbl' into table REGION FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';

load data infile '/YOUR_TPCH_DATA_PATH/part.tbl' into table PART FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';

load data infile '/YOUR_TPCH_DATA_PATH/supplier.tbl' into table SUPPLIER FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';

load data infile '/YOUR_TPCH_DATA_PATH/partsupp.tbl' into table PARTSUPP FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';

load data infile '/YOUR_TPCH_DATA_PATH/orders.tbl' into table ORDERS FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';

load data infile '/YOUR_TPCH_DATA_PATH/customer.tbl' into table CUSTOMER FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';

load data infile '/YOUR_TPCH_DATA_PATH/lineitem.tbl' into table LINEITEM FIELDS TERMINATED BY '|' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';

加载完成后,可以使用创建的表查询 MatrixOne 中的数据。

5. 运行 TPCH 测试命令

-- Q1
select
    l_returnflag,
    l_linestatus,
    sum(l_quantity) as sum_qty,
    sum(l_extendedprice) as sum_base_price,
    sum(l_extendedprice * (1 - l_discount)) as sum_disc_price,
    sum(l_extendedprice * (1 - l_discount) * (1 + l_tax)) as sum_charge,
    avg(l_quantity) as avg_qty,
    avg(l_extendedprice) as avg_price,
    avg(l_discount) as avg_disc,
    count(*) as count_order
from
    lineitem
where
    l_shipdate <= date '1998-12-01' - interval '112' day
group by
    l_returnflag,
    l_linestatus
order by
    l_returnflag,
    l_linestatus
;

-- Q2
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 = 48
    and p_type like '%TIN'
    and s_nationkey = n_nationkey
    and n_regionkey = r_regionkey
    and r_name = 'MIDDLE EAST'
    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 = 'MIDDLE EAST'
    )
order by
    s_acctbal desc,
    n_name,
    s_name,
    p_partkey
limit 100
;


-- Q3
select
    l_orderkey,
    sum(l_extendedprice * (1 - l_discount)) as revenue,
    o_orderdate,
    o_shippriority
from
    customer,
    orders,
    lineitem
where
    c_mktsegment = 'HOUSEHOLD'
    and c_custkey = o_custkey
    and l_orderkey = o_orderkey
    and o_orderdate < date '1995-03-29'
    and l_shipdate > date '1995-03-29'
group by
    l_orderkey,
    o_orderdate,
    o_shippriority
order by
    revenue desc,
    o_orderdate
limit 10
;

-- Q4
select
    o_orderpriority,
    count(*) as order_count
from
    orders
where
    o_orderdate >= date '1997-07-01'
    and o_orderdate < date '1997-07-01' + interval '3' month
    and exists (
        select
            *
        from
            lineitem
        where
            l_orderkey = o_orderkey
            and l_commitdate < l_receiptdate
    )
group by
    o_orderpriority
order by
    o_orderpriority
;


-- Q5
select
    n_name,
    sum(l_extendedprice * (1 - l_discount)) as revenue
from
    customer,
    orders,
    lineitem,
    supplier,
    nation,
    region
where
    c_custkey = o_custkey
    and l_orderkey = o_orderkey
    and l_suppkey = s_suppkey
    and c_nationkey = s_nationkey
    and s_nationkey = n_nationkey
    and n_regionkey = r_regionkey
    and r_name = 'AMERICA'
    and o_orderdate >= date '1994-01-01'
    and o_orderdate < date '1994-01-01' + interval '1' year
group by
    n_name
order by
    revenue desc
;


-- Q6
select
    sum(l_extendedprice * l_discount) as revenue
from
    lineitem
where
    l_shipdate >= date '1994-01-01'
    and l_shipdate < date '1994-01-01' + interval '1' year
    and l_discount between 0.03 - 0.01 and 0.03 + 0.01
    and l_quantity < 24;

-- Q7
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,
            extract(year from l_shipdate) as l_year,
            l_extendedprice * (1 - l_discount) as volume
        from
            supplier,
            lineitem,
            orders,
            customer,
            nation n1,
            nation n2
        where
            s_suppkey = l_suppkey
            and o_orderkey = l_orderkey
            and c_custkey = o_custkey
            and s_nationkey = n1.n_nationkey
            and c_nationkey = n2.n_nationkey
            and (
                (n1.n_name = 'FRANCE' and n2.n_name = 'ARGENTINA')
                or (n1.n_name = 'ARGENTINA' and n2.n_name = 'FRANCE')
            )
            and l_shipdate between date '1995-01-01' and date '1996-12-31'
    ) as shipping
group by
    supp_nation,
    cust_nation,
    l_year
order by
    supp_nation,
    cust_nation,
    l_year
;

-- Q8
select
    o_year,
    (sum(case
        when nation = 'ARGENTINA' then volume
        else 0
    end) / sum(volume)) as mkt_share
from
    (
        select
            extract(year from o_orderdate) as o_year,
            l_extendedprice * (1 - l_discount) as volume,
            n2.n_name as nation
        from
            part,
            supplier,
            lineitem,
            orders,
            customer,
            nation n1,
            nation n2,
            region
        where
            p_partkey = l_partkey
            and s_suppkey = l_suppkey
            and l_orderkey = o_orderkey
            and o_custkey = c_custkey
            and c_nationkey = n1.n_nationkey
            and n1.n_regionkey = r_regionkey
            and r_name = 'AMERICA'
            and s_nationkey = n2.n_nationkey
            and o_orderdate between date '1995-01-01' and date '1996-12-31'
            and p_type = 'ECONOMY BURNISHED TIN'
    ) as all_nations
group by
    o_year
order by
    o_year
;

-- Q9
select
    nation,
    o_year,
    sum(amount) as sum_profit
from
    (
        select
            n_name as nation,
            extract(year from o_orderdate) as o_year,
            l_extendedprice * (1 - l_discount) - ps_supplycost * l_quantity as amount
        from
            part,
            supplier,
            lineitem,
            partsupp,
            orders,
            nation
        where
            s_suppkey = l_suppkey
            and ps_suppkey = l_suppkey
            and ps_partkey = l_partkey
            and p_partkey = l_partkey
            and o_orderkey = l_orderkey
            and s_nationkey = n_nationkey
            and p_name like '%pink%'
    ) as profit
group by
    nation,
    o_year
order by
    nation,
    o_year desc
;


-- Q10
select
    c_custkey,
    c_name,
    sum(l_extendedprice * (1 - l_discount)) as revenue,
    c_acctbal,
    n_name,
    c_address,
    c_phone,
    c_comment
from
    customer,
    orders,
    lineitem,
    nation
where
    c_custkey = o_custkey
    and l_orderkey = o_orderkey
    and o_orderdate >= date '1993-03-01'
    and o_orderdate < date '1993-03-01' + interval '3' month
    and l_returnflag = 'R'
    and c_nationkey = n_nationkey
group by
    c_custkey,
    c_name,
    c_acctbal,
    c_phone,
    n_name,
    c_address,
    c_comment
order by
    revenue desc
limit 20
;


-- Q11
select
    ps_partkey,
    sum(ps_supplycost * ps_availqty) as value
from
    partsupp,
    supplier,
    nation
where
    ps_suppkey = s_suppkey
    and s_nationkey = n_nationkey
    and n_name = 'JAPAN'
group by
    ps_partkey having
        sum(ps_supplycost * ps_availqty) > (
        select
            sum(ps_supplycost * ps_availqty) * 0.0001000000
                from
                partsupp,
                supplier,nation
            where
                ps_suppkey = s_suppkey
                and s_nationkey = n_nationkey
                and n_name = 'JAPAN'
        )
order by
    value desc
;

-- Q12
select
        l_shipmode,
        sum(case
                when o_orderpriority = '1-URGENT'
                        or o_orderpriority = '2-HIGH'
                        then 1
                else 0
        end) as high_line_count,
        sum(case
                when o_orderpriority <> '1-URGENT'
                        and o_orderpriority <> '2-HIGH'
                        then 1
                else 0
        end) as low_line_count
from
        orders,
        lineitem
where
        o_orderkey = l_orderkey
        and l_shipmode in ('FOB', 'TRUCK')
        and l_commitdate < l_receiptdate
        and l_shipdate < l_commitdate
        and l_receiptdate >= date '1996-01-01'
        and l_receiptdate < date '1996-01-01' + interval '1' year
group by
        l_shipmode
order by
        l_shipmode
;

-- Q13
select
    c_count,
    count(*) as custdist
from
    (
        select
            c_custkey,
            count(o_orderkey)
        from
            customer left outer join orders on
                c_custkey = o_custkey
                and o_comment not like '%pending%accounts%'
        group by
            c_custkey
    ) as c_orders (c_custkey, c_count)
group by
    c_count
order by
    custdist desc,
    c_count desc
;

-- Q14
select
    100.00 * sum(case
        when p_type like 'PROMO%'
            then l_extendedprice * (1 - l_discount)
        else 0
    end) / sum(l_extendedprice * (1 - l_discount)) as promo_revenue
from
    lineitem,
    part
where
    l_partkey = p_partkey
    and l_shipdate >= date '1996-04-01'
    and l_shipdate < date '1996-04-01' + interval '1' month;

-- Q15
with q15_revenue0 as (
    select
        l_suppkey as supplier_no,
        sum(l_extendedprice * (1 - l_discount)) as total_revenue
    from
        lineitem
    where
        l_shipdate >= date '1995-12-01'
        and l_shipdate < date '1995-12-01' + interval '3' month
    group by
        l_suppkey
    )
select
    s_suppkey,
    s_name,
    s_address,
    s_phone,
    total_revenue
from
    supplier,
    q15_revenue0
where
    s_suppkey = supplier_no
    and total_revenue = (
        select
            max(total_revenue)
        from
            q15_revenue0
    )
order by
    s_suppkey
;

-- Q16
select
    p_brand,
    p_type,
    p_size,
    count(distinct ps_suppkey) as supplier_cnt
from
    partsupp,
    part
where
    p_partkey = ps_partkey
    and p_brand <> 'Brand#35'
    and p_type not like 'ECONOMY BURNISHED%'
    and p_size in (14, 7, 21, 24, 35, 33, 2, 20)
    and ps_suppkey not in (
        select
            s_suppkey
        from
            supplier
        where
            s_comment like '%Customer%Complaints%'
    )
group by
    p_brand,
    p_type,
    p_size
order by
    supplier_cnt desc,
    p_brand,
    p_type,
    p_size
;

-- Q17
select
    sum(l_extendedprice) / 7.0 as avg_yearly
from
    lineitem,
    part
where
    p_partkey = l_partkey
    and p_brand = 'Brand#54'
    and p_container = 'LG BAG'
    and l_quantity < (
        select
            0.2 * avg(l_quantity)
        from
            lineitem
        where
            l_partkey = p_partkey
    );

-- Q18
select
    c_name,
    c_custkey,
    o_orderkey,
    o_orderdate,
    o_totalprice,
    sum(l_quantity)
from
    customer,
    orders,
    lineitem
where
    o_orderkey in (
        select
            l_orderkey
        from
            lineitem
        group by
            l_orderkey having
                sum(l_quantity) > 314
    )
    and c_custkey = o_custkey
    and o_orderkey = l_orderkey
group by
    c_name,
    c_custkey,
    o_orderkey,
    o_orderdate,
    o_totalprice
order by
    o_totalprice desc,
    o_orderdate
limit 100
;

-- Q19
select
    sum(l_extendedprice* (1 - l_discount)) as revenue
from
    lineitem,
    part
where
    (
        p_partkey = l_partkey
        and p_brand = 'Brand#23'
        and p_container in ('SM CASE', 'SM BOX', 'SM PACK', 'SM PKG')
        and l_quantity >= 5 and l_quantity <= 5 + 10
        and p_size between 1 and 5
        and l_shipmode in ('AIR', 'AIR REG')
        and l_shipinstruct = 'DELIVER IN PERSON'
    )
    or
    (
        p_partkey = l_partkey
        and p_brand = 'Brand#15'
        and p_container in ('MED BAG', 'MED BOX', 'MED PKG', 'MED PACK')
        and l_quantity >= 14 and l_quantity <= 14 + 10
        and p_size between 1 and 10
        and l_shipmode in ('AIR', 'AIR REG')
        and l_shipinstruct = 'DELIVER IN PERSON'
    )
    or
    (
        p_partkey = l_partkey
        and p_brand = 'Brand#44'
        and p_container in ('LG CASE', 'LG BOX', 'LG PACK', 'LG PKG')
        and l_quantity >= 28 and l_quantity <= 28 + 10
        and p_size between 1 and 15
        and l_shipmode in ('AIR', 'AIR REG')
        and l_shipinstruct = 'DELIVER IN PERSON'
    );

-- Q20
select
    s_name,
    s_address
from
    supplier,
    nation
where
    s_suppkey in (
        select
            ps_suppkey
        from
            partsupp
        where
            ps_partkey in (
                select
                    p_partkey
                from
                    part
                where
                    p_name like 'lime%'
            )
            and ps_availqty > (
                select
                    0.5 * sum(l_quantity)
                from
                    lineitem
                where
                    l_partkey = ps_partkey
                    and l_suppkey = ps_suppkey
                    and l_shipdate >= date '1993-01-01'
                    and l_shipdate < date '1993-01-01' + interval '1' year
            )
    )
    and s_nationkey = n_nationkey
    and n_name = 'VIETNAM'
order by s_name
;

-- Q21
select
    s_name,
    count(*) as numwait
from
    supplier,
    lineitem l1,
    orders,
    nation
where
    s_suppkey = l1.l_suppkey
    and o_orderkey = l1.l_orderkey
    and o_orderstatus = 'F'
    and l1.l_receiptdate > l1.l_commitdate
    and exists (
        select
            *
        from
            lineitem l2
        where
            l2.l_orderkey = l1.l_orderkey
            and l2.l_suppkey <> l1.l_suppkey
    )
    and not exists (
        select
            *
        from
            lineitem l3
        where
            l3.l_orderkey = l1.l_orderkey
            and l3.l_suppkey <> l1.l_suppkey
            and l3.l_receiptdate > l3.l_commitdate
    )
    and s_nationkey = n_nationkey
    and n_name = 'BRAZIL'
group by
    s_name
order by
    numwait desc,
    s_name
limit 100
;

-- Q22
select
    cntrycode,
    count(*) as numcust,
    sum(c_acctbal) as totacctbal
from
    (
        select
            substring(c_phone from 1 for 2) as cntrycode,
            c_acctbal
        from
            customer
        where
            substring(c_phone from 1 for 2) in
                ('10', '11', '26', '22', '19', '20', '27')
            and c_acctbal > (
                select
                    avg(c_acctbal)
                from
                    customer
                where
                    c_acctbal > 0.00
                    and substring(c_phone from 1 for 2) in
                        ('10', '11', '26', '22', '19', '20', '27')
            )
            and not exists (
                select
                    *
                from
                    orders
                where
                    o_custkey = c_custkey
            )
    ) as custsale
group by
    cntrycode
order by
    cntrycode
;

6. 运行预期结果

以下为 22 个 TPCH 查询的预期结果。

说明:由于 Q16 的结果段落过长,无法在下文展示,请参阅此连结的完整结果:Q16 运行预期结果

Q1
+--------------+--------------+-------------+-----------------+-------------------+---------------------+-------------+----------------+------------+-------------+
| l_returnflag | l_linestatus | sum_qty     | sum_base_price  | sum_disc_price    | sum_charge          | avg_qty     | avg_price      | avg_disc   | count_order |
+--------------+--------------+-------------+-----------------+-------------------+---------------------+-------------+----------------+------------+-------------+
| A            | F            | 37734107.00 |  56586554400.73 |  53758257134.8700 |  55909065222.827692 | 25.52200585 | 38273.12973462 | 0.04998530 |     1478493 |
| N            | F            |   991417.00 |   1487504710.38 |   1413082168.0541 |   1469649223.194375 | 25.51647192 | 38284.46776085 | 0.05009343 |       38854 |
| N            | O            | 73295769.00 | 109931611187.71 | 104436646745.0693 | 108617847377.142872 | 25.50176452 | 38248.45691074 | 0.04999662 |     2874145 |
| R            | F            | 37719753.00 |  56568041380.90 |  53741292684.6040 |  55889619119.831932 | 25.50579361 | 38250.85462610 | 0.05000941 |     1478870 |
+--------------+--------------+-------------+-----------------+-------------------+---------------------+-------------+----------------+------------+-------------+
4 rows in set (0.56 sec)

Q2
+-----------+--------------------+--------------+-----------+----------------+------------------------------------------+-----------------+-----------------------------------------------------------------------------------------------------+
| s_acctbal | s_name             | n_name       | p_partkey | p_mfgr         | s_address                                | s_phone         | s_comment                                                                                           |
+-----------+--------------------+--------------+-----------+----------------+------------------------------------------+-----------------+-----------------------------------------------------------------------------------------------------+
|   9973.93 | Supplier#000004194 | JORDAN       |     14193 | Manufacturer#1 | A8AoX9AK,qhf,CpEF                        | 23-944-413-2681 | t fluffily. regular requests about the regular, unusual somas play of the furiously busy            |
|   9956.34 | Supplier#000005108 | IRAN         |    140079 | Manufacturer#5 | d3PLCdpPP3uE4GzbbAh4bWmU 7ecOifL9e1mNnzG | 20-842-882-7047 | ronic accounts. carefully bold accounts sleep beyond                                                |
|   9836.43 | Supplier#000000489 | IRAN         |    190488 | Manufacturer#2 | y9NMoYGxDUPfrB1GwjYhLtCeV7pOt            | 20-375-500-2226 |  quickly carefully pending accounts. fina                                                           |
|   9825.95 | Supplier#000007554 | IRAQ         |     40041 | Manufacturer#5 | Huq0k qKET hByp3RcMcr                    | 21-787-637-9651 | ending, final requests thrash pending,                                                              |
|   9806.52 | Supplier#000005276 | IRAQ         |    132762 | Manufacturer#2 | inh0KOhRfLM7WRhdRNvJJDQx                 | 21-834-496-7360 | the slyly unusual theodolites; carefully even accounts use slyly. sl                                |
|   9796.31 | Supplier#000005847 | IRAQ         |    188292 | Manufacturer#1 | obol3bfh0zWi                             | 21-530-950-2847 | equests. blithely regular deposits should have to impress. final platelets integrate fluffily       |
|   9775.37 | Supplier#000007245 | IRAQ         |    169696 | Manufacturer#5 | 5VOUnvxlJeOJ                             | 21-663-724-2985 | ic deposits about the slyly bold requests                                                           |
|   9755.43 | Supplier#000002439 | EGYPT        |    172438 | Manufacturer#5 | rXxojWV0VefSK7A0dhF                      | 14-410-168-5354 | p quickly packages. carefully pending pinto beans after the                                         |
|   9714.60 | Supplier#000007317 | EGYPT        |     29810 | Manufacturer#4 | nJGsPl2ruoq4Ydtv0fwWG385eOFV6  VUokbCZ   | 14-666-351-2592 | ons integrate furiously? slyly ironic requests sl                                                   |
|   9557.33 | Supplier#000007367 | EGYPT        |    197366 | Manufacturer#3 | bTP8DLvaRAB0n                            | 14-234-934-5255 | ep slyly regular accounts-- regular, regular excuses dazzle furiously about the reg                 |
|   9538.15 | Supplier#000000979 | IRAN         |     55968 | Manufacturer#1 | cdvHjrKZR7iDlmSWU2a                      | 20-151-688-1408 | ckages cajole quietly carefully regular in                                                          |
|   9513.31 | Supplier#000004163 | SAUDI ARABIA |    109142 | Manufacturer#4 | 2VnQypC7pJPJRu6HzYRg7nAvhzckcYAQFbI      | 30-544-852-3772 | he regular requests. blithely final                                                                 |
|   9450.15 | Supplier#000002067 | EGYPT        |      9566 | Manufacturer#3 | 9dO68x0XLMCUDuFk1J6k9hpvLoKx 4qasok4lIb  | 14-252-246-5791 | rding to the regular dolphins. quickly ir                                                           |
|   9359.59 | Supplier#000005087 | JORDAN       |     55086 | Manufacturer#4 | q0c6r9wYVQx31IeGBZKfe                    | 23-335-392-5204 | osits. quickly regular packages haggle among the quickly silent ins                                 |
|   9343.35 | Supplier#000006337 | IRAN         |    173819 | Manufacturer#1 | ilQgNOdCAysclt3SgODb6LeJ7d4RzYD          | 20-950-345-8173 | quickly ironic packages affix aft                                                                   |
|   9318.47 | Supplier#000003834 | SAUDI ARABIA |     11332 | Manufacturer#5 | cxGQnW3nShks59xA5bPoaC bIvcBWUt          | 30-823-353-6520 | regular instructions. express packages run slyly pending                                            |
|   9318.47 | Supplier#000003834 | SAUDI ARABIA |    108813 | Manufacturer#2 | cxGQnW3nShks59xA5bPoaC bIvcBWUt          | 30-823-353-6520 | regular instructions. express packages run slyly pending                                            |
|   9315.33 | Supplier#000003009 | IRAN         |     40504 | Manufacturer#2 | oTbwfQ,Yfdcf3ysgc60NKtTpSIc              | 20-306-556-2450 | the carefully special requests. express instructions wake                                           |
|   9296.31 | Supplier#000008213 | JORDAN       |    163180 | Manufacturer#2 | YhdN9ESxYvhJp9ngr12Bbeo4t3zLPD,          | 23-197-507-9431 | g to the blithely regular accounts! deposit                                                         |
|   9284.57 | Supplier#000009781 | EGYPT        |      4780 | Manufacturer#4 | 49NAd1iDiY4,                             | 14-410-636-4312 | its. ironic pinto beans are blithely. express depths use caref                                      |
|   9261.13 | Supplier#000000664 | EGYPT        |    125639 | Manufacturer#5 | ln6wISAnC8Bpj q4V                        | 14-244-772-4913 | ly special foxes cajole slyly ironic reque                                                          |
|   9260.78 | Supplier#000001949 | IRAN         |     86932 | Manufacturer#2 | W79M2lpYiSY76Ujo6fSRUQiu                 | 20-531-767-2819 |  thinly ironic excuses haggle slyly. f                                                              |
|   9227.16 | Supplier#000009461 | EGYPT        |    126948 | Manufacturer#2 | Eweba 0sfaF,l4sAxXGTgEjzsJsNWWIGjYhFkRWV | 14-983-137-4957 | lly bold packages. carefully express deposits integrate about the unusual accounts. regular,        |
|   9185.89 | Supplier#000007888 | EGYPT        |     27887 | Manufacturer#1 | nq06Y48amPfS8YBuduy1RYu                  | 14-462-704-3828 | ole slyly-- blithely careful foxes wake against the furiously ironic accounts. pending ideas        |
|   9185.89 | Supplier#000007888 | EGYPT        |    190330 | Manufacturer#4 | nq06Y48amPfS8YBuduy1RYu                  | 14-462-704-3828 | ole slyly-- blithely careful foxes wake against the furiously ironic accounts. pending ideas        |
|   9132.92 | Supplier#000007878 | IRAN         |     92859 | Manufacturer#3 | aq6T3tUVq1,                              | 20-861-274-6282 |  waters cajole ironic, ironic requests. furi                                                        |
|   9058.94 | Supplier#000002789 | IRAN         |    142788 | Manufacturer#4 | 7EkIldjP7M6psSWcJ11tf65GT7ZC7UaiCh       | 20-842-716-4307 | s. platelets use carefully. busily regular accounts cajole fluffily above the slowly final pinto be |
|   9026.80 | Supplier#000005436 | SAUDI ARABIA |     92926 | Manufacturer#3 | 3HiusYZGYmHItExgX5VfNCdJwkW8W7R          | 30-453-280-6340 | . blithely unusual requests                                                                         |
|   9007.16 | Supplier#000001747 | EGYPT        |    121746 | Manufacturer#3 | UyDlFjVxanP,ifej7L5jtNaubC               | 14-141-360-9722 | maintain bravely across the busily express pinto beans. sometimes                                   |
|   8846.35 | Supplier#000005446 | EGYPT        |     57930 | Manufacturer#2 | Nusoq0ckv9SwnJZV8Rw2dUqE,V0ylm Bon       | 14-468-853-6477 | deposits. ironic, bold ideas wake. fluffily ironic deposits must have to sleep furiously pending    |
|   8837.21 | Supplier#000007210 | JORDAN       |    144695 | Manufacturer#3 | G7MYkWkkJDVu,rr23aXjQCwNqZ2Vk6           | 23-560-295-1805 | en, express foxes use across the blithely bold                                                      |
|   8800.91 | Supplier#000008182 | EGYPT        |    143153 | Manufacturer#5 | KGMyipBiAF00tSB99DwH                     | 14-658-338-3635 | thely even excuses integrate blithel                                                                |
|   8788.46 | Supplier#000003437 | IRAN         |    118414 | Manufacturer#4 | JfgZDO9fsP4ljfzsi,s7431Ld3A7zXtHfrF74    | 20-547-871-1712 | ickly unusual dependencies. carefully regular dolphins ha                                           |
|   8750.12 | Supplier#000001064 | IRAQ         |     31063 | Manufacturer#5 | QgmUIaEs5KpuW ,oREZV2b4wr3HEC1z4F        | 21-440-809-7599 | sly even deposits? furiously regular pack                                                           |
|   8594.80 | Supplier#000007553 | IRAN         |      5052 | Manufacturer#4 | wAU2Lui w9                               | 20-663-409-7956 | old, stealthy accounts are blithely. fluffily final                                                 |
|   8594.80 | Supplier#000007553 | IRAN         |    195033 | Manufacturer#1 | wAU2Lui w9                               | 20-663-409-7956 | old, stealthy accounts are blithely. fluffily final                                                 |
|   8588.63 | Supplier#000008094 | SAUDI ARABIA |    148093 | Manufacturer#1 | SNS6FCscBNZBFecA                         | 30-465-665-6735 | ake quickly blithely ironic theodolites. quickly ironic ideas boost. furiously iro                  |
|   8522.70 | Supplier#000004208 | IRAQ         |    166659 | Manufacturer#5 | x3jZYF7ZYN 8a4LY1c1kEsh                  | 21-468-998-1571 | furiously regular accounts!                                                                         |
|   8514.86 | Supplier#000006347 | JORDAN       |    181310 | Manufacturer#5 | wwR5j4kdIAwLe33uBwo                      | 23-340-942-3641 | uests breach blithely ironic deposi                                                                 |
|   8473.01 | Supplier#000003912 | IRAQ         |     33911 | Manufacturer#3 | Op7,1zt3MAxs34Qo4O W                     | 21-474-809-6508 | es. regular, brave instructions wa                                                                  |
|   8405.28 | Supplier#000007886 | IRAQ         |    192847 | Manufacturer#4 | sFTj5nzc5EIVmzjXwenFTXD U                | 21-735-778-5786 | ven dependencies boost blithely ironic de                                                           |
|   8375.58 | Supplier#000001259 | IRAQ         |     38755 | Manufacturer#2 | 32cJBGFFpGEkEjx1sF8JZAy0A72uXL5qU        | 21-427-422-4993 | ironic accounts haggle slyly alongside of the carefully ironic deposit                              |
|   8351.75 | Supplier#000007495 | IRAQ         |    114983 | Manufacturer#4 | 3jQQGvfs,5Aryhn0Z                        | 21-953-463-7239 |  requests. carefully final accounts after the qui                                                   |
|   8230.12 | Supplier#000001058 | SAUDI ARABIA |     68551 | Manufacturer#2 | fJ8egP,xkLygXGv8bmtc9T1FJ                | 30-496-504-3341 |  requests haggle? regular, regular pinto beans integrate fluffily. dependenc                        |
|   8195.44 | Supplier#000009805 | IRAQ         |      4804 | Manufacturer#4 | dTTmLRYJNat,JbhlQlxwWp HjMR              | 21-838-243-3925 | lets. quickly even theodolites dazzle slyly even a                                                  |
|   8175.17 | Supplier#000003172 | IRAN         |     55656 | Manufacturer#5 | 8ngbGS7BQoTDmJyMa5WV9XbaM31u5FAayd2vT3   | 20-834-374-7746 | ss deposits use furiously after the quickly final sentiments. fluffily ruthless ideas believe regu  |
|   8159.13 | Supplier#000007486 | EGYPT        |     17485 | Manufacturer#1 | AjfdzbrrJE1                              | 14-970-643-1521 | ld accounts. enticingly furious requests cajole. final packages s                                   |
|   8111.40 | Supplier#000007567 | IRAN         |    197566 | Manufacturer#1 | 7W4k2qEVoBkRehprGliXRSYVOQEh             | 20-377-181-7435 | gular foxes. silent attainments boost furiousl                                                      |
|   8046.55 | Supplier#000001625 | IRAQ         |     14121 | Manufacturer#2 | yKlKMbENR6bfmIu7aCFmbs                   | 21-769-404-7617 |  deposits. ideas boost blithely. slyly even Tiresias according to the platelets are q               |
|   8040.16 | Supplier#000001925 | SAUDI ARABIA |      4424 | Manufacturer#4 | Cu5Ub AAdXT                              | 30-969-417-1108 | pending packages across the regular req                                                             |
|   8031.68 | Supplier#000002370 | SAUDI ARABIA |    147341 | Manufacturer#5 | xGQB9xSPqRtCuMZaJavOrFuTY7km             | 30-373-388-2352 | dependencies. carefully express deposits use slyly among the slyly unusual pearls. dogge            |
|   8031.42 | Supplier#000008216 | IRAN         |     83199 | Manufacturer#2 | jsqlyr1ViAo                              | 20-224-305-7298 | to the carefully even excuses haggle blithely against the pending pinto be                          |
|   8007.83 | Supplier#000006266 | JORDAN       |     81249 | Manufacturer#1 | XWBf5Jd2V5SOurbn11Tt1                    | 23-363-445-7184 | as cajole carefully against the quickly special ac                                                  |
|   7995.78 | Supplier#000006957 | IRAN         |    161924 | Manufacturer#1 | 8lvRhU5xtXv                              | 20-312-173-2216 | ly ironic accounts. stealthily regular foxes about the blithely ironic requests play blithely abo   |
|   7913.40 | Supplier#000003148 | JORDAN       |     58137 | Manufacturer#1 | CpCJWI4PHeiwYuq0                         | 23-767-770-9172 | ove the quickly final packages boost fluffily among the furiously final platelets. carefully s      |
|   7910.16 | Supplier#000002102 | IRAQ         |     99592 | Manufacturer#2 | 1kuyUn5q6czLOGB60fAVgpv68M2suwchpmp2nK   | 21-367-198-9930 |  accounts after the blithely                                                                        |
|   7893.58 | Supplier#000000918 | SAUDI ARABIA |     13414 | Manufacturer#1 | e0sB7xAU3,cWF7pzXrpIbATUNydCUZup         | 30-303-831-1662 | ependencies wake carefull                                                                           |
|   7885.17 | Supplier#000004001 | JORDAN       |     38994 | Manufacturer#2 | 3M39sZY1XeQXPDRO                         | 23-109-632-6806 | efully express packages integrate across the regular pearls. blithely unusual packages mainta       |
|   7880.20 | Supplier#000005352 | JORDAN       |       351 | Manufacturer#3 | PP9gHTn946hXqUF5E7idIPLkhnN              | 23-557-756-7951 | egular frays. final instructions sleep a                                                            |
|   7844.31 | Supplier#000006987 | IRAQ         |     44482 | Manufacturer#5 | UH1zBxTNjTminnmHRe h YUT1eR              | 21-963-444-7397 | nag quickly carefully regular requests. ironic theo                                                 |
|   7812.27 | Supplier#000006967 | SAUDI ARABIA |    151936 | Manufacturer#4 | S4i1HfrSM4m3di3R9Cxxp59M1                | 30-193-457-6365 | ely. dependencies cajole quickly. final warhorses across the furiously ironic foxes integr          |
|   7767.63 | Supplier#000004306 | IRAN         |     31802 | Manufacturer#2 | SkZkJZflW5mDg9wL fJ                      | 20-911-180-1895 | uickly regular ideas. blithely express accounts along the carefully sile                            |
|   7741.42 | Supplier#000000899 | IRAQ         |     53383 | Manufacturer#5 | oLlkiVghtro IwzcwFuzwMCG94rRpux          | 21-980-994-3905 | equests wake quickly special, express accounts. courts promi                                        |
|   7741.42 | Supplier#000000899 | IRAQ         |    105878 | Manufacturer#3 | oLlkiVghtro IwzcwFuzwMCG94rRpux          | 21-980-994-3905 | equests wake quickly special, express accounts. courts promi                                        |
|   7741.10 | Supplier#000001059 | IRAN         |    103528 | Manufacturer#4 | 4tBenOMokWbWVRB8i8HwENeO cQjM9           | 20-620-710-8984 |  to the carefully special courts.                                                                   |
|   7599.20 | Supplier#000006596 | SAUDI ARABIA |    184077 | Manufacturer#2 | k8qeFxfXKIGYdQ82RXAfCwddSrc              | 30-804-947-3851 | ously unusual deposits boost carefully after the enticing                                           |
|   7598.31 | Supplier#000008857 | IRAQ         |     63844 | Manufacturer#4 | dP2th8vneyOLIUFwNBwqixkFD6               | 21-691-170-4769 | s. quickly ironic frays detect carefully                                                            |
|   7591.79 | Supplier#000009723 | JORDAN       |    104702 | Manufacturer#2 | Q1CkkpDdlLOpCJiV,zIf,Mv86otWhxj7slGc     | 23-710-907-3873 | e fluffily even instructions. packages impress enticingly.                                          |
|   7575.12 | Supplier#000007557 | IRAQ         |     77556 | Manufacturer#1 | udLvpjNvIx9qeRNdjL1ZAO0OZNOBo6h          | 21-629-935-9941 | ally special accounts nod; f                                                                        |
|   7496.91 | Supplier#000005828 | IRAN         |    103317 | Manufacturer#1 | Xt0EqDCNU6X00sNsIO7nd0ws3H               | 20-435-850-8703 | furiously about the fluffily careful idea                                                           |
|   7472.88 | Supplier#000004204 | EGYPT        |     14203 | Manufacturer#1 | 0rGZJ6VZXdH                              | 14-520-667-4690 | y pending pinto beans. even, final requests sleep care                                              |
|   7472.88 | Supplier#000004204 | EGYPT        |    161687 | Manufacturer#3 | 0rGZJ6VZXdH                              | 14-520-667-4690 | y pending pinto beans. even, final requests sleep care                                              |
|   7467.63 | Supplier#000003270 | IRAN         |     45757 | Manufacturer#2 | 7j4n5FnNEHVJxFhiyz                       | 20-450-599-9591 | regular, even instructions boost deposits                                                           |
|   7465.41 | Supplier#000008686 | EGYPT        |    188685 | Manufacturer#4 | 4Onf4yxuNwHCRIC0y                        | 14-454-946-4151 | ly final ideas. bravely unusual deposits doze carefully. expr                                       |
|   7460.80 | Supplier#000008701 | IRAQ         |     83684 | Manufacturer#3 | PLR2QehcW08                              | 21-747-984-4244 | ideas use carefully pending, final deposits. ironic, pe                                             |
|   7447.86 | Supplier#000005877 | JORDAN       |    120852 | Manufacturer#2 | EyqOHClZZMJkq grnOX9 4alZx6P7B2fq        | 23-419-288-6451 | lar pinto beans breach carefully final pinto                                                        |
|   7445.03 | Supplier#000009802 | IRAQ         |    164769 | Manufacturer#5 | y6wLN KiZuTf5HT9Hbm0BELn1GUTD6yl         | 21-116-708-2013 | nic requests. pinto beans across the carefully regular grouches snooze among the final pin          |
|   7401.46 | Supplier#000008677 | IRAN         |    123652 | Manufacturer#5 | WNa780JZzivxuGBEsDszqoT1Pj               | 20-899-256-5288 | onic instructions along the furiously ironic accounts haggle fluffily silently un                   |
|   7393.50 | Supplier#000007056 | IRAQ         |     54550 | Manufacturer#1 | M5cAJQvW9D5zwC7o2qkoe                    | 21-175-383-4727 | slyly even requests. forges haggle boldly express requests. furio                                   |
|   7376.11 | Supplier#000003982 | IRAQ         |    118959 | Manufacturer#1 | jx9EloF33Ez                              | 21-890-236-4160 | s the furiously special warhorses affix after the car                                               |
|   7264.42 | Supplier#000001565 | IRAQ         |     14061 | Manufacturer#4 | bOwKHdBteMkZoZcxdigk4Tnu07w1gDztmV7hvCw  | 21-791-273-8592 | to beans. express accounts nag around the                                                           |
|   7256.46 | Supplier#000009116 | IRAQ         |      4115 | Manufacturer#3 | ULjaQwNbcB XUG9dvbZDHvJVwLo08utswt       | 21-241-469-8343 | ending deposits. slyly ironic dependencies breach. blithely speci                                   |
|   7256.46 | Supplier#000009116 | IRAQ         |     99115 | Manufacturer#1 | ULjaQwNbcB XUG9dvbZDHvJVwLo08utswt       | 21-241-469-8343 | ending deposits. slyly ironic dependencies breach. blithely speci                                   |
|   7256.46 | Supplier#000009116 | IRAQ         |    131576 | Manufacturer#4 | ULjaQwNbcB XUG9dvbZDHvJVwLo08utswt       | 21-241-469-8343 | ending deposits. slyly ironic dependencies breach. blithely speci                                   |
|   7254.81 | Supplier#000005664 | EGYPT        |     35663 | Manufacturer#2 | b8VWuTXRt66wF9bfrgTmNGuxf1PU0x3O9e       | 14-214-171-8987 | ts across the quickly pending pin                                                                   |
|   7186.63 | Supplier#000006958 | IRAN         |     71943 | Manufacturer#4 | 0n9BD,gRzUc3B,PsFcxDBGp4BFf4P            | 20-185-413-5590 | against the instructions. requests are. speci                                                       |
|   7166.36 | Supplier#000003541 | EGYPT        |    116007 | Manufacturer#1 | DbwyOxoaMEdhEtIB3y045QrKCi2fQpGRu,       | 14-508-763-1850 | ages. carefully unusual requests across the pending instructions aff                                |
|   7128.81 | Supplier#000000677 | JORDAN       |     50676 | Manufacturer#4 | 8mhrffG7D2WJBSQbOGstQ                    | 23-290-639-3315 | nder blithely. slyly unusual theod                                                                  |
|   7051.73 | Supplier#000003349 | IRAQ         |    125812 | Manufacturer#3 | wtTK9df9kY7mQ5QUM0Xe5bHLMRLgwE           | 21-614-525-7451 | ar theodolites cajole fluffily across the pending requests. slyly final requests a                  |
|   7023.47 | Supplier#000009543 | SAUDI ARABIA |     47038 | Manufacturer#1 | VYKinyOBNXRr Hdqn8kOxfTw                 | 30-785-782-6088 | sts. furiously pending packages sleep slyly even requests. final excuses print deposits. final pac  |
|   6985.93 | Supplier#000006409 | IRAQ         |    131382 | Manufacturer#1 | eO8JDNM19HrlQMR                          | 21-627-356-3992 | sts. slyly final deposits around the regular accounts are along the furiously final pac             |
|   6964.75 | Supplier#000009931 | EGYPT        |     57425 | Manufacturer#1 | peQYiRFk G0xZKfJ                         | 14-989-166-5782 | deposits according to the sometimes silent requests wake along the packages-- blithely f            |
|   6964.04 | Supplier#000007399 | IRAQ         |     77398 | Manufacturer#2 | zdxjENOGR4QiCFP                          | 21-859-733-1999 | e blithely after the even requests. carefully ironic packages use slyly a                           |
|   6913.81 | Supplier#000002625 | IRAQ         |     22624 | Manufacturer#3 | a4V0rWemgbsT ZMj w7DB8rUbZ4F4lqqW5VKljQF | 21-136-564-3910 | . asymptotes among the express requests cajole furiously after the ca                               |
|   6880.18 | Supplier#000006704 | IRAN         |     26703 | Manufacturer#4 | 97rxJlAImbO1 sUlChUWoOJ0ZzvQ2NI3KI6VDOwk | 20-588-916-1286 | old accounts wake quickly. ca                                                                       |
|   6878.62 | Supplier#000001697 | IRAQ         |    146668 | Manufacturer#5 | 37nm ODTeHy0xWTWegplgdWQqelh             | 21-377-544-4864 | ironic theodolites. furiously regular d                                                             |
|   6790.39 | Supplier#000008703 | IRAN         |    123678 | Manufacturer#4 | wMslK1A8SEUTIIdApQ                       | 20-782-266-2552 | eep blithely regular, pending w                                                                     |
|   6763.46 | Supplier#000007882 | EGYPT        |    137881 | Manufacturer#5 | JDv8BZiYG0UlZ                            | 14-111-252-9120 |  the silent accounts wake foxes. furious                                                            |
|   6751.81 | Supplier#000003156 | EGYPT        |    165607 | Manufacturer#2 | alRWaW4FTFERMM4vf2rHKIKE                 | 14-843-946-7775 |  are furiously. final theodolites affix slyly bold deposits. even packages haggle idly slyly specia |
|   6702.07 | Supplier#000006276 | EGYPT        |     31269 | Manufacturer#2 | ,dE1anEjKQGZfgquYfkx2fkGcXH              | 14-896-626-7847 | ze about the carefully regular pint                                                                 |
+-----------+--------------------+--------------+-----------+----------------+------------------------------------------+-----------------+-----------------------------------------------------------------------------------------------------+
100 rows in set (0.11 sec)

Q3
+------------+-------------+-------------+----------------+
| l_orderkey | revenue     | o_orderdate | o_shippriority |
+------------+-------------+-------------+----------------+
|    2152675 | 431309.8065 | 1995-03-28  |              0 |
|    4994400 | 423834.7976 | 1995-03-09  |              0 |
|    2160291 | 401149.7805 | 1995-03-18  |              0 |
|    2845094 | 401094.1393 | 1995-03-06  |              0 |
|    1902471 | 400497.3847 | 1995-03-01  |              0 |
|    5624358 | 395710.6806 | 1995-03-20  |              0 |
|    2346242 | 392580.0394 | 1995-03-17  |              0 |
|    2529826 | 387365.1560 | 1995-02-17  |              0 |
|    5168933 | 385433.6198 | 1995-03-20  |              0 |
|    2839239 | 380503.7310 | 1995-03-22  |              0 |
+------------+-------------+-------------+----------------+
10 rows in set

Q4
+-----------------+-------------+
| o_orderpriority | order_count |
+-----------------+-------------+
| 1-URGENT        |       10623 |
| 2-HIGH          |       10465 |
| 3-MEDIUM        |       10309 |
| 4-NOT SPECIFIED |       10618 |
| 5-LOW           |       10541 |
+-----------------+-------------+
5 rows in set

Q5
+---------------+---------------+
| n_name        | revenue       |
+---------------+---------------+
| PERU          | 56206762.5035 |
| CANADA        | 56052846.0161 |
| ARGENTINA     | 54595012.8076 |
| BRAZIL        | 53601776.5201 |
| UNITED STATES | 50890580.8962 |
+---------------+---------------+
5 rows in set

Q6
+---------------+
| revenue       |
+---------------+
| 61660051.7967 |
+---------------+

Q7
+-------------+-------------+--------+---------------+
| supp_nation | cust_nation | l_year | revenue       |
+-------------+-------------+--------+---------------+
| ARGENTINA   | FRANCE      |   1995 | 57928886.8015 |
| ARGENTINA   | FRANCE      |   1996 | 55535134.8474 |
| FRANCE      | ARGENTINA   |   1995 | 52916227.7375 |
| FRANCE      | ARGENTINA   |   1996 | 51077995.8841 |
+-------------+-------------+--------+---------------+
4 rows in set

Q8
+--------+----------------------+
| o_year | mkt_share            |
+--------+----------------------+
|   1995 | 0.035094304475112484 |
|   1996 |  0.03724375099464825 |
+--------+----------------------+
2 rows in set

Q9
+----------------+--------+---------------+
| nation         | o_year | sum_profit    |
+----------------+--------+---------------+
| ALGERIA        |   1998 | 29931671.4862 |
| ALGERIA        |   1997 | 49521023.1139 |
| ALGERIA        |   1996 | 51283603.7356 |
| ALGERIA        |   1995 | 50206939.3447 |
| ALGERIA        |   1994 | 48738988.5891 |
| ALGERIA        |   1993 | 48084070.1204 |
| ALGERIA        |   1992 | 49725592.1793 |
| ARGENTINA      |   1998 | 26407044.9262 |
| ARGENTINA      |   1997 | 46224601.0785 |
| ARGENTINA      |   1996 | 44579611.0571 |
| ARGENTINA      |   1995 | 45081953.2540 |
| ARGENTINA      |   1994 | 48291282.8512 |
| ARGENTINA      |   1993 | 48063838.9130 |
| ARGENTINA      |   1992 | 45277890.2991 |
| BRAZIL         |   1998 | 28577022.6384 |
| BRAZIL         |   1997 | 46808660.3688 |
| BRAZIL         |   1996 | 47119265.0765 |
| BRAZIL         |   1995 | 47706399.9100 |
| BRAZIL         |   1994 | 48377469.9386 |
| BRAZIL         |   1993 | 46933565.7471 |
| BRAZIL         |   1992 | 47272215.5408 |
| CANADA         |   1998 | 30500303.6521 |
| CANADA         |   1997 | 50046257.5687 |
| CANADA         |   1996 | 52638586.9029 |
| CANADA         |   1995 | 50433911.3289 |
| CANADA         |   1994 | 51605251.7124 |
| CANADA         |   1993 | 50117218.8464 |
| CANADA         |   1992 | 50347111.2789 |
| CHINA          |   1998 | 26956001.9487 |
| CHINA          |   1997 | 48311246.7866 |
| CHINA          |   1996 | 51133929.1033 |
| CHINA          |   1995 | 48024289.1049 |
| CHINA          |   1994 | 50027433.6557 |
| CHINA          |   1993 | 48240226.3801 |
| CHINA          |   1992 | 47769117.6007 |
| EGYPT          |   1998 | 26972573.1604 |
| EGYPT          |   1997 | 46708654.7666 |
| EGYPT          |   1996 | 46095050.4457 |
| EGYPT          |   1995 | 44901908.2949 |
| EGYPT          |   1994 | 48522762.8892 |
| EGYPT          |   1993 | 49055807.7642 |
| EGYPT          |   1992 | 46909796.1083 |
| ETHIOPIA       |   1998 | 26364411.6457 |
| ETHIOPIA       |   1997 | 44889623.0645 |
| ETHIOPIA       |   1996 | 47554295.2892 |
| ETHIOPIA       |   1995 | 44747639.5440 |
| ETHIOPIA       |   1994 | 46497570.0631 |
| ETHIOPIA       |   1993 | 43853718.5460 |
| ETHIOPIA       |   1992 | 44005773.0397 |
| FRANCE         |   1998 | 27033406.6353 |
| FRANCE         |   1997 | 45763555.5515 |
| FRANCE         |   1996 | 47178544.9301 |
| FRANCE         |   1995 | 48821282.1929 |
| FRANCE         |   1994 | 46444640.9397 |
| FRANCE         |   1993 | 46602311.0590 |
| FRANCE         |   1992 | 47769356.5113 |
| GERMANY        |   1998 | 26165681.8305 |
| GERMANY        |   1997 | 46600844.4431 |
| GERMANY        |   1996 | 44873520.1979 |
| GERMANY        |   1995 | 47761215.6058 |
| GERMANY        |   1994 | 42283120.0209 |
| GERMANY        |   1993 | 46954873.9820 |
| GERMANY        |   1992 | 46263626.6361 |
| INDIA          |   1998 | 27651103.0250 |
| INDIA          |   1997 | 46000888.8340 |
| INDIA          |   1996 | 43993476.7354 |
| INDIA          |   1995 | 44015709.1914 |
| INDIA          |   1994 | 44281439.6282 |
| INDIA          |   1993 | 45367255.7857 |
| INDIA          |   1992 | 45350810.5330 |
| INDONESIA      |   1998 | 27120545.3120 |
| INDONESIA      |   1997 | 45745362.3667 |
| INDONESIA      |   1996 | 45347554.8232 |
| INDONESIA      |   1995 | 45685709.4978 |
| INDONESIA      |   1994 | 44738603.1901 |
| INDONESIA      |   1993 | 45172063.2033 |
| INDONESIA      |   1992 | 44623924.3942 |
| IRAN           |   1998 | 27876287.0949 |
| IRAN           |   1997 | 47184621.5647 |
| IRAN           |   1996 | 47397859.7878 |
| IRAN           |   1995 | 49579120.6991 |
| IRAN           |   1994 | 48032316.8744 |
| IRAN           |   1993 | 48295593.2066 |
| IRAN           |   1992 | 50531453.3934 |
| IRAQ           |   1998 | 29997323.2927 |
| IRAQ           |   1997 | 52851471.1377 |
| IRAQ           |   1996 | 53671825.6297 |
| IRAQ           |   1995 | 53251012.1025 |
| IRAQ           |   1994 | 50934553.4361 |
| IRAQ           |   1993 | 51961214.1186 |
| IRAQ           |   1992 | 50840364.3833 |
| JAPAN          |   1998 | 26054615.4955 |
| JAPAN          |   1997 | 43557394.2595 |
| JAPAN          |   1996 | 46531743.0980 |
| JAPAN          |   1995 | 41688293.4741 |
| JAPAN          |   1994 | 45526719.0728 |
| JAPAN          |   1993 | 45619475.4478 |
| JAPAN          |   1992 | 44545639.3069 |
| JORDAN         |   1998 | 24793092.4101 |
| JORDAN         |   1997 | 42050730.7748 |
| JORDAN         |   1996 | 42562783.8663 |
| JORDAN         |   1995 | 42253019.5330 |
| JORDAN         |   1994 | 45027034.7721 |
| JORDAN         |   1993 | 44797510.9808 |
| JORDAN         |   1992 | 41313405.2890 |
| KENYA          |   1998 | 24550926.4693 |
| KENYA          |   1997 | 42767120.5848 |
| KENYA          |   1996 | 45000095.1105 |
| KENYA          |   1995 | 43250458.0109 |
| KENYA          |   1994 | 42891596.7158 |
| KENYA          |   1993 | 43599201.5126 |
| KENYA          |   1992 | 45286145.8141 |
| MOROCCO        |   1998 | 23482053.5970 |
| MOROCCO        |   1997 | 41503033.0020 |
| MOROCCO        |   1996 | 45645555.9409 |
| MOROCCO        |   1995 | 44462858.7689 |
| MOROCCO        |   1994 | 44768368.8310 |
| MOROCCO        |   1993 | 44611871.2477 |
| MOROCCO        |   1992 | 43057959.1352 |
| MOZAMBIQUE     |   1998 | 28824737.9244 |
| MOZAMBIQUE     |   1997 | 48682746.5995 |
| MOZAMBIQUE     |   1996 | 50816940.9909 |
| MOZAMBIQUE     |   1995 | 50010039.0178 |
| MOZAMBIQUE     |   1994 | 48794892.1253 |
| MOZAMBIQUE     |   1993 | 48451128.3332 |
| MOZAMBIQUE     |   1992 | 50113858.5449 |
| PERU           |   1998 | 30575758.1899 |
| PERU           |   1997 | 49323405.6808 |
| PERU           |   1996 | 50063490.6085 |
| PERU           |   1995 | 51272843.6555 |
| PERU           |   1994 | 50690589.2334 |
| PERU           |   1993 | 49086129.3668 |
| PERU           |   1992 | 50067216.3450 |
| ROMANIA        |   1998 | 27367992.9903 |
| ROMANIA        |   1997 | 45668932.7094 |
| ROMANIA        |   1996 | 46594220.7498 |
| ROMANIA        |   1995 | 44576835.1623 |
| ROMANIA        |   1994 | 45640971.0684 |
| ROMANIA        |   1993 | 46374545.0712 |
| ROMANIA        |   1992 | 47130533.3076 |
| RUSSIA         |   1998 | 27486839.8755 |
| RUSSIA         |   1997 | 44050712.6907 |
| RUSSIA         |   1996 | 45604597.4983 |
| RUSSIA         |   1995 | 48972490.6009 |
| RUSSIA         |   1994 | 45652045.5872 |
| RUSSIA         |   1993 | 47139548.1597 |
| RUSSIA         |   1992 | 47159990.1221 |
| SAUDI ARABIA   |   1998 | 29766229.7961 |
| SAUDI ARABIA   |   1997 | 51473031.6922 |
| SAUDI ARABIA   |   1996 | 52859666.6646 |
| SAUDI ARABIA   |   1995 | 50946175.0229 |
| SAUDI ARABIA   |   1994 | 53085288.9954 |
| SAUDI ARABIA   |   1993 | 50907571.2046 |
| SAUDI ARABIA   |   1992 | 50334063.0381 |
| UNITED KINGDOM |   1998 | 27904712.8220 |
| UNITED KINGDOM |   1997 | 48170994.4362 |
| UNITED KINGDOM |   1996 | 46498116.9611 |
| UNITED KINGDOM |   1995 | 43210619.0456 |
| UNITED KINGDOM |   1994 | 47339709.9122 |
| UNITED KINGDOM |   1993 | 44308436.3275 |
| UNITED KINGDOM |   1992 | 45870809.6693 |
| UNITED STATES  |   1998 | 25856187.3719 |
| UNITED STATES  |   1997 | 44934753.2208 |
| UNITED STATES  |   1996 | 44826974.2915 |
| UNITED STATES  |   1995 | 44160425.4086 |
| UNITED STATES  |   1994 | 43193241.6843 |
| UNITED STATES  |   1993 | 45126307.2619 |
| UNITED STATES  |   1992 | 44205926.3317 |
| VIETNAM        |   1998 | 28289193.6726 |
| VIETNAM        |   1997 | 48284585.4019 |
| VIETNAM        |   1996 | 48360225.9084 |
| VIETNAM        |   1995 | 48742082.6165 |
| VIETNAM        |   1994 | 49035537.3894 |
| VIETNAM        |   1993 | 47222674.6352 |
| VIETNAM        |   1992 | 48628336.9011 |
+----------------+--------+---------------+
175 rows in set

Q10
+-----------+--------------------+-------------+-----------+----------------+------------------------------------------+-----------------+-----------------------------------------------------------------------------------------------------------------+
| c_custkey | c_name             | revenue     | c_acctbal | n_name         | c_address                                | c_phone         | c_comment                                                                                                       |
+-----------+--------------------+-------------+-----------+----------------+------------------------------------------+-----------------+-----------------------------------------------------------------------------------------------------------------+
|     95962 | Customer#000095962 | 704336.0774 |     -9.33 | MOZAMBIQUE     | 83wOMt9iAb9OJ0HbkQ1PaX3odXVBNEIMXaE      | 26-127-693-7436 | nusual theodolites maintain furiously fluffily iro                                                              |
|     87064 | Customer#000087064 | 684037.4349 |   5244.68 | BRAZIL         | 0xej6ldT8zi7MwLdDJ1II3YWwprkvwB1 I0kwsf  | 12-930-206-2571 | de of the ironic, silent warthogs. bold, r                                                                      |
|     56416 | Customer#000056416 | 661218.0492 |   4303.82 | INDIA          | CEuBN,xZVmP                              | 18-212-984-8331 | al waters cajole along the slyly unusual dugouts. carefully regular deposits use slyly? packages h              |
|     46450 | Customer#000046450 | 646205.6835 |   2400.59 | UNITED STATES  | rzWQxB9iFpd8i4KUCAPdv                    | 34-765-320-4326 | ss, final deposits cajole sly                                                                                   |
|    128713 | Customer#000128713 | 643240.1183 |   7200.30 | ARGENTINA      | mm0kxtHFCchaZX4eYSCCyQHno7vq,SRmv4       | 11-174-994-6880 | ording to the express accounts cajole carefully across the bravely special packages. carefully regular account  |
|    102187 | Customer#000102187 | 637493.0787 |   -896.03 | ETHIOPIA       | EAi6vcGnWHUMb6rJwn,PtUgSH74tR Aixa       | 15-877-462-6534 | gular packages. carefully regular deposits cajole carefully of the regular requests. carefully special accou    |
|     42541 | Customer#000042541 | 634546.9756 |   8082.14 | IRAN           | IccOGHgp8g                               | 20-442-159-1337 | cross the final asymptotes. final packages wake furiously ironic dec                                            |
|     51595 | Customer#000051595 | 611926.8265 |   7236.80 | UNITED STATES  | wQFWZk 7JCpeg50O0KCzSmUFnNNwX1aEQ7V3Q    | 34-844-269-9070 | sts. always express accounts use carefully along the quickly speci                                              |
|     66391 | Customer#000066391 | 608385.5852 |   9404.57 | UNITED STATES  | V0XvU1Nh9NU4zsyOkm,RBa                   | 34-149-224-8119 | ages cajole carefully carefully bold deposits: fluffily unusual deposits promise slyly carefully ironic co      |
|     48358 | Customer#000048358 | 603621.4823 |   -611.15 | ETHIOPIA       | ycg3uMG7iDdwQvJ1irr                      | 15-687-936-5181 | the slyly unusual foxes-- carefully regular                                                                     |
|     99175 | Customer#000099175 | 602125.3304 |   2218.76 | INDONESIA      | 9wbW52xx9T84E0dZ Rvz1ozQ1                | 19-125-912-6494 | ide of the slyly ironic foxes boost silently ironic, even instructions. blithe                                  |
|    122509 | Customer#000122509 | 601580.1203 |   2613.83 | KENYA          | ZN1sc0eJrkD8t6X5Q1d3                     | 24-421-308-3881 | brave deposits haggle across the even deposits. instr                                                           |
|    148055 | Customer#000148055 | 601003.6812 |    455.31 | PERU           | Y,RCZ3Bislx64nTsPaRL,5gjx7xgC6y, yKYnCw  | 27-473-476-4382 | uickly final accounts wake carefully sl                                                                         |
|    117451 | Customer#000117451 | 599792.7063 |   1090.48 | UNITED STATES  | bSwr7mNPiaf1f lNK9 uTJxWCL2sn1Lak5NIB    | 34-354-586-6011 | ding to the furiously express accounts boost carefully af                                                       |
|    104110 | Customer#000104110 | 588194.3118 |   2762.52 | JORDAN         | mm7 ZuDX5Z5nAQbKObB 80XBCy,1nyW          | 23-639-800-5768 | urts sleep furiously alongside of the packages! slyly ironic packages sleep                                     |
|     13666 | Customer#000013666 | 579926.1679 |   7453.98 | EGYPT          | DLRUWGcprmWqdROJvmZwpE                   | 14-316-135-4381 | ross the silent requests. special theodolit                                                                     |
|     96202 | Customer#000096202 | 571017.3398 |   4703.04 | CANADA         | 4Vcxcx3w4zMjVYNQaqrweweQY6TJO AP9rdvQaLl | 13-194-779-9597 | en packages use. fluffily regular dependencies boost. never pending requ                                        |
|     70279 | Customer#000070279 | 561369.3650 |   9109.34 | CHINA          | ltie8o3ihwffMrqMrkvN957KZVWmH5           | 28-842-825-1717 | theodolites sleep: blithely final requests are fur                                                              |
|     16972 | Customer#000016972 | 560435.8065 |   6408.66 | ROMANIA        | X6T8vRKy6kSO0f2wJJt                      | 29-483-958-3347 | sts. pending deposits are across the regular, express instructions. carefully daring foxes cajol                |
|    113443 | Customer#000113443 | 557272.6706 |    -72.67 | UNITED KINGDOM | SUHbS85cYxgVkKbfh9sUpEa6ezVSlQuCKe3CV    | 33-819-742-6112 | ic foxes cajole thinly furiously stealthy instructions. pinto beans are. quickly regular accounts integrate car |
+-----------+--------------------+-------------+-----------+----------------+------------------------------------------+-----------------+-----------------------------------------------------------------------------------------------------------------+
20 rows in set

Q11
+------------+-------------+
| ps_partkey | value       |
+------------+-------------+
|     131630 | 17882680.37 |
|     104150 | 17613017.18 |
|     128284 | 16502418.74 |
|       8978 | 16470438.59 |
|     147193 | 16462742.12 |
|      78788 | 16010246.37 |
|      76331 | 15776882.05 |
|     137287 | 15770471.15 |
|      51302 | 15730620.22 |
|     141553 | 15333540.19 |
|     137196 | 15035435.60 |
|     186531 | 14818272.68 |
|     103818 | 14690943.63 |
|      80080 | 14626441.35 |
|       1312 | 14330729.50 |
|       6531 | 14267308.08 |
|      96162 | 14154396.04 |
|      69605 | 14018927.25 |
|      30118 | 13854726.38 |
|      17006 | 13731495.60 |
|      95347 | 13716648.60 |
|      18722 | 13707978.71 |
|     122875 | 13640341.00 |
|     105499 | 13532912.80 |
|     165560 | 13509536.95 |
|       1531 | 13337454.55 |
|      34732 | 13304041.48 |
|     173221 | 13038078.41 |
|     180975 | 13038039.17 |
|      24703 | 12957050.80 |
|      72036 | 12939426.90 |
|     124814 | 12849842.04 |
|     174453 | 12814999.00 |
|      14209 | 12814858.56 |
|     185186 | 12657201.05 |
|     187868 | 12647101.80 |
|     125085 | 12639931.63 |
|      80331 | 12625007.00 |
|     118685 | 12515185.68 |
|     163988 | 12484272.80 |
|     124685 | 12432747.32 |
|      92838 | 12410071.57 |
|     140928 | 12396673.84 |
|       1218 | 12362877.75 |
|      39201 | 12328085.10 |
|      33237 | 12180622.98 |
|     183791 | 12150040.50 |
|       3243 | 12136315.74 |
|      62740 | 12131313.60 |
|     154171 | 12105470.89 |
|      49034 | 11982382.52 |
|      88673 | 11925499.04 |
|      52527 | 11923653.16 |
|      83974 | 11871084.73 |
|      88254 | 11870393.22 |
|        411 | 11806670.95 |
|      14320 | 11800136.02 |
|     164979 | 11794760.03 |
|     166149 | 11778499.72 |
|      74105 | 11750224.34 |
|     169104 | 11708532.18 |
|      15542 | 11687293.42 |
|     161538 | 11661769.80 |
|      63337 | 11592505.40 |
|     117197 | 11508165.60 |
|     102989 | 11497056.75 |
|      10836 | 11465875.43 |
|     199561 | 11431793.36 |
|     134683 | 11384564.54 |
|     136318 | 11351893.30 |
|     166270 | 11336004.81 |
|      32200 | 11324838.00 |
|      57033 | 11281026.52 |
|      18098 | 11245398.24 |
|     135174 | 11189782.12 |
|     181616 | 11183947.65 |
|      85064 | 11175761.43 |
|     120719 | 11164342.08 |
|      99670 | 11140257.47 |
|      46096 | 11034143.76 |
|     195124 | 11030197.30 |
|      78838 | 11012446.40 |
|     151656 | 11010376.90 |
|     156956 | 10996384.80 |
|      34028 | 10942671.24 |
|      15778 | 10937778.75 |
|     199707 | 10924333.33 |
|     118776 | 10920609.31 |
|      27640 | 10919693.42 |
|      15237 | 10918145.54 |
|     148243 | 10916765.29 |
|     111498 | 10867707.51 |
|     132024 | 10834280.47 |
|      35124 | 10806898.50 |
|     196818 | 10787371.25 |
|     197669 | 10779504.60 |
|     110042 | 10778828.37 |
|     197422 | 10770092.44 |
|      75160 | 10746976.60 |
|     191567 | 10642430.39 |
|      34225 | 10574664.41 |
|     102588 | 10567012.05 |
|      44148 | 10505249.34 |
|     126607 | 10484944.29 |
|     172625 | 10444857.62 |
|     157054 | 10406203.24 |
|      19322 | 10378704.98 |
|     136541 | 10371536.77 |
|     167526 | 10320346.58 |
|     136011 | 10302146.84 |
|     107431 | 10273992.76 |
|      16485 | 10257703.67 |
|      52580 | 10250264.05 |
|        839 | 10238243.36 |
|      31704 | 10196678.94 |
|     122558 | 10137326.18 |
|     180386 | 10123318.07 |
|      97705 | 10089163.37 |
|      96327 | 10087851.88 |
|     136143 | 10082137.97 |
|      15174 | 10057277.55 |
|     193324 | 10039922.93 |
|      33593 | 10019952.10 |
|     126288 | 10014855.05 |
|      64123 |  9985650.90 |
|     183712 |  9973256.18 |
|     138831 |  9963069.10 |
|     123694 |  9959096.38 |
|      51734 |  9952439.73 |
|      11861 |  9949647.12 |
|     119127 |  9942105.69 |
|     173308 |  9932264.52 |
|      40986 |  9921554.40 |
|     176970 |  9919708.65 |
|      54316 |  9913595.16 |
|      62644 |  9903936.27 |
|     185354 |  9895956.52 |
|      81468 |  9885132.60 |
|     104687 |  9883888.05 |
|     198959 |  9875351.28 |
|     179767 |  9872309.86 |
|     102835 |  9870743.52 |
|     163221 |  9856173.04 |
|      32633 |  9852565.04 |
|      19605 |  9850164.48 |
|      47378 |  9826135.11 |
|      44026 |  9822433.44 |
|     126629 |  9816227.30 |
|     199665 |  9812400.23 |
|      30989 |  9812295.52 |
|     102177 |  9810372.32 |
|      25765 |  9806344.88 |
|     110721 |  9804895.23 |
|     159532 |  9803738.34 |
|     101640 |  9801375.65 |
|     151569 |  9792489.20 |
|     180629 |  9782164.34 |
|     165528 |  9769074.10 |
|      23772 |  9766084.22 |
|     149727 |  9765190.96 |
|     189605 |  9761887.80 |
|      74703 |  9758757.28 |
|      83382 |  9758144.21 |
|      93775 |  9726901.71 |
|      56192 |  9725508.16 |
|      50060 |  9712714.65 |
|      15409 |  9706898.91 |
|     139104 |  9701070.72 |
|     177435 |  9686566.09 |
|      31351 |  9675197.98 |
|      20495 |  9672566.31 |
|      24537 |  9654516.03 |
|     160528 |  9650804.70 |
|      34706 |  9647241.90 |
|     149039 |  9643498.32 |
|     147139 |  9642356.34 |
|     118629 |  9624960.80 |
|      35359 |  9621549.92 |
|      33854 |  9616857.73 |
|      33707 |  9609988.84 |
|     149055 |  9599364.32 |
|     127429 |  9580670.49 |
|      67575 |  9579613.26 |
|      80727 |  9576545.81 |
|     181650 |  9574445.40 |
|      50176 |  9573389.08 |
|     171093 |  9571625.20 |
|     151342 |  9569230.21 |
|     123052 |  9561903.68 |
|     132633 |  9545052.14 |
|     130419 |  9524936.49 |
|      89241 |  9512992.32 |
|     138255 |  9503515.93 |
|      31680 |  9502841.07 |
|     151986 |  9500862.59 |
|     146390 |  9490242.96 |
|      62275 |  9475584.10 |
|      33518 |  9475074.40 |
|       5286 |  9473739.88 |
|      39020 |  9467701.22 |
|     113281 |  9466510.94 |
|     138789 |  9464407.24 |
|     165040 |  9462153.75 |
|     150766 |  9461855.88 |
|      54341 |  9459425.45 |
|      33464 |  9459377.37 |
|      15251 |  9455980.84 |
|     145308 |  9454189.29 |
|     192621 |  9449324.14 |
|     175218 |  9448987.35 |
|      58992 |  9446144.40 |
|      24548 |  9442739.03 |
|     177563 |  9440891.04 |
|     184482 |  9431486.10 |
|      78961 |  9430401.05 |
|     174167 |  9428622.96 |
|      88265 |  9423143.28 |
|       6057 |  9405359.37 |
|      85387 |  9402175.55 |
|      47053 |  9399707.66 |
|     128973 |  9399265.92 |
|      65668 |  9395584.45 |
|      50222 |  9394502.96 |
|     116534 |  9388011.08 |
|     140959 |  9386284.56 |
|      46897 |  9385056.21 |
|     141872 |  9383820.48 |
|     177181 |  9383551.92 |
|     168265 |  9376664.16 |
|      48974 |  9374769.12 |
|      46218 |  9364135.50 |
|     104039 |  9363227.03 |
|      61538 |  9360159.08 |
|      94688 |  9359604.98 |
|     122393 |  9357937.19 |
|       7323 |  9356712.30 |
|     197892 |  9356573.44 |
|     194056 |  9352381.73 |
|      61285 |  9348480.54 |
|     180336 |  9347874.15 |
|     121930 |  9347784.74 |
|      80652 |  9347143.50 |
|      18549 |  9346038.72 |
|      23992 |  9339908.16 |
|     136583 |  9337299.56 |
|     156151 |  9337138.10 |
|     160572 |  9336553.40 |
|     113391 |  9335558.10 |
|      48068 |  9334317.92 |
|      20409 |  9331093.65 |
|      39712 |  9324685.28 |
|      59364 |  9322249.86 |
|       1344 |  9308304.39 |
|      60549 |  9308293.20 |
|      83854 |  9307387.25 |
|      92092 |  9307165.64 |
|     193306 |  9306177.31 |
|     118265 |  9300250.20 |
|     107568 |  9296254.34 |
|     109127 |  9293552.10 |
|     184688 |  9291647.92 |
|       8718 |  9287337.37 |
|      80433 |  9286295.52 |
|      26670 |  9284963.44 |
|     139548 |  9283605.21 |
|      14736 |  9280119.20 |
|      97886 |  9273852.42 |
|     181442 |  9273130.50 |
|     172360 |  9272824.92 |
|     192714 |  9268366.36 |
|     106726 |  9264879.90 |
|      72157 |  9263498.40 |
|      70445 |  9257553.92 |
|      75148 |  9257420.83 |
|      26170 |  9256074.12 |
|     116531 |  9249721.71 |
|     133665 |  9245464.80 |
|     129041 |  9244629.48 |
|     136486 |  9240748.92 |
|     198924 |  9239976.06 |
|     115254 |  9233580.37 |
|     168135 |  9232693.98 |
|      22480 |  9232190.78 |
|     192018 |  9230386.58 |
|     111889 |  9228204.96 |
|     151661 |  9227926.90 |
|      96482 |  9226960.85 |
|      49198 |  9226436.40 |
|      41219 |  9222883.52 |
|     113502 |  9222208.59 |
|      84009 |  9218703.22 |
|     192788 |  9213468.00 |
|     160251 |  9206353.32 |
|     188162 |  9200537.88 |
|     167589 |  9195835.03 |
|     132673 |  9194021.22 |
|     191105 |  9192417.12 |
|     128748 |  9189941.55 |
|     130423 |  9184710.96 |
|      22639 |  9182963.16 |
|     199034 |  9180909.86 |
|     187644 |  9180350.20 |
|        970 |  9175757.70 |
|      59070 |  9170000.64 |
|      66568 |  9166070.04 |
|      52715 |  9161221.80 |
|     130276 |  9161201.57 |
|      24189 |  9160740.15 |
|     132402 |  9144498.48 |
|      37799 |  9142271.24 |
|     173337 |  9140566.68 |
|     176552 |  9135054.51 |
|     195714 |  9133679.77 |
|     119363 |  9123261.90 |
|     161160 |  9122259.60 |
|     196968 |  9111592.20 |
|      61943 |  9111527.33 |
|      79766 |  9109534.89 |
|     178082 |  9105694.92 |
|      38800 |  9105468.72 |
|      83608 |  9099493.68 |
|     146346 |  9098628.00 |
|     116690 |  9098099.93 |
|      64690 |  9095441.10 |
|      82061 |  9095381.18 |
|      89015 |  9092660.48 |
|     188457 |  9091400.40 |
|     125177 |  9090455.55 |
|     114776 |  9088177.68 |
|       4486 |  9087487.20 |
|     176940 |  9086842.84 |
|      93157 |  9084361.81 |
|     148624 |  9083370.78 |
|       4441 |  9079520.58 |
|      63590 |  9079125.44 |
|     174189 |  9078023.39 |
|      63054 |  9075441.98 |
|      14950 |  9073156.19 |
|     175646 |  9072322.47 |
|      63712 |  9067710.48 |
|     157197 |  9067452.77 |
|     147196 |  9064699.80 |
|      50551 |  9062434.72 |
|      43035 |  9061782.03 |
|     187679 |  9056529.40 |
|      96673 |  9056525.94 |
|     130148 |  9054217.06 |
|     159007 |  9053155.29 |
|      41544 |  9052820.94 |
|     109476 |  9048012.09 |
|      60092 |  9045562.44 |
|     197490 |  9044579.88 |
|      47311 |  9037223.52 |
|      87230 |  9033227.61 |
|       3860 |  9030622.02 |
|       5466 |  9029841.66 |
|     171537 |  9024699.30 |
|      39707 |  9022833.12 |
|     167048 |  9022709.18 |
|     109006 |  9022258.40 |
|      17910 |  9019688.45 |
|     132826 |  9017286.74 |
|     157502 |  9016444.08 |
|     142309 |  9016270.60 |
|      78891 |  9005693.25 |
|      88301 |  9002414.82 |
|      11496 |  9000803.97 |
|     163633 |  8996162.06 |
|     151809 |  8993104.95 |
|     131555 |  8988340.68 |
|      72812 |  8985370.68 |
|      77047 |  8981489.79 |
|       1553 |  8977226.10 |
|     162531 |  8973689.92 |
|     154026 |  8973320.24 |
|     125499 |  8969667.84 |
|      34547 |  8966116.43 |
|      41301 |  8965350.42 |
|      12853 |  8959403.59 |
|      27736 |  8957933.23 |
|     162817 |  8956868.20 |
|     155389 |  8955349.85 |
|     130360 |  8952928.25 |
|     120878 |  8952393.10 |
|     150671 |  8952112.72 |
|     190365 |  8951671.57 |
|      72364 |  8950587.82 |
|      71615 |  8949277.07 |
|      95277 |  8947796.58 |
|      78180 |  8946814.80 |
|      97062 |  8945057.46 |
|     170013 |  8944660.40 |
|     113426 |  8943016.29 |
|     173751 |  8942914.28 |
|       1478 |  8941906.24 |
|      26061 |  8941022.48 |
|     152527 |  8939654.10 |
|     148360 |  8939589.40 |
|      44057 |  8939101.36 |
|      13595 |  8936720.10 |
|      33337 |  8935366.48 |
|     169698 |  8931507.20 |
|      26155 |  8927283.11 |
|      17185 |  8927218.40 |
|      51996 |  8926661.08 |
|     101869 |  8919281.70 |
|      14561 |  8910653.92 |
|     190047 |  8909427.90 |
|     104143 |  8909328.40 |
|     133330 |  8907195.90 |
|     169144 |  8904989.34 |
|      87067 |  8900079.44 |
|     176075 |  8898845.64 |
|      25076 |  8895274.12 |
|      80838 |  8895205.30 |
|      40387 |  8890891.55 |
|      88004 |  8888748.80 |
|     105527 |  8888672.72 |
|      40741 |  8886674.24 |
|      76690 |  8880622.61 |
|      86485 |  8880488.57 |
|      75736 |  8877666.06 |
|      48704 |  8876626.52 |
|      56450 |  8872277.59 |
|      61683 |  8870173.93 |
|      24067 |  8867814.12 |
|     108012 |  8863632.38 |
|     180971 |  8862007.20 |
|     132986 |  8861335.20 |
|      35839 |  8859344.64 |
|     191553 |  8857411.14 |
|     163492 |  8855825.91 |
|     112101 |  8851904.10 |
|      27050 |  8847924.19 |
|      57481 |  8845309.59 |
|     163252 |  8842276.65 |
|      87958 |  8840221.67 |
|      60162 |  8838927.08 |
|     131928 |  8838900.48 |
|     123514 |  8833601.14 |
|      42891 |  8830401.37 |
|      71547 |  8829540.72 |
|      13975 |  8826582.48 |
|      31577 |  8825371.40 |
|      86165 |  8816308.38 |
|     164646 |  8815470.18 |
|     150176 |  8814992.11 |
|     152464 |  8814533.82 |
|     183434 |  8813941.24 |
|      58839 |  8808010.20 |
|      59952 |  8801497.32 |
|     151038 |  8800215.80 |
|     139523 |  8800032.57 |
|       8828 |  8798704.66 |
|      14080 |  8797032.12 |
|     194080 |  8792825.27 |
|      87199 |  8788933.64 |
|      91747 |  8785811.64 |
|     194429 |  8776185.03 |
|     118998 |  8776071.00 |
|     179467 |  8771474.74 |
|      68715 |  8771302.80 |
|     180572 |  8771095.68 |
|      19821 |  8770770.82 |
|      41702 |  8770565.71 |
|      27916 |  8769001.47 |
|     121302 |  8763598.50 |
|     107013 |  8762893.37 |
|      37287 |  8761196.43 |
|     117050 |  8758230.00 |
|      58547 |  8757757.40 |
|     197088 |  8749026.12 |
|      55839 |  8747234.02 |
|      71829 |  8744546.91 |
|      30961 |  8743416.92 |
|     134548 |  8741635.28 |
|     179833 |  8738680.00 |
|      79721 |  8737857.70 |
|     144577 |  8736427.08 |
|      29051 |  8729063.28 |
|     131481 |  8728799.64 |
|      73271 |  8727985.25 |
|      89553 |  8725727.19 |
|      31306 |  8724451.12 |
|      82181 |  8724017.16 |
|      95549 |  8723460.30 |
|      31507 |  8722094.40 |
|      21302 |  8722054.95 |
|     137953 |  8721611.83 |
|     195768 |  8721020.99 |
|     180105 |  8718021.20 |
|      98241 |  8717935.36 |
|      59431 |  8715482.28 |
|     143694 |  8713267.63 |
|     109020 |  8713043.36 |
|      46732 |  8711642.04 |
|     144172 |  8711013.10 |
|     139056 |  8710786.50 |
|     107543 |  8706135.75 |
|      89127 |  8705410.56 |
|     146544 |  8704812.86 |
|     195524 |  8699333.14 |
|     133563 |  8698060.14 |
|     112707 |  8694322.84 |
|      98951 |  8690376.70 |
|     132635 |  8689305.24 |
|      69056 |  8688980.25 |
|     134143 |  8688695.26 |
|     148150 |  8687553.16 |
|      89122 |  8686767.31 |
|      15085 |  8685772.26 |
|     196686 |  8682783.57 |
|       3076 |  8672940.78 |
|     137428 |  8672547.80 |
|      27263 |  8671719.36 |
|     101561 |  8667962.72 |
|      12597 |  8662223.52 |
|     143329 |  8661688.72 |
|     130813 |  8659409.04 |
|     183679 |  8658698.30 |
|      47449 |  8658493.58 |
|     164677 |  8658220.00 |
|      51437 |  8654713.02 |
|     116162 |  8649713.36 |
|      71889 |  8645159.67 |
|       6486 |  8639891.76 |
|     192102 |  8638102.72 |
|     101660 |  8634451.80 |
|     124703 |  8633146.86 |
|     150469 |  8631948.60 |
|     197467 |  8630739.78 |
|      97621 |  8630453.32 |
|     150354 |  8630288.15 |
|     179544 |  8630121.63 |
|      38972 |  8626072.00 |
|     110732 |  8625761.16 |
|     170791 |  8625203.06 |
|     149414 |  8617070.17 |
|      59527 |  8616079.20 |
|     157580 |  8615676.04 |
|      16268 |  8615087.46 |
|      76464 |  8610219.38 |
|      44474 |  8607934.92 |
|     125527 |  8607708.08 |
|     118076 |  8602251.65 |
|     180362 |  8601367.05 |
|       5808 |  8599851.04 |
|      28703 |  8599486.36 |
|     113373 |  8597996.36 |
|     118918 |  8597063.80 |
|      44868 |  8596304.52 |
|      43419 |  8596265.35 |
|      89763 |  8595248.64 |
|     119232 |  8594224.56 |
|     108649 |  8590683.68 |
|      10396 |  8588398.05 |
|      79536 |  8587117.83 |
|     149800 |  8587058.86 |
|     165839 |  8582991.20 |
|     115397 |  8581524.77 |
|     104394 |  8581384.42 |
|     142569 |  8581127.40 |
|      63676 |  8580930.08 |
|      29029 |  8580613.53 |
|     156604 |  8580477.00 |
|       7310 |  8579949.50 |
|     105381 |  8576164.24 |
|      84306 |  8573960.40 |
|      61217 |  8570393.04 |
|     164438 |  8569616.36 |
|      28073 |  8565639.60 |
|     125743 |  8563258.90 |
|     190032 |  8561620.55 |
|     147122 |  8561245.68 |
|       5384 |  8558830.08 |
|      70172 |  8558319.64 |
|     161966 |  8556193.38 |
|      69530 |  8554377.60 |
|     111243 |  8553627.55 |
|      72590 |  8551077.51 |
|     134423 |  8550604.77 |
|      44509 |  8547134.31 |
|     160707 |  8546000.68 |
|      54123 |  8545976.26 |
|      36547 |  8540333.04 |
|      48715 |  8537983.35 |
|     103078 |  8537142.60 |
|     137613 |  8536278.96 |
|      44995 |  8532416.72 |
|     191159 |  8532173.37 |
|     119345 |  8532070.56 |
|     109941 |  8531904.79 |
|       5449 |  8528034.35 |
|     134116 |  8526854.95 |
|     199268 |  8523599.58 |
|     168520 |  8523360.67 |
|     154189 |  8521620.13 |
|     108771 |  8513853.87 |
|     198651 |  8511238.80 |
|      93681 |  8510935.14 |
|     170680 |  8509087.68 |
|     106409 |  8506859.19 |
|      27110 |  8499811.75 |
|      43224 |  8499539.52 |
|     153225 |  8499434.28 |
|      16681 |  8498021.66 |
|     117983 |  8496934.32 |
|     192158 |  8492372.03 |
|      33900 |  8491139.64 |
|      37006 |  8489126.28 |
|     176554 |  8488633.92 |
|      69234 |  8484937.26 |
|     176652 |  8484496.02 |
|      41660 |  8480585.65 |
|     129104 |  8480411.17 |
|      66960 |  8478978.86 |
|      36296 |  8472438.75 |
|      98665 |  8471241.57 |
|     134173 |  8467888.57 |
|      60496 |  8467019.22 |
|     197520 |  8466553.20 |
|     116746 |  8465792.60 |
|     187394 |  8458248.24 |
|     140377 |  8455546.68 |
|      97326 |  8450501.67 |
|      26770 |  8449625.64 |
|     104884 |  8446152.26 |
|     143109 |  8443547.19 |
|     127361 |  8441094.08 |
|     104754 |  8436883.50 |
|     183676 |  8436165.76 |
|        906 |  8434608.12 |
|      55768 |  8433763.69 |
|     118654 |  8433465.57 |
|      39310 |  8433214.55 |
|     173261 |  8432992.53 |
|      93976 |  8432605.20 |
|      63318 |  8432149.26 |
|     128243 |  8424182.94 |
|     156063 |  8422743.54 |
|     195087 |  8421279.30 |
|      67668 |  8417594.98 |
|      49882 |  8417237.80 |
|     105631 |  8412628.07 |
|      40987 |  8406033.41 |
|     185735 |  8404112.83 |
|     173986 |  8403050.34 |
|      87372 |  8402838.40 |
|      24509 |  8398807.24 |
|     180522 |  8394989.75 |
|      76215 |  8394433.35 |
|     193872 |  8390435.23 |
|     141234 |  8390180.92 |
|      91138 |  8386645.20 |
|      28097 |  8385577.38 |
|       4053 |  8384952.75 |
|      17050 |  8380304.40 |
|      64050 |  8377921.56 |
|      80836 |  8375803.16 |
|      86084 |  8373551.95 |
|     168499 |  8373348.72 |
|     178642 |  8372218.52 |
|       8498 |  8370557.16 |
|     156312 |  8366249.30 |
|     136803 |  8361949.92 |
|      92109 |  8359503.23 |
|     138625 |  8358135.21 |
|     137540 |  8358031.08 |
|     176531 |  8355437.00 |
|      53783 |  8352395.63 |
|     106977 |  8352334.98 |
|      21385 |  8351786.37 |
|     114885 |  8351582.40 |
|     113643 |  8350530.65 |
|      89061 |  8349422.08 |
|      77752 |  8348730.24 |
|      28623 |  8348321.44 |
|      74478 |  8348064.27 |
|      41383 |  8347223.45 |
|     147632 |  8346967.80 |
|      40948 |  8346743.30 |
|     154324 |  8346521.91 |
|      89724 |  8346034.80 |
|     119083 |  8338084.92 |
|     124143 |  8335841.76 |
|      80512 |  8335705.69 |
|     105047 |  8332249.86 |
|      38243 |  8329017.19 |
|      42583 |  8328613.91 |
|      44240 |  8327684.64 |
|      57611 |  8321693.94 |
|       9730 |  8319725.70 |
|      91655 |  8318837.40 |
|      13140 |  8316216.96 |
|     112257 |  8315169.85 |
|      27182 |  8314740.99 |
|     166654 |  8314332.64 |
|      40572 |  8312654.55 |
|      26680 |  8311626.68 |
|     138947 |  8311347.29 |
|     184982 |  8310393.08 |
|      35540 |  8308058.43 |
|     181446 |  8304851.76 |
|      65160 |  8299581.90 |
|       9533 |  8299139.42 |
|      67836 |  8294228.46 |
|     159414 |  8293114.90 |
|     115025 |  8291746.65 |
|      30780 |  8291580.00 |
|     164680 |  8290263.02 |
|       4599 |  8288816.03 |
|      73366 |  8286818.96 |
|     135625 |  8284930.92 |
|      46497 |  8284638.88 |
|      63781 |  8284447.60 |
|      84332 |  8283372.14 |
|     196269 |  8276407.36 |
|     166651 |  8275663.35 |
|        142 |  8273960.31 |
|      56904 |  8272891.44 |
|      46821 |  8272603.71 |
|      76051 |  8272300.75 |
|      19666 |  8270192.64 |
|      92723 |  8267074.20 |
|     125843 |  8266816.38 |
|     158722 |  8266634.88 |
|      28941 |  8266245.12 |
|      39968 |  8265605.53 |
|      41429 |  8265317.84 |
|      61601 |  8264074.31 |
|     179159 |  8260137.47 |
|      15969 |  8259835.96 |
|     121125 |  8253912.49 |
|      66486 |  8253743.66 |
|     181031 |  8253570.14 |
|      43712 |  8250825.78 |
|      13842 |  8245765.00 |
|      76203 |  8245412.16 |
|      68992 |  8243081.46 |
|     119704 |  8241363.06 |
|      86109 |  8240377.92 |
|      29534 |  8239914.00 |
|      68596 |  8239825.29 |
|     168291 |  8237626.32 |
|     183308 |  8235947.21 |
|      78657 |  8233481.64 |
|     193545 |  8233037.49 |
|      23658 |  8232306.18 |
|     179945 |  8231365.25 |
|      53391 |  8231252.10 |
|      71380 |  8231125.68 |
|      53666 |  8226715.00 |
|     118592 |  8226181.00 |
|      67203 |  8225355.99 |
|       1178 |  8224625.05 |
|     147876 |  8224189.62 |
|      80042 |  8220826.70 |
|      48950 |  8218611.22 |
|      43331 |  8218448.04 |
|     177706 |  8215723.50 |
|     145442 |  8215706.16 |
|     197042 |  8215536.00 |
|     169952 |  8214698.43 |
|      57907 |  8211740.04 |
|     145741 |  8210316.57 |
|      91144 |  8209855.02 |
|     160266 |  8209468.80 |
|      31602 |  8209366.90 |
|      98672 |  8208412.85 |
|     199012 |  8207897.50 |
|     151148 |  8207645.16 |
|     116545 |  8207573.24 |
|     122176 |  8207508.04 |
|      11021 |  8206766.10 |
|      47752 |  8203436.82 |
|        124 |  8203209.30 |
|     148126 |  8202846.66 |
|      15753 |  8202695.55 |
|      50833 |  8200880.16 |
|      11523 |  8196478.02 |
|      71478 |  8195930.68 |
|     129262 |  8190520.80 |
|      43023 |  8186451.85 |
|     119193 |  8184853.14 |
|      85067 |  8182638.86 |
|     164534 |  8181563.04 |
|      82556 |  8180455.14 |
|      31813 |  8179417.14 |
|      81345 |  8173128.69 |
|      38413 |  8172464.04 |
|     106014 |  8171418.35 |
|     191180 |  8170663.97 |
|      43274 |  8169669.72 |
|       5837 |  8166123.50 |
|      63332 |  8161839.60 |
|      47668 |  8161790.04 |
|     112468 |  8160728.40 |
|     132541 |  8160680.00 |
|      59457 |  8160393.33 |
|      71751 |  8159865.19 |
|     118395 |  8156795.00 |
|     132390 |  8154867.54 |
|      44792 |  8153384.22 |
|     128838 |  8153018.30 |
|      87197 |  8152281.72 |
|     187978 |  8150832.56 |
|     147419 |  8150063.60 |
|     149166 |  8149406.78 |
|     196012 |  8147307.42 |
|     190519 |  8145402.96 |
|     151511 |  8144276.58 |
|      88891 |  8140166.24 |
|     168056 |  8139101.96 |
|     189186 |  8136933.25 |
|     117326 |  8136047.82 |
|      60575 |  8133316.80 |
|      75452 |  8130427.37 |
|     194126 |  8129751.80 |
|     130199 |  8129270.88 |
|      41680 |  8128823.40 |
|     107624 |  8125799.20 |
|     135069 |  8123999.10 |
|     119032 |  8123770.24 |
|      27635 |  8123076.65 |
|      14317 |  8121553.23 |
|     148018 |  8119898.16 |
|      51152 |  8118370.26 |
|     112643 |  8117331.37 |
|     119526 |  8116075.80 |
|     192084 |  8114896.38 |
|     151385 |  8114711.28 |
|     160836 |  8112053.68 |
|      91468 |  8111785.50 |
|      58877 |  8108256.25 |
|      41885 |  8107026.81 |
|     155542 |  8106757.18 |
|     149968 |  8104953.78 |
|     168380 |  8103576.00 |
|     134641 |  8101092.32 |
|      92470 |  8100877.70 |
|     113610 |  8098591.93 |
|     198538 |  8097343.20 |
|     122506 |  8096090.76 |
|      29082 |  8093543.55 |
|     161345 |  8093157.93 |
|     105743 |  8093045.53 |
|     103572 |  8091573.66 |
|      59514 |  8089470.48 |
|       8801 |  8088454.15 |
|     129062 |  8088206.58 |
|     155464 |  8086115.79 |
|      86363 |  8082561.00 |
|     180836 |  8082087.30 |
|      92558 |  8081407.80 |
|      85120 |  8073164.00 |
|     149026 |  8072285.40 |
|      51138 |  8072074.48 |
|      36306 |  8071648.86 |
|     102380 |  8070503.00 |
|     147597 |  8069397.60 |
|      41382 |  8059995.35 |
|     121856 |  8059809.11 |
|      86644 |  8058667.76 |
|     108481 |  8058214.81 |
|      41685 |  8057355.39 |
|     175712 |  8054878.30 |
|      72815 |  8052294.24 |
|      58794 |  8047848.00 |
|     118769 |  8047465.14 |
|     157192 |  8046501.96 |
|     195708 |  8045001.94 |
|     163683 |  8044727.02 |
|     189018 |  8043927.54 |
|      62904 |  8043011.65 |
|      80095 |  8042575.59 |
|      90500 |  8042502.65 |
|      73281 |  8040167.52 |
|     150710 |  8035910.80 |
|     139282 |  8034489.36 |
|     172904 |  8033791.68 |
|      38881 |  8032557.38 |
|      53055 |  8030796.15 |
|     105816 |  8025318.24 |
|      88304 |  8024637.06 |
|     115565 |  8023928.25 |
|      55376 |  8021432.16 |
|      56334 |  8019313.12 |
|      58875 |  8016065.00 |
|       4688 |  8012303.00 |
|      49117 |  8009207.80 |
|      57173 |  8008116.27 |
|      48176 |  8006765.85 |
|     112191 |  8003883.39 |
|      33265 |  8002391.76 |
|     181788 |  8002030.50 |
|     172799 |  8001050.55 |
|       2084 |  7999172.30 |
|     174747 |  7997167.48 |
|     171184 |  7996930.11 |
|     113271 |  7992683.04 |
|      68662 |  7991426.30 |
|     179375 |  7991170.88 |
|     188383 |  7990226.27 |
|      50208 |  7989363.27 |
|      23653 |  7988890.87 |
|     159419 |  7988841.36 |
|      74581 |  7987356.50 |
|     133590 |  7986046.81 |
|     195820 |  7985473.14 |
|      87903 |  7983482.88 |
|      69032 |  7981908.18 |
|     113975 |  7980561.00 |
|     178678 |  7975116.93 |
|      52316 |  7973618.16 |
|     135546 |  7972669.80 |
|      89425 |  7970077.44 |
|     115937 |  7966015.20 |
|     151483 |  7964850.88 |
|      73974 |  7964186.23 |
|      39976 |  7964104.24 |
|     130168 |  7961690.88 |
|      58973 |  7957416.76 |
|      16354 |  7956051.07 |
|      23988 |  7955837.92 |
|     138467 |  7955481.05 |
|      26096 |  7955212.32 |
|     192216 |  7953429.18 |
|     112833 |  7952279.26 |
|      60599 |  7951261.80 |
|     129116 |  7948811.85 |
|      79529 |  7947581.91 |
|      71616 |  7944476.54 |
|     136821 |  7942188.24 |
|     116204 |  7941096.90 |
|     165298 |  7939933.31 |
|      44009 |  7939859.65 |
|     194487 |  7938247.20 |
|      11299 |  7938135.81 |
|      76488 |  7935926.86 |
|      58998 |  7934414.04 |
|      25175 |  7931035.11 |
|     136144 |  7929283.23 |
|     132829 |  7926841.62 |
|      84176 |  7925781.05 |
|      68592 |  7922872.98 |
|     139280 |  7922119.48 |
|     160669 |  7921588.43 |
|      42938 |  7917524.56 |
|     183183 |  7915624.86 |
|      95449 |  7914292.08 |
|     115390 |  7912655.54 |
|     173723 |  7911329.40 |
|      48992 |  7911153.12 |
|     173464 |  7910458.65 |
|      26098 |  7910217.75 |
|     141115 |  7909496.38 |
|     195218 |  7906315.56 |
|     116608 |  7906302.60 |
|     163793 |  7905477.33 |
|      10419 |  7904598.30 |
|     106312 |  7901466.72 |
|      48674 |  7901010.24 |
|      35198 |  7899974.88 |
|      88954 |  7899573.52 |
|      41505 |  7897709.99 |
|     115586 |  7897301.88 |
|     167431 |  7895826.00 |
|     158787 |  7894948.50 |
|     161712 |  7893410.70 |
|      46930 |  7892707.77 |
|      58633 |  7892088.15 |
|      10599 |  7892067.69 |
|      99523 |  7891485.16 |
|      70126 |  7890247.41 |
|      32476 |  7890149.34 |
|     152617 |  7890136.50 |
|     162639 |  7889822.70 |
|      82056 |  7889345.05 |
|     186450 |  7887873.56 |
|      39082 |  7886019.89 |
|     183217 |  7885948.48 |
|     192551 |  7884432.48 |
|     164801 |  7882870.10 |
|     112804 |  7882772.00 |
|       5956 |  7878805.04 |
|      73054 |  7878479.63 |
|      62593 |  7878401.44 |
|     137687 |  7873755.91 |
|      80526 |  7871839.50 |
|     195354 |  7869617.75 |
|       4122 |  7867967.09 |
|       4057 |  7865176.80 |
|      63195 |  7864322.16 |
|     143370 |  7863444.54 |
|      41473 |  7862926.89 |
|     155060 |  7860900.96 |
|      76875 |  7858529.64 |
|     135778 |  7857660.51 |
|      30534 |  7855226.08 |
|      99405 |  7853410.95 |
|     161551 |  7852244.40 |
|     185034 |  7850752.00 |
|      17264 |  7850704.88 |
|      23652 |  7848909.16 |
|     123681 |  7848265.36 |
|     186170 |  7845527.50 |
|      81496 |  7840427.40 |
|      25407 |  7840234.72 |
|      96662 |  7839907.41 |
|     156407 |  7839647.75 |
|     165843 |  7839562.80 |
|     153361 |  7838813.07 |
|     149362 |  7838282.52 |
|      46057 |  7835709.81 |
|     114341 |  7835492.25 |
|     154823 |  7834898.61 |
|     139538 |  7834690.64 |
|      42853 |  7833252.60 |
|     177659 |  7831803.58 |
|      29158 |  7829880.80 |
|      85583 |  7825996.64 |
|     165714 |  7825006.46 |
|      58662 |  7821977.76 |
|     185839 |  7821640.74 |
|      93559 |  7821137.52 |
|      58481 |  7818648.16 |
|     162217 |  7817923.47 |
|     130014 |  7815929.34 |
|     125640 |  7815262.90 |
|      83723 |  7815021.48 |
|      54314 |  7813732.94 |
|     146652 |  7809817.39 |
|     189256 |  7808972.00 |
|      87994 |  7808660.48 |
|     157067 |  7806217.25 |
|      56859 |  7805947.60 |
|     118132 |  7804423.69 |
|     189457 |  7802777.91 |
|       1509 |  7802315.42 |
|     129101 |  7801994.70 |
|     162285 |  7801859.52 |
|     182358 |  7801430.46 |
|       6288 |  7800363.30 |
|      68972 |  7799224.95 |
|      51684 |  7795455.46 |
|     148645 |  7794585.92 |
|      94359 |  7794358.92 |
|      40451 |  7791437.70 |
|      44019 |  7790053.76 |
|      81470 |  7788716.85 |
|      12731 |  7786998.38 |
|     114393 |  7784963.34 |
|      69323 |  7783583.08 |
|     169794 |  7780968.30 |
|      25378 |  7778569.60 |
|     104509 |  7777137.62 |
|      81874 |  7775216.80 |
|      70859 |  7771185.07 |
|     135768 |  7769704.84 |
|     181960 |  7768847.90 |
|      28481 |  7768516.61 |
|     191604 |  7765367.68 |
|        754 |  7762507.02 |
|     127702 |  7761776.05 |
|      36488 |  7761744.00 |
|     183906 |  7759864.80 |
|      90365 |  7759602.50 |
|      60725 |  7759495.78 |
|      69436 |  7759033.52 |
|      12963 |  7756623.52 |
|      64571 |  7755731.04 |
|     160111 |  7753787.70 |
|     107970 |  7753735.88 |
|     132036 |  7753401.36 |
|      79965 |  7748656.15 |
|     149862 |  7747239.10 |
|      73218 |  7745499.42 |
|     161036 |  7742807.45 |
|     152467 |  7742471.40 |
|     163358 |  7742034.00 |
|     197951 |  7741768.84 |
|      15820 |  7740003.00 |
|      31444 |  7739519.60 |
|     151208 |  7738273.85 |
|      20410 |  7737192.99 |
|      45462 |  7736792.55 |
|     128966 |  7736467.65 |
|     118945 |  7735275.00 |
|     106458 |  7734069.72 |
|     162706 |  7730189.88 |
|      70528 |  7730088.25 |
|     107998 |  7728273.45 |
|     163110 |  7728042.40 |
|      74591 |  7727297.76 |
|     121454 |  7726200.56 |
|     181252 |  7724464.38 |
|      29154 |  7724129.66 |
|      63854 |  7720353.88 |
|      34157 |  7719803.30 |
|      30684 |  7718307.84 |
|       3985 |  7715042.96 |
|      29387 |  7714858.80 |
|     184703 |  7712545.12 |
|     124679 |  7712528.72 |
|      15606 |  7710658.46 |
|     123814 |  7709872.95 |
|      83760 |  7709633.92 |
|      22084 |  7707219.79 |
|     123210 |  7706030.42 |
|      75066 |  7704727.51 |
|      16337 |  7704517.80 |
|      47109 |  7704111.51 |
|       8232 |  7702887.50 |
|      11222 |  7702535.62 |
|      84961 |  7701923.72 |
|     157118 |  7700132.88 |
|     118362 |  7699210.20 |
|     193755 |  7698545.20 |
|       1520 |  7697759.37 |
|     114599 |  7697377.50 |
|     168842 |  7696152.00 |
|     172245 |  7694286.06 |
|       4584 |  7693352.79 |
|     113651 |  7689659.67 |
|     183207 |  7687955.66 |
|     175802 |  7686604.70 |
|      59066 |  7685120.43 |
|     130726 |  7684159.25 |
|      89672 |  7684049.50 |
|       7224 |  7683446.40 |
|      97533 |  7680694.62 |
|      59941 |  7680100.80 |
|      29298 |  7676823.42 |
|     163962 |  7675924.96 |
|      41086 |  7674518.14 |
|     185483 |  7673376.60 |
|     165010 |  7672469.70 |
|       3708 |  7671744.18 |
|     192994 |  7671712.00 |
|      79968 |  7668060.48 |
|     118494 |  7666659.00 |
|      59236 |  7666625.98 |
|     149509 |  7665930.67 |
|       3793 |  7664981.28 |
|      28979 |  7664632.93 |
|     178389 |  7662544.96 |
|      65315 |  7661085.88 |
|      59710 |  7657442.00 |
|     170276 |  7656813.89 |
|     182707 |  7656387.06 |
|     129170 |  7655820.48 |
|      59765 |  7655009.92 |
|      23337 |  7654271.94 |
|      90396 |  7653568.35 |
|      68842 |  7652742.72 |
|      16315 |  7652630.70 |
|        956 |  7652174.81 |
|      10639 |  7651375.80 |
|     112886 |  7649534.08 |
|       9561 |  7648502.73 |
|      65484 |  7647789.30 |
|      68677 |  7646879.14 |
|     196529 |  7645482.24 |
|       6556 |  7642116.06 |
|       9113 |  7640163.68 |
|     128139 |  7638760.00 |
|     143264 |  7635499.56 |
|      21569 |  7634785.86 |
|     193402 |  7633576.06 |
|      35545 |  7632210.69 |
|      65068 |  7632188.76 |
|      25515 |  7630952.93 |
|     180189 |  7630887.10 |
|     131680 |  7629593.64 |
|      80162 |  7629440.93 |
|     139054 |  7629417.37 |
|       8028 |  7629134.04 |
|      76804 |  7626731.00 |
|      74179 |  7624974.03 |
|     122507 |  7623903.87 |
|     141889 |  7623552.30 |
|     184279 |  7623048.17 |
|       8076 |  7620897.81 |
|     192681 |  7619802.09 |
|      21398 |  7617942.52 |
|      14825 |  7617843.60 |
|      17969 |  7617524.64 |
|     170764 |  7616119.96 |
|     115303 |  7615914.17 |
|      67708 |  7615306.08 |
|      33317 |  7613417.24 |
|     190782 |  7613203.42 |
|     113818 |  7612852.48 |
|     178091 |  7611457.30 |
|      87603 |  7611343.68 |
|     108317 |  7610509.71 |
|     106552 |  7609868.84 |
|      28679 |  7609292.20 |
|     192350 |  7609140.81 |
|     154801 |  7607944.38 |
|       5768 |  7607785.68 |
|     127689 |  7606313.94 |
|      62847 |  7605651.45 |
|     111212 |  7605052.00 |
|     156065 |  7603327.60 |
|     115140 |  7601161.68 |
|      19597 |  7601153.46 |
|      55233 |  7600940.23 |
|      89353 |  7600929.84 |
|      75701 |  7600492.60 |
|      64974 |  7599754.80 |
|     116156 |  7597452.48 |
|      59491 |  7596352.84 |
|       6138 |  7594861.54 |
|      62317 |  7594854.10 |
|     106575 |  7594520.08 |
|     161092 |  7594454.40 |
|       9872 |  7593734.34 |
|      77711 |  7593431.60 |
|      61206 |  7593153.00 |
|     123776 |  7592736.80 |
|     185141 |  7592617.12 |
|       5542 |  7592513.04 |
|     185296 |  7591439.31 |
|      72597 |  7591142.40 |
+------------+-------------+
1225 rows in set

Q12
+------------+-----------------+----------------+
| l_shipmode | high_line_count | low_line_count |
+------------+-----------------+----------------+
| FOB        |            6273 |           9429 |
| TRUCK      |            6336 |           9300 |
+------------+-----------------+----------------+

Q13
+---------+----------+
| c_count | custdist |
+---------+----------+
|       0 |    50005 |
|      10 |     6574 |
|       9 |     6554 |
|      11 |     6072 |
|       8 |     5934 |
|      12 |     5598 |
|      13 |     5032 |
|      19 |     4685 |
|       7 |     4663 |
|      20 |     4607 |
|      17 |     4550 |
|      18 |     4515 |
|      14 |     4480 |
|      15 |     4476 |
|      16 |     4341 |
|      21 |     4176 |
|      22 |     3710 |
|       6 |     3303 |
|      23 |     3172 |
|      24 |     2670 |
|      25 |     2111 |
|       5 |     1954 |
|      26 |     1605 |
|      27 |     1195 |
|       4 |     1030 |
|      28 |      898 |
|      29 |      620 |
|       3 |      408 |
|      30 |      353 |
|      31 |      225 |
|      32 |      135 |
|       2 |      128 |
|      33 |       82 |
|      34 |       54 |
|      35 |       33 |
|       1 |       18 |
|      36 |       17 |
|      37 |        7 |
|      41 |        3 |
|      40 |        3 |
|      38 |        3 |
|      39 |        1 |
+---------+----------+
42 rows in set


Q14
+-------------------+
| promo_revenue     |
+-------------------+
| 16.65118731292792 |
+-------------------+

Q15
+-----------+--------------------+----------------------------------+-----------------+---------------+
| s_suppkey | s_name             | s_address                        | s_phone         | total_revenue |
+-----------+--------------------+----------------------------------+-----------------+---------------+
|      7895 | Supplier#000007895 | NYl,i8UhxTykLxGJ2voIRn20Ugk1KTzz | 14-559-808-3306 |  1678635.2636 |
+-----------+--------------------+----------------------------------+-----------------+---------------+


Q16
+----------+---------------------------+--------+--------------+
| p_brand  | p_type                    | p_size | supplier_cnt |
+----------+---------------------------+--------+--------------+
| Brand#55 | LARGE BURNISHED TIN       |     21 |           36 |
| Brand#25 | PROMO BRUSHED STEEL       |     24 |           28 |
| Brand#54 | STANDARD BRUSHED COPPER   |     14 |           27 |
| Brand#12 | MEDIUM PLATED BRASS       |     21 |           24 |
| Brand#14 | ECONOMY PLATED TIN        |     33 |           24 |
| Brand#24 | ECONOMY PLATED TIN        |     33 |           24 |
| Brand#25 | MEDIUM PLATED STEEL       |     35 |           24 |
| Brand#32 | MEDIUM POLISHED COPPER    |     20 |           24 |
| Brand#32 | SMALL ANODIZED BRASS      |      7 |           24 |
| Brand#33 | ECONOMY PLATED STEEL      |      7 |           24 |
| Brand#33 | MEDIUM PLATED COPPER      |     20 |           24 |
| Brand#33 | PROMO POLISHED STEEL      |     14 |           24 |
...
| Brand#31 | PROMO ANODIZED COPPER     |     20 |            3 |
| Brand#41 | LARGE BURNISHED STEEL     |     20 |            3 |
| Brand#43 | SMALL BRUSHED COPPER      |      7 |            3 |
| Brand#52 | MEDIUM POLISHED BRASS     |     21 |            3 |
| Brand#52 | SMALL POLISHED TIN        |      2 |            3 |
+----------+---------------------------+--------+--------------+
18341 rows in set

Q17
+-------------------+
| avg_yearly        |
+-------------------+
| 348406.0542857143 |
+-------------------+

Q18
+--------------------+-----------+------------+-------------+--------------+-----------------+
| c_name             | c_custkey | o_orderkey | o_orderdate | o_totalprice | sum(l_quantity) |
+--------------------+-----------+------------+-------------+--------------+-----------------+
| Customer#000128120 |    128120 |    4722021 | 1994-04-07  |    544089.09 |          323.00 |
| Customer#000144617 |    144617 |    3043270 | 1997-02-12  |    530604.44 |          317.00 |
| Customer#000066790 |     66790 |    2199712 | 1996-09-30  |    515531.82 |          327.00 |
| Customer#000015619 |     15619 |    3767271 | 1996-08-07  |    480083.96 |          318.00 |
| Customer#000147197 |    147197 |    1263015 | 1997-02-02  |    467149.67 |          320.00 |
| Customer#000117919 |    117919 |    2869152 | 1996-06-20  |    456815.92 |          317.00 |
| Customer#000126865 |    126865 |    4702759 | 1994-11-07  |    447606.65 |          320.00 |
| Customer#000036619 |     36619 |    4806726 | 1995-01-17  |    446704.09 |          328.00 |
| Customer#000119989 |    119989 |    1544643 | 1997-09-20  |    434568.25 |          320.00 |
+--------------------+-----------+------------+-------------+--------------+-----------------+
9 rows in set

Q19
+--------------+
| revenue      |
+--------------+
| 3083843.0578 |
+--------------+

Q20
+--------------------+------------------------------------------+
| s_name             | s_address                                |
+--------------------+------------------------------------------+
| Supplier#000000035 | QymmGXxjVVQ5OuABCXVVsu,4eF gU0Qc6        |
| Supplier#000000068 | Ue6N50wH2CwE4PPgTGLmat,ibGYYlDoOb3xQwtgb |
| Supplier#000000080 | cJ2MHSEJ13rIL2Wj3D5i6hRo30,ZiNUXhqn      |
| Supplier#000000100 | rIlN li8zvW22l2slbcx ECP4fL              |
| Supplier#000000274 | usxbl9KSW41DTE6FAglxHU                   |
| Supplier#000000406 | zMhU58CDF4aHTeodxg9IgRZgq                |
| Supplier#000000444 | mHr2VcUpRkvyQ9rjKMaPkeWbVZmEIhxhb8F      |
| Supplier#000000453 | bpt98PxU5HSQt61bVB695JPjBmJKUv hNzQeHvC  |
| Supplier#000000458 | IFNkUK1H53HwUHabiONkMFAUDb               |
| Supplier#000000622 | gCQimU1jYHoQiglDmW1FkQM9wzi YC1P15pMy1   |
| Supplier#000000713 | DBMIf1HiYY8OyRFcbtHpKIz                  |
| Supplier#000000767 | bHEuqKKdmCMEKOV                          |
| Supplier#000000776 | nklfFoSkCwf,ooSuF                        |
| Supplier#000000823 |  gC0DrEG5U,v893fp3nj mmXa6rYhJ0tjpJ      |
| Supplier#000000828 | 0B2aPqJ6KTEr2fqxuC7z                     |
| Supplier#000000941 | gqG2XEnVlzUhjjfQGYGlwk,jcaNsplI8Rleg     |
| Supplier#000000973 | 5 nhBZ 03rG6EcOEDkZXvt                   |
| Supplier#000000984 | 6H6qqye iYbYzCmwWhj                      |
| Supplier#000001149 | Nuno37wiZOjNGHF                          |
| Supplier#000001201 | Seh4D7pi9UdK,XQkF46A0O2N                 |
| Supplier#000001309 | 72RNUzKzbniUnnsSs24ZzGDvmcv2Pd           |
| Supplier#000001344 | 6iF,zVDNTykohVKcb7FKvn82s74ez            |
| Supplier#000001351 | zXdoBMmmRx1wOD7GKoHHBtemXGuYKLDb,U2KP    |
| Supplier#000001391 | hkWoAM561QlLjBNk,SdFdIgFx                |
| Supplier#000001481 | ARqVvJHMxBNKl2LrfPsR  Wq9ZUXh,14         |
| Supplier#000001584 | gJbTkijteJxSMLmdzBSzeMAH                 |
| Supplier#000001651 | 6rJNoWL9YL                               |
| Supplier#000001710 | J,sdOOJwUhwPv2mrEiNEA0UZlmu5IRmgz        |
| Supplier#000001755 | QstBVfnY,93NsbWXCqO                      |
| Supplier#000001869 | nogoCdaFQii,ri9rs3P8f5rPt1wVOMw9I7TmypxK |
| Supplier#000001895 | lywAGDbk37fYPDS                          |
| Supplier#000001910 | vih,zrhclXX1O9x                          |
| Supplier#000001930 | 2jCSw3KOLHol7y5omVO13                    |
| Supplier#000001979 | UNW7nA,IC 5igvVsgUHA7OaLL,jOzUcT         |
| Supplier#000002046 | BiTDgHknmvQGT6FpZXfRX,xlnR               |
| Supplier#000002071 | zLH3QAtZuuOq8AoVNM                       |
| Supplier#000002270 | HIscbvhw8N94djn,3UbPaY4R                 |
| Supplier#000002350 | TWsO2iJGOl7v3vSwiscXp6X                  |
| Supplier#000002409 | oy39SaSQ,FIP pzLqblhxj                   |
| Supplier#000002520 | 5y55UzYQKByZP3                           |
| Supplier#000002618 | 3UtbE1kKm29kKyx09hSEBMhRLM               |
| Supplier#000002643 | eDN6YjGtp2dcj0IF,BKEEYjElO,sUjjcNI       |
| Supplier#000002649 | agDQi9iCt1cUaS                           |
| Supplier#000002655 | i6v8dkQBuK0NSCeqQCE8                     |
| Supplier#000002812 | Q9sO3wZkBU5QBe0VITRWShv                  |
| Supplier#000002888 | 3AtRoxBFh6HIBa9kdBX,6,Ml2SZGUA           |
| Supplier#000002910 | nlH1gjApxHkQe5SU4iVZwi2xWk88wwhTWRkSvOBB |
| Supplier#000002914 | fUC4IkGB8pt1S                            |
| Supplier#000003000 | JtDvRf4iWHJkj54PYxl                      |
| Supplier#000003011 | vfL mV0MTdyozfRIPZkJbM1Z7Lcm2NCPIj6qSgBz |
| Supplier#000003038 | F5Tz7P juuCbABDuW8JGomRFxqVHBWyQrsLwg4i  |
| Supplier#000003150 | XwSjsmzEnANK,wAQUp4Xf5xJDqR              |
| Supplier#000003305 | GLZJimfuzKoQcqcv4                        |
| Supplier#000003394 | R6D7n3WrQjWNGSQTb7eN ,X0oCMkhyuTHBOSPw   |
| Supplier#000003452 | 7tMycIKhE,pe4OL3Du                       |
| Supplier#000003666 | ENS fE9iSrSzw,iTwA,zGorkflw              |
| Supplier#000003698 | lnSEu64ca4B53BfznJPg                     |
| Supplier#000003773 | UWjSotAjkAD                              |
| Supplier#000003837 | SYXpXaKop3                               |
| Supplier#000003846 | wl076KfcEpYLRegb1LfIf93b3n5HBabFK2R,mEM  |
| Supplier#000003862 | 0XXFhF1IDBh                              |
| Supplier#000003868 | 5aP4VBn0t666NbGYB                        |
| Supplier#000003880 | DZo80mSznrhCpb8                          |
| Supplier#000003955 | piECPB8qbn7s3XP                          |
| Supplier#000004007 | cvlSgCCKGOwpaB iFIPx4vU2qA5b6K hz9Z91    |
| Supplier#000004066 | TNBnJFDScUmsjBy6pSWTS sfMg9jpfKx         |
| Supplier#000004127 | EduKm3NcCc75Cd                           |
| Supplier#000004174 | Bk97olQYwXmjYdQjwyt N                    |
| Supplier#000004328 | euddbWZRcVMD3W                           |
| Supplier#000004341 | ea8KZYvO7amq8A                           |
| Supplier#000004360 | w 7kM5J,fqjiqBu4SU0UPEDqspaUEm           |
| Supplier#000004375 | Cmr952zcJJuW0xAYc0W0MA7N6vMcCjy          |
| Supplier#000004391 | pcsiJBhSEHuFHNAxR3K c                    |
| Supplier#000004398 | khZZ0CmLip49Zncec                        |
| Supplier#000004402 | acagGfDWzwmS,,WVBsszubFs3LOA8rDRS0I      |
| Supplier#000004714 | IKRla2xArMmR4p3Mbn8JV8g0                 |
| Supplier#000004717 | H,Suh5pN230Ol,ggx0QEh3rrvzyQsq050Lat     |
| Supplier#000004740 | yM0TXkhfjpObafbQhuWU                     |
| Supplier#000004763 | W 7kS9LLh4ZgLpk2                         |
| Supplier#000004837 | tYHMZS4XlJjzvj34mH2PCoj                  |
| Supplier#000004882 | e,V Bo1KZEt                              |
| Supplier#000004913 | em,yC41xEl Fst9LwEik                     |
| Supplier#000005005 | K6 GI4WzmbsGEOh                          |
| Supplier#000005238 | jmtI76 8RNG8Z2BZu                        |
| Supplier#000005289 | 62XeOur9SnXgbdjGwb9E1aJIEBr5PA9          |
| Supplier#000005317 | lPOPHufNjwZaUJGVNHCC2DE FYQcKZBzHltL5    |
| Supplier#000005401 | eEOlCEAaIfVexStlrgTuzwQx7vjPF6ZT dm      |
| Supplier#000005449 | fhc8lUuZdqWUujcVaWogowEq1WVL9Y8m1efwCl3G |
| Supplier#000005472 | LlyLSmvY9GFvMN4QhHzMokW0k5d              |
| Supplier#000005572 | o0VYozeSbEyqck                           |
| Supplier#000005579 | ACVEMP4IwRf                              |
| Supplier#000005661 | pq5wuxmkIW0DyWU                          |
| Supplier#000005676 | HInJHZisl5svSU1oKsr                      |
| Supplier#000005815 | S6cu6cspYxHlTz2                          |
| Supplier#000005835 | rYoXzV3EZ77Z                             |
| Supplier#000006103 | l32l8iaPdbHgRXoq,kdjFAj3hZk2d            |
| Supplier#000006173 | hBdratcVfL4LpWxsEpCRP g0AksN0CDhBZ       |
| Supplier#000006226 | CKuDyeGAxPHeRHwC4a                       |
| Supplier#000006254 | g7OY1vWNUb1vxIRgEl                       |
| Supplier#000006348 | f2KDn2rLnadX8I DZR                       |
| Supplier#000006359 | QyUuVHYBp8sTd7Y9WveNfsz                  |
| Supplier#000006430 | F2RrkeaNcs6po8x2PyYvcPa1rtKd,fT2AMxP     |
| Supplier#000006516 | 89XwFOC,hLRxGq5rL0txv0EM9F               |
| Supplier#000006700 | BWjerJH5kbEPu 8h9                        |
| Supplier#000006785 | lyo6PpwulTeN9ZfIkvWag5NucL,XMC  89Kn7U   |
| Supplier#000006998 | r2i3HfkSQh9dvho, NpoabdMsPBG             |
| Supplier#000007019 | 2GQsALzRiTt2BQum6bocdeGawkOrsjNIZ        |
| Supplier#000007114 | s9s4YLeLWo7fLRO3rdQKFfUnZhrZUPjOC        |
| Supplier#000007170 | 9vABqu hZaciXSCQrbTj                     |
| Supplier#000007171 | DXerxFIhNRpqF9dWNRw hDOlLX gEJFxh0       |
| Supplier#000007213 | 2Nrby3JJHDJyWwVNiqPtm2U JGWlZpU          |
| Supplier#000007219 | p5Ui3IGPcmotYu                           |
| Supplier#000007229 | iwNoWdaURFzLAsQHxK,BeOPpI5TOTo           |
| Supplier#000007263 | malQPdYc8xiup2MiFuKHa                    |
| Supplier#000007270 | TksERECGdYZRPUjkUdDRZv5pW26cOTaA1        |
| Supplier#000007276 | Vi9,aBg2ychZf                            |
| Supplier#000007334 | NPXYWdJ8L9EDr20tw9CZQsEMqXlgXzI2JC Y     |
| Supplier#000007400 | 7r9zZj8J,,hN2GRfWtDxzuGa                 |
| Supplier#000007442 | DzycM1,T6kh2EutfPeFpv0Ro                 |
| Supplier#000007456 | ITYEeccPVJi0HvnAwVs2Z                    |
| Supplier#000007559 | Wmzx1vskciC                              |
| Supplier#000007677 | OoTYQdxQyd7NukSaSRv                      |
| Supplier#000007712 | DyTQD 3ajuOtHQTpI4LsWSF kSd2SE6U4COgYHQ  |
| Supplier#000007715 | gZHd7Yzbtv7yb7DYCCAQPJH8FRHTqi6T4w       |
| Supplier#000007816 | 1ejcJ545bwLWLuY6Qq4qyEExZIsp0SG          |
| Supplier#000007845 | agwGVTzLyRKOsZxLVi,mPWZ08Qxb             |
| Supplier#000007875 | E0CkoBYngcIoH                            |
| Supplier#000007908 | ghhHapj7GK                               |
| Supplier#000007972 | WW0GuiWP2N3kUo4f                         |
| Supplier#000008162 | XASpbn08mRV0kgHRmUSKx                    |
| Supplier#000008235 | TjVWq6bTdGJB                             |
| Supplier#000008249 | PwUjvlMk y72zaMRtZQ8trbCmu4j             |
| Supplier#000008309 | 6P,FQbW6sJouqunvttVO6vEeY                |
| Supplier#000008339 | uWw8 P6u,S                               |
| Supplier#000008343 |  BbHngAVqj0J8                            |
| Supplier#000008349 | 8Hkx1IDd0mZCTX                           |
| Supplier#000008377 | ,Yk0mflw2LqQCTxMYR sU2juj5DorUAG4w6i     |
| Supplier#000008468 | 5R4jsweitleustYlE3w,u5otW                |
| Supplier#000008523 | C4ocdfNu5I2nnnVG2xSd3016J6KNLIg          |
| Supplier#000008580 | t5ri71bM6Sox3riP4JUZsMMNC                |
| Supplier#000008638 | yxj50B 8aMql                             |
| Supplier#000008642 | qnN9N9du9Dg2arf6kjD xW0DjMT9cM           |
| Supplier#000008651 | pfw32RGA7BPXrUiavYqE                     |
| Supplier#000008679 | JWFVoSsCwn9p8o                           |
| Supplier#000008704 | a6DjHp0B6mifKBtqUk,C                     |
| Supplier#000008737 | MsdGxF9Xoq9 8s                           |
| Supplier#000008820 | uAsBvPBNsEsO                             |
| Supplier#000008829 | lNcY7xNLDonCw TuRYL                      |
| Supplier#000008947 | 1Ij3T0egGHnVbLich98HzY,UeCdVbxzYa ZpKDVc |
| Supplier#000008964 | U2YJW,Y1xCbUWbjuovtzsLfsl                |
| Supplier#000008974 | 4JCXOJ3MyPfa51mIf,MQu                    |
| Supplier#000008997 | KY MmMEcyQ6FEDCooFj xa uCwF2GbaeA8       |
| Supplier#000009065 | ZELuiqWrWbJV9zAuco1OnXKTJClhR            |
| Supplier#000009114 | nkn6bcPvlP5w,lUpO0nZTBSj                 |
| Supplier#000009125 | IQbCXbN1mmght                            |
| Supplier#000009131 | gDBXgWtg4rTxu0WUJhhV                     |
| Supplier#000009149 | yKX,bKryD6YtvF,cVLIKC0Z6rN               |
| Supplier#000009182 | z56kNgeqaWQ1kHFBp                        |
| Supplier#000009220 | N4y,vP kdArpcmdypBh,fJVVB                |
| Supplier#000009226 | yzT10vNTFJ                               |
| Supplier#000009288 |  251AA4ziZ3d7TTWXLGnXjb4BnXv             |
| Supplier#000009360 | 1NVjjX8zMjyBX2UapDTP0Sz                  |
| Supplier#000009381 | rhCTm7QehIznqd8 Np7VT,H5J5zSGr           |
| Supplier#000009403 | 70841REghyWBrHyyg762Jh4sjCG7CKaIc        |
| Supplier#000009504 | Rqt07,ANI92kj1oU                         |
| Supplier#000009598 | PnTAz7rNRLVDFO3zoo2QRTlh4o               |
| Supplier#000009609 | LV2rJUGfr0k3dPNRqufG1IoYHzV              |
| Supplier#000009619 | K0RwcJ9S75Xil jqKukFoDNkD                |
| Supplier#000009626 | Nm1FnIh4asUR3EnXv2Pvy3gXqI9es            |
| Supplier#000009738 | 15RRSVTuOzwdMP LmfCtIguMGXK              |
| Supplier#000009770 | Ag, SZfowit580QPDdbP8kmFHdpZ9ASI         |
| Supplier#000009865 | extcOh9ZrdDCMsHhhsFTkTUAh,HM2UQ2qa8sRo   |
| Supplier#000009866 | Auh6aZnOnQG1pPYKZ5o9ATramJBA             |
| Supplier#000009890 | izJXemCM Ikpgxk                          |
| Supplier#000009937 | edZ9HQJ0KJAU6EWknTiDghKfRLHq6vtFqdey,0l  |
| Supplier#000009954 | VzElx9ihlXFJLIQw2Hn4bC2                  |
| Supplier#000009958 | ggiiSA4CSyvhwQUYjdJhWlKEY9PAfs           |
+--------------------+------------------------------------------+
177 rows in set


Q21
+--------------------+---------+
| s_name             | numwait |
+--------------------+---------+
| Supplier#000009302 |      21 |
| Supplier#000000342 |      20 |
| Supplier#000000632 |      19 |
| Supplier#000002196 |      19 |
| Supplier#000003325 |      18 |
| Supplier#000003915 |      18 |
| Supplier#000005045 |      18 |
| Supplier#000006442 |      18 |
| Supplier#000003093 |      17 |
| Supplier#000004498 |      17 |
| Supplier#000000906 |      16 |
| Supplier#000001183 |      16 |
| Supplier#000001477 |      16 |
| Supplier#000006043 |      16 |
| Supplier#000000689 |      15 |
| Supplier#000001955 |      15 |
| Supplier#000002066 |      15 |
| Supplier#000002146 |      15 |
| Supplier#000003253 |      15 |
| Supplier#000003527 |      15 |
| Supplier#000003947 |      15 |
| Supplier#000004915 |      15 |
| Supplier#000005248 |      15 |
| Supplier#000006718 |      15 |
| Supplier#000007773 |      15 |
| Supplier#000008121 |      15 |
| Supplier#000008169 |      15 |
| Supplier#000008645 |      15 |
| Supplier#000008684 |      15 |
| Supplier#000009079 |      15 |
| Supplier#000009956 |      15 |
| Supplier#000000737 |      14 |
| Supplier#000000775 |      14 |
| Supplier#000001474 |      14 |
| Supplier#000001502 |      14 |
| Supplier#000003196 |      14 |
| Supplier#000004415 |      14 |
| Supplier#000004940 |      14 |
| Supplier#000005253 |      14 |
| Supplier#000005703 |      14 |
| Supplier#000006308 |      14 |
| Supplier#000006789 |      14 |
| Supplier#000007161 |      14 |
| Supplier#000007952 |      14 |
| Supplier#000008062 |      14 |
| Supplier#000008414 |      14 |
| Supplier#000008442 |      14 |
| Supplier#000008508 |      14 |
| Supplier#000000300 |      13 |
| Supplier#000000727 |      13 |
| Supplier#000000921 |      13 |
| Supplier#000000992 |      13 |
| Supplier#000001282 |      13 |
| Supplier#000001582 |      13 |
| Supplier#000001662 |      13 |
| Supplier#000001683 |      13 |
| Supplier#000002933 |      13 |
| Supplier#000003177 |      13 |
| Supplier#000003428 |      13 |
| Supplier#000003640 |      13 |
| Supplier#000004842 |      13 |
| Supplier#000004951 |      13 |
| Supplier#000005795 |      13 |
| Supplier#000005981 |      13 |
| Supplier#000006118 |      13 |
| Supplier#000006433 |      13 |
| Supplier#000006484 |      13 |
| Supplier#000007268 |      13 |
| Supplier#000008599 |      13 |
| Supplier#000008675 |      13 |
| Supplier#000009474 |      13 |
| Supplier#000009521 |      13 |
| Supplier#000009853 |      13 |
| Supplier#000000021 |      12 |
| Supplier#000000211 |      12 |
| Supplier#000000743 |      12 |
| Supplier#000000951 |      12 |
| Supplier#000001654 |      12 |
| Supplier#000001868 |      12 |
| Supplier#000002089 |      12 |
| Supplier#000002879 |      12 |
| Supplier#000003060 |      12 |
| Supplier#000003215 |      12 |
| Supplier#000003365 |      12 |
| Supplier#000003873 |      12 |
| Supplier#000003985 |      12 |
| Supplier#000004452 |      12 |
| Supplier#000004639 |      12 |
| Supplier#000005122 |      12 |
| Supplier#000005633 |      12 |
| Supplier#000005671 |      12 |
| Supplier#000005782 |      12 |
| Supplier#000006088 |      12 |
| Supplier#000006477 |      12 |
| Supplier#000006508 |      12 |
| Supplier#000006750 |      12 |
| Supplier#000006802 |      12 |
| Supplier#000008236 |      12 |
| Supplier#000009294 |      12 |
| Supplier#000009329 |      12 |
+--------------------+---------+
100 rows in set

Q22
+-----------+---------+------------+
| cntrycode | numcust | totacctbal |
+-----------+---------+------------+
| 10        |     882 | 6606081.31 |
| 11        |     899 | 6702253.34 |
| 19        |     963 | 7230776.82 |
| 20        |     916 | 6824676.02 |
| 22        |     894 | 6636740.03 |
| 26        |     861 | 6404695.86 |
| 27        |     877 | 6565078.99 |
+-----------+---------+------------+
7 rows in set