完成 SSB 测试

完成 SSB 测试

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

准备工作

1. 编译 dbgen

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

Note

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

2. 生成数据

选项一：生成单表数据集

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

1. ./dbgen -s 1 -T c
2. ./dbgen -s 1 -T l
3. ./dbgen -s 1 -T p
4. ./dbgen -s 1 -T s
5. ./dbgen -s 1 -T d

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

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

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

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

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

3. 在 MatrixOne 中建表

1. create database if not exists ssb;
2. use ssb;
3. drop table if exists lineorder;
4. drop table if exists part;
5. drop table if exists supplier;
6. drop table if exists customer;
7. drop table if exists date;
8. drop table if exists lineorder_flat;

10. create table lineorder (
11. lo_orderkey bigint,
12. lo_linenumber int,
13. lo_custkey int,
14. lo_partkey int,
15. lo_suppkey int,
16. lo_orderdate date,
17. lo_orderpriority char (15),
18. lo_shippriority tinyint,
19. lo_quantity double,
20. lo_extendedprice double,
21. lo_ordtotalprice double,
22. lo_discount double,
23. lo_revenue double,
24. lo_supplycost double,
25. lo_tax double,
26. lo_commitdate date,
27. lo_shipmode char (10)
28. ) ;

30. create table part (
31. p_partkey int,
32. p_name varchar (22),
33. p_mfgr char (6),
34. p_category char (7),
35. p_brand char (9),
36. p_color varchar (11),
37. p_type varchar (25),
38. p_size int,
39. p_container char (10)
40. ) ;

42. create table supplier (
43. s_suppkey int,
44. s_name char (25),
45. s_address varchar (25),
46. s_city char (10),
47. s_nation char (15),
48. s_region char (12),
49. s_phone char (15)
50. ) ;

52. create table customer (
53. c_custkey int,
54. c_name varchar (25),
55. c_address varchar (25),
56. c_city char (10),
57. c_nation char (15),
58. c_region char (12),
59. c_phone char (15),
60. c_mktsegment char (10)
61. ) ;

63. create table date (
64. d_datekey date,
65. d_date char (18),
66. d_dayofweek char (9),
67. d_month char (9),
68. d_year int,
69. d_yearmonthnum int,
70. d_yearmonth char (7),
71. d_daynuminweek varchar(12),
72. d_daynuminmonth int,
73. d_daynuminyear int,
74. d_monthnuminyear int,
75. d_weeknuminyear int,
76. d_sellingseason varchar (12),
77. d_lastdayinweekfl varchar (1),
78. d_lastdayinmonthfl varchar (1),
79. d_holidayfl varchar (1),
80. d_weekdayfl varchar (1)
81. ) ;

83. CREATE TABLE lineorder_flat(
84. LO_ORDERKEY bigint key,
85. LO_LINENUMBER int,
86. LO_CUSTKEY int,
87. LO_PARTKEY int,
88. LO_SUPPKEY int,
89. LO_ORDERDATE date,
90. LO_ORDERPRIORITY char(15),
91. LO_SHIPPRIORITY tinyint,
92. LO_QUANTITY double,
93. LO_EXTENDEDPRICE double,
94. LO_ORDTOTALPRICE double,
95. LO_DISCOUNT double,
96. LO_REVENUE int unsigned,
97. LO_SUPPLYCOST int unsigned,
98. LO_TAX double,
99. LO_COMMITDATE date,
100. LO_SHIPMODE char(10),
101. C_NAME varchar(25),
102. C_ADDRESS varchar(25),
103. C_CITY char(10),
104. C_NATION char(15),
105. C_REGION char(12),
106. C_PHONE char(15),
107. C_MKTSEGMENT char(10),
108. S_NAME char(25),
109. S_ADDRESS varchar(25),
110. S_CITY char(10),
111. S_NATION char(15),
112. S_REGION char(12),
113. S_PHONE char(15),
114. P_NAME varchar(22),
115. P_MFGR char(6),
116. P_CATEGORY char(7),
117. P_BRAND char(9),
118. P_COLOR varchar(11),
119. P_TYPE varchar(25),
120. P_SIZE int,
121. P_CONTAINER char(10)
122. );

4. 导入数据

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

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

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

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

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

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

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

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

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

1. 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 测试命令

单表查询

1. --Q1.1
2. 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;

4. --Q1.2
5. 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;

7. --Q1.3
8. 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;

10. --Q2.1
11. 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, P_BRAND ORDER BY year,P_BRAND;

13. --Q2.2
14. 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, P_BRAND ORDER BY year, P_BRAND;

16. --Q2.3
17. 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, P_BRAND ORDER BY year, P_BRAND;

19. --Q3.1
20. 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;

22. --Q3.2
23. 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;

25. --Q3.3
26. 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;

28. --Q3.4
29. 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;

31. --Q4.1
32. 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;

34. --Q4.2
35. 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;

37. --Q4.3
38. 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;

多表查询

1. --Q1.1
2. select sum(lo_revenue) as revenue
3. from lineorder join date on lo_orderdate = d_datekey
4. where year(d_datekey)  = 1993 and lo_discount between 1 and 3 and lo_quantity < 25;

6. --Q1.2
7. select sum(lo_revenue) as revenue
8. from lineorder
9. join date on lo_orderdate = d_datekey
10. where d_yearmonthnum = 199401
11. and lo_discount between 4 and 6
12. and lo_quantity between 26 and 35;

14. --Q1.3
15. select sum(lo_revenue) as revenue
16. from lineorder
17. join date on lo_orderdate = d_datekey
18. where d_weeknuminyear = 6 and year(d_datekey)  = 1994
19. and lo_discount between 5 and 7
20. and lo_quantity between 26 and 35;

22. --Q2.1
23. select sum(lo_revenue) as lo_revenue, year(d_datekey) as year, p_brand
24. from lineorder
25. join date on lo_orderdate = d_datekey
26. join part on lo_partkey = p_partkey
27. join supplier on lo_suppkey = s_suppkey
28. where p_category = 'MFGR#12' and s_region = 'AMERICA'
29. group by year, p_brand
30. order by year, p_brand;

32. --Q2.2
33. select sum(lo_revenue) as lo_revenue, year(d_datekey) as year, p_brand
34. from lineorder
35. join date on lo_orderdate = d_datekey
36. join part on lo_partkey = p_partkey
37. join supplier on lo_suppkey = s_suppkey
38. where p_brand between 'MFGR#2221' and 'MFGR#2228' and s_region = 'ASIA'
39. group by year, p_brand
40. order by year, p_brand;

42. --Q2.3
43. select sum(lo_revenue) as lo_revenue, year(d_datekey) as year, p_brand
44. from lineorder
45. join date on lo_orderdate = d_datekey
46. join part on lo_partkey = p_partkey
47. join supplier on lo_suppkey = s_suppkey
48. where p_brand = 'MFGR#2239' and s_region = 'EUROPE'
49. group by year, p_brand
50. order by year, p_brand;

52. --Q3.1
53. select c_nation, s_nation, year(d_datekey) as year, sum(lo_revenue) as lo_revenue
54. from lineorder
55. join date on lo_orderdate = d_datekey
56. join customer on lo_custkey = c_custkey
57. join supplier on lo_suppkey = s_suppkey
58. where c_region = 'ASIA' and s_region = 'ASIA' and year(d_datekey) between 1992 and 1997
59. group by c_nation, s_nation, year
60. order by year asc, lo_revenue desc;

62. --Q3.2
63. select c_city, s_city, year(d_datekey) as year, sum(lo_revenue) as lo_revenue
64. from lineorder
65. join date on lo_orderdate = d_datekey
66. join customer on lo_custkey = c_custkey
67. join supplier on lo_suppkey = s_suppkey
68. where c_nation = 'UNITED STATES' and s_nation = 'UNITED STATES'
69. and year(d_datekey) between 1992 and 1997
70. group by c_city, s_city, year
71. order by year asc, lo_revenue desc;

73. --Q3.3
74. select c_city, s_city, year(d_datekey) as year, sum(lo_revenue) as lo_revenue
75. from lineorder
76. join date on lo_orderdate = d_datekey
77. join customer on lo_custkey = c_custkey
78. join supplier on lo_suppkey = s_suppkey
79. where (c_city='UNITED KI1' or c_city='UNITED KI5')
80. and (s_city='UNITED KI1' or s_city='UNITED KI5')
81. and year(d_datekey) between 1992 and 1997
82. group by c_city, s_city, year
83. order by year asc, lo_revenue desc;

85. --Q3.4
86. select c_city, s_city, year(d_datekey) as year, sum(lo_revenue) as lo_revenue
87. from lineorder
88. join date on lo_orderdate = d_datekey
89. join customer on lo_custkey = c_custkey
90. join supplier on lo_suppkey = s_suppkey
91. where (c_city='UNITED KI1' or c_city='UNITED KI5') and (s_city='UNITED KI1' or s_city='UNITED KI5') and d_yearmonth = 'Dec1997'
92. group by c_city, s_city, year
93. order by year asc, lo_revenue desc;

95. --Q4.1
96. select year(d_datekey) as year, c_nation, sum(lo_revenue) - sum(lo_supplycost) as profit
97. from lineorder
98. join date on lo_orderdate = d_datekey
99. join customer on lo_custkey = c_custkey
100. join supplier on lo_suppkey = s_suppkey
101. join part on lo_partkey = p_partkey
102. where c_region = 'AMERICA' and s_region = 'AMERICA' and (p_mfgr = 'MFGR#1' or p_mfgr = 'MFGR#2')
103. group by year, c_nation
104. order by year, c_nation;

106. --Q4.2
107. select year(d_datekey) as year, s_nation, p_category, sum(lo_revenue) - sum(lo_supplycost) as profit
108. from lineorder
109. join date on lo_orderdate = d_datekey
110. join customer on lo_custkey = c_custkey
111. join supplier on lo_suppkey = s_suppkey
112. join part on lo_partkey = p_partkey
113. where c_region = 'AMERICA'and s_region = 'AMERICA'
114. and (year(d_datekey) = 1997 or year(d_datekey) = 1998)
115. and (p_mfgr = 'MFGR#1' or p_mfgr = 'MFGR#2')
116. group by year, s_nation, p_category
117. order by year, s_nation, p_category;

119. --Q4.3
120. select year(d_datekey) as year, s_city, p_brand, sum(lo_revenue) - sum(lo_supplycost) as profit,c_region , s_nation, p_category
121. from lineorder
122. join date on lo_orderdate = d_datekey
123. join customer on lo_custkey = c_custkey
124. join supplier on lo_suppkey = s_suppkey
125. join part on lo_partkey = p_partkey
126. where
127. (year(d_datekey) = 1997 or year(d_datekey) = 1998)
128. and s_nation='ALGERIA'
129. group by year, s_city, p_brand
130. order by year, s_city, p_brand;

6. 运行预期结果

单表查询运行预期结果

``` 1. -- Q1.1 2. +--------------+ 3. | revenue | 4. +--------------+ 5. | 702223464659 | 6. +--------------+

-- 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

（本文超出站点单文档体积上限，已截断）