完成 SSB 测试

SSB 星型模式基准测试是 OLAP 数据库性能测试的常用场景，通过本篇教程，您可以了解到如何在 MatrixOne 中实现 SSB 测试。

准备工作

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

1. 编译 dbgen

git clone https://github.com/vadimtk/ssb-dbgen.git
cd ssb-dbgen
make

Note

如果你的硬件配置为 M1 芯片，编译 dbgen 仍需进行其他配置，参见部署常见问题。

2. 生成数据

选项一：生成单表数据集

当使用 -s 1 时 dbgen 命令会生产近 600 万行数据 (670MB)，当使用 -s 10 时会生产近 6000 万行数据，会耗费大量时间。

./dbgen -s 1 -T c
./dbgen -s 1 -T l
./dbgen -s 1 -T p
./dbgen -s 1 -T s
./dbgen -s 1 -T d

选项二：下载大宽表数据集

我们准备了 1GB 的大宽表数据集供你下载。

1. 在下面链接中直接获取大宽表数据集文件：

https://community-shared-data-1308875761.cos.ap-beijing.myqcloud.com/lineorder_flat.tar.bz2

1. 下载完成后将数据文件解压。

3. 在 MatrixOne 中建表

create database if not exists ssb;
use ssb;
drop table if exists lineorder;
drop table if exists part;
drop table if exists supplier;
drop table if exists customer;
drop table if exists date;
drop table if exists lineorder_flat;
create table lineorder (
        lo_orderkey bigint,
        lo_linenumber int,
        lo_custkey int,
        lo_partkey int,
        lo_suppkey int,
        lo_orderdate date,
        lo_orderpriority char (15),
        lo_shippriority tinyint,
        lo_quantity double,
        lo_extendedprice double,
        lo_ordtotalprice double,
        lo_discount double,
        lo_revenue double,
        lo_supplycost double,
        lo_tax double,
        lo_commitdate date,
        lo_shipmode char (10)
) ;
create table part (
        p_partkey int,
        p_name varchar (22),
        p_mfgr char (6),
        p_category char (7),
        p_brand char (9),
        p_color varchar (11),
        p_type varchar (25),
        p_size int,
        p_container char (10)
) ;
create table supplier (
        s_suppkey int,
        s_name char (25),
        s_address varchar (25),
        s_city char (10),
        s_nation char (15),
        s_region char (12),
        s_phone char (15)
) ;
create table customer (
        c_custkey int,
        c_name varchar (25),
        c_address varchar (25),
        c_city char (10),
        c_nation char (15),
        c_region char (12),
        c_phone char (15),
        c_mktsegment char (10)
) ;
create table date (
        d_datekey date,
        d_date char (18),
        d_dayofweek char (9),
        d_month char (9),
        d_year int,
        d_yearmonthnum int,
        d_yearmonth char (7),
        d_daynuminweek varchar(12),
        d_daynuminmonth int,
        d_daynuminyear int,
        d_monthnuminyear int,
        d_weeknuminyear int,
        d_sellingseason varchar (12),
        d_lastdayinweekfl varchar (1),
        d_lastdayinmonthfl varchar (1),
        d_holidayfl varchar (1),
        d_weekdayfl varchar (1)
) ;
CREATE TABLE lineorder_flat(
  LO_ORDERKEY bigint key,
  LO_LINENUMBER int,
  LO_CUSTKEY int,
  LO_PARTKEY int,
  LO_SUPPKEY int,
  LO_ORDERDATE date,
  LO_ORDERPRIORITY char(15),
  LO_SHIPPRIORITY tinyint,
  LO_QUANTITY double,
  LO_EXTENDEDPRICE double,
  LO_ORDTOTALPRICE double,
  LO_DISCOUNT double,
  LO_REVENUE int unsigned,
  LO_SUPPLYCOST int unsigned,
  LO_TAX double,
  LO_COMMITDATE date,
  LO_SHIPMODE char(10),
  C_NAME varchar(25),
  C_ADDRESS varchar(25),
  C_CITY char(10),
  C_NATION char(15),
  C_REGION char(12),
  C_PHONE char(15),
  C_MKTSEGMENT char(10),
  S_NAME char(25),
  S_ADDRESS varchar(25),
  S_CITY char(10),
  S_NATION char(15),
  S_REGION char(12),
  S_PHONE char(15),
  P_NAME varchar(22),
  P_MFGR char(6),
  P_CATEGORY char(7),
  P_BRAND char(9),
  P_COLOR varchar(11),
  P_TYPE varchar(25),
  P_SIZE int,
  P_CONTAINER char(10)
);

4. 导入数据

选项一：使用如下命令导入单表数据集

load data infile '/ssb-dbgen-path/supplier.tbl' into table supplier FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';
load data infile '/ssb-dbgen-path/customer.tbl' into table customer FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';
load data infile '/ssb-dbgen-path/date.tbl' into table date FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';
load data infile '/ssb-dbgen-path/part.tbl' into table part FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';
load data infile '/ssb-dbgen-path/lineorder.tbl' into table lineorder FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';

接着你可以在 MatrixOne 中进行查询操作。

选项二：使用如下命令导入大宽表数据集

运行以下命令将数据导入 lineorder_flat：

load data infile '/ssb-dbgen-path/lineorder_flat.tbl' into table lineorder_flat FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';

5. 运行 SSB 测试命令

Note

GROUP BY 暂不支持使用别名。

单表查询

-- Q1.1
SELECT sum(LO_EXTENDEDPRICE * LO_DISCOUNT) AS revenue FROM lineorder_flat WHERE year(LO_ORDERDATE)=1993 AND LO_DISCOUNT BETWEEN 1 AND 3 AND LO_QUANTITY < 25;
-- Q1.2
SELECT sum(LO_EXTENDEDPRICE * LO_DISCOUNT) AS revenue FROM lineorder_flat WHERE year(LO_ORDERDATE)=1994 AND LO_DISCOUNT BETWEEN 4 AND 6 AND LO_QUANTITY BETWEEN 26 AND 35;
-- Q1.3
SELECT sum(LO_EXTENDEDPRICE * LO_DISCOUNT) AS revenue FROM lineorder_flat WHERE year(LO_ORDERDATE)=1994 AND LO_DISCOUNT BETWEEN 5 AND 7 AND LO_QUANTITY BETWEEN 26 AND 35;
-- Q2.1
SELECT sum(LO_REVENUE),year(LO_ORDERDATE) AS year,P_BRAND FROM lineorder_flat WHERE P_CATEGORY = 'MFGR#12' AND S_REGION = 'AMERICA' GROUP BY year(LO_ORDERDATE), P_BRAND ORDER BY year,P_BRAND;
-- Q2.2
SELECT sum(LO_REVENUE), year(LO_ORDERDATE) AS year, P_BRAND FROM lineorder_flat WHERE P_BRAND BETWEEN 'MFGR#2221' AND 'MFGR#2228' AND S_REGION = 'ASIA' GROUP BY year(LO_ORDERDATE), P_BRAND ORDER BY year, P_BRAND;
-- Q2.3
SELECT sum(LO_REVENUE), year(LO_ORDERDATE) AS year, P_BRAND FROM lineorder_flat WHERE P_BRAND = 'MFGR#2239' AND S_REGION = 'EUROPE' GROUP BY year(LO_ORDERDATE), P_BRAND ORDER BY year, P_BRAND;
-- Q3.1
SELECT C_NATION, S_NATION, year(LO_ORDERDATE) AS year, sum(LO_REVENUE) AS revenue FROM lineorder_flat WHERE C_REGION = 'ASIA' AND S_REGION = 'ASIA' AND year(LO_ORDERDATE)  between 1992 AND 1997 GROUP BY C_NATION, S_NATION, year(LO_ORDERDATE) ORDER BY year asc, revenue desc;
-- Q3.2
SELECT C_CITY, S_CITY, year(LO_ORDERDATE) AS year, sum(LO_REVENUE) AS revenue FROM lineorder_flat WHERE C_NATION = 'CHINA' AND S_NATION = 'CHINA' AND year(LO_ORDERDATE)  between 1992 AND 1997 GROUP BY C_CITY, S_CITY, year(LO_ORDERDATE)  ORDER BY year asc, revenue desc;
-- Q3.3
SELECT C_CITY, S_CITY, year(LO_ORDERDATE) AS year, sum(LO_REVENUE) AS revenue FROM lineorder_flat WHERE (C_CITY = 'UNITED KI0' OR C_CITY = 'UNITED KI7') AND (S_CITY = 'UNITED KI0' OR S_CITY = 'UNITED KI7') AND year(LO_ORDERDATE)  between 1992 AND 1997 GROUP BY C_CITY, S_CITY, year(LO_ORDERDATE) ORDER BY year asc, revenue desc;
-- Q3.4
SELECT C_CITY, S_CITY, year(LO_ORDERDATE) AS year, sum(LO_REVENUE) AS revenue FROM lineorder_flat WHERE (C_CITY = 'UNITED KI0' OR C_CITY = 'UNITED KI7') AND (S_CITY = 'MOZAMBIQU1' OR S_CITY = 'KENYA    4') AND year(LO_ORDERDATE)= 1997 GROUP BY C_CITY, S_CITY, year(LO_ORDERDATE) ORDER BY year asc, revenue desc;
-- Q4.1
SELECT year(LO_ORDERDATE) AS year, C_NATION, sum(LO_REVENUE - LO_SUPPLYCOST) AS profit FROM lineorder_flat WHERE C_REGION = 'AMERICA' AND S_REGION = 'AMERICA' AND (P_MFGR = 'MFGR#1' OR P_MFGR = 'MFGR#2') GROUP BY year(LO_ORDERDATE), C_NATION ORDER BY year, C_NATION;
-- Q4.2
SELECT year(LO_ORDERDATE) AS year, S_NATION, P_CATEGORY, sum(LO_REVENUE - LO_SUPPLYCOST) AS profit FROM lineorder_flat WHERE C_REGION = 'AMERICA' AND S_REGION = 'AMERICA' AND (year(LO_ORDERDATE) = 1997 OR year(LO_ORDERDATE) = 1998) AND (P_MFGR = 'MFGR#1' OR P_MFGR = 'MFGR#2') GROUP BY  year(LO_ORDERDATE), S_NATION, P_CATEGORY ORDER BY year, S_NATION, P_CATEGORY;
-- Q4.3
SELECT year(LO_ORDERDATE) AS year, S_CITY, P_BRAND, sum(LO_REVENUE - LO_SUPPLYCOST) AS profit FROM lineorder_flat WHERE S_NATION = 'UNITED STATES' AND (year(LO_ORDERDATE) = 1997 OR year(LO_ORDERDATE) = 1998) AND P_CATEGORY = 'MFGR#14' GROUP BY  year(LO_ORDERDATE), S_CITY, P_BRAND ORDER BY year, S_CITY, P_BRAND;

多表查询

-- Q1.1
select sum(lo_revenue) as revenue
from lineorder join date on lo_orderdate = d_datekey
where year(d_datekey)  = 1993 and lo_discount between 1 and 3 and lo_quantity < 25;
-- Q1.2
select sum(lo_revenue) as revenue
from lineorder
join date on lo_orderdate = d_datekey
where d_yearmonthnum = 199401
and lo_discount between 4 and 6
and lo_quantity between 26 and 35;
-- Q1.3
select sum(lo_revenue) as revenue
from lineorder
join date on lo_orderdate = d_datekey
where d_weeknuminyear = 6 and year(d_datekey)  = 1994
and lo_discount between 5 and 7
and lo_quantity between 26 and 35;
-- Q2.1
select sum(lo_revenue) as lo_revenue, year(d_datekey) as year, p_brand
from lineorder
join date on lo_orderdate = d_datekey
join part on lo_partkey = p_partkey
join supplier on lo_suppkey = s_suppkey
where p_category = 'MFGR#12' and s_region = 'AMERICA'
group by year(d_datekey), p_brand
order by year, p_brand;
-- Q2.2
select sum(lo_revenue) as lo_revenue, year(d_datekey) as year, p_brand
from lineorder
join date on lo_orderdate = d_datekey
join part on lo_partkey = p_partkey
join supplier on lo_suppkey = s_suppkey
where p_brand between 'MFGR#2221' and 'MFGR#2228' and s_region = 'ASIA'
group by year(d_datekey), p_brand
order by year, p_brand;
-- Q2.3
select sum(lo_revenue) as lo_revenue, year(d_datekey) as year, p_brand
from lineorder
join date on lo_orderdate = d_datekey
join part on lo_partkey = p_partkey
join supplier on lo_suppkey = s_suppkey
where p_brand = 'MFGR#2239' and s_region = 'EUROPE'
group by year(d_datekey), p_brand
order by year, p_brand;
-- Q3.1
select c_nation, s_nation, year(d_datekey) as year, sum(lo_revenue) as lo_revenue
from lineorder
join date on lo_orderdate = d_datekey
join customer on lo_custkey = c_custkey
join supplier on lo_suppkey = s_suppkey
where c_region = 'ASIA' and s_region = 'ASIA' and year(d_datekey) between 1992 and 1997
group by c_nation, s_nation, year(d_datekey)
order by year asc, lo_revenue desc;
-- Q3.2
select c_city, s_city, year(d_datekey) as year, sum(lo_revenue) as lo_revenue
from lineorder
join date on lo_orderdate = d_datekey
join customer on lo_custkey = c_custkey
join supplier on lo_suppkey = s_suppkey
where c_nation = 'UNITED STATES' and s_nation = 'UNITED STATES'
and year(d_datekey) between 1992 and 1997
group by c_city, s_city, year(d_datekey)
order by year asc, lo_revenue desc;
-- Q3.3
select c_city, s_city, year(d_datekey) as year, sum(lo_revenue) as lo_revenue
from lineorder
join date on lo_orderdate = d_datekey
join customer on lo_custkey = c_custkey
join supplier on lo_suppkey = s_suppkey
where (c_city='UNITED KI1' or c_city='UNITED KI5')
and (s_city='UNITED KI1' or s_city='UNITED KI5')
and year(d_datekey) between 1992 and 1997
group by c_city, s_city, year(d_datekey)
order by year asc, lo_revenue desc;
-- Q3.4
select c_city, s_city, year(d_datekey) as year, sum(lo_revenue) as lo_revenue
from lineorder
join date on lo_orderdate = d_datekey
join customer on lo_custkey = c_custkey
join supplier on lo_suppkey = s_suppkey
where (c_city='UNITED KI1' or c_city='UNITED KI5') and (s_city='UNITED KI1' or s_city='UNITED KI5') and d_yearmonth = '199712'
group by c_city, s_city, year(d_datekey)
order by year(d_datekey) asc, lo_revenue desc;
-- Q4.1
select year(d_datekey) as year, c_nation, sum(lo_revenue) - sum(lo_supplycost) as profit
from lineorder
join date on lo_orderdate = d_datekey
join customer on lo_custkey = c_custkey
join supplier on lo_suppkey = s_suppkey
join part on lo_partkey = p_partkey
where c_region = 'AMERICA' and s_region = 'AMERICA' and (p_mfgr = 'MFGR#1' or p_mfgr = 'MFGR#2')
group by year(d_datekey), c_nation
order by year, c_nation;
-- Q4.2
select year(d_datekey) as year, s_nation, p_category, sum(lo_revenue) - sum(lo_supplycost) as profit
from lineorder
join date on lo_orderdate = d_datekey
join customer on lo_custkey = c_custkey
join supplier on lo_suppkey = s_suppkey
join part on lo_partkey = p_partkey
where c_region = 'AMERICA'and s_region = 'AMERICA'
and (year(d_datekey) = 1997 or year(d_datekey) = 1998)
and (p_mfgr = 'MFGR#1' or p_mfgr = 'MFGR#2')
group by year(d_datekey), s_nation, p_category
order by year, s_nation, p_category;
-- Q4.3
select year(d_datekey) as year, s_city, p_brand, sum(lo_revenue) - sum(lo_supplycost) as profit
from lineorder
join dates on lo_orderdate = d_datekey
join customer on lo_custkey = c_custkey
join supplier on lo_suppkey = s_suppkey
join part on lo_partkey = p_partkey
where
(year(d_datekey) = 1997 or year(d_datekey) = 1998)
and c_region = 'AMERICA'
and s_nation = 'UNITED STATES'
and p_category = 'MFGR#14'
group by year, s_city, p_brand
order by year, s_city, p_brand;

6. 运行预期结果

单表查询运行预期结果

-- Q1.1
+--------------+
| revenue      |
+--------------+
| 702223464659 |
+--------------+
-- Q1.2
+---------------+
| revenue       |
+---------------+
| 1842875090496 |
+---------------+
-- Q1.3
+---------------+
| revenue       |
+---------------+
| 2208738861324 |
+---------------+
-- Q2.1
+-----------------+------+-----------+
| sum(lo_revenue) | year | p_brand   |
+-----------------+------+-----------+
|       283684289 | 1992 | MFGR#121  |
|      1344702529 | 1992 | MFGR#1210 |
|       757158682 | 1992 | MFGR#1211 |
|      1156022815 | 1992 | MFGR#1212 |
|       676164367 | 1992 | MFGR#1213 |
|       522779256 | 1992 | MFGR#1214 |
|       233507213 | 1992 | MFGR#1215 |
|       726755819 | 1992 | MFGR#1216 |
|      1865504710 | 1992 | MFGR#1217 |
|       685600451 | 1992 | MFGR#1218 |
|       814671470 | 1992 | MFGR#1219 |
|       655405800 | 1992 | MFGR#122  |
|       962120553 | 1992 | MFGR#1220 |
|       961393626 | 1992 | MFGR#1221 |
|       922110830 | 1992 | MFGR#1222 |
|       814842712 | 1992 | MFGR#1223 |
|      1402773165 | 1992 | MFGR#1224 |
|       977517439 | 1992 | MFGR#1225 |
|      1392114944 | 1992 | MFGR#1226 |
|       658922951 | 1992 | MFGR#1227 |
|       892495927 | 1992 | MFGR#1228 |
|       806609100 | 1992 | MFGR#1229 |
|       578875657 | 1992 | MFGR#123  |
|       691236902 | 1992 | MFGR#1230 |
|       482715249 | 1992 | MFGR#1231 |
|       618556590 | 1992 | MFGR#1232 |
|       981657009 | 1992 | MFGR#1233 |
|      1050794669 | 1992 | MFGR#1234 |
|      1335217991 | 1992 | MFGR#1235 |
|       686009527 | 1992 | MFGR#1236 |
|       605242584 | 1992 | MFGR#1237 |
|       430455641 | 1992 | MFGR#1238 |
|       359654993 | 1992 | MFGR#1239 |
|       818818457 | 1992 | MFGR#124  |
|      1388502581 | 1992 | MFGR#1240 |
|       711566198 | 1992 | MFGR#125  |
|       893045647 | 1992 | MFGR#126  |
|      1240534333 | 1992 | MFGR#127  |
|       871966127 | 1992 | MFGR#128  |
|       719176622 | 1992 | MFGR#129  |
|       245880758 | 1993 | MFGR#121  |
|      1480662753 | 1993 | MFGR#1210 |
|       982292725 | 1993 | MFGR#1211 |
|      1001136766 | 1993 | MFGR#1212 |
|       227144072 | 1993 | MFGR#1213 |
|       291611370 | 1993 | MFGR#1214 |
|       454576668 | 1993 | MFGR#1215 |
|       772027256 | 1993 | MFGR#1216 |
|      1155751851 | 1993 | MFGR#1217 |
|       897883050 | 1993 | MFGR#1218 |
|      1209508962 | 1993 | MFGR#1219 |
|       530577973 | 1993 | MFGR#122  |
|       901650471 | 1993 | MFGR#1220 |
|       739540494 | 1993 | MFGR#1221 |
|       698751459 | 1993 | MFGR#1222 |
|      1327979157 | 1993 | MFGR#1223 |
|      1476697469 | 1993 | MFGR#1224 |
|       792103134 | 1993 | MFGR#1225 |
|      1420277376 | 1993 | MFGR#1226 |
|      1446032835 | 1993 | MFGR#1227 |
|       884375309 | 1993 | MFGR#1228 |
|       522705868 | 1993 | MFGR#1229 |
|       601685233 | 1993 | MFGR#123  |
|       806727248 | 1993 | MFGR#1230 |
|       399477390 | 1993 | MFGR#1231 |
|       894047578 | 1993 | MFGR#1232 |
|       496067089 | 1993 | MFGR#1233 |
|      1050223756 | 1993 | MFGR#1234 |
|       891681399 | 1993 | MFGR#1235 |
|      1402903631 | 1993 | MFGR#1236 |
|       347380448 | 1993 | MFGR#1237 |
|       514853194 | 1993 | MFGR#1238 |
|       410543863 | 1993 | MFGR#1239 |
|       673483594 | 1993 | MFGR#124  |
|       713343630 | 1993 | MFGR#1240 |
|       512610707 | 1993 | MFGR#125  |
|      1228110634 | 1993 | MFGR#126  |
|       936958961 | 1993 | MFGR#127  |
|       579067515 | 1993 | MFGR#128  |
|       636174833 | 1993 | MFGR#129  |
|       370347074 | 1994 | MFGR#121  |
|       483900410 | 1994 | MFGR#1210 |
|      1240306281 | 1994 | MFGR#1211 |
|      1003345253 | 1994 | MFGR#1212 |
|       557310864 | 1994 | MFGR#1213 |
|       314972328 | 1994 | MFGR#1214 |
|      1130260810 | 1994 | MFGR#1215 |
|       401618319 | 1994 | MFGR#1216 |
|       652173601 | 1994 | MFGR#1217 |
|       923612074 | 1994 | MFGR#1218 |
|       469711377 | 1994 | MFGR#1219 |
|       580152115 | 1994 | MFGR#122  |
|       433134653 | 1994 | MFGR#1220 |
|       730569849 | 1994 | MFGR#1221 |
|       607609104 | 1994 | MFGR#1222 |
|       949877669 | 1994 | MFGR#1223 |
|      1644687916 | 1994 | MFGR#1224 |
|       492974194 | 1994 | MFGR#1225 |
|       921499688 | 1994 | MFGR#1226 |
|       719059761 | 1994 | MFGR#1227 |
|      1000497056 | 1994 | MFGR#1228 |
|       486968927 | 1994 | MFGR#1229 |
|       734124906 | 1994 | MFGR#123  |
|       645016873 | 1994 | MFGR#1230 |
|       526638240 | 1994 | MFGR#1231 |
|      1358112405 | 1994 | MFGR#1232 |
|      1167074905 | 1994 | MFGR#1233 |
|      1102915239 | 1994 | MFGR#1234 |
|       693058125 | 1994 | MFGR#1235 |
|      1673392892 | 1994 | MFGR#1236 |
|       849630029 | 1994 | MFGR#1237 |
|       721392705 | 1994 | MFGR#1238 |
|      1237195774 | 1994 | MFGR#1239 |
|      1107832795 | 1994 | MFGR#124  |
|       827906290 | 1994 | MFGR#1240 |
|       682827304 | 1994 | MFGR#125  |
|      1198768141 | 1994 | MFGR#126  |
|      1274148181 | 1994 | MFGR#127  |
|       738849138 | 1994 | MFGR#128  |
|       751136619 | 1994 | MFGR#129  |
|       318978803 | 1995 | MFGR#121  |
|       383199448 | 1995 | MFGR#1210 |
|      1300165814 | 1995 | MFGR#1211 |
|      1550400731 | 1995 | MFGR#1212 |
|       451958158 | 1995 | MFGR#1213 |
|       431434279 | 1995 | MFGR#1214 |
|       713735582 | 1995 | MFGR#1215 |
|       919323722 | 1995 | MFGR#1216 |
|      1542358864 | 1995 | MFGR#1217 |
|       500930092 | 1995 | MFGR#1218 |
|      1208162086 | 1995 | MFGR#1219 |
|       785707989 | 1995 | MFGR#122  |
|       993828211 | 1995 | MFGR#1220 |
|       667253893 | 1995 | MFGR#1221 |
|      1654114297 | 1995 | MFGR#1222 |
|       986528377 | 1995 | MFGR#1223 |
|       755014642 | 1995 | MFGR#1224 |
|      1090300100 | 1995 | MFGR#1225 |
|      1063626454 | 1995 | MFGR#1226 |
|      1382528859 | 1995 | MFGR#1227 |
|       919953351 | 1995 | MFGR#1228 |
|       457795295 | 1995 | MFGR#1229 |
|       953851827 | 1995 | MFGR#123  |
|       807209283 | 1995 | MFGR#1230 |
|       236304454 | 1995 | MFGR#1231 |
|       668449537 | 1995 | MFGR#1232 |
|       240657083 | 1995 | MFGR#1233 |
|       920389826 | 1995 | MFGR#1234 |
|       684096065 | 1995 | MFGR#1235 |
|      1005844219 | 1995 | MFGR#1236 |
|       626170996 | 1995 | MFGR#1237 |
|       984581826 | 1995 | MFGR#1238 |
|       602850634 | 1995 | MFGR#1239 |
|      1172025628 | 1995 | MFGR#124  |
|       489788581 | 1995 | MFGR#1240 |
|       643100327 | 1995 | MFGR#125  |
|       894596661 | 1995 | MFGR#126  |
|       706917239 | 1995 | MFGR#127  |
|       428671983 | 1995 | MFGR#128  |
|       971611472 | 1995 | MFGR#129  |
|       306497573 | 1996 | MFGR#121  |
|       890719726 | 1996 | MFGR#1210 |
|      1761977172 | 1996 | MFGR#1211 |
|       633845765 | 1996 | MFGR#1212 |
|       475801202 | 1996 | MFGR#1213 |
|       271930385 | 1996 | MFGR#1214 |
|       366399844 | 1996 | MFGR#1215 |
|       877472476 | 1996 | MFGR#1216 |
|       970366290 | 1996 | MFGR#1217 |
|       537175690 | 1996 | MFGR#1218 |
|       956970528 | 1996 | MFGR#1219 |
|       711962074 | 1996 | MFGR#122  |
|      1062161683 | 1996 | MFGR#1220 |
|       406293744 | 1996 | MFGR#1221 |
|       785404335 | 1996 | MFGR#1222 |
|       579267044 | 1996 | MFGR#1223 |
|      1220640256 | 1996 | MFGR#1224 |
|       490130196 | 1996 | MFGR#1225 |
|      1603805636 | 1996 | MFGR#1226 |
|      1530646510 | 1996 | MFGR#1227 |
|      1093328922 | 1996 | MFGR#1228 |
|       596520140 | 1996 | MFGR#1229 |
|       450815571 | 1996 | MFGR#123  |
|       315053350 | 1996 | MFGR#1230 |
|       198951017 | 1996 | MFGR#1231 |
|       579778438 | 1996 | MFGR#1232 |
|       480905486 | 1996 | MFGR#1233 |
|      1433336215 | 1996 | MFGR#1234 |
|       560925251 | 1996 | MFGR#1235 |
|      1038766181 | 1996 | MFGR#1236 |
|       783697960 | 1996 | MFGR#1237 |
|       972656445 | 1996 | MFGR#1238 |
|       614528801 | 1996 | MFGR#1239 |
|      1418931894 | 1996 | MFGR#124  |
|       995139591 | 1996 | MFGR#1240 |
|       824028471 | 1996 | MFGR#125  |
|       669475113 | 1996 | MFGR#126  |
|       831704651 | 1996 | MFGR#127  |
|       920514555 | 1996 | MFGR#128  |
|       436162421 | 1996 | MFGR#129  |
|       553684594 | 1997 | MFGR#121  |
|      1317368046 | 1997 | MFGR#1210 |
|      1617056983 | 1997 | MFGR#1211 |
|      1196031005 | 1997 | MFGR#1212 |
|      1056458336 | 1997 | MFGR#1213 |
|       352179650 | 1997 | MFGR#1214 |
|       511058114 | 1997 | MFGR#1215 |
|       658259312 | 1997 | MFGR#1216 |
|      1238450697 | 1997 | MFGR#1217 |
|       376245955 | 1997 | MFGR#1218 |
|       913437812 | 1997 | MFGR#1219 |
|      1114996000 | 1997 | MFGR#122  |
|       814059433 | 1997 | MFGR#1220 |
|       817328516 | 1997 | MFGR#1221 |
|       541428597 | 1997 | MFGR#1222 |
|      1260539052 | 1997 | MFGR#1223 |
|      1766426582 | 1997 | MFGR#1224 |
|      1221271245 | 1997 | MFGR#1225 |
|      1499152922 | 1997 | MFGR#1226 |
|       491586909 | 1997 | MFGR#1227 |
|       911517084 | 1997 | MFGR#1228 |
|       728186585 | 1997 | MFGR#1229 |
|       904363416 | 1997 | MFGR#123  |
|       605369014 | 1997 | MFGR#1230 |
|       290370455 | 1997 | MFGR#1231 |
|       602414397 | 1997 | MFGR#1232 |
|       765339065 | 1997 | MFGR#1233 |
|      1170973957 | 1997 | MFGR#1234 |
|       860319765 | 1997 | MFGR#1235 |
|      1031080311 | 1997 | MFGR#1236 |
|       736404810 | 1997 | MFGR#1237 |
|      1012330790 | 1997 | MFGR#1238 |
|       681055343 | 1997 | MFGR#1239 |
|       601626600 | 1997 | MFGR#124  |
|       920404157 | 1997 | MFGR#1240 |
|      1007678757 | 1997 | MFGR#125  |
|       622347203 | 1997 | MFGR#126  |
|      1215295592 | 1997 | MFGR#127  |
|       822274972 | 1997 | MFGR#128  |
|       643903475 | 1997 | MFGR#129  |
|       470008435 | 1998 | MFGR#121  |
|       568508492 | 1998 | MFGR#1210 |
|       323759101 | 1998 | MFGR#1211 |
|       572013331 | 1998 | MFGR#1212 |
|       448137748 | 1998 | MFGR#1213 |
|       137422458 | 1998 | MFGR#1214 |
|       346491756 | 1998 | MFGR#1215 |
|       454542243 | 1998 | MFGR#1216 |
|       759205210 | 1998 | MFGR#1217 |
|       674544462 | 1998 | MFGR#1218 |
|       735952270 | 1998 | MFGR#1219 |
|       490186568 | 1998 | MFGR#122  |
|       769456686 | 1998 | MFGR#1220 |
|       654540341 | 1998 | MFGR#1221 |
|       800329859 | 1998 | MFGR#1222 |
|       263849231 | 1998 | MFGR#1223 |
|       445461642 | 1998 | MFGR#1224 |
|       387808862 | 1998 | MFGR#1225 |
|       675424382 | 1998 | MFGR#1226 |
|       265906673 | 1998 | MFGR#1227 |
|       585938371 | 1998 | MFGR#1228 |
|       683188537 | 1998 | MFGR#1229 |
|       304403717 | 1998 | MFGR#123  |
|       533781674 | 1998 | MFGR#1230 |
|       304060011 | 1998 | MFGR#1231 |
|       635275907 | 1998 | MFGR#1232 |
|       658295080 | 1998 | MFGR#1233 |
|       524133341 | 1998 | MFGR#1234 |
|       363911877 | 1998 | MFGR#1235 |
|       300885635 | 1998 | MFGR#1236 |
|       532608453 | 1998 | MFGR#1237 |
|       484291410 | 1998 | MFGR#1238 |
|       445336624 | 1998 | MFGR#1239 |
|       719027801 | 1998 | MFGR#124  |
|       518860961 | 1998 | MFGR#1240 |
|       491235383 | 1998 | MFGR#125  |
|       520917638 | 1998 | MFGR#126  |
|      1158787745 | 1998 | MFGR#127  |
|       401190922 | 1998 | MFGR#128  |
|       406656337 | 1998 | MFGR#129  |
+-----------------+------+-----------+
-- Q2.2
+-----------------+------+-----------+
| sum(lo_revenue) | year | p_brand   |
+-----------------+------+-----------+
|      1259802358 | 1992 | MFGR#2221 |
|      1728549344 | 1992 | MFGR#2222 |
|      1375260024 | 1992 | MFGR#2223 |
|      1299982475 | 1992 | MFGR#2224 |
|      1541960331 | 1992 | MFGR#2225 |
|      1151853513 | 1992 | MFGR#2226 |
|      1271175264 | 1992 | MFGR#2227 |
|      1726441695 | 1992 | MFGR#2228 |
|      1251460032 | 1993 | MFGR#2221 |
|      1331062515 | 1993 | MFGR#2222 |
|       902809293 | 1993 | MFGR#2223 |
|       980512417 | 1993 | MFGR#2224 |
|      1253088003 | 1993 | MFGR#2225 |
|       959195148 | 1993 | MFGR#2226 |
|       555593932 | 1993 | MFGR#2227 |
|      2186479174 | 1993 | MFGR#2228 |
|      1094092222 | 1994 | MFGR#2221 |
|      1491699323 | 1994 | MFGR#2222 |
|      1501160826 | 1994 | MFGR#2223 |
|      1387107418 | 1994 | MFGR#2224 |
|      1641588884 | 1994 | MFGR#2225 |
|      1387296390 | 1994 | MFGR#2226 |
|      1038341470 | 1994 | MFGR#2227 |
|      1565763138 | 1994 | MFGR#2228 |
|      1412945650 | 1995 | MFGR#2221 |
|      1546178356 | 1995 | MFGR#2222 |
|      1218352073 | 1995 | MFGR#2223 |
|      1052197762 | 1995 | MFGR#2224 |
|      1822921900 | 1995 | MFGR#2225 |
|       728142181 | 1995 | MFGR#2226 |
|       966131607 | 1995 | MFGR#2227 |
|      1379320517 | 1995 | MFGR#2228 |
|      1042767284 | 1996 | MFGR#2221 |
|       994733835 | 1996 | MFGR#2222 |
|      1615788545 | 1996 | MFGR#2223 |
|      1113980216 | 1996 | MFGR#2224 |
|      1622570253 | 1996 | MFGR#2225 |
|      1540226758 | 1996 | MFGR#2226 |
|      1115687883 | 1996 | MFGR#2227 |
|      1716355343 | 1996 | MFGR#2228 |
|       867705636 | 1997 | MFGR#2221 |
|      1529877498 | 1997 | MFGR#2222 |
|      1594444450 | 1997 | MFGR#2223 |
|       587421043 | 1997 | MFGR#2224 |
|      1112274470 | 1997 | MFGR#2225 |
|      1327884722 | 1997 | MFGR#2226 |
|       884180880 | 1997 | MFGR#2227 |
|      1664207656 | 1997 | MFGR#2228 |
|       827743515 | 1998 | MFGR#2221 |
|       662242310 | 1998 | MFGR#2222 |
|       861445539 | 1998 | MFGR#2223 |
|       694538672 | 1998 | MFGR#2224 |
|       675179021 | 1998 | MFGR#2225 |
|       480728720 | 1998 | MFGR#2226 |
|       643763072 | 1998 | MFGR#2227 |
|       994499201 | 1998 | MFGR#2228 |
+-----------------+------+-----------+
-- Q2.3
+-----------------+------+-----------+
| sum(lo_revenue) | year | p_brand   |
+-----------------+------+-----------+
|      1428843284 | 1992 | MFGR#2239 |
|      1865666054 | 1993 | MFGR#2239 |
|      2242753254 | 1994 | MFGR#2239 |
|      1446677305 | 1995 | MFGR#2239 |
|       921681503 | 1996 | MFGR#2239 |
|      1549990572 | 1997 | MFGR#2239 |
|       926327433 | 1998 | MFGR#2239 |
+-----------------+------+-----------+
-- Q3.1
+-----------+-----------+------+-------------+
| c_nation  | s_nation  | year | revenue     |
+-----------+-----------+------+-------------+
| VIETNAM   | CHINA     | 1992 | 17194479086 |
| JAPAN     | CHINA     | 1992 | 15572594510 |
| JAPAN     | JAPAN     | 1992 | 13861682954 |
| INDONESIA | CHINA     | 1992 | 13499663933 |
| VIETNAM   | INDONESIA | 1992 | 13163103649 |
| JAPAN     | INDONESIA | 1992 | 13035158590 |
| INDIA     | CHINA     | 1992 | 12987688902 |
| INDONESIA | JAPAN     | 1992 | 12939737918 |
| VIETNAM   | JAPAN     | 1992 | 12174715858 |
| JAPAN     | VIETNAM   | 1992 | 11669093753 |
| INDIA     | INDONESIA | 1992 | 11452602145 |
| INDONESIA | INDONESIA | 1992 | 10394407561 |
| INDIA     | JAPAN     | 1992 | 10313084900 |
| JAPAN     | INDIA     | 1992 | 10035511089 |
| CHINA     | CHINA     | 1992 |  9828744666 |
| VIETNAM   | VIETNAM   | 1992 |  9701522505 |
| INDONESIA | INDIA     | 1992 |  9271105764 |
| INDIA     | INDIA     | 1992 |  8879645522 |
| CHINA     | INDONESIA | 1992 |  8373693838 |
| CHINA     | JAPAN     | 1992 |  8051248951 |
| VIETNAM   | INDIA     | 1992 |  7804539029 |
| INDONESIA | VIETNAM   | 1992 |  7615465790 |
| CHINA     | INDIA     | 1992 |  7344868842 |
| INDIA     | VIETNAM   | 1992 |  6830508508 |
| CHINA     | VIETNAM   | 1992 |  6529888238 |
| JAPAN     | CHINA     | 1993 | 18839180326 |
| VIETNAM   | CHINA     | 1993 | 14761890330 |
| JAPAN     | INDONESIA | 1993 | 13648082171 |
| INDONESIA | CHINA     | 1993 | 13518181805 |
| INDIA     | CHINA     | 1993 | 13249555999 |
| JAPAN     | JAPAN     | 1993 | 12667833152 |
| JAPAN     | VIETNAM   | 1993 | 11529854580 |
| CHINA     | CHINA     | 1993 | 11216468573 |
| INDONESIA | INDONESIA | 1993 | 10953284722 |
| VIETNAM   | INDONESIA | 1993 | 10582912267 |
| INDIA     | JAPAN     | 1993 | 10482950584 |
| VIETNAM   | JAPAN     | 1993 | 10370811002 |
| INDIA     | INDONESIA | 1993 | 10145286112 |
| INDONESIA | JAPAN     | 1993 |  9850020303 |
| VIETNAM   | VIETNAM   | 1993 |  9591468153 |
| CHINA     | INDONESIA | 1993 |  9015864524 |
| CHINA     | JAPAN     | 1993 |  8972996729 |
| INDONESIA | INDIA     | 1993 |  8903638786 |
| JAPAN     | INDIA     | 1993 |  8848048514 |
| INDONESIA | VIETNAM   | 1993 |  8024464882 |
| VIETNAM   | INDIA     | 1993 |  7806575746 |
| INDIA     | VIETNAM   | 1993 |  7537331106 |
| INDIA     | INDIA     | 1993 |  7211053846 |
| CHINA     | VIETNAM   | 1993 |  6700022269 |
| CHINA     | INDIA     | 1993 |  6327331541 |
| JAPAN     | CHINA     | 1994 | 15661051644 |
| VIETNAM   | CHINA     | 1994 | 13958591931 |
| JAPAN     | JAPAN     | 1994 | 13566252348 |
| CHINA     | CHINA     | 1994 | 12870010072 |
| VIETNAM   | JAPAN     | 1994 | 12728320716 |
| INDONESIA | CHINA     | 1994 | 12295790872 |
| INDIA     | CHINA     | 1994 | 12166419121 |
| JAPAN     | INDONESIA | 1994 | 11358955025 |
| INDIA     | INDONESIA | 1994 | 11111248365 |
| JAPAN     | INDIA     | 1994 | 10078806371 |
| VIETNAM   | INDONESIA | 1994 |  9923852578 |
| INDIA     | JAPAN     | 1994 |  9839136767 |
| CHINA     | JAPAN     | 1994 |  9836586308 |
| INDONESIA | JAPAN     | 1994 |  9786694572 |
| INDIA     | VIETNAM   | 1994 |  9551081406 |
| JAPAN     | VIETNAM   | 1994 |  9035431932 |
| VIETNAM   | INDIA     | 1994 |  9032319402 |
| INDONESIA | INDONESIA | 1994 |  8876012426 |
| CHINA     | INDONESIA | 1994 |  8375581981 |
| VIETNAM   | VIETNAM   | 1994 |  8095638136 |
| INDONESIA | INDIA     | 1994 |  7943993512 |
| INDONESIA | VIETNAM   | 1994 |  7927236697 |
| INDIA     | INDIA     | 1994 |  7534915457 |
| CHINA     | VIETNAM   | 1994 |  6062387221 |
| CHINA     | INDIA     | 1994 |  5816794324 |
| VIETNAM   | CHINA     | 1995 | 15128423080 |
| INDONESIA | CHINA     | 1995 | 14794647970 |
| INDIA     | CHINA     | 1995 | 14724240804 |
| JAPAN     | CHINA     | 1995 | 14579848516 |
| CHINA     | CHINA     | 1995 | 14296657586 |
| INDIA     | JAPAN     | 1995 | 13511381754 |
| JAPAN     | JAPAN     | 1995 | 12015968288 |
| VIETNAM   | INDONESIA | 1995 | 11290647784 |
| JAPAN     | INDONESIA | 1995 | 10968840402 |
| INDIA     | INDONESIA | 1995 | 10879296370 |
| CHINA     | INDONESIA | 1995 | 10611767914 |
| VIETNAM   | JAPAN     | 1995 | 10493043807 |
| INDONESIA | INDONESIA | 1995 | 10350165199 |
| VIETNAM   | INDIA     | 1995 | 10147175135 |
| CHINA     | JAPAN     | 1995 |  9967113498 |
| JAPAN     | VIETNAM   | 1995 |  9871240910 |
| INDONESIA | JAPAN     | 1995 |  9554798320 |
| JAPAN     | INDIA     | 1995 |  9224478715 |
| INDIA     | INDIA     | 1995 |  8880501531 |
| VIETNAM   | VIETNAM   | 1995 |  8530802028 |
| INDIA     | VIETNAM   | 1995 |  8470249830 |
| CHINA     | INDIA     | 1995 |  8460557790 |
| INDONESIA | VIETNAM   | 1995 |  8393411088 |
| CHINA     | VIETNAM   | 1995 |  7838238263 |
| INDONESIA | INDIA     | 1995 |  7001659338 |
| JAPAN     | CHINA     | 1996 | 14974943391 |
| INDIA     | CHINA     | 1996 | 14236197987 |
| VIETNAM   | CHINA     | 1996 | 13723231674 |
| JAPAN     | INDONESIA | 1996 | 13304501801 |
| INDONESIA | CHINA     | 1996 | 12444022202 |
| CHINA     | CHINA     | 1996 | 12120893189 |
| INDIA     | JAPAN     | 1996 | 11649117519 |
| INDONESIA | JAPAN     | 1996 | 11345350775 |
| VIETNAM   | JAPAN     | 1996 | 11294284203 |
| INDONESIA | INDONESIA | 1996 | 11111201530 |
| JAPAN     | INDIA     | 1996 | 10871364136 |
| JAPAN     | JAPAN     | 1996 | 10836947449 |
| INDIA     | INDONESIA | 1996 | 10568008435 |
| JAPAN     | VIETNAM   | 1996 | 10503890555 |
| VIETNAM   | INDONESIA | 1996 | 10494783196 |
| INDONESIA | VIETNAM   | 1996 |  9940440124 |
| INDONESIA | INDIA     | 1996 |  9864980677 |
| VIETNAM   | VIETNAM   | 1996 |  9560258720 |
| INDIA     | VIETNAM   | 1996 |  9324764214 |
| INDIA     | INDIA     | 1996 |  9023346020 |
| VIETNAM   | INDIA     | 1996 |  8968179949 |
| CHINA     | INDONESIA | 1996 |  8877441837 |
| CHINA     | JAPAN     | 1996 |  8749420872 |
| CHINA     | VIETNAM   | 1996 |  6973983457 |
| CHINA     | INDIA     | 1996 |  6515658476 |
| JAPAN     | CHINA     | 1997 | 15365039212 |
| INDONESIA | CHINA     | 1997 | 14159930904 |
| VIETNAM   | CHINA     | 1997 | 13678288757 |
| INDIA     | CHINA     | 1997 | 13599028484 |
| JAPAN     | JAPAN     | 1997 | 12921870544 |
| CHINA     | CHINA     | 1997 | 12720975220 |
| VIETNAM   | JAPAN     | 1997 | 11929000810 |
| VIETNAM   | INDONESIA | 1997 | 11325447090 |
| JAPAN     | INDONESIA | 1997 | 10764312416 |
| INDONESIA | JAPAN     | 1997 | 10555558162 |
| INDONESIA | INDONESIA | 1997 | 10416928126 |
| CHINA     | INDONESIA | 1997 | 10317902565 |
| INDIA     | JAPAN     | 1997 | 10272590051 |
| JAPAN     | VIETNAM   | 1997 |  9940032294 |
| CHINA     | JAPAN     | 1997 |  9519485461 |
| JAPAN     | INDIA     | 1997 |  9465935835 |
| INDIA     | INDONESIA | 1997 |  9405085270 |
| INDONESIA | INDIA     | 1997 |  8930955270 |
| INDIA     | INDIA     | 1997 |  8295504178 |
| VIETNAM   | VIETNAM   | 1997 |  8293412532 |
| INDONESIA | VIETNAM   | 1997 |  8116443059 |
| INDIA     | VIETNAM   | 1997 |  7960292262 |
| VIETNAM   | INDIA     | 1997 |  7529455873 |
| CHINA     | VIETNAM   | 1997 |  7038413355 |
| CHINA     | INDIA     | 1997 |  6530770558 |
+-----------+-----------+------+-------------+
-- Q3.2
+------------+------------+------+-----------+
| c_city     | s_city     | year | revenue   |
+------------+------------+------+-----------+
| CHINA    3 | CHINA    0 | 1992 | 539864249 |
| CHINA    0 | CHINA    6 | 1992 | 471363128 |
| CHINA    8 | CHINA    1 | 1992 | 421384110 |
| CHINA    6 | CHINA    1 | 1992 | 382204882 |
| CHINA    6 | CHINA    7 | 1992 | 355755835 |
| CHINA    8 | CHINA    9 | 1992 | 349006417 |
| CHINA    7 | CHINA    7 | 1992 | 320232842 |
| CHINA    8 | CHINA    3 | 1992 | 296105733 |
| CHINA    5 | CHINA    3 | 1992 | 277283951 |
| CHINA    6 | CHINA    6 | 1992 | 265527771 |
| CHINA    4 | CHINA    1 | 1992 | 237402078 |
| CHINA    8 | CHINA    6 | 1992 | 234720401 |
| CHINA    4 | CHINA    6 | 1992 | 230169075 |
| CHINA    9 | CHINA    1 | 1992 | 223815249 |
| CHINA    1 | CHINA    1 | 1992 | 223467947 |
| CHINA    2 | CHINA    1 | 1992 | 219559691 |
| CHINA    9 | CHINA    6 | 1992 | 205915890 |
| CHINA    7 | CHINA    9 | 1992 | 201288909 |
| CHINA    1 | CHINA    6 | 1992 | 195622902 |
| CHINA    9 | CHINA    7 | 1992 | 190345063 |
| CHINA    8 | CHINA    4 | 1992 | 174478626 |
| CHINA    1 | CHINA    7 | 1992 | 173803257 |
| CHINA    9 | CHINA    9 | 1992 | 162458028 |
| CHINA    6 | CHINA    0 | 1992 | 154260702 |
| CHINA    8 | CHINA    0 | 1992 | 149794069 |
| CHINA    5 | CHINA    9 | 1992 | 149369922 |
| CHINA    8 | CHINA    8 | 1992 | 147607252 |
| CHINA    6 | CHINA    4 | 1992 | 147137516 |
| CHINA    7 | CHINA    8 | 1992 | 139974858 |
| CHINA    5 | CHINA    6 | 1992 | 138467127 |
| CHINA    3 | CHINA    6 | 1992 | 119521008 |
| CHINA    8 | CHINA    7 | 1992 | 109887269 |
| CHINA    6 | CHINA    3 | 1992 | 107201214 |
| CHINA    9 | CHINA    4 | 1992 | 101504450 |
| CHINA    1 | CHINA    3 | 1992 | 101388208 |
| CHINA    7 | CHINA    0 | 1992 |  98475237 |
| CHINA    5 | CHINA    8 | 1992 |  98370738 |
| CHINA    2 | CHINA    6 | 1992 |  93254616 |
| CHINA    2 | CHINA    4 | 1992 |  86394644 |
| CHINA    3 | CHINA    7 | 1992 |  81027008 |
| CHINA    5 | CHINA    4 | 1992 |  78587418 |
| CHINA    3 | CHINA    9 | 1992 |  78114762 |
| CHINA    2 | CHINA    0 | 1992 |  77786892 |
| CHINA    2 | CHINA    8 | 1992 |  75605732 |
| CHINA    4 | CHINA    3 | 1992 |  75101512 |
| CHINA    7 | CHINA    4 | 1992 |  74119240 |
| CHINA    2 | CHINA    9 | 1992 |  73413108 |
| CHINA    5 | CHINA    7 | 1992 |  73199718 |
| CHINA    4 | CHINA    4 | 1992 |  72839118 |
| CHINA    1 | CHINA    9 | 1992 |  68538220 |
| CHINA    0 | CHINA    8 | 1992 |  65856888 |
| CHINA    0 | CHINA    9 | 1992 |  65590624 |
| CHINA    3 | CHINA    8 | 1992 |  64556586 |
| CHINA    2 | CHINA    7 | 1992 |  63336330 |
| CHINA    4 | CHINA    9 | 1992 |  57645963 |
| CHINA    0 | CHINA    7 | 1992 |  55251918 |
| CHINA    0 | CHINA    1 | 1992 |  51774462 |
| CHINA    6 | CHINA    8 | 1992 |  45676858 |
| CHINA    3 | CHINA    3 | 1992 |  41147560 |
| CHINA    3 | CHINA    4 | 1992 |  36838082 |
| CHINA    5 | CHINA    0 | 1992 |  36554488 |
| CHINA    3 | CHINA    1 | 1992 |  32036313 |
| CHINA    4 | CHINA    8 | 1992 |  31517575 |
| CHINA    0 | CHINA    3 | 1992 |  25524054 |
| CHINA    1 | CHINA    4 | 1992 |  12681846 |
| CHINA    7 | CHINA    3 | 1992 |  11395152 |
| CHINA    6 | CHINA    9 | 1992 |   8642375 |
| CHINA    8 | CHINA    6 | 1993 | 638396852 |
| CHINA    7 | CHINA    6 | 1993 | 576731239 |
| CHINA    2 | CHINA    6 | 1993 | 528008729 |
| CHINA    8 | CHINA    9 | 1993 | 522412584 |
| CHINA    8 | CHINA    7 | 1993 | 475478848 |
| CHINA    8 | CHINA    1 | 1993 | 452064153 |
| CHINA    0 | CHINA    1 | 1993 | 425902649 |
| CHINA    9 | CHINA    1 | 1993 | 405252987 |
| CHINA    6 | CHINA    9 | 1993 | 385005953 |
| CHINA    8 | CHINA    8 | 1993 | 382884778 |
| CHINA    0 | CHINA    6 | 1993 | 344911487 |
| CHINA    6 | CHINA    7 | 1993 | 341436211 |
| CHINA    3 | CHINA    6 | 1993 | 291652051 |
| CHINA    7 | CHINA    1 | 1993 | 257769861 |
| CHINA    8 | CHINA    0 | 1993 | 231981252 |
| CHINA    4 | CHINA    6 | 1993 | 215180968 |
| CHINA    3 | CHINA    0 | 1993 | 213320777 |
| CHINA    9 | CHINA    6 | 1993 | 207281000 |
| CHINA    5 | CHINA    9 | 1993 | 206555882 |
| CHINA    6 | CHINA    1 | 1993 | 205665388 |
| CHINA    5 | CHINA    1 | 1993 | 193491875 |
| CHINA    2 | CHINA    9 | 1993 | 193324425 |
| CHINA    5 | CHINA    8 | 1993 | 190521023 |
| CHINA    7 | CHINA    0 | 1993 | 183487919 |
| CHINA    0 | CHINA    9 | 1993 | 170223958 |
| CHINA    6 | CHINA    8 | 1993 | 166821272 |
| CHINA    3 | CHINA    8 | 1993 | 163053528 |
| CHINA    2 | CHINA    0 | 1993 | 158276154 |
| CHINA    3 | CHINA    1 | 1993 | 153652018 |
| CHINA    5 | CHINA    6 | 1993 | 151359347 |
| CHINA    6 | CHINA    0 | 1993 | 140494698 |
| CHINA    8 | CHINA    4 | 1993 | 139857147 |
| CHINA    2 | CHINA    7 | 1993 | 136009418 |
| CHINA    5 | CHINA    7 | 1993 | 133892119 |
| CHINA    9 | CHINA    9 | 1993 | 118965507 |
| CHINA    1 | CHINA    1 | 1993 | 108898379 |
| CHINA    6 | CHINA    6 | 1993 | 100311475 |
| CHINA    0 | CHINA    4 | 1993 |  93483068 |
| CHINA    1 | CHINA    4 | 1993 |  87714152 |
| CHINA    4 | CHINA    1 | 1993 |  87690658 |
| CHINA    4 | CHINA    7 | 1993 |  83701574 |
| CHINA    1 | CHINA    0 | 1993 |  82670983 |
| CHINA    7 | CHINA    4 | 1993 |  77396461 |
| CHINA    5 | CHINA    4 | 1993 |  73556161 |
| CHINA    4 | CHINA    8 | 1993 |  72203335 |
| CHINA    0 | CHINA    7 | 1993 |  70395334 |
| CHINA    3 | CHINA    4 | 1993 |  64771003 |
| CHINA    7 | CHINA    8 | 1993 |  64514099 |
| CHINA    3 | CHINA    7 | 1993 |  62868516 |
| CHINA    8 | CHINA    3 | 1993 |  56504804 |
| CHINA    2 | CHINA    4 | 1993 |  56031779 |
| CHINA    1 | CHINA    7 | 1993 |  48951262 |
| CHINA    7 | CHINA    3 | 1993 |  45962220 |
| CHINA    4 | CHINA    9 | 1993 |  43158138 |
| CHINA    7 | CHINA    9 | 1993 |  42611979 |
| CHINA    2 | CHINA    8 | 1993 |  38092546 |
| CHINA    1 | CHINA    9 | 1993 |  29665374 |
| CHINA    1 | CHINA    3 | 1993 |  23991216 |
| CHINA    6 | CHINA    6 | 1994 | 596294890 |
| CHINA    8 | CHINA    6 | 1994 | 542104721 |
| CHINA    6 | CHINA    1 | 1994 | 504359553 |
| CHINA    3 | CHINA    7 | 1994 | 476727294 |
| CHINA    3 | CHINA    6 | 1994 | 476349724 |
| CHINA    8 | CHINA    9 | 1994 | 427241348 |
| CHINA    6 | CHINA    9 | 1994 | 358191581 |
| CHINA    9 | CHINA    6 | 1994 | 352344057 |
| CHINA    3 | CHINA    0 | 1994 | 351708546 |
| CHINA    8 | CHINA    0 | 1994 | 351131413 |
| CHINA    3 | CHINA    3 | 1994 | 339279574 |
| CHINA    0 | CHINA    1 | 1994 | 298307857 |
| CHINA    0 | CHINA    7 | 1994 | 289536010 |
| CHINA    0 | CHINA    6 | 1994 | 285639032 |
| CHINA    7 | CHINA    6 | 1994 | 263170455 |
| CHINA    2 | CHINA    8 | 1994 | 250332990 |
| CHINA    6 | CHINA    4 | 1994 | 235897763 |
| CHINA    5 | CHINA    1 | 1994 | 234681515 |
| CHINA    8 | CHINA    7 | 1994 | 234390101 |
| CHINA    1 | CHINA    6 | 1994 | 232792764 |
| CHINA    8 | CHINA    1 | 1994 | 223808842 |
| CHINA    4 | CHINA    6 | 1994 | 209522926 |
| CHINA    8 | CHINA    4 | 1994 | 208632636 |
| CHINA    7 | CHINA    3 | 1994 | 202424117 |
| CHINA    4 | CHINA    7 | 1994 | 185487544 |
| CHINA    2 | CHINA    7 | 1994 | 183551771 |
| CHINA    7 | CHINA    1 | 1994 | 178421732 |
| CHINA    4 | CHINA    1 | 1994 | 176262868 |
| CHINA    5 | CHINA    6 | 1994 | 173651872 |
| CHINA    0 | CHINA    4 | 1994 | 173584501 |
| CHINA    8 | CHINA    8 | 1994 | 172179808 |
| CHINA    9 | CHINA    1 | 1994 | 169617585 |
| CHINA    0 | CHINA    9 | 1994 | 167569085 |
| CHINA    5 | CHINA    8 | 1994 | 162066559 |
| CHINA    7 | CHINA    9 | 1994 | 161041255 |
| CHINA    5 | CHINA    4 | 1994 | 154820955 |
| CHINA    7 | CHINA    0 | 1994 | 152844960 |
| CHINA    2 | CHINA    6 | 1994 | 149839190 |
| CHINA    7 | CHINA    8 | 1994 | 149536114 |
| CHINA    1 | CHINA    4 | 1994 | 142403628 |
| CHINA    9 | CHINA    9 | 1994 | 131064832 |
| CHINA    2 | CHINA    1 | 1994 | 124489283 |
| CHINA    2 | CHINA    0 | 1994 | 114263273 |
| CHINA    5 | CHINA    7 | 1994 | 113311766 |
| CHINA    8 | CHINA    3 | 1994 | 112573609 |
| CHINA    3 | CHINA    4 | 1994 | 104903651 |
| CHINA    4 | CHINA    0 | 1994 | 101914439 |
| CHINA    3 | CHINA    1 | 1994 |  98253251 |
| CHINA    1 | CHINA    7 | 1994 |  94582288 |
| CHINA    4 | CHINA    4 | 1994 |  92818317 |
| CHINA    1 | CHINA    9 | 1994 |  85220541 |
| CHINA    6 | CHINA    3 | 1994 |  84604801 |
| CHINA    0 | CHINA    3 | 1994 |  77574978 |
| CHINA    1 | CHINA    3 | 1994 |  74435316 |
| CHINA    4 | CHINA    9 | 1994 |  72622300 |
| CHINA    3 | CHINA    8 | 1994 |  72559366 |
| CHINA    9 | CHINA    0 | 1994 |  69298222 |
| CHINA    3 | CHINA    9 | 1994 |  67472592 |
| CHINA    6 | CHINA    8 | 1994 |  66271372 |
| CHINA    7 | CHINA    4 | 1994 |  59634606 |
| CHINA    2 | CHINA    9 | 1994 |  56882136 |
| CHINA    1 | CHINA    1 | 1994 |  56592337 |
| CHINA    5 | CHINA    9 | 1994 |  52879724 |
| CHINA    9 | CHINA    4 | 1994 |  49324497 |
| CHINA    2 | CHINA    3 | 1994 |  45042384 |
| CHINA    7 | CHINA    7 | 1994 |  44458451 |
| CHINA    5 | CHINA    0 | 1994 |  39091925 |
| CHINA    9 | CHINA    3 | 1994 |  39082405 |
| CHINA    0 | CHINA    8 | 1994 |  28203459 |
| CHINA    6 | CHINA    7 | 1994 |  27243775 |
| CHINA    0 | CHINA    0 | 1994 |  15591040 |
| CHINA    2 | CHINA    6 | 1995 | 832176707 |
| CHINA    8 | CHINA    6 | 1995 | 793322102 |
| CHINA    3 | CHINA    7 | 1995 | 505446788 |
| CHINA    7 | CHINA    9 | 1995 | 483519933 |
| CHINA    4 | CHINA    6 | 1995 | 440320366 |
| CHINA    8 | CHINA    1 | 1995 | 394522570 |
| CHINA    7 | CHINA    1 | 1995 | 393861389 |
| CHINA    5 | CHINA    1 | 1995 | 343166828 |
| CHINA    1 | CHINA    7 | 1995 | 341736584 |
| CHINA    8 | CHINA    7 | 1995 | 323623203 |
| CHINA    6 | CHINA    6 | 1995 | 312876143 |
| CHINA    3 | CHINA    6 | 1995 | 306516324 |
| CHINA    7 | CHINA    6 | 1995 | 294840537 |
| CHINA    3 | CHINA    3 | 1995 | 290066240 |
| CHINA    8 | CHINA    3 | 1995 | 289182495 |
| CHINA    3 | CHINA    1 | 1995 | 288853766 |
| CHINA    0 | CHINA    1 | 1995 | 279082523 |
| CHINA    0 | CHINA    8 | 1995 | 265291443 |
| CHINA    1 | CHINA    6 | 1995 | 262283412 |
| CHINA    4 | CHINA    1 | 1995 | 246559891 |
| CHINA    2 | CHINA    8 | 1995 | 246465167 |
| CHINA    6 | CHINA    7 | 1995 | 246385862 |
| CHINA    9 | CHINA    6 | 1995 | 231314393 |
| CHINA    2 | CHINA    7 | 1995 | 224354491 |
| CHINA    4 | CHINA    7 | 1995 | 222368398 |
| CHINA    0 | CHINA    7 | 1995 | 221334917 |
| CHINA    6 | CHINA    3 | 1995 | 217756587 |
| CHINA    6 | CHINA    9 | 1995 | 215736018 |
| CHINA    4 | CHINA    9 | 1995 | 210496516 |
| CHINA    0 | CHINA    6 | 1995 | 197891458 |
| CHINA    8 | CHINA    9 | 1995 | 192018213 |
| CHINA    7 | CHINA    0 | 1995 | 188804482 |
| CHINA    5 | CHINA    6 | 1995 | 186378531 |
| CHINA    6 | CHINA    1 | 1995 | 165831073 |
| CHINA    1 | CHINA    3 | 1995 | 165118263 |
| CHINA    6 | CHINA    8 | 1995 | 157640218 |
| CHINA    1 | CHINA    1 | 1995 | 150838433 |
| CHINA    1 | CHINA    4 | 1995 | 147632879 |
| CHINA    6 | CHINA    0 | 1995 | 147314401 |
| CHINA    5 | CHINA    4 | 1995 | 142820978 |
| CHINA    5 | CHINA    9 | 1995 | 141416829 |
| CHINA    2 | CHINA    0 | 1995 | 135608473 |
| CHINA    5 | CHINA    7 | 1995 | 131596218 |
| CHINA    0 | CHINA    4 | 1995 | 129159370 |
| CHINA    3 | CHINA    9 | 1995 | 126837748 |
| CHINA    8 | CHINA    0 | 1995 | 126564932 |
| CHINA    0 | CHINA    3 | 1995 | 121337041 |
| CHINA    7 | CHINA    7 | 1995 | 118697587 |
| CHINA    5 | CHINA    8 | 1995 | 116538842 |
| CHINA    8 | CHINA    8 | 1995 | 110161904 |
| CHINA    9 | CHINA    0 | 1995 | 109582187 |
| CHINA    9 | CHINA    1 | 1995 | 103455098 |
| CHINA    2 | CHINA    1 | 1995 | 100264691 |
| CHINA    7 | CHINA    3 | 1995 |  99011859 |
| CHINA    3 | CHINA    0 | 1995 |  90383390 |
| CHINA    4 | CHINA    3 | 1995 |  89908903 |
| CHINA    7 | CHINA    8 | 1995 |  81425699 |
| CHINA    3 | CHINA    4 | 1995 |  77577579 |
| CHINA    4 | CHINA    8 | 1995 |  74805746 |
| CHINA    9 | CHINA    7 | 1995 |  74597020 |
| CHINA    9 | CHINA    9 | 1995 |  73514511 |
| CHINA    5 | CHINA    0 | 1995 |  73274726 |
| CHINA    8 | CHINA    4 | 1995 |  61708487 |
| CHINA    1 | CHINA    0 | 1995 |  58753734 |
| CHINA    3 | CHINA    8 | 1995 |  57133566 |
| CHINA    9 | CHINA    4 | 1995 |  53259334 |
| CHINA    1 | CHINA    9 | 1995 |  46177797 |
| CHINA    2 | CHINA    4 | 1995 |  45147325 |
| CHINA    0 | CHINA    0 | 1995 |  43963173 |
| CHINA    0 | CHINA    9 | 1995 |  40184107 |
| CHINA    1 | CHINA    8 | 1995 |  18859188 |
| CHINA    8 | CHINA    7 | 1996 | 621957444 |
| CHINA    3 | CHINA    9 | 1996 | 530082848 |
| CHINA    8 | CHINA    6 | 1996 | 525755549 |
| CHINA    8 | CHINA    1 | 1996 | 399229343 |
| CHINA    6 | CHINA    7 | 1996 | 365540749 |
| CHINA    8 | CHINA    8 | 1996 | 351864283 |
| CHINA    1 | CHINA    6 | 1996 | 329186504 |
| CHINA    9 | CHINA    6 | 1996 | 321113085 |
| CHINA    3 | CHINA    6 | 1996 | 318264871 |
| CHINA    2 | CHINA    6 | 1996 | 315233397 |
| CHINA    2 | CHINA    9 | 1996 | 285852841 |
| CHINA    9 | CHINA    9 | 1996 | 264510548 |
| CHINA    5 | CHINA    6 | 1996 | 261385523 |
| CHINA    8 | CHINA    9 | 1996 | 259497265 |
| CHINA    6 | CHINA    6 | 1996 | 258200131 |
| CHINA    4 | CHINA    9 | 1996 | 257345949 |
| CHINA    6 | CHINA    9 | 1996 | 247667288 |
| CHINA    2 | CHINA    7 | 1996 | 234569026 |
| CHINA    2 | CHINA    1 | 1996 | 218568966 |
| CHINA    4 | CHINA    1 | 1996 | 207383476 |
| CHINA    0 | CHINA    1 | 1996 | 204596428 |
| CHINA    3 | CHINA    0 | 1996 | 204375870 |
| CHINA    4 | CHINA    0 | 1996 | 202299286 |
| CHINA    4 | CHINA    4 | 1996 | 191983261 |
| CHINA    4 | CHINA    8 | 1996 | 183961012 |
| CHINA    4 | CHINA    6 | 1996 | 183872085 |
| CHINA    6 | CHINA    8 | 1996 | 182132356 |
| CHINA    7 | CHINA    9 | 1996 | 170941341 |
| CHINA    0 | CHINA    6 | 1996 | 168082672 |
| CHINA    1 | CHINA    7 | 1996 | 165942066 |
| CHINA    1 | CHINA    9 | 1996 | 165878775 |
| CHINA    9 | CHINA    8 | 1996 | 156009357 |
| CHINA    7 | CHINA    7 | 1996 | 155842944 |
| CHINA    2 | CHINA    0 | 1996 | 147709906 |
| CHINA    5 | CHINA    7 | 1996 | 147257366 |
| CHINA    1 | CHINA    8 | 1996 | 141840928 |
| CHINA    2 | CHINA    4 | 1996 | 136244052 |
| CHINA    9 | CHINA    0 | 1996 | 130997019 |
| CHINA    1 | CHINA    0 | 1996 | 124362038 |
| CHINA    0 | CHINA    9 | 1996 | 114011231 |
| CHINA    7 | CHINA    3 | 1996 | 112398764 |
| CHINA    4 | CHINA    7 | 1996 | 110567337 |
| CHINA    3 | CHINA    4 | 1996 | 109269982 |
| CHINA    5 | CHINA    1 | 1996 | 107482704 |
| CHINA    6 | CHINA    4 | 1996 | 105485170 |
| CHINA    1 | CHINA    4 | 1996 | 105320270 |
| CHINA    0 | CHINA    7 | 1996 | 102545071 |
| CHINA    2 | CHINA    3 | 1996 | 100407151 |
| CHINA    0 | CHINA    4 | 1996 |  95913303 |
| CHINA    7 | CHINA    0 | 1996 |  94706269 |
| CHINA    6 | CHINA    1 | 1996 |  86949951 |
| CHINA    8 | CHINA    3 | 1996 |  84157344 |
| CHINA    2 | CHINA    8 | 1996 |  83176903 |
| CHINA    5 | CHINA    9 | 1996 |  83104330 |
| CHINA    7 | CHINA    8 | 1996 |  81490639 |
| CHINA    9 | CHINA    3 | 1996 |  79655829 |
| CHINA    5 | CHINA    0 | 1996 |  77489995 |
| CHINA    8 | CHINA    0 | 1996 |  76989056 |
| CHINA    9 | CHINA    1 | 1996 |  72011031 |
| CHINA    7 | CHINA    4 | 1996 |  64764322 |
| CHINA    5 | CHINA    4 | 1996 |  62827767 |
| CHINA    5 | CHINA    8 | 1996 |  62673237 |
| CHINA    7 | CHINA    6 | 1996 |  61880459 |
| CHINA    3 | CHINA    7 | 1996 |  56642844 |
| CHINA    3 | CHINA    1 | 1996 |  50799366 |
| CHINA    3 | CHINA    3 | 1996 |  42601269 |
| CHINA    4 | CHINA    3 | 1996 |  38290290 |
| CHINA    3 | CHINA    8 | 1996 |  21263056 |
| CHINA    7 | CHINA    1 | 1996 |  14836937 |
| CHINA    5 | CHINA    3 | 1996 |  13611339 |
| CHINA    1 | CHINA    3 | 1996 |   8430793 |
| CHINA    1 | CHINA    1 | 1996 |   1601332 |
| CHINA    1 | CHINA    7 | 1997 | 664436721 |
| CHINA    8 | CHINA    9 | 1997 | 585552148 |
| CHINA    8 | CHINA    6 | 1997 | 543571889 |
| CHINA    8 | CHINA    7 | 1997 | 516131917 |
| CHINA    6 | CHINA    7 | 1997 | 467477883 |
| CHINA    3 | CHINA    9 | 1997 | 444914344 |
| CHINA    5 | CHINA    6 | 1997 | 353316321 |
| CHINA    6 | CHINA    4 | 1997 | 338136205 |
| CHINA    0 | CHINA    7 | 1997 | 329137493 |
| CHINA    5 | CHINA    1 | 1997 | 328142466 |
| CHINA    8 | CHINA    4 | 1997 | 308276385 |
| CHINA    6 | CHINA    9 | 1997 | 306814317 |
| CHINA    5 | CHINA    9 | 1997 | 301145803 |
| CHINA    7 | CHINA    1 | 1997 | 299575802 |
| CHINA    8 | CHINA    8 | 1997 | 282083295 |
| CHINA    4 | CHINA    9 | 1997 | 280242025 |
| CHINA    9 | CHINA    1 | 1997 | 253155313 |
| CHINA    4 | CHINA    6 | 1997 | 234247182 |
| CHINA    5 | CHINA    0 | 1997 | 217246162 |
| CHINA    9 | CHINA    4 | 1997 | 215424663 |
| CHINA    0 | CHINA    6 | 1997 | 211152240 |
| CHINA    3 | CHINA    6 | 1997 | 205982217 |
| CHINA    7 | CHINA    6 | 1997 | 196440117 |
| CHINA    1 | CHINA    6 | 1997 | 195757737 |
| CHINA    2 | CHINA    3 | 1997 | 189836909 |
| CHINA    7 | CHINA    8 | 1997 | 189291379 |
| CHINA    9 | CHINA    6 | 1997 | 189236146 |
| CHINA    3 | CHINA    1 | 1997 | 188537684 |
| CHINA    9 | CHINA    7 | 1997 | 182516267 |
| CHINA    0 | CHINA    0 | 1997 | 182459980 |
| CHINA    5 | CHINA    8 | 1997 | 177077882 |
| CHINA    2 | CHINA    6 | 1997 | 176030529 |
| CHINA    2 | CHINA    1 | 1997 | 168770050 |
| CHINA    8 | CHINA    0 | 1997 | 167294093 |
| CHINA    4 | CHINA    3 | 1997 | 161980658 |
| CHINA    3 | CHINA    4 | 1997 | 154433882 |
| CHINA    6 | CHINA    6 | 1997 | 153336736 |
| CHINA    6 | CHINA    3 | 1997 | 151596497 |
| CHINA    8 | CHINA    1 | 1997 | 145432603 |
| CHINA    1 | CHINA    4 | 1997 | 126773981 |
| CHINA    1 | CHINA    0 | 1997 | 120594770 |
| CHINA    7 | CHINA    3 | 1997 | 119618460 |
| CHINA    6 | CHINA    1 | 1997 | 119529805 |
| CHINA    2 | CHINA    9 | 1997 | 114591288 |
| CHINA    7 | CHINA    7 | 1997 | 111335941 |
| CHINA    5 | CHINA    3 | 1997 | 111044153 |
| CHINA    6 | CHINA    0 | 1997 | 104404276 |
| CHINA    1 | CHINA    1 | 1997 |  98869501 |
| CHINA    7 | CHINA    0 | 1997 |  97198605 |
| CHINA    7 | CHINA    9 | 1997 |  92872632 |
| CHINA    0 | CHINA    9 | 1997 |  91097832 |
| CHINA    9 | CHINA    9 | 1997 |  86479272 |
| CHINA    2 | CHINA    7 | 1997 |  79380820 |
| CHINA    9 | CHINA    0 | 1997 |  78499693 |
| CHINA    1 | CHINA    9 | 1997 |  73589328 |
| CHINA    2 | CHINA    8 | 1997 |  71633835 |
| CHINA    8 | CHINA    3 | 1997 |  70505885 |
| CHINA    3 | CHINA    0 | 1997 |  61039282 |
| CHINA    0 | CHINA    3 | 1997 |  58325113 |
| CHINA    5 | CHINA    7 | 1997 |  55476389 |
| CHINA    4 | CHINA    7 | 1997 |  46480159 |
| CHINA    0 | CHINA    1 | 1997 |  38223038 |
| CHINA    4 | CHINA    1 | 1997 |  21636342 |
| CHINA    9 | CHINA    3 | 1997 |  13092788 |
| CHINA    6 | CHINA    8 | 1997 |   2490092 |
+------------+------------+------+-----------+
-- Q3.3
+------------+------------+------+-----------+
| c_city     | s_city     | year | revenue   |
+------------+------------+------+-----------+
| UNITED KI0 | UNITED KI7 | 1992 | 251282102 |
| UNITED KI0 | UNITED KI0 | 1992 | 170005406 |
| UNITED KI7 | UNITED KI7 | 1992 |  36835396 |
| UNITED KI0 | UNITED KI7 | 1993 | 560335810 |
| UNITED KI0 | UNITED KI0 | 1993 | 294257692 |
| UNITED KI7 | UNITED KI0 | 1993 | 159005896 |
| UNITED KI7 | UNITED KI7 | 1993 | 139029264 |
| UNITED KI0 | UNITED KI7 | 1994 | 739847089 |
| UNITED KI0 | UNITED KI0 | 1994 | 302339390 |
| UNITED KI7 | UNITED KI7 | 1994 | 275609814 |
| UNITED KI7 | UNITED KI0 | 1994 | 117654093 |
| UNITED KI0 | UNITED KI7 | 1995 | 540994655 |
| UNITED KI0 | UNITED KI0 | 1995 | 230825439 |
| UNITED KI7 | UNITED KI0 | 1995 | 197347696 |
| UNITED KI7 | UNITED KI7 | 1995 | 136620517 |
| UNITED KI0 | UNITED KI7 | 1996 | 448412094 |
| UNITED KI0 | UNITED KI0 | 1996 | 203511607 |
| UNITED KI7 | UNITED KI7 | 1996 |  94528075 |
| UNITED KI7 | UNITED KI0 | 1996 |  35448536 |
| UNITED KI7 | UNITED KI0 | 1997 | 289323850 |
| UNITED KI7 | UNITED KI7 | 1997 | 214791175 |
| UNITED KI0 | UNITED KI7 | 1997 | 196510174 |
| UNITED KI0 | UNITED KI0 | 1997 | 125066127 |
+------------+------------+------+-----------+
-- Q3.4
+------------+------------+------+-----------+
| c_city     | s_city     | year | revenue   |
+------------+------------+------+-----------+
| UNITED KI7 | KENYA    4 | 1997 | 170083300 |
| UNITED KI0 | MOZAMBIQU1 | 1997 | 155234463 |
| UNITED KI0 | KENYA    4 | 1997 |  87283610 |
+------------+------------+------+-----------+
-- Q4.1
+------+---------------+-------------+
| year | c_nation      | profit      |
+------+---------------+-------------+
| 1992 | ARGENTINA     | 13746243380 |
| 1992 | BRAZIL        | 15762831144 |
| 1992 | CANADA        | 17477043721 |
| 1992 | PERU          | 14698567030 |
| 1992 | UNITED STATES | 14043501956 |
| 1993 | ARGENTINA     | 13992888207 |
| 1993 | BRAZIL        | 15146262693 |
| 1993 | CANADA        | 12463985574 |
| 1993 | PERU          | 11385007831 |
| 1993 | UNITED STATES | 10651361815 |
| 1994 | ARGENTINA     | 13128610315 |
| 1994 | BRAZIL        | 13764866493 |
| 1994 | CANADA        | 13723188154 |
| 1994 | PERU          | 12784683808 |
| 1994 | UNITED STATES | 12554422837 |
| 1995 | ARGENTINA     | 14337205612 |
| 1995 | BRAZIL        | 15068918320 |
| 1995 | CANADA        | 14529005783 |
| 1995 | PERU          | 13086675480 |
| 1995 | UNITED STATES | 11330297649 |
| 1996 | ARGENTINA     | 13659108915 |
| 1996 | BRAZIL        | 12660837584 |
| 1996 | CANADA        | 14558903190 |
| 1996 | PERU          | 14162285166 |
| 1996 | UNITED STATES | 11117076866 |
| 1997 | ARGENTINA     | 12556399750 |
| 1997 | BRAZIL        | 13961587144 |
| 1997 | CANADA        | 15567856947 |
| 1997 | PERU          | 13595325340 |
| 1997 | UNITED STATES | 10779073839 |
| 1998 | ARGENTINA     |  7843424759 |
| 1998 | BRAZIL        |  8853904827 |
| 1998 | CANADA        |  8286104334 |
| 1998 | PERU          |  5822590950 |
| 1998 | UNITED STATES |  8526236814 |
+------+---------------+-------------+
-- Q4.2
+------+---------------+------------+------------+
| year | s_nation      | p_category | profit     |
+------+---------------+------------+------------+
| 1997 | ARGENTINA     | MFGR#11    | 1636950553 |
| 1997 | ARGENTINA     | MFGR#12    | 1265547847 |
| 1997 | ARGENTINA     | MFGR#13    | 1505131346 |
| 1997 | ARGENTINA     | MFGR#14    | 1405447137 |
| 1997 | ARGENTINA     | MFGR#15    | 1564085340 |
| 1997 | ARGENTINA     | MFGR#21    | 1335009490 |
| 1997 | ARGENTINA     | MFGR#22    | 1309054179 |
| 1997 | ARGENTINA     | MFGR#23    | 1305213794 |
| 1997 | ARGENTINA     | MFGR#24    | 1089725126 |
| 1997 | ARGENTINA     | MFGR#25    | 1291995512 |
| 1997 | BRAZIL        | MFGR#11    |  721240147 |
| 1997 | BRAZIL        | MFGR#12    |  928318830 |
| 1997 | BRAZIL        | MFGR#13    | 1164674879 |
| 1997 | BRAZIL        | MFGR#14    | 1215622587 |
| 1997 | BRAZIL        | MFGR#15    |  940971658 |
| 1997 | BRAZIL        | MFGR#21    | 1158909618 |
| 1997 | BRAZIL        | MFGR#22    | 1251221641 |
| 1997 | BRAZIL        | MFGR#23    | 1552552455 |
| 1997 | BRAZIL        | MFGR#24    |  929057361 |
| 1997 | BRAZIL        | MFGR#25    |  574645288 |
| 1997 | CANADA        | MFGR#11    | 1170341370 |
| 1997 | CANADA        | MFGR#12    | 1220238121 |
| 1997 | CANADA        | MFGR#13    | 1245774025 |
| 1997 | CANADA        | MFGR#14    | 1032046642 |
| 1997 | CANADA        | MFGR#15    |  738650612 |
| 1997 | CANADA        | MFGR#21    | 1476055209 |
| 1997 | CANADA        | MFGR#22    | 1239005798 |
| 1997 | CANADA        | MFGR#23    |  869393804 |
| 1997 | CANADA        | MFGR#24    | 1466964051 |
| 1997 | CANADA        | MFGR#25    | 1358922727 |
| 1997 | PERU          | MFGR#11    | 1031023174 |
| 1997 | PERU          | MFGR#12    |  731821491 |
| 1997 | PERU          | MFGR#13    | 1044642877 |
| 1997 | PERU          | MFGR#14    |  654877417 |
| 1997 | PERU          | MFGR#15    | 1201769474 |
| 1997 | PERU          | MFGR#21    | 1275496672 |
| 1997 | PERU          | MFGR#22    |  599324545 |
| 1997 | PERU          | MFGR#23    | 1200754744 |
| 1997 | PERU          | MFGR#24    |  942152801 |
| 1997 | PERU          | MFGR#25    | 1064322995 |
| 1997 | UNITED STATES | MFGR#11    | 2365218925 |
| 1997 | UNITED STATES | MFGR#12    | 1132346574 |
| 1997 | UNITED STATES | MFGR#13    | 2460882362 |
| 1997 | UNITED STATES | MFGR#14    | 2190816877 |
| 1997 | UNITED STATES | MFGR#15    | 1687829921 |
| 1997 | UNITED STATES | MFGR#21    | 2125880770 |
| 1997 | UNITED STATES | MFGR#22    | 2013348097 |
| 1997 | UNITED STATES | MFGR#23    | 2570581084 |
| 1997 | UNITED STATES | MFGR#24    | 2724372315 |
| 1997 | UNITED STATES | MFGR#25    | 1480012758 |
| 1998 | ARGENTINA     | MFGR#11    |  783662770 |
| 1998 | ARGENTINA     | MFGR#12    |  472818450 |
| 1998 | ARGENTINA     | MFGR#13    |  585091533 |
| 1998 | ARGENTINA     | MFGR#14    |  507297527 |
| 1998 | ARGENTINA     | MFGR#15    |  549185408 |
| 1998 | ARGENTINA     | MFGR#21    |  972928972 |
| 1998 | ARGENTINA     | MFGR#22    | 1508294213 |
| 1998 | ARGENTINA     | MFGR#23    |  517896738 |
| 1998 | ARGENTINA     | MFGR#24    |  240754731 |
| 1998 | ARGENTINA     | MFGR#25    |  757030162 |
| 1998 | BRAZIL        | MFGR#11    |  826283793 |
| 1998 | BRAZIL        | MFGR#12    |  482293349 |
| 1998 | BRAZIL        | MFGR#13    | 1037202334 |
| 1998 | BRAZIL        | MFGR#14    |  743598666 |
| 1998 | BRAZIL        | MFGR#15    |  584176304 |
| 1998 | BRAZIL        | MFGR#21    |  557259779 |
| 1998 | BRAZIL        | MFGR#22    |  535654445 |
| 1998 | BRAZIL        | MFGR#23    |  403656721 |
| 1998 | BRAZIL        | MFGR#24    | 1305217551 |
| 1998 | BRAZIL        | MFGR#25    | 1109801463 |
| 1998 | CANADA        | MFGR#11    |  936169617 |
| 1998 | CANADA        | MFGR#12    | 1017751308 |
| 1998 | CANADA        | MFGR#13    |  850046376 |
| 1998 | CANADA        | MFGR#14    |  808138010 |
| 1998 | CANADA        | MFGR#15    |  701990010 |
| 1998 | CANADA        | MFGR#21    |  402611051 |
| 1998 | CANADA        | MFGR#22    |  382705122 |
| 1998 | CANADA        | MFGR#23    |  509674722 |
| 1998 | CANADA        | MFGR#24    | 1003021250 |
| 1998 | CANADA        | MFGR#25    |  574602788 |
| 1998 | PERU          | MFGR#11    |  552608732 |
| 1998 | PERU          | MFGR#12    |  500581456 |
| 1998 | PERU          | MFGR#13    |  894607711 |
| 1998 | PERU          | MFGR#14    |  386487826 |
| 1998 | PERU          | MFGR#15    | 1044780577 |
| 1998 | PERU          | MFGR#21    |  184346232 |
| 1998 | PERU          | MFGR#22    |  674942976 |
| 1998 | PERU          | MFGR#23    |  665523956 |
| 1998 | PERU          | MFGR#24    |  631374203 |
| 1998 | PERU          | MFGR#25    |  602609608 |
| 1998 | UNITED STATES | MFGR#11    | 1230069867 |
| 1998 | UNITED STATES | MFGR#12    | 1557720319 |
| 1998 | UNITED STATES | MFGR#13    |  999206739 |
| 1998 | UNITED STATES | MFGR#14    |  605040268 |
| 1998 | UNITED STATES | MFGR#15    |  850219215 |
| 1998 | UNITED STATES | MFGR#21    | 1032550760 |
| 1998 | UNITED STATES | MFGR#22    | 1370141401 |
| 1998 | UNITED STATES | MFGR#23    | 1226632297 |
| 1998 | UNITED STATES | MFGR#24    | 1528135100 |
| 1998 | UNITED STATES | MFGR#25    | 1127867278 |
+------+---------------+------------+------------+
-- Q4.3
+------+------------+-----------+-----------+
| year | s_city     | p_brand   | profit    |
+------+------------+-----------+-----------+
| 1997 | UNITED ST0 | MFGR#1410 |  58481513 |
| 1997 | UNITED ST0 | MFGR#1412 |  33582225 |
| 1997 | UNITED ST0 | MFGR#1413 | 135625490 |
| 1997 | UNITED ST0 | MFGR#1414 |  18581969 |
| 1997 | UNITED ST0 | MFGR#142  | 164080005 |
| 1997 | UNITED ST0 | MFGR#1420 |  30831591 |
| 1997 | UNITED ST0 | MFGR#1424 |   4085253 |
| 1997 | UNITED ST0 | MFGR#1425 | 163183170 |
| 1997 | UNITED ST0 | MFGR#1427 |  87578288 |
| 1997 | UNITED ST0 | MFGR#1428 | 109488143 |
| 1997 | UNITED ST0 | MFGR#143  | 198055627 |
| 1997 | UNITED ST0 | MFGR#1430 |  52544552 |
| 1997 | UNITED ST0 | MFGR#1432 | 158742311 |
| 1997 | UNITED ST0 | MFGR#144  |  43479982 |
| 1997 | UNITED ST0 | MFGR#1440 |  40412893 |
| 1997 | UNITED ST0 | MFGR#145  | 175568435 |
| 1997 | UNITED ST1 | MFGR#141  |  11932912 |
| 1997 | UNITED ST1 | MFGR#1411 |  40637463 |
| 1997 | UNITED ST1 | MFGR#1415 |  27562355 |
| 1997 | UNITED ST1 | MFGR#1421 | 100271780 |
| 1997 | UNITED ST1 | MFGR#1422 | 103286764 |
| 1997 | UNITED ST1 | MFGR#1423 | 106114459 |
| 1997 | UNITED ST1 | MFGR#1427 | 157715681 |
| 1997 | UNITED ST1 | MFGR#1428 |  91550168 |
| 1997 | UNITED ST1 | MFGR#1430 |  56560173 |
| 1997 | UNITED ST1 | MFGR#1431 | 248448914 |
| 1997 | UNITED ST1 | MFGR#1435 |    994228 |
| 1997 | UNITED ST1 | MFGR#144  |  55729825 |
| 1997 | UNITED ST1 | MFGR#145  | 118034196 |
| 1997 | UNITED ST1 | MFGR#146  |  99170724 |
| 1997 | UNITED ST1 | MFGR#147  |   5123001 |
| 1997 | UNITED ST2 | MFGR#141  | 111908637 |
| 1997 | UNITED ST2 | MFGR#1414 |  96864725 |
| 1997 | UNITED ST2 | MFGR#1415 | 123601050 |
| 1997 | UNITED ST2 | MFGR#1421 |  21014618 |
| 1997 | UNITED ST2 | MFGR#1427 |  46524767 |
| 1997 | UNITED ST2 | MFGR#1429 |  18800062 |
| 1997 | UNITED ST2 | MFGR#1431 |  79199532 |
| 1997 | UNITED ST2 | MFGR#1432 |  53841788 |
| 1997 | UNITED ST2 | MFGR#1433 | 133842836 |
| 1997 | UNITED ST2 | MFGR#1434 |  96443006 |
| 1997 | UNITED ST2 | MFGR#1435 |  50858424 |
| 1997 | UNITED ST2 | MFGR#1438 |  64571457 |
| 1997 | UNITED ST2 | MFGR#144  |  61319000 |
| 1997 | UNITED ST2 | MFGR#146  |  69558050 |
| 1997 | UNITED ST2 | MFGR#147  |  41160961 |
| 1997 | UNITED ST2 | MFGR#149  |  31735872 |
| 1997 | UNITED ST3 | MFGR#1410 | 306449140 |
| 1997 | UNITED ST3 | MFGR#1411 | 114677189 |
| 1997 | UNITED ST3 | MFGR#1412 |  49229127 |
| 1997 | UNITED ST3 | MFGR#1413 | 174911640 |
| 1997 | UNITED ST3 | MFGR#1415 | 134932298 |
| 1997 | UNITED ST3 | MFGR#1416 |  97111854 |
| 1997 | UNITED ST3 | MFGR#1417 | 176279103 |
| 1997 | UNITED ST3 | MFGR#1418 |  70684147 |
| 1997 | UNITED ST3 | MFGR#1420 |  27591782 |
| 1997 | UNITED ST3 | MFGR#1422 |  39411253 |
| 1997 | UNITED ST3 | MFGR#1424 | 226736650 |
| 1997 | UNITED ST3 | MFGR#1426 |  63997112 |
| 1997 | UNITED ST3 | MFGR#1429 |    556053 |
| 1997 | UNITED ST3 | MFGR#143  |  73550925 |
| 1997 | UNITED ST3 | MFGR#1430 | 218807697 |
| 1997 | UNITED ST3 | MFGR#1431 |  39936281 |
| 1997 | UNITED ST3 | MFGR#1432 |  44356689 |
| 1997 | UNITED ST3 | MFGR#1435 |  49225455 |
| 1997 | UNITED ST3 | MFGR#1436 |  90326644 |
| 1997 | UNITED ST3 | MFGR#1439 |  84615817 |
| 1997 | UNITED ST3 | MFGR#144  |  59081596 |
| 1997 | UNITED ST3 | MFGR#1440 |  59601014 |
| 1997 | UNITED ST3 | MFGR#145  | 100692258 |
| 1997 | UNITED ST3 | MFGR#147  | 142417874 |
| 1997 | UNITED ST3 | MFGR#148  |  38233221 |
| 1997 | UNITED ST5 | MFGR#1416 |  62387773 |
| 1997 | UNITED ST5 | MFGR#1417 |  54974702 |
| 1997 | UNITED ST5 | MFGR#1418 |  87301086 |
| 1997 | UNITED ST5 | MFGR#1421 |   9869673 |
| 1997 | UNITED ST5 | MFGR#1422 |  58912225 |
| 1997 | UNITED ST5 | MFGR#1424 |  80038584 |
| 1997 | UNITED ST5 | MFGR#1428 |  44422717 |
| 1997 | UNITED ST5 | MFGR#1430 |  67186074 |
| 1997 | UNITED ST5 | MFGR#1433 | 105646942 |
| 1997 | UNITED ST5 | MFGR#1434 |  13923867 |
| 1997 | UNITED ST5 | MFGR#145  | 104286534 |
| 1997 | UNITED ST5 | MFGR#146  |  20965182 |
| 1997 | UNITED ST5 | MFGR#148  | 170596496 |
| 1997 | UNITED ST5 | MFGR#149  |  42639213 |
| 1997 | UNITED ST6 | MFGR#1411 |  48199726 |
| 1997 | UNITED ST6 | MFGR#1413 |  28825982 |
| 1997 | UNITED ST6 | MFGR#1414 | 107783723 |
| 1997 | UNITED ST6 | MFGR#1415 |  92119787 |
| 1997 | UNITED ST6 | MFGR#1416 |  35390328 |
| 1997 | UNITED ST6 | MFGR#1417 |  92594053 |
| 1997 | UNITED ST6 | MFGR#1418 |  67638716 |
| 1997 | UNITED ST6 | MFGR#1421 |  98608466 |
| 1997 | UNITED ST6 | MFGR#143  |  23938737 |
| 1997 | UNITED ST6 | MFGR#1432 | 104846191 |
| 1997 | UNITED ST6 | MFGR#1435 | 185809031 |
| 1997 | UNITED ST6 | MFGR#1436 |  82920407 |
| 1997 | UNITED ST6 | MFGR#1438 | 137524730 |
| 1997 | UNITED ST6 | MFGR#146  |  28124052 |
| 1997 | UNITED ST7 | MFGR#141  |  65266383 |
| 1997 | UNITED ST7 | MFGR#1411 |  78295166 |
| 1997 | UNITED ST7 | MFGR#1413 |  37554700 |
| 1997 | UNITED ST7 | MFGR#1414 |  20428356 |
| 1997 | UNITED ST7 | MFGR#1416 |  92381468 |
| 1997 | UNITED ST7 | MFGR#1418 | 105276410 |
| 1997 | UNITED ST7 | MFGR#1419 | 116086880 |
| 1997 | UNITED ST7 | MFGR#1420 |  62010492 |
| 1997 | UNITED ST7 | MFGR#1428 |  50904528 |
| 1997 | UNITED ST7 | MFGR#1430 | 103558679 |
| 1997 | UNITED ST7 | MFGR#1431 |  38342548 |
| 1997 | UNITED ST7 | MFGR#1436 |  59859992 |
| 1997 | UNITED ST7 | MFGR#1437 |  90701341 |
| 1997 | UNITED ST7 | MFGR#147  | 133840269 |
| 1997 | UNITED ST7 | MFGR#148  | 175852097 |
| 1997 | UNITED ST9 | MFGR#1411 |  62786695 |
| 1997 | UNITED ST9 | MFGR#1416 |  25354497 |
| 1997 | UNITED ST9 | MFGR#1417 |  47367797 |
| 1997 | UNITED ST9 | MFGR#1418 |  27220077 |
| 1997 | UNITED ST9 | MFGR#142  |  41015203 |
| 1997 | UNITED ST9 | MFGR#1423 |  41473506 |
| 1997 | UNITED ST9 | MFGR#1424 |  10735092 |
| 1997 | UNITED ST9 | MFGR#1425 |  27926087 |
| 1997 | UNITED ST9 | MFGR#1426 | 136645966 |
| 1997 | UNITED ST9 | MFGR#1430 |  41283531 |
| 1997 | UNITED ST9 | MFGR#1433 |    497505 |
| 1997 | UNITED ST9 | MFGR#1434 | 101147110 |
| 1997 | UNITED ST9 | MFGR#1436 |  30923170 |
| 1997 | UNITED ST9 | MFGR#145  |  18049495 |
| 1997 | UNITED ST9 | MFGR#146  |  43726737 |
| 1998 | UNITED ST0 | MFGR#1413 | 131487843 |
| 1998 | UNITED ST0 | MFGR#1426 |  52942692 |
| 1998 | UNITED ST0 | MFGR#146  |  13567224 |
| 1998 | UNITED ST1 | MFGR#1410 |  65992198 |
| 1998 | UNITED ST1 | MFGR#1416 | 115552383 |
| 1998 | UNITED ST1 | MFGR#1418 |  15646035 |
| 1998 | UNITED ST1 | MFGR#1419 | 129708776 |
| 1998 | UNITED ST1 | MFGR#1428 |  18176281 |
| 1998 | UNITED ST1 | MFGR#1431 |  17985830 |
| 1998 | UNITED ST1 | MFGR#1436 |  16714417 |
| 1998 | UNITED ST1 | MFGR#145  |  48297153 |
| 1998 | UNITED ST2 | MFGR#1418 |   9240384 |
| 1998 | UNITED ST2 | MFGR#1419 |  40909344 |
| 1998 | UNITED ST2 | MFGR#1420 |  78625306 |
| 1998 | UNITED ST2 | MFGR#1426 |  67161050 |
| 1998 | UNITED ST2 | MFGR#1430 |  19028508 |
| 1998 | UNITED ST2 | MFGR#1434 | 127804385 |
| 1998 | UNITED ST2 | MFGR#1435 |  75092689 |
| 1998 | UNITED ST2 | MFGR#1436 |  54579894 |
| 1998 | UNITED ST2 | MFGR#1440 |  29067722 |
| 1998 | UNITED ST2 | MFGR#148  |  78886426 |
| 1998 | UNITED ST3 | MFGR#141  |   4311846 |
| 1998 | UNITED ST3 | MFGR#1412 |  98979253 |
| 1998 | UNITED ST3 | MFGR#1415 | 102275672 |
| 1998 | UNITED ST3 | MFGR#1416 |  50781431 |
| 1998 | UNITED ST3 | MFGR#1419 |  37451476 |
| 1998 | UNITED ST3 | MFGR#1420 |  24660608 |
| 1998 | UNITED ST3 | MFGR#1422 |  98548762 |
| 1998 | UNITED ST3 | MFGR#1424 |  96601854 |
| 1998 | UNITED ST3 | MFGR#1425 |  74508450 |
| 1998 | UNITED ST3 | MFGR#1426 | 330583054 |
| 1998 | UNITED ST3 | MFGR#1427 |  41352585 |
| 1998 | UNITED ST3 | MFGR#1428 |  61979722 |
| 1998 | UNITED ST3 | MFGR#1429 |    869295 |
| 1998 | UNITED ST3 | MFGR#1432 |  66991135 |
| 1998 | UNITED ST3 | MFGR#146  |  35929398 |
| 1998 | UNITED ST3 | MFGR#147  |   8484972 |
| 1998 | UNITED ST3 | MFGR#149  |  11793257 |
| 1998 | UNITED ST5 | MFGR#1410 |  55951811 |
| 1998 | UNITED ST5 | MFGR#1413 |  13403140 |
| 1998 | UNITED ST5 | MFGR#142  |  24156762 |
| 1998 | UNITED ST5 | MFGR#1422 | 105826683 |
| 1998 | UNITED ST5 | MFGR#1430 |  67851607 |
| 1998 | UNITED ST5 | MFGR#1431 |  84833774 |
| 1998 | UNITED ST5 | MFGR#1434 |  45541810 |
| 1998 | UNITED ST5 | MFGR#1437 |  33353745 |
| 1998 | UNITED ST5 | MFGR#146  |  19891496 |
| 1998 | UNITED ST6 | MFGR#1413 | 135522572 |
| 1998 | UNITED ST6 | MFGR#1416 | 185707286 |
| 1998 | UNITED ST6 | MFGR#1417 |  80511133 |
| 1998 | UNITED ST6 | MFGR#1419 | 127132766 |
| 1998 | UNITED ST6 | MFGR#142  |  72629474 |
| 1998 | UNITED ST6 | MFGR#1435 | 158543190 |
| 1998 | UNITED ST7 | MFGR#1412 |  56750777 |
| 1998 | UNITED ST7 | MFGR#1424 |  89508621 |
| 1998 | UNITED ST7 | MFGR#1425 | 160377031 |
| 1998 | UNITED ST7 | MFGR#1434 |  20882477 |
| 1998 | UNITED ST7 | MFGR#146  | 100783548 |
| 1998 | UNITED ST7 | MFGR#147  |  61595522 |
| 1998 | UNITED ST9 | MFGR#1412 |   5049765 |
| 1998 | UNITED ST9 | MFGR#142  |  69919113 |
| 1998 | UNITED ST9 | MFGR#1425 |  11003199 |
| 1998 | UNITED ST9 | MFGR#1426 | 103616972 |
| 1998 | UNITED ST9 | MFGR#1435 |  18879758 |
| 1998 | UNITED ST9 | MFGR#1438 | 101903219 |
+------+------------+-----------+-----------+