完成 SSB 测试

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

准备工作

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

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. 在下面链接中直接获取大宽表数据集文件：
  1. https://community-shared-data-1308875761.cos.ap-beijing.myqcloud.com/lineorder_flat.tar.bz2
  1. 下载完成后将数据文件解压。

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

Note

GROUP BY 暂不支持使用别名。

单表查询

  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(LO_ORDERDATE), 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(LO_ORDERDATE), 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(LO_ORDERDATE), 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(d_datekey), 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(d_datekey), 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(d_datekey), 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(d_datekey)
  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(d_datekey)
  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(d_datekey)
  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 = '199712'
  92. group by c_city, s_city, year(d_datekey)
  93. order by year(d_datekey) 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(d_datekey), 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(d_datekey), 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
  121. from lineorder
  122. join dates 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 c_region = 'AMERICA'
  129. and s_nation = 'UNITED STATES'
  130. and p_category = 'MFGR#14'
  131. group by year, s_city, p_brand
  132. order by year, s_city, p_brand;

6. 运行预期结果

单表查询运行预期结果

  1. -- Q1.1
  2. +--------------+
  3. | revenue      |
  4. +--------------+
  5. | 702223464659 |
  6. +--------------+
  8. -- Q1.2
  9. +---------------+
  10. | revenue       |
  11. +---------------+
  12. | 1842875090496 |
  13. +---------------+
  15. -- Q1.3
  16. +---------------+
  17. | revenue       |
  18. +---------------+
  19. | 2208738861324 |
  20. +---------------+
  22. -- Q2.1
  23. +-----------------+------+-----------+
  24. | sum(lo_revenue) | year | p_brand   |
  25. +-----------------+------+-----------+
  26. |       283684289 | 1992 | MFGR#121  |
  27. |      1344702529 | 1992 | MFGR#1210 |
  28. |       757158682 | 1992 | MFGR#1211 |
  29. |      1156022815 | 1992 | MFGR#1212 |
  30. |       676164367 | 1992 | MFGR#1213 |
  31. |       522779256 | 1992 | MFGR#1214 |
  32. |       233507213 | 1992 | MFGR#1215 |
  33. |       726755819 | 1992 | MFGR#1216 |
  34. |      1865504710 | 1992 | MFGR#1217 |
  35. |       685600451 | 1992 | MFGR#1218 |
  36. |       814671470 | 1992 | MFGR#1219 |
  37. |       655405800 | 1992 | MFGR#122  |
  38. |       962120553 | 1992 | MFGR#1220 |
  39. |       961393626 | 1992 | MFGR#1221 |
  40. |       922110830 | 1992 | MFGR#1222 |
  41. |       814842712 | 1992 | MFGR#1223 |
  42. |      1402773165 | 1992 | MFGR#1224 |
  43. |       977517439 | 1992 | MFGR#1225 |
  44. |      1392114944 | 1992 | MFGR#1226 |
  45. |       658922951 | 1992 | MFGR#1227 |
  46. |       892495927 | 1992 | MFGR#1228 |
  47. |       806609100 | 1992 | MFGR#1229 |
  48. |       578875657 | 1992 | MFGR#123  |
  49. |       691236902 | 1992 | MFGR#1230 |
  50. |       482715249 | 1992 | MFGR#1231 |
  51. |       618556590 | 1992 | MFGR#1232 |
  52. |       981657009 | 1992 | MFGR#1233 |
  53. |      1050794669 | 1992 | MFGR#1234 |
  54. |      1335217991 | 1992 | MFGR#1235 |
  55. |       686009527 | 1992 | MFGR#1236 |
  56. |       605242584 | 1992 | MFGR#1237 |
  57. |       430455641 | 1992 | MFGR#1238 |
  58. |       359654993 | 1992 | MFGR#1239 |
  59. |       818818457 | 1992 | MFGR#124  |
  60. |      1388502581 | 1992 | MFGR#1240 |
  61. |       711566198 | 1992 | MFGR#125  |
  62. |       893045647 | 1992 | MFGR#126  |
  63. |      1240534333 | 1992 | MFGR#127  |
  64. |       871966127 | 1992 | MFGR#128  |
  65. |       719176622 | 1992 | MFGR#129  |
  66. |       245880758 | 1993 | MFGR#121  |
  67. |      1480662753 | 1993 | MFGR#1210 |
  68. |       982292725 | 1993 | MFGR#1211 |
  69. |      1001136766 | 1993 | MFGR#1212 |
  70. |       227144072 | 1993 | MFGR#1213 |
  71. |       291611370 | 1993 | MFGR#1214 |
  72. |       454576668 | 1993 | MFGR#1215 |
  73. |       772027256 | 1993 | MFGR#1216 |
  74. |      1155751851 | 1993 | MFGR#1217 |
  75. |       897883050 | 1993 | MFGR#1218 |
  76. |      1209508962 | 1993 | MFGR#1219 |
  77. |       530577973 | 1993 | MFGR#122  |
  78. |       901650471 | 1993 | MFGR#1220 |
  79. |       739540494 | 1993 | MFGR#1221 |
  80. |       698751459 | 1993 | MFGR#1222 |
  81. |      1327979157 | 1993 | MFGR#1223 |
  82. |      1476697469 | 1993 | MFGR#1224 |
  83. |       792103134 | 1993 | MFGR#1225 |
  84. |      1420277376 | 1993 | MFGR#1226 |
  85. |      1446032835 | 1993 | MFGR#1227 |
  86. |       884375309 | 1993 | MFGR#1228 |
  87. |       522705868 | 1993 | MFGR#1229 |
  88. |       601685233 | 1993 | MFGR#123  |
  89. |       806727248 | 1993 | MFGR#1230 |
  90. |       399477390 | 1993 | MFGR#1231 |
  91. |       894047578 | 1993 | MFGR#1232 |
  92. |       496067089 | 1993 | MFGR#1233 |
  93. |      1050223756 | 1993 | MFGR#1234 |
  94. |       891681399 | 1993 | MFGR#1235 |
  95. |      1402903631 | 1993 | MFGR#1236 |
  96. |       347380448 | 1993 | MFGR#1237 |
  97. |       514853194 | 1993 | MFGR#1238 |
  98. |       410543863 | 1993 | MFGR#1239 |
  99. |       673483594 | 1993 | MFGR#124  |
  100. |       713343630 | 1993 | MFGR#1240 |
  101. |       512610707 | 1993 | MFGR#125  |
  102. |      1228110634 | 1993 | MFGR#126  |
  103. |       936958961 | 1993 | MFGR#127  |
  104. |       579067515 | 1993 | MFGR#128  |
  105. |       636174833 | 1993 | MFGR#129  |
  106. |       370347074 | 1994 | MFGR#121  |
  107. |       483900410 | 1994 | MFGR#1210 |
  108. |      1240306281 | 1994 | MFGR#1211 |
  109. |      1003345253 | 1994 | MFGR#1212 |
  110. |       557310864 | 1994 | MFGR#1213 |
  111. |       314972328 | 1994 | MFGR#1214 |
  112. |      1130260810 | 1994 | MFGR#1215 |
  113. |       401618319 | 1994 | MFGR#1216 |
  114. |       652173601 | 1994 | MFGR#1217 |
  115. |       923612074 | 1994 | MFGR#1218 |
  116. |       469711377 | 1994 | MFGR#1219 |
  117. |       580152115 | 1994 | MFGR#122  |
  118. |       433134653 | 1994 | MFGR#1220 |
  119. |       730569849 | 1994 | MFGR#1221 |
  120. |       607609104 | 1994 | MFGR#1222 |
  121. |       949877669 | 1994 | MFGR#1223 |
  122. |      1644687916 | 1994 | MFGR#1224 |
  123. |       492974194 | 1994 | MFGR#1225 |
  124. |       921499688 | 1994 | MFGR#1226 |
  125. |       719059761 | 1994 | MFGR#1227 |
  126. |      1000497056 | 1994 | MFGR#1228 |
  127. |       486968927 | 1994 | MFGR#1229 |
  128. |       734124906 | 1994 | MFGR#123  |
  129. |       645016873 | 1994 | MFGR#1230 |
  130. |       526638240 | 1994 | MFGR#1231 |
  131. |      1358112405 | 1994 | MFGR#1232 |
  132. |      1167074905 | 1994 | MFGR#1233 |
  133. |      1102915239 | 1994 | MFGR#1234 |
  134. |       693058125 | 1994 | MFGR#1235 |
  135. |      1673392892 | 1994 | MFGR#1236 |
  136. |       849630029 | 1994 | MFGR#1237 |
  137. |       721392705 | 1994 | MFGR#1238 |
  138. |      1237195774 | 1994 | MFGR#1239 |
  139. |      1107832795 | 1994 | MFGR#124  |
  140. |       827906290 | 1994 | MFGR#1240 |
  141. |       682827304 | 1994 | MFGR#125  |
  142. |      1198768141 | 1994 | MFGR#126  |
  143. |      1274148181 | 1994 | MFGR#127  |
  144. |       738849138 | 1994 | MFGR#128  |
  145. |       751136619 | 1994 | MFGR#129  |
  146. |       318978803 | 1995 | MFGR#121  |
  147. |       383199448 | 1995 | MFGR#1210 |
  148. |      1300165814 | 1995 | MFGR#1211 |
  149. |      1550400731 | 1995 | MFGR#1212 |
  150. |       451958158 | 1995 | MFGR#1213 |
  151. |       431434279 | 1995 | MFGR#1214 |
  152. |       713735582 | 1995 | MFGR#1215 |
  153. |       919323722 | 1995 | MFGR#1216 |
  154. |      1542358864 | 1995 | MFGR#1217 |
  155. |       500930092 | 1995 | MFGR#1218 |
  156. |      1208162086 | 1995 | MFGR#1219 |
  157. |       785707989 | 1995 | MFGR#122  |
  158. |       993828211 | 1995 | MFGR#1220 |
  159. |       667253893 | 1995 | MFGR#1221 |
  160. |      1654114297 | 1995 | MFGR#1222 |
  161. |       986528377 | 1995 | MFGR#1223 |
  162. |       755014642 | 1995 | MFGR#1224 |
  163. |      1090300100 | 1995 | MFGR#1225 |
  164. |      1063626454 | 1995 | MFGR#1226 |
  165. |      1382528859 | 1995 | MFGR#1227 |
  166. |       919953351 | 1995 | MFGR#1228 |
  167. |       457795295 | 1995 | MFGR#1229 |
  168. |       953851827 | 1995 | MFGR#123  |
  169. |       807209283 | 1995 | MFGR#1230 |
  170. |       236304454 | 1995 | MFGR#1231 |
  171. |       668449537 | 1995 | MFGR#1232 |
  172. |       240657083 | 1995 | MFGR#1233 |
  173. |       920389826 | 1995 | MFGR#1234 |
  174. |       684096065 | 1995 | MFGR#1235 |
  175. |      1005844219 | 1995 | MFGR#1236 |
  176. |       626170996 | 1995 | MFGR#1237 |
  177. |       984581826 | 1995 | MFGR#1238 |
  178. |       602850634 | 1995 | MFGR#1239 |
  179. |      1172025628 | 1995 | MFGR#124  |
  180. |       489788581 | 1995 | MFGR#1240 |
  181. |       643100327 | 1995 | MFGR#125  |
  182. |       894596661 | 1995 | MFGR#126  |
  183. |       706917239 | 1995 | MFGR#127  |
  184. |       428671983 | 1995 | MFGR#128  |
  185. |       971611472 | 1995 | MFGR#129  |
  186. |       306497573 | 1996 | MFGR#121  |
  187. |       890719726 | 1996 | MFGR#1210 |
  188. |      1761977172 | 1996 | MFGR#1211 |
  189. |       633845765 | 1996 | MFGR#1212 |
  190. |       475801202 | 1996 | MFGR#1213 |
  191. |       271930385 | 1996 | MFGR#1214 |
  192. |       366399844 | 1996 | MFGR#1215 |
  193. |       877472476 | 1996 | MFGR#1216 |
  194. |       970366290 | 1996 | MFGR#1217 |
  195. |       537175690 | 1996 | MFGR#1218 |
  196. |       956970528 | 1996 | MFGR#1219 |
  197. |       711962074 | 1996 | MFGR#122  |
  198. |      1062161683 | 1996 | MFGR#1220 |
  199. |       406293744 | 1996 | MFGR#1221 |
  200. |       785404335 | 1996 | MFGR#1222 |
  201. |       579267044 | 1996 | MFGR#1223 |
  202. |      1220640256 | 1996 | MFGR#1224 |
  203. |       490130196 | 1996 | MFGR#1225 |
  204. |      1603805636 | 1996 | MFGR#1226 |
  205. |      1530646510 | 1996 | MFGR#1227 |
  206. |      1093328922 | 1996 | MFGR#1228 |
  207. |       596520140 | 1996 | MFGR#1229 |
  208. |       450815571 | 1996 | MFGR#123  |
  209. |       315053350 | 1996 | MFGR#1230 |
  210. |       198951017 | 1996 | MFGR#1231 |
  211. |       579778438 | 1996 | MFGR#1232 |
  212. |       480905486 | 1996 | MFGR#1233 |
  213. |      1433336215 | 1996 | MFGR#1234 |
  214. |       560925251 | 1996 | MFGR#1235 |
  215. |      1038766181 | 1996 | MFGR#1236 |
  216. |       783697960 | 1996 | MFGR#1237 |
  217. |       972656445 | 1996 | MFGR#1238 |
  218. |       614528801 | 1996 | MFGR#1239 |
  219. |      1418931894 | 1996 | MFGR#124  |
  220. |       995139591 | 1996 | MFGR#1240 |
  221. |       824028471 | 1996 | MFGR#125  |
  222. |       669475113 | 1996 | MFGR#126  |
  223. |       831704651 | 1996 | MFGR#127  |
  224. |       920514555 | 1996 | MFGR#128  |
  225. |       436162421 | 1996 | MFGR#129  |
  226. |       553684594 | 1997 | MFGR#121  |
  227. |      1317368046 | 1997 | MFGR#1210 |
  228. |      1617056983 | 1997 | MFGR#1211 |
  229. |      1196031005 | 1997 | MFGR#1212 |
  230. |      1056458336 | 1997 | MFGR#1213 |
  231. |       352179650 | 1997 | MFGR#1214 |
  232. |       511058114 | 1997 | MFGR#1215 |
  233. |       658259312 | 1997 | MFGR#1216 |
  234. |      1238450697 | 1997 | MFGR#1217 |
  235. |       376245955 | 1997 | MFGR#1218 |
  236. |       913437812 | 1997 | MFGR#1219 |
  237. |      1114996000 | 1997 | MFGR#122  |
  238. |       814059433 | 1997 | MFGR#1220 |
  239. |       817328516 | 1997 | MFGR#1221 |
  240. |       541428597 | 1997 | MFGR#1222 |
  241. |      1260539052 | 1997 | MFGR#1223 |
  242. |      1766426582 | 1997 | MFGR#1224 |
  243. |      1221271245 | 1997 | MFGR#1225 |
  244. |      1499152922 | 1997 | MFGR#1226 |
  245. |       491586909 | 1997 | MFGR#1227 |
  246. |       911517084 | 1997 | MFGR#1228 |
  247. |       728186585 | 1997 | MFGR#1229 |
  248. |       904363416 | 1997 | MFGR#123  |
  249. |       605369014 | 1997 | MFGR#1230 |
  250. |       290370455 | 1997 | MFGR#1231 |
  251. |       602414397 | 1997 | MFGR#1232 |
  252. |       765339065 | 1997 | MFGR#1233 |
  253. |      1170973957 | 1997 | MFGR#1234 |
  254. |       860319765 | 1997 | MFGR#1235 |
  255. |      1031080311 | 1997 | MFGR#1236 |
  256. |       736404810 | 1997 | MFGR#1237 |
  257. |      1012330790 | 1997 | MFGR#1238 |
  258. |       681055343 | 1997 | MFGR#1239 |
  259. |       601626600 | 1997 | MFGR#124  |
  260. |       920404157 | 1997 | MFGR#1240 |
  261. |      1007678757 | 1997 | MFGR#125  |
  262. |       622347203 | 1997 | MFGR#126  |
  263. |      1215295592 | 1997 | MFGR#127  |
  264. |       822274972 | 1997 | MFGR#128  |
  265. |       643903475 | 1997 | MFGR#129  |
  266. |       470008435 | 1998 | MFGR#121  |
  267. |       568508492 | 1998 | MFGR#1210 |
  268. |       323759101 | 1998 | MFGR#1211 |
  269. |       572013331 | 1998 | MFGR#1212 |
  270. |       448137748 | 1998 | MFGR#1213 |
  271. |       137422458 | 1998 | MFGR#1214 |
  272. |       346491756 | 1998 | MFGR#1215 |
  273. |       454542243 | 1998 | MFGR#1216 |
  274. |       759205210 | 1998 | MFGR#1217 |
  275. |       674544462 | 1998 | MFGR#1218 |
  276. |       735952270 | 1998 | MFGR#1219 |
  277. |       490186568 | 1998 | MFGR#122  |
  278. |       769456686 | 1998 | MFGR#1220 |
  279. |       654540341 | 1998 | MFGR#1221 |
  280. |       800329859 | 1998 | MFGR#1222 |
  281. |       263849231 | 1998 | MFGR#1223 |
  282. |       445461642 | 1998 | MFGR#1224 |
  283. |       387808862 | 1998 | MFGR#1225 |
  284. |       675424382 | 1998 | MFGR#1226 |
  285. |       265906673 | 1998 | MFGR#1227 |
  286. |       585938371 | 1998 | MFGR#1228 |
  287. |       683188537 | 1998 | MFGR#1229 |
  288. |       304403717 | 1998 | MFGR#123  |
  289. |       533781674 | 1998 | MFGR#1230 |
  290. |       304060011 | 1998 | MFGR#1231 |
  291. |       635275907 | 1998 | MFGR#1232 |
  292. |       658295080 | 1998 | MFGR#1233 |
  293. |       524133341 | 1998 | MFGR#1234 |
  294. |       363911877 | 1998 | MFGR#1235 |
  295. |       300885635 | 1998 | MFGR#1236 |
  296. |       532608453 | 1998 | MFGR#1237 |
  297. |       484291410 | 1998 | MFGR#1238 |
  298. |       445336624 | 1998 | MFGR#1239 |
  299. |       719027801 | 1998 | MFGR#124  |
  300. |       518860961 | 1998 | MFGR#1240 |
  301. |       491235383 | 1998 | MFGR#125  |
  302. |       520917638 | 1998 | MFGR#126  |
  303. |      1158787745 | 1998 | MFGR#127  |
  304. |       401190922 | 1998 | MFGR#128  |
  305. |       406656337 | 1998 | MFGR#129  |
  306. +-----------------+------+-----------+
  308. -- Q2.2
  309. +-----------------+------+-----------+
  310. | sum(lo_revenue) | year | p_brand   |
  311. +-----------------+------+-----------+
  312. |      1259802358 | 1992 | MFGR#2221 |
  313. |      1728549344 | 1992 | MFGR#2222 |
  314. |      1375260024 | 1992 | MFGR#2223 |
  315. |      1299982475 | 1992 | MFGR#2224 |
  316. |      1541960331 | 1992 | MFGR#2225 |
  317. |      1151853513 | 1992 | MFGR#2226 |
  318. |      1271175264 | 1992 | MFGR#2227 |
  319. |      1726441695 | 1992 | MFGR#2228 |
  320. |      1251460032 | 1993 | MFGR#2221 |
  321. |      1331062515 | 1993 | MFGR#2222 |
  322. |       902809293 | 1993 | MFGR#2223 |
  323. |       980512417 | 1993 | MFGR#2224 |
  324. |      1253088003 | 1993 | MFGR#2225 |
  325. |       959195148 | 1993 | MFGR#2226 |
  326. |       555593932 | 1993 | MFGR#2227 |
  327. |      2186479174 | 1993 | MFGR#2228 |
  328. |      1094092222 | 1994 | MFGR#2221 |
  329. |      1491699323 | 1994 | MFGR#2222 |
  330. |      1501160826 | 1994 | MFGR#2223 |
  331. |      1387107418 | 1994 | MFGR#2224 |
  332. |      1641588884 | 1994 | MFGR#2225 |
  333. |      1387296390 | 1994 | MFGR#2226 |
  334. |      1038341470 | 1994 | MFGR#2227 |
  335. |      1565763138 | 1994 | MFGR#2228 |
  336. |      1412945650 | 1995 | MFGR#2221 |
  337. |      1546178356 | 1995 | MFGR#2222 |
  338. |      1218352073 | 1995 | MFGR#2223 |
  339. |      1052197762 | 1995 | MFGR#2224 |
  340. |      1822921900 | 1995 | MFGR#2225 |
  341. |       728142181 | 1995 | MFGR#2226 |
  342. |       966131607 | 1995 | MFGR#2227 |
  343. |      1379320517 | 1995 | MFGR#2228 |
  344. |      1042767284 | 1996 | MFGR#2221 |
  345. |       994733835 | 1996 | MFGR#2222 |
  346. |      1615788545 | 1996 | MFGR#2223 |
  347. |      1113980216 | 1996 | MFGR#2224 |
  348. |      1622570253 | 1996 | MFGR#2225 |
  349. |      1540226758 | 1996 | MFGR#2226 |
  350. |      1115687883 | 1996 | MFGR#2227 |
  351. |      1716355343 | 1996 | MFGR#2228 |
  352. |       867705636 | 1997 | MFGR#2221 |
  353. |      1529877498 | 1997 | MFGR#2222 |
  354. |      1594444450 | 1997 | MFGR#2223 |
  355. |       587421043 | 1997 | MFGR#2224 |
  356. |      1112274470 | 1997 | MFGR#2225 |
  357. |      1327884722 | 1997 | MFGR#2226 |
  358. |       884180880 | 1997 | MFGR#2227 |
  359. |      1664207656 | 1997 | MFGR#2228 |
  360. |       827743515 | 1998 | MFGR#2221 |
  361. |       662242310 | 1998 | MFGR#2222 |
  362. |       861445539 | 1998 | MFGR#2223 |
  363. |       694538672 | 1998 | MFGR#2224 |
  364. |       675179021 | 1998 | MFGR#2225 |
  365. |       480728720 | 1998 | MFGR#2226 |
  366. |       643763072 | 1998 | MFGR#2227 |
  367. |       994499201 | 1998 | MFGR#2228 |
  368. +-----------------+------+-----------+
  370. -- Q2.3
  371. +-----------------+------+-----------+
  372. | sum(lo_revenue) | year | p_brand   |
  373. +-----------------+------+-----------+
  374. |      1428843284 | 1992 | MFGR#2239 |
  375. |      1865666054 | 1993 | MFGR#2239 |
  376. |      2242753254 | 1994 | MFGR#2239 |
  377. |      1446677305 | 1995 | MFGR#2239 |
  378. |       921681503 | 1996 | MFGR#2239 |
  379. |      1549990572 | 1997 | MFGR#2239 |
  380. |       926327433 | 1998 | MFGR#2239 |
  381. +-----------------+------+-----------+
  383. -- Q3.1
  384. +-----------+-----------+------+-------------+
  385. | c_nation  | s_nation  | year | revenue     |
  386. +-----------+-----------+------+-------------+
  387. | VIETNAM   | CHINA     | 1992 | 17194479086 |
  388. | JAPAN     | CHINA     | 1992 | 15572594510 |
  389. | JAPAN     | JAPAN     | 1992 | 13861682954 |
  390. | INDONESIA | CHINA     | 1992 | 13499663933 |
  391. | VIETNAM   | INDONESIA | 1992 | 13163103649 |
  392. | JAPAN     | INDONESIA | 1992 | 13035158590 |
  393. | INDIA     | CHINA     | 1992 | 12987688902 |
  394. | INDONESIA | JAPAN     | 1992 | 12939737918 |
  395. | VIETNAM   | JAPAN     | 1992 | 12174715858 |
  396. | JAPAN     | VIETNAM   | 1992 | 11669093753 |
  397. | INDIA     | INDONESIA | 1992 | 11452602145 |
  398. | INDONESIA | INDONESIA | 1992 | 10394407561 |
  399. | INDIA     | JAPAN     | 1992 | 10313084900 |
  400. | JAPAN     | INDIA     | 1992 | 10035511089 |
  401. | CHINA     | CHINA     | 1992 |  9828744666 |
  402. | VIETNAM   | VIETNAM   | 1992 |  9701522505 |
  403. | INDONESIA | INDIA     | 1992 |  9271105764 |
  404. | INDIA     | INDIA     | 1992 |  8879645522 |
  405. | CHINA     | INDONESIA | 1992 |  8373693838 |
  406. | CHINA     | JAPAN     | 1992 |  8051248951 |
  407. | VIETNAM   | INDIA     | 1992 |  7804539029 |
  408. | INDONESIA | VIETNAM   | 1992 |  7615465790 |
  409. | CHINA     | INDIA     | 1992 |  7344868842 |
  410. | INDIA     | VIETNAM   | 1992 |  6830508508 |
  411. | CHINA     | VIETNAM   | 1992 |  6529888238 |
  412. | JAPAN     | CHINA     | 1993 | 18839180326 |
  413. | VIETNAM   | CHINA     | 1993 | 14761890330 |
  414. | JAPAN     | INDONESIA | 1993 | 13648082171 |
  415. | INDONESIA | CHINA     | 1993 | 13518181805 |
  416. | INDIA     | CHINA     | 1993 | 13249555999 |
  417. | JAPAN     | JAPAN     | 1993 | 12667833152 |
  418. | JAPAN     | VIETNAM   | 1993 | 11529854580 |
  419. | CHINA     | CHINA     | 1993 | 11216468573 |
  420. | INDONESIA | INDONESIA | 1993 | 10953284722 |
  421. | VIETNAM   | INDONESIA | 1993 | 10582912267 |
  422. | INDIA     | JAPAN     | 1993 | 10482950584 |
  423. | VIETNAM   | JAPAN     | 1993 | 10370811002 |
  424. | INDIA     | INDONESIA | 1993 | 10145286112 |
  425. | INDONESIA | JAPAN     | 1993 |  9850020303 |
  426. | VIETNAM   | VIETNAM   | 1993 |  9591468153 |
  427. | CHINA     | INDONESIA | 1993 |  9015864524 |
  428. | CHINA     | JAPAN     | 1993 |  8972996729 |
  429. | INDONESIA | INDIA     | 1993 |  8903638786 |
  430. | JAPAN     | INDIA     | 1993 |  8848048514 |
  431. | INDONESIA | VIETNAM   | 1993 |  8024464882 |
  432. | VIETNAM   | INDIA     | 1993 |  7806575746 |
  433. | INDIA     | VIETNAM   | 1993 |  7537331106 |
  434. | INDIA     | INDIA     | 1993 |  7211053846 |
  435. | CHINA     | VIETNAM   | 1993 |  6700022269 |
  436. | CHINA     | INDIA     | 1993 |  6327331541 |
  437. | JAPAN     | CHINA     | 1994 | 15661051644 |
  438. | VIETNAM   | CHINA     | 1994 | 13958591931 |
  439. | JAPAN     | JAPAN     | 1994 | 13566252348 |
  440. | CHINA     | CHINA     | 1994 | 12870010072 |
  441. | VIETNAM   | JAPAN     | 1994 | 12728320716 |
  442. | INDONESIA | CHINA     | 1994 | 12295790872 |
  443. | INDIA     | CHINA     | 1994 | 12166419121 |
  444. | JAPAN     | INDONESIA | 1994 | 11358955025 |
  445. | INDIA     | INDONESIA | 1994 | 11111248365 |
  446. | JAPAN     | INDIA     | 1994 | 10078806371 |
  447. | VIETNAM   | INDONESIA | 1994 |  9923852578 |
  448. | INDIA     | JAPAN     | 1994 |  9839136767 |
  449. | CHINA     | JAPAN     | 1994 |  9836586308 |
  450. | INDONESIA | JAPAN     | 1994 |  9786694572 |
  451. | INDIA     | VIETNAM   | 1994 |  9551081406 |
  452. | JAPAN     | VIETNAM   | 1994 |  9035431932 |
  453. | VIETNAM   | INDIA     | 1994 |  9032319402 |
  454. | INDONESIA | INDONESIA | 1994 |  8876012426 |
  455. | CHINA     | INDONESIA | 1994 |  8375581981 |
  456. | VIETNAM   | VIETNAM   | 1994 |  8095638136 |
  457. | INDONESIA | INDIA     | 1994 |  7943993512 |
  458. | INDONESIA | VIETNAM   | 1994 |  7927236697 |
  459. | INDIA     | INDIA     | 1994 |  7534915457 |
  460. | CHINA     | VIETNAM   | 1994 |  6062387221 |
  461. | CHINA     | INDIA     | 1994 |  5816794324 |
  462. | VIETNAM   | CHINA     | 1995 | 15128423080 |
  463. | INDONESIA | CHINA     | 1995 | 14794647970 |
  464. | INDIA     | CHINA     | 1995 | 14724240804 |
  465. | JAPAN     | CHINA     | 1995 | 14579848516 |
  466. | CHINA     | CHINA     | 1995 | 14296657586 |
  467. | INDIA     | JAPAN     | 1995 | 13511381754 |
  468. | JAPAN     | JAPAN     | 1995 | 12015968288 |
  469. | VIETNAM   | INDONESIA | 1995 | 11290647784 |
  470. | JAPAN     | INDONESIA | 1995 | 10968840402 |
  471. | INDIA     | INDONESIA | 1995 | 10879296370 |
  472. | CHINA     | INDONESIA | 1995 | 10611767914 |
  473. | VIETNAM   | JAPAN     | 1995 | 10493043807 |
  474. | INDONESIA | INDONESIA | 1995 | 10350165199 |
  475. | VIETNAM   | INDIA     | 1995 | 10147175135 |
  476. | CHINA     | JAPAN     | 1995 |  9967113498 |
  477. | JAPAN     | VIETNAM   | 1995 |  9871240910 |
  478. | INDONESIA | JAPAN     | 1995 |  9554798320 |
  479. | JAPAN     | INDIA     | 1995 |  9224478715 |
  480. | INDIA     | INDIA     | 1995 |  8880501531 |
  481. | VIETNAM   | VIETNAM   | 1995 |  8530802028 |
  482. | INDIA     | VIETNAM   | 1995 |  8470249830 |
  483. | CHINA     | INDIA     | 1995 |  8460557790 |
  484. | INDONESIA | VIETNAM   | 1995 |  8393411088 |
  485. | CHINA     | VIETNAM   | 1995 |  7838238263 |
  486. | INDONESIA | INDIA     | 1995 |  7001659338 |
  487. | JAPAN     | CHINA     | 1996 | 14974943391 |
  488. | INDIA     | CHINA     | 1996 | 14236197987 |
  489. | VIETNAM   | CHINA     | 1996 | 13723231674 |
  490. | JAPAN     | INDONESIA | 1996 | 13304501801 |
  491. | INDONESIA | CHINA     | 1996 | 12444022202 |
  492. | CHINA     | CHINA     | 1996 | 12120893189 |
  493. | INDIA     | JAPAN     | 1996 | 11649117519 |
  494. | INDONESIA | JAPAN     | 1996 | 11345350775 |
  495. | VIETNAM   | JAPAN     | 1996 | 11294284203 |
  496. | INDONESIA | INDONESIA | 1996 | 11111201530 |
  497. | JAPAN     | INDIA     | 1996 | 10871364136 |
  498. | JAPAN     | JAPAN     | 1996 | 10836947449 |
  499. | INDIA     | INDONESIA | 1996 | 10568008435 |
  500. | JAPAN     | VIETNAM   | 1996 | 10503890555 |
  501. | VIETNAM   | INDONESIA | 1996 | 10494783196 |
  502. | INDONESIA | VIETNAM   | 1996 |  9940440124 |
  503. | INDONESIA | INDIA     | 1996 |  9864980677 |
  504. | VIETNAM   | VIETNAM   | 1996 |  9560258720 |
  505. | INDIA     | VIETNAM   | 1996 |  9324764214 |
  506. | INDIA     | INDIA     | 1996 |  9023346020 |
  507. | VIETNAM   | INDIA     | 1996 |  8968179949 |
  508. | CHINA     | INDONESIA | 1996 |  8877441837 |
  509. | CHINA     | JAPAN     | 1996 |  8749420872 |
  510. | CHINA     | VIETNAM   | 1996 |  6973983457 |
  511. | CHINA     | INDIA     | 1996 |  6515658476 |
  512. | JAPAN     | CHINA     | 1997 | 15365039212 |
  513. | INDONESIA | CHINA     | 1997 | 14159930904 |
  514. | VIETNAM   | CHINA     | 1997 | 13678288757 |
  515. | INDIA     | CHINA     | 1997 | 13599028484 |
  516. | JAPAN     | JAPAN     | 1997 | 12921870544 |
  517. | CHINA     | CHINA     | 1997 | 12720975220 |
  518. | VIETNAM   | JAPAN     | 1997 | 11929000810 |
  519. | VIETNAM   | INDONESIA | 1997 | 11325447090 |
  520. | JAPAN     | INDONESIA | 1997 | 10764312416 |
  521. | INDONESIA | JAPAN     | 1997 | 10555558162 |
  522. | INDONESIA | INDONESIA | 1997 | 10416928126 |
  523. | CHINA     | INDONESIA | 1997 | 10317902565 |
  524. | INDIA     | JAPAN     | 1997 | 10272590051 |
  525. | JAPAN     | VIETNAM   | 1997 |  9940032294 |
  526. | CHINA     | JAPAN     | 1997 |  9519485461 |
  527. | JAPAN     | INDIA     | 1997 |  9465935835 |
  528. | INDIA     | INDONESIA | 1997 |  9405085270 |
  529. | INDONESIA | INDIA     | 1997 |  8930955270 |
  530. | INDIA     | INDIA     | 1997 |  8295504178 |
  531. | VIETNAM   | VIETNAM   | 1997 |  8293412532 |
  532. | INDONESIA | VIETNAM   | 1997 |  8116443059 |
  533. | INDIA     | VIETNAM   | 1997 |  7960292262 |
  534. | VIETNAM   | INDIA     | 1997 |  7529455873 |
  535. | CHINA     | VIETNAM   | 1997 |  7038413355 |
  536. | CHINA     | INDIA     | 1997 |  6530770558 |
  537. +-----------+-----------+------+-------------+
  539. -- Q3.2
  541. +------------+------------+------+-----------+
  542. | c_city     | s_city     | year | revenue   |
  543. +------------+------------+------+-----------+
  544. | CHINA    3 | CHINA    0 | 1992 | 539864249 |
  545. | CHINA    0 | CHINA    6 | 1992 | 471363128 |
  546. | CHINA    8 | CHINA    1 | 1992 | 421384110 |
  547. | CHINA    6 | CHINA    1 | 1992 | 382204882 |
  548. | CHINA    6 | CHINA    7 | 1992 | 355755835 |
  549. | CHINA    8 | CHINA    9 | 1992 | 349006417 |
  550. | CHINA    7 | CHINA    7 | 1992 | 320232842 |
  551. | CHINA    8 | CHINA    3 | 1992 | 296105733 |
  552. | CHINA    5 | CHINA    3 | 1992 | 277283951 |
  553. | CHINA    6 | CHINA    6 | 1992 | 265527771 |
  554. | CHINA    4 | CHINA    1 | 1992 | 237402078 |
  555. | CHINA    8 | CHINA    6 | 1992 | 234720401 |
  556. | CHINA    4 | CHINA    6 | 1992 | 230169075 |
  557. | CHINA    9 | CHINA    1 | 1992 | 223815249 |
  558. | CHINA    1 | CHINA    1 | 1992 | 223467947 |
  559. | CHINA    2 | CHINA    1 | 1992 | 219559691 |
  560. | CHINA    9 | CHINA    6 | 1992 | 205915890 |
  561. | CHINA    7 | CHINA    9 | 1992 | 201288909 |
  562. | CHINA    1 | CHINA    6 | 1992 | 195622902 |
  563. | CHINA    9 | CHINA    7 | 1992 | 190345063 |
  564. | CHINA    8 | CHINA    4 | 1992 | 174478626 |
  565. | CHINA    1 | CHINA    7 | 1992 | 173803257 |
  566. | CHINA    9 | CHINA    9 | 1992 | 162458028 |
  567. | CHINA    6 | CHINA    0 | 1992 | 154260702 |
  568. | CHINA    8 | CHINA    0 | 1992 | 149794069 |
  569. | CHINA    5 | CHINA    9 | 1992 | 149369922 |
  570. | CHINA    8 | CHINA    8 | 1992 | 147607252 |
  571. | CHINA    6 | CHINA    4 | 1992 | 147137516 |
  572. | CHINA    7 | CHINA    8 | 1992 | 139974858 |
  573. | CHINA    5 | CHINA    6 | 1992 | 138467127 |
  574. | CHINA    3 | CHINA    6 | 1992 | 119521008 |
  575. | CHINA    8 | CHINA    7 | 1992 | 109887269 |
  576. | CHINA    6 | CHINA    3 | 1992 | 107201214 |
  577. | CHINA    9 | CHINA    4 | 1992 | 101504450 |
  578. | CHINA    1 | CHINA    3 | 1992 | 101388208 |
  579. | CHINA    7 | CHINA    0 | 1992 |  98475237 |
  580. | CHINA    5 | CHINA    8 | 1992 |  98370738 |
  581. | CHINA    2 | CHINA    6 | 1992 |  93254616 |
  582. | CHINA    2 | CHINA    4 | 1992 |  86394644 |
  583. | CHINA    3 | CHINA    7 | 1992 |  81027008 |
  584. | CHINA    5 | CHINA    4 | 1992 |  78587418 |
  585. | CHINA    3 | CHINA    9 | 1992 |  78114762 |
  586. | CHINA    2 | CHINA    0 | 1992 |  77786892 |
  587. | CHINA    2 | CHINA    8 | 1992 |  75605732 |
  588. | CHINA    4 | CHINA    3 | 1992 |  75101512 |
  589. | CHINA    7 | CHINA    4 | 1992 |  74119240 |
  590. | CHINA    2 | CHINA    9 | 1992 |  73413108 |
  591. | CHINA    5 | CHINA    7 | 1992 |  73199718 |
  592. | CHINA    4 | CHINA    4 | 1992 |  72839118 |
  593. | CHINA    1 | CHINA    9 | 1992 |  68538220 |
  594. | CHINA    0 | CHINA    8 | 1992 |  65856888 |
  595. | CHINA    0 | CHINA    9 | 1992 |  65590624 |
  596. | CHINA    3 | CHINA    8 | 1992 |  64556586 |
  597. | CHINA    2 | CHINA    7 | 1992 |  63336330 |
  598. | CHINA    4 | CHINA    9 | 1992 |  57645963 |
  599. | CHINA    0 | CHINA    7 | 1992 |  55251918 |
  600. | CHINA    0 | CHINA    1 | 1992 |  51774462 |
  601. | CHINA    6 | CHINA    8 | 1992 |  45676858 |
  602. | CHINA    3 | CHINA    3 | 1992 |  41147560 |
  603. | CHINA    3 | CHINA    4 | 1992 |  36838082 |
  604. | CHINA    5 | CHINA    0 | 1992 |  36554488 |
  605. | CHINA    3 | CHINA    1 | 1992 |  32036313 |
  606. | CHINA    4 | CHINA    8 | 1992 |  31517575 |
  607. | CHINA    0 | CHINA    3 | 1992 |  25524054 |
  608. | CHINA    1 | CHINA    4 | 1992 |  12681846 |
  609. | CHINA    7 | CHINA    3 | 1992 |  11395152 |
  610. | CHINA    6 | CHINA    9 | 1992 |   8642375 |
  611. | CHINA    8 | CHINA    6 | 1993 | 638396852 |
  612. | CHINA    7 | CHINA    6 | 1993 | 576731239 |
  613. | CHINA    2 | CHINA    6 | 1993 | 528008729 |
  614. | CHINA    8 | CHINA    9 | 1993 | 522412584 |
  615. | CHINA    8 | CHINA    7 | 1993 | 475478848 |
  616. | CHINA    8 | CHINA    1 | 1993 | 452064153 |
  617. | CHINA    0 | CHINA    1 | 1993 | 425902649 |
  618. | CHINA    9 | CHINA    1 | 1993 | 405252987 |
  619. | CHINA    6 | CHINA    9 | 1993 | 385005953 |
  620. | CHINA    8 | CHINA    8 | 1993 | 382884778 |
  621. | CHINA    0 | CHINA    6 | 1993 | 344911487 |
  622. | CHINA    6 | CHINA    7 | 1993 | 341436211 |
  623. | CHINA    3 | CHINA    6 | 1993 | 291652051 |
  624. | CHINA    7 | CHINA    1 | 1993 | 257769861 |
  625. | CHINA    8 | CHINA    0 | 1993 | 231981252 |
  626. | CHINA    4 | CHINA    6 | 1993 | 215180968 |
  627. | CHINA    3 | CHINA    0 | 1993 | 213320777 |
  628. | CHINA    9 | CHINA    6 | 1993 | 207281000 |
  629. | CHINA    5 | CHINA    9 | 1993 | 206555882 |
  630. | CHINA    6 | CHINA    1 | 1993 | 205665388 |
  631. | CHINA    5 | CHINA    1 | 1993 | 193491875 |
  632. | CHINA    2 | CHINA    9 | 1993 | 193324425 |
  633. | CHINA    5 | CHINA    8 | 1993 | 190521023 |
  634. | CHINA    7 | CHINA    0 | 1993 | 183487919 |
  635. | CHINA    0 | CHINA    9 | 1993 | 170223958 |
  636. | CHINA    6 | CHINA    8 | 1993 | 166821272 |
  637. | CHINA    3 | CHINA    8 | 1993 | 163053528 |
  638. | CHINA    2 | CHINA    0 | 1993 | 158276154 |
  639. | CHINA    3 | CHINA    1 | 1993 | 153652018 |
  640. | CHINA    5 | CHINA    6 | 1993 | 151359347 |
  641. | CHINA    6 | CHINA    0 | 1993 | 140494698 |
  642. | CHINA    8 | CHINA    4 | 1993 | 139857147 |
  643. | CHINA    2 | CHINA    7 | 1993 | 136009418 |
  644. | CHINA    5 | CHINA    7 | 1993 | 133892119 |
  645. | CHINA    9 | CHINA    9 | 1993 | 118965507 |
  646. | CHINA    1 | CHINA    1 | 1993 | 108898379 |
  647. | CHINA    6 | CHINA    6 | 1993 | 100311475 |
  648. | CHINA    0 | CHINA    4 | 1993 |  93483068 |
  649. | CHINA    1 | CHINA    4 | 1993 |  87714152 |
  650. | CHINA    4 | CHINA    1 | 1993 |  87690658 |
  651. | CHINA    4 | CHINA    7 | 1993 |  83701574 |
  652. | CHINA    1 | CHINA    0 | 1993 |  82670983 |
  653. | CHINA    7 | CHINA    4 | 1993 |  77396461 |
  654. | CHINA    5 | CHINA    4 | 1993 |  73556161 |
  655. | CHINA    4 | CHINA    8 | 1993 |  72203335 |
  656. | CHINA    0 | CHINA    7 | 1993 |  70395334 |
  657. | CHINA    3 | CHINA    4 | 1993 |  64771003 |
  658. | CHINA    7 | CHINA    8 | 1993 |  64514099 |
  659. | CHINA    3 | CHINA    7 | 1993 |  62868516 |
  660. | CHINA    8 | CHINA    3 | 1993 |  56504804 |
  661. | CHINA    2 | CHINA    4 | 1993 |  56031779 |
  662. | CHINA    1 | CHINA    7 | 1993 |  48951262 |
  663. | CHINA    7 | CHINA    3 | 1993 |  45962220 |
  664. | CHINA    4 | CHINA    9 | 1993 |  43158138 |
  665. | CHINA    7 | CHINA    9 | 1993 |  42611979 |
  666. | CHINA    2 | CHINA    8 | 1993 |  38092546 |
  667. | CHINA    1 | CHINA    9 | 1993 |  29665374 |
  668. | CHINA    1 | CHINA    3 | 1993 |  23991216 |
  669. | CHINA    6 | CHINA    6 | 1994 | 596294890 |
  670. | CHINA    8 | CHINA    6 | 1994 | 542104721 |
  671. | CHINA    6 | CHINA    1 | 1994 | 504359553 |
  672. | CHINA    3 | CHINA    7 | 1994 | 476727294 |
  673. | CHINA    3 | CHINA    6 | 1994 | 476349724 |
  674. | CHINA    8 | CHINA    9 | 1994 | 427241348 |
  675. | CHINA    6 | CHINA    9 | 1994 | 358191581 |
  676. | CHINA    9 | CHINA    6 | 1994 | 352344057 |
  677. | CHINA    3 | CHINA    0 | 1994 | 351708546 |
  678. | CHINA    8 | CHINA    0 | 1994 | 351131413 |
  679. | CHINA    3 | CHINA    3 | 1994 | 339279574 |
  680. | CHINA    0 | CHINA    1 | 1994 | 298307857 |
  681. | CHINA    0 | CHINA    7 | 1994 | 289536010 |
  682. | CHINA    0 | CHINA    6 | 1994 | 285639032 |
  683. | CHINA    7 | CHINA    6 | 1994 | 263170455 |
  684. | CHINA    2 | CHINA    8 | 1994 | 250332990 |
  685. | CHINA    6 | CHINA    4 | 1994 | 235897763 |
  686. | CHINA    5 | CHINA    1 | 1994 | 234681515 |
  687. | CHINA    8 | CHINA    7 | 1994 | 234390101 |
  688. | CHINA    1 | CHINA    6 | 1994 | 232792764 |
  689. | CHINA    8 | CHINA    1 | 1994 | 223808842 |
  690. | CHINA    4 | CHINA    6 | 1994 | 209522926 |
  691. | CHINA    8 | CHINA    4 | 1994 | 208632636 |
  692. | CHINA    7 | CHINA    3 | 1994 | 202424117 |
  693. | CHINA    4 | CHINA    7 | 1994 | 185487544 |
  694. | CHINA    2 | CHINA    7 | 1994 | 183551771 |
  695. | CHINA    7 | CHINA    1 | 1994 | 178421732 |
  696. | CHINA    4 | CHINA    1 | 1994 | 176262868 |
  697. | CHINA    5 | CHINA    6 | 1994 | 173651872 |
  698. | CHINA    0 | CHINA    4 | 1994 | 173584501 |
  699. | CHINA    8 | CHINA    8 | 1994 | 172179808 |
  700. | CHINA    9 | CHINA    1 | 1994 | 169617585 |
  701. | CHINA    0 | CHINA    9 | 1994 | 167569085 |
  702. | CHINA    5 | CHINA    8 | 1994 | 162066559 |
  703. | CHINA    7 | CHINA    9 | 1994 | 161041255 |
  704. | CHINA    5 | CHINA    4 | 1994 | 154820955 |
  705. | CHINA    7 | CHINA    0 | 1994 | 152844960 |
  706. | CHINA    2 | CHINA    6 | 1994 | 149839190 |
  707. | CHINA    7 | CHINA    8 | 1994 | 149536114 |
  708. | CHINA    1 | CHINA    4 | 1994 | 142403628 |
  709. | CHINA    9 | CHINA    9 | 1994 | 131064832 |
  710. | CHINA    2 | CHINA    1 | 1994 | 124489283 |
  711. | CHINA    2 | CHINA    0 | 1994 | 114263273 |
  712. | CHINA    5 | CHINA    7 | 1994 | 113311766 |
  713. | CHINA    8 | CHINA    3 | 1994 | 112573609 |
  714. | CHINA    3 | CHINA    4 | 1994 | 104903651 |
  715. | CHINA    4 | CHINA    0 | 1994 | 101914439 |
  716. | CHINA    3 | CHINA    1 | 1994 |  98253251 |
  717. | CHINA    1 | CHINA    7 | 1994 |  94582288 |
  718. | CHINA    4 | CHINA    4 | 1994 |  92818317 |
  719. | CHINA    1 | CHINA    9 | 1994 |  85220541 |
  720. | CHINA    6 | CHINA    3 | 1994 |  84604801 |
  721. | CHINA    0 | CHINA    3 | 1994 |  77574978 |
  722. | CHINA    1 | CHINA    3 | 1994 |  74435316 |
  723. | CHINA    4 | CHINA    9 | 1994 |  72622300 |
  724. | CHINA    3 | CHINA    8 | 1994 |  72559366 |
  725. | CHINA    9 | CHINA    0 | 1994 |  69298222 |
  726. | CHINA    3 | CHINA    9 | 1994 |  67472592 |
  727. | CHINA    6 | CHINA    8 | 1994 |  66271372 |
  728. | CHINA    7 | CHINA    4 | 1994 |  59634606 |
  729. | CHINA    2 | CHINA    9 | 1994 |  56882136 |
  730. | CHINA    1 | CHINA    1 | 1994 |  56592337 |
  731. | CHINA    5 | CHINA    9 | 1994 |  52879724 |
  732. | CHINA    9 | CHINA    4 | 1994 |  49324497 |
  733. | CHINA    2 | CHINA    3 | 1994 |  45042384 |
  734. | CHINA    7 | CHINA    7 | 1994 |  44458451 |
  735. | CHINA    5 | CHINA    0 | 1994 |  39091925 |
  736. | CHINA    9 | CHINA    3 | 1994 |  39082405 |
  737. | CHINA    0 | CHINA    8 | 1994 |  28203459 |
  738. | CHINA    6 | CHINA    7 | 1994 |  27243775 |
  739. | CHINA    0 | CHINA    0 | 1994 |  15591040 |
  740. | CHINA    2 | CHINA    6 | 1995 | 832176707 |
  741. | CHINA    8 | CHINA    6 | 1995 | 793322102 |
  742. | CHINA    3 | CHINA    7 | 1995 | 505446788 |
  743. | CHINA    7 | CHINA    9 | 1995 | 483519933 |
  744. | CHINA    4 | CHINA    6 | 1995 | 440320366 |
  745. | CHINA    8 | CHINA    1 | 1995 | 394522570 |
  746. | CHINA    7 | CHINA    1 | 1995 | 393861389 |
  747. | CHINA    5 | CHINA    1 | 1995 | 343166828 |
  748. | CHINA    1 | CHINA    7 | 1995 | 341736584 |
  749. | CHINA    8 | CHINA    7 | 1995 | 323623203 |
  750. | CHINA    6 | CHINA    6 | 1995 | 312876143 |
  751. | CHINA    3 | CHINA    6 | 1995 | 306516324 |
  752. | CHINA    7 | CHINA    6 | 1995 | 294840537 |
  753. | CHINA    3 | CHINA    3 | 1995 | 290066240 |
  754. | CHINA    8 | CHINA    3 | 1995 | 289182495 |
  755. | CHINA    3 | CHINA    1 | 1995 | 288853766 |
  756. | CHINA    0 | CHINA    1 | 1995 | 279082523 |
  757. | CHINA    0 | CHINA    8 | 1995 | 265291443 |
  758. | CHINA    1 | CHINA    6 | 1995 | 262283412 |
  759. | CHINA    4 | CHINA    1 | 1995 | 246559891 |
  760. | CHINA    2 | CHINA    8 | 1995 | 246465167 |
  761. | CHINA    6 | CHINA    7 | 1995 | 246385862 |
  762. | CHINA    9 | CHINA    6 | 1995 | 231314393 |
  763. | CHINA    2 | CHINA    7 | 1995 | 224354491 |
  764. | CHINA    4 | CHINA    7 | 1995 | 222368398 |
  765. | CHINA    0 | CHINA    7 | 1995 | 221334917 |
  766. | CHINA    6 | CHINA    3 | 1995 | 217756587 |
  767. | CHINA    6 | CHINA    9 | 1995 | 215736018 |
  768. | CHINA    4 | CHINA    9 | 1995 | 210496516 |
  769. | CHINA    0 | CHINA    6 | 1995 | 197891458 |
  770. | CHINA    8 | CHINA    9 | 1995 | 192018213 |
  771. | CHINA    7 | CHINA    0 | 1995 | 188804482 |
  772. | CHINA    5 | CHINA    6 | 1995 | 186378531 |
  773. | CHINA    6 | CHINA    1 | 1995 | 165831073 |
  774. | CHINA    1 | CHINA    3 | 1995 | 165118263 |
  775. | CHINA    6 | CHINA    8 | 1995 | 157640218 |
  776. | CHINA    1 | CHINA    1 | 1995 | 150838433 |
  777. | CHINA    1 | CHINA    4 | 1995 | 147632879 |
  778. | CHINA    6 | CHINA    0 | 1995 | 147314401 |
  779. | CHINA    5 | CHINA    4 | 1995 | 142820978 |
  780. | CHINA    5 | CHINA    9 | 1995 | 141416829 |
  781. | CHINA    2 | CHINA    0 | 1995 | 135608473 |
  782. | CHINA    5 | CHINA    7 | 1995 | 131596218 |
  783. | CHINA    0 | CHINA    4 | 1995 | 129159370 |
  784. | CHINA    3 | CHINA    9 | 1995 | 126837748 |
  785. | CHINA    8 | CHINA    0 | 1995 | 126564932 |
  786. | CHINA    0 | CHINA    3 | 1995 | 121337041 |
  787. | CHINA    7 | CHINA    7 | 1995 | 118697587 |
  788. | CHINA    5 | CHINA    8 | 1995 | 116538842 |
  789. | CHINA    8 | CHINA    8 | 1995 | 110161904 |
  790. | CHINA    9 | CHINA    0 | 1995 | 109582187 |
  791. | CHINA    9 | CHINA    1 | 1995 | 103455098 |
  792. | CHINA    2 | CHINA    1 | 1995 | 100264691 |
  793. | CHINA    7 | CHINA    3 | 1995 |  99011859 |
  794. | CHINA    3 | CHINA    0 | 1995 |  90383390 |
  795. | CHINA    4 | CHINA    3 | 1995 |  89908903 |
  796. | CHINA    7 | CHINA    8 | 1995 |  81425699 |
  797. | CHINA    3 | CHINA    4 | 1995 |  77577579 |
  798. | CHINA    4 | CHINA    8 | 1995 |  74805746 |
  799. | CHINA    9 | CHINA    7 | 1995 |  74597020 |
  800. | CHINA    9 | CHINA    9 | 1995 |  73514511 |
  801. | CHINA    5 | CHINA    0 | 1995 |  73274726 |
  802. | CHINA    8 | CHINA    4 | 1995 |  61708487 |
  803. | CHINA    1 | CHINA    0 | 1995 |  58753734 |
  804. | CHINA    3 | CHINA    8 | 1995 |  57133566 |
  805. | CHINA    9 | CHINA    4 | 1995 |  53259334 |
  806. | CHINA    1 | CHINA    9 | 1995 |  46177797 |
  807. | CHINA    2 | CHINA    4 | 1995 |  45147325 |
  808. | CHINA    0 | CHINA    0 | 1995 |  43963173 |
  809. | CHINA    0 | CHINA    9 | 1995 |  40184107 |
  810. | CHINA    1 | CHINA    8 | 1995 |  18859188 |
  811. | CHINA    8 | CHINA    7 | 1996 | 621957444 |
  812. | CHINA    3 | CHINA    9 | 1996 | 530082848 |
  813. | CHINA    8 | CHINA    6 | 1996 | 525755549 |
  814. | CHINA    8 | CHINA    1 | 1996 | 399229343 |
  815. | CHINA    6 | CHINA    7 | 1996 | 365540749 |
  816. | CHINA    8 | CHINA    8 | 1996 | 351864283 |
  817. | CHINA    1 | CHINA    6 | 1996 | 329186504 |
  818. | CHINA    9 | CHINA    6 | 1996 | 321113085 |
  819. | CHINA    3 | CHINA    6 | 1996 | 318264871 |
  820. | CHINA    2 | CHINA    6 | 1996 | 315233397 |
  821. | CHINA    2 | CHINA    9 | 1996 | 285852841 |
  822. | CHINA    9 | CHINA    9 | 1996 | 264510548 |
  823. | CHINA    5 | CHINA    6 | 1996 | 261385523 |
  824. | CHINA    8 | CHINA    9 | 1996 | 259497265 |
  825. | CHINA    6 | CHINA    6 | 1996 | 258200131 |
  826. | CHINA    4 | CHINA    9 | 1996 | 257345949 |
  827. | CHINA    6 | CHINA    9 | 1996 | 247667288 |
  828. | CHINA    2 | CHINA    7 | 1996 | 234569026 |
  829. | CHINA    2 | CHINA    1 | 1996 | 218568966 |
  830. | CHINA    4 | CHINA    1 | 1996 | 207383476 |
  831. | CHINA    0 | CHINA    1 | 1996 | 204596428 |
  832. | CHINA    3 | CHINA    0 | 1996 | 204375870 |
  833. | CHINA    4 | CHINA    0 | 1996 | 202299286 |
  834. | CHINA    4 | CHINA    4 | 1996 | 191983261 |
  835. | CHINA    4 | CHINA    8 | 1996 | 183961012 |
  836. | CHINA    4 | CHINA    6 | 1996 | 183872085 |
  837. | CHINA    6 | CHINA    8 | 1996 | 182132356 |
  838. | CHINA    7 | CHINA    9 | 1996 | 170941341 |
  839. | CHINA    0 | CHINA    6 | 1996 | 168082672 |
  840. | CHINA    1 | CHINA    7 | 1996 | 165942066 |
  841. | CHINA    1 | CHINA    9 | 1996 | 165878775 |
  842. | CHINA    9 | CHINA    8 | 1996 | 156009357 |
  843. | CHINA    7 | CHINA    7 | 1996 | 155842944 |
  844. | CHINA    2 | CHINA    0 | 1996 | 147709906 |
  845. | CHINA    5 | CHINA    7 | 1996 | 147257366 |
  846. | CHINA    1 | CHINA    8 | 1996 | 141840928 |
  847. | CHINA    2 | CHINA    4 | 1996 | 136244052 |
  848. | CHINA    9 | CHINA    0 | 1996 | 130997019 |
  849. | CHINA    1 | CHINA    0 | 1996 | 124362038 |
  850. | CHINA    0 | CHINA    9 | 1996 | 114011231 |
  851. | CHINA    7 | CHINA    3 | 1996 | 112398764 |
  852. | CHINA    4 | CHINA    7 | 1996 | 110567337 |
  853. | CHINA    3 | CHINA    4 | 1996 | 109269982 |
  854. | CHINA    5 | CHINA    1 | 1996 | 107482704 |
  855. | CHINA    6 | CHINA    4 | 1996 | 105485170 |
  856. | CHINA    1 | CHINA    4 | 1996 | 105320270 |
  857. | CHINA    0 | CHINA    7 | 1996 | 102545071 |
  858. | CHINA    2 | CHINA    3 | 1996 | 100407151 |
  859. | CHINA    0 | CHINA    4 | 1996 |  95913303 |
  860. | CHINA    7 | CHINA    0 | 1996 |  94706269 |
  861. | CHINA    6 | CHINA    1 | 1996 |  86949951 |
  862. | CHINA    8 | CHINA    3 | 1996 |  84157344 |
  863. | CHINA    2 | CHINA    8 | 1996 |  83176903 |
  864. | CHINA    5 | CHINA    9 | 1996 |  83104330 |
  865. | CHINA    7 | CHINA    8 | 1996 |  81490639 |
  866. | CHINA    9 | CHINA    3 | 1996 |  79655829 |
  867. | CHINA    5 | CHINA    0 | 1996 |  77489995 |
  868. | CHINA    8 | CHINA    0 | 1996 |  76989056 |
  869. | CHINA    9 | CHINA    1 | 1996 |  72011031 |
  870. | CHINA    7 | CHINA    4 | 1996 |  64764322 |
  871. | CHINA    5 | CHINA    4 | 1996 |  62827767 |
  872. | CHINA    5 | CHINA    8 | 1996 |  62673237 |
  873. | CHINA    7 | CHINA    6 | 1996 |  61880459 |
  874. | CHINA    3 | CHINA    7 | 1996 |  56642844 |
  875. | CHINA    3 | CHINA    1 | 1996 |  50799366 |
  876. | CHINA    3 | CHINA    3 | 1996 |  42601269 |
  877. | CHINA    4 | CHINA    3 | 1996 |  38290290 |
  878. | CHINA    3 | CHINA    8 | 1996 |  21263056 |
  879. | CHINA    7 | CHINA    1 | 1996 |  14836937 |
  880. | CHINA    5 | CHINA    3 | 1996 |  13611339 |
  881. | CHINA    1 | CHINA    3 | 1996 |   8430793 |
  882. | CHINA    1 | CHINA    1 | 1996 |   1601332 |
  883. | CHINA    1 | CHINA    7 | 1997 | 664436721 |
  884. | CHINA    8 | CHINA    9 | 1997 | 585552148 |
  885. | CHINA    8 | CHINA    6 | 1997 | 543571889 |
  886. | CHINA    8 | CHINA    7 | 1997 | 516131917 |
  887. | CHINA    6 | CHINA    7 | 1997 | 467477883 |
  888. | CHINA    3 | CHINA    9 | 1997 | 444914344 |
  889. | CHINA    5 | CHINA    6 | 1997 | 353316321 |
  890. | CHINA    6 | CHINA    4 | 1997 | 338136205 |
  891. | CHINA    0 | CHINA    7 | 1997 | 329137493 |
  892. | CHINA    5 | CHINA    1 | 1997 | 328142466 |
  893. | CHINA    8 | CHINA    4 | 1997 | 308276385 |
  894. | CHINA    6 | CHINA    9 | 1997 | 306814317 |
  895. | CHINA    5 | CHINA    9 | 1997 | 301145803 |
  896. | CHINA    7 | CHINA    1 | 1997 | 299575802 |
  897. | CHINA    8 | CHINA    8 | 1997 | 282083295 |
  898. | CHINA    4 | CHINA    9 | 1997 | 280242025 |
  899. | CHINA    9 | CHINA    1 | 1997 | 253155313 |
  900. | CHINA    4 | CHINA    6 | 1997 | 234247182 |
  901. | CHINA    5 | CHINA    0 | 1997 | 217246162 |
  902. | CHINA    9 | CHINA    4 | 1997 | 215424663 |
  903. | CHINA    0 | CHINA    6 | 1997 | 211152240 |
  904. | CHINA    3 | CHINA    6 | 1997 | 205982217 |
  905. | CHINA    7 | CHINA    6 | 1997 | 196440117 |
  906. | CHINA    1 | CHINA    6 | 1997 | 195757737 |
  907. | CHINA    2 | CHINA    3 | 1997 | 189836909 |
  908. | CHINA    7 | CHINA    8 | 1997 | 189291379 |
  909. | CHINA    9 | CHINA    6 | 1997 | 189236146 |
  910. | CHINA    3 | CHINA    1 | 1997 | 188537684 |
  911. | CHINA    9 | CHINA    7 | 1997 | 182516267 |
  912. | CHINA    0 | CHINA    0 | 1997 | 182459980 |
  913. | CHINA    5 | CHINA    8 | 1997 | 177077882 |
  914. | CHINA    2 | CHINA    6 | 1997 | 176030529 |
  915. | CHINA    2 | CHINA    1 | 1997 | 168770050 |
  916. | CHINA    8 | CHINA    0 | 1997 | 167294093 |
  917. | CHINA    4 | CHINA    3 | 1997 | 161980658 |
  918. | CHINA    3 | CHINA    4 | 1997 | 154433882 |
  919. | CHINA    6 | CHINA    6 | 1997 | 153336736 |
  920. | CHINA    6 | CHINA    3 | 1997 | 151596497 |
  921. | CHINA    8 | CHINA    1 | 1997 | 145432603 |
  922. | CHINA    1 | CHINA    4 | 1997 | 126773981 |
  923. | CHINA    1 | CHINA    0 | 1997 | 120594770 |
  924. | CHINA    7 | CHINA    3 | 1997 | 119618460 |
  925. | CHINA    6 | CHINA    1 | 1997 | 119529805 |
  926. | CHINA    2 | CHINA    9 | 1997 | 114591288 |
  927. | CHINA    7 | CHINA    7 | 1997 | 111335941 |
  928. | CHINA    5 | CHINA    3 | 1997 | 111044153 |
  929. | CHINA    6 | CHINA    0 | 1997 | 104404276 |
  930. | CHINA    1 | CHINA    1 | 1997 |  98869501 |
  931. | CHINA    7 | CHINA    0 | 1997 |  97198605 |
  932. | CHINA    7 | CHINA    9 | 1997 |  92872632 |
  933. | CHINA    0 | CHINA    9 | 1997 |  91097832 |
  934. | CHINA    9 | CHINA    9 | 1997 |  86479272 |
  935. | CHINA    2 | CHINA    7 | 1997 |  79380820 |
  936. | CHINA    9 | CHINA    0 | 1997 |  78499693 |
  937. | CHINA    1 | CHINA    9 | 1997 |  73589328 |
  938. | CHINA    2 | CHINA    8 | 1997 |  71633835 |
  939. | CHINA    8 | CHINA    3 | 1997 |  70505885 |
  940. | CHINA    3 | CHINA    0 | 1997 |  61039282 |
  941. | CHINA    0 | CHINA    3 | 1997 |  58325113 |
  942. | CHINA    5 | CHINA    7 | 1997 |  55476389 |
  943. | CHINA    4 | CHINA    7 | 1997 |  46480159 |
  944. | CHINA    0 | CHINA    1 | 1997 |  38223038 |
  945. | CHINA    4 | CHINA    1 | 1997 |  21636342 |
  946. | CHINA    9 | CHINA    3 | 1997 |  13092788 |
  947. | CHINA    6 | CHINA    8 | 1997 |   2490092 |
  948. +------------+------------+------+-----------+
  950. -- Q3.3
  951. +------------+------------+------+-----------+
  952. | c_city     | s_city     | year | revenue   |
  953. +------------+------------+------+-----------+
  954. | UNITED KI0 | UNITED KI7 | 1992 | 251282102 |
  955. | UNITED KI0 | UNITED KI0 | 1992 | 170005406 |
  956. | UNITED KI7 | UNITED KI7 | 1992 |  36835396 |
  957. | UNITED KI0 | UNITED KI7 | 1993 | 560335810 |
  958. | UNITED KI0 | UNITED KI0 | 1993 | 294257692 |
  959. | UNITED KI7 | UNITED KI0 | 1993 | 159005896 |
  960. | UNITED KI7 | UNITED KI7 | 1993 | 139029264 |
  961. | UNITED KI0 | UNITED KI7 | 1994 | 739847089 |
  962. | UNITED KI0 | UNITED KI0 | 1994 | 302339390 |
  963. | UNITED KI7 | UNITED KI7 | 1994 | 275609814 |
  964. | UNITED KI7 | UNITED KI0 | 1994 | 117654093 |
  965. | UNITED KI0 | UNITED KI7 | 1995 | 540994655 |
  966. | UNITED KI0 | UNITED KI0 | 1995 | 230825439 |
  967. | UNITED KI7 | UNITED KI0 | 1995 | 197347696 |
  968. | UNITED KI7 | UNITED KI7 | 1995 | 136620517 |
  969. | UNITED KI0 | UNITED KI7 | 1996 | 448412094 |
  970. | UNITED KI0 | UNITED KI0 | 1996 | 203511607 |
  971. | UNITED KI7 | UNITED KI7 | 1996 |  94528075 |
  972. | UNITED KI7 | UNITED KI0 | 1996 |  35448536 |
  973. | UNITED KI7 | UNITED KI0 | 1997 | 289323850 |
  974. | UNITED KI7 | UNITED KI7 | 1997 | 214791175 |
  975. | UNITED KI0 | UNITED KI7 | 1997 | 196510174 |
  976. | UNITED KI0 | UNITED KI0 | 1997 | 125066127 |
  977. +------------+------------+------+-----------+
  979. -- Q3.4
  980. +------------+------------+------+-----------+
  981. | c_city     | s_city     | year | revenue   |
  982. +------------+------------+------+-----------+
  983. | UNITED KI7 | KENYA    4 | 1997 | 170083300 |
  984. | UNITED KI0 | MOZAMBIQU1 | 1997 | 155234463 |
  985. | UNITED KI0 | KENYA    4 | 1997 |  87283610 |
  986. +------------+------------+------+-----------+
  988. -- Q4.1
  989. +------+---------------+-------------+
  990. | year | c_nation      | profit      |
  991. +------+---------------+-------------+
  992. | 1992 | ARGENTINA     | 13746243380 |
  993. | 1992 | BRAZIL        | 15762831144 |
  994. | 1992 | CANADA        | 17477043721 |
  995. | 1992 | PERU          | 14698567030 |
  996. | 1992 | UNITED STATES | 14043501956 |
  997. | 1993 | ARGENTINA     | 13992888207 |
  998. | 1993 | BRAZIL        | 15146262693 |
  999. | 1993 | CANADA        | 12463985574 |
  1000. | 1993 | PERU          | 11385007831 |
  1001. | 1993 | UNITED STATES | 10651361815 |
  1002. | 1994 | ARGENTINA     | 13128610315 |
  1003. | 1994 | BRAZIL        | 13764866493 |
  1004. | 1994 | CANADA        | 13723188154 |
  1005. | 1994 | PERU          | 12784683808 |
  1006. | 1994 | UNITED STATES | 12554422837 |
  1007. | 1995 | ARGENTINA     | 14337205612 |
  1008. | 1995 | BRAZIL        | 15068918320 |
  1009. | 1995 | CANADA        | 14529005783 |
  1010. | 1995 | PERU          | 13086675480 |
  1011. | 1995 | UNITED STATES | 11330297649 |
  1012. | 1996 | ARGENTINA     | 13659108915 |
  1013. | 1996 | BRAZIL        | 12660837584 |
  1014. | 1996 | CANADA        | 14558903190 |
  1015. | 1996 | PERU          | 14162285166 |
  1016. | 1996 | UNITED STATES | 11117076866 |
  1017. | 1997 | ARGENTINA     | 12556399750 |
  1018. | 1997 | BRAZIL        | 13961587144 |
  1019. | 1997 | CANADA        | 15567856947 |
  1020. | 1997 | PERU          | 13595325340 |
  1021. | 1997 | UNITED STATES | 10779073839 |
  1022. | 1998 | ARGENTINA     |  7843424759 |
  1023. | 1998 | BRAZIL        |  8853904827 |
  1024. | 1998 | CANADA        |  8286104334 |
  1025. | 1998 | PERU          |  5822590950 |
  1026. | 1998 | UNITED STATES |  8526236814 |
  1027. +------+---------------+-------------+
  1029. -- Q4.2
  1030. +------+---------------+------------+------------+
  1031. | year | s_nation      | p_category | profit     |
  1032. +------+---------------+------------+------------+
  1033. | 1997 | ARGENTINA     | MFGR#11    | 1636950553 |
  1034. | 1997 | ARGENTINA     | MFGR#12    | 1265547847 |
  1035. | 1997 | ARGENTINA     | MFGR#13    | 1505131346 |
  1036. | 1997 | ARGENTINA     | MFGR#14    | 1405447137 |
  1037. | 1997 | ARGENTINA     | MFGR#15    | 1564085340 |
  1038. | 1997 | ARGENTINA     | MFGR#21    | 1335009490 |
  1039. | 1997 | ARGENTINA     | MFGR#22    | 1309054179 |
  1040. | 1997 | ARGENTINA     | MFGR#23    | 1305213794 |
  1041. | 1997 | ARGENTINA     | MFGR#24    | 1089725126 |
  1042. | 1997 | ARGENTINA     | MFGR#25    | 1291995512 |
  1043. | 1997 | BRAZIL        | MFGR#11    |  721240147 |
  1044. | 1997 | BRAZIL        | MFGR#12    |  928318830 |
  1045. | 1997 | BRAZIL        | MFGR#13    | 1164674879 |
  1046. | 1997 | BRAZIL        | MFGR#14    | 1215622587 |
  1047. | 1997 | BRAZIL        | MFGR#15    |  940971658 |
  1048. | 1997 | BRAZIL        | MFGR#21    | 1158909618 |
  1049. | 1997 | BRAZIL        | MFGR#22    | 1251221641 |
  1050. | 1997 | BRAZIL        | MFGR#23    | 1552552455 |
  1051. | 1997 | BRAZIL        | MFGR#24    |  929057361 |
  1052. | 1997 | BRAZIL        | MFGR#25    |  574645288 |
  1053. | 1997 | CANADA        | MFGR#11    | 1170341370 |
  1054. | 1997 | CANADA        | MFGR#12    | 1220238121 |
  1055. | 1997 | CANADA        | MFGR#13    | 1245774025 |
  1056. | 1997 | CANADA        | MFGR#14    | 1032046642 |
  1057. | 1997 | CANADA        | MFGR#15    |  738650612 |
  1058. | 1997 | CANADA        | MFGR#21    | 1476055209 |
  1059. | 1997 | CANADA        | MFGR#22    | 1239005798 |
  1060. | 1997 | CANADA        | MFGR#23    |  869393804 |
  1061. | 1997 | CANADA        | MFGR#24    | 1466964051 |
  1062. | 1997 | CANADA        | MFGR#25    | 1358922727 |
  1063. | 1997 | PERU          | MFGR#11    | 1031023174 |
  1064. | 1997 | PERU          | MFGR#12    |  731821491 |
  1065. | 1997 | PERU          | MFGR#13    | 1044642877 |
  1066. | 1997 | PERU          | MFGR#14    |  654877417 |
  1067. | 1997 | PERU          | MFGR#15    | 1201769474 |
  1068. | 1997 | PERU          | MFGR#21    | 1275496672 |
  1069. | 1997 | PERU          | MFGR#22    |  599324545 |
  1070. | 1997 | PERU          | MFGR#23    | 1200754744 |
  1071. | 1997 | PERU          | MFGR#24    |  942152801 |
  1072. | 1997 | PERU          | MFGR#25    | 1064322995 |
  1073. | 1997 | UNITED STATES | MFGR#11    | 2365218925 |
  1074. | 1997 | UNITED STATES | MFGR#12    | 1132346574 |
  1075. | 1997 | UNITED STATES | MFGR#13    | 2460882362 |
  1076. | 1997 | UNITED STATES | MFGR#14    | 2190816877 |
  1077. | 1997 | UNITED STATES | MFGR#15    | 1687829921 |
  1078. | 1997 | UNITED STATES | MFGR#21    | 2125880770 |
  1079. | 1997 | UNITED STATES | MFGR#22    | 2013348097 |
  1080. | 1997 | UNITED STATES | MFGR#23    | 2570581084 |
  1081. | 1997 | UNITED STATES | MFGR#24    | 2724372315 |
  1082. | 1997 | UNITED STATES | MFGR#25    | 1480012758 |
  1083. | 1998 | ARGENTINA     | MFGR#11    |  783662770 |
  1084. | 1998 | ARGENTINA     | MFGR#12    |  472818450 |
  1085. | 1998 | ARGENTINA     | MFGR#13    |  585091533 |
  1086. | 1998 | ARGENTINA     | MFGR#14    |  507297527 |
  1087. | 1998 | ARGENTINA     | MFGR#15    |  549185408 |
  1088. | 1998 | ARGENTINA     | MFGR#21    |  972928972 |
  1089. | 1998 | ARGENTINA     | MFGR#22    | 1508294213 |
  1090. | 1998 | ARGENTINA     | MFGR#23    |  517896738 |
  1091. | 1998 | ARGENTINA     | MFGR#24    |  240754731 |
  1092. | 1998 | ARGENTINA     | MFGR#25    |  757030162 |
  1093. | 1998 | BRAZIL        | MFGR#11    |  826283793 |
  1094. | 1998 | BRAZIL        | MFGR#12    |  482293349 |
  1095. | 1998 | BRAZIL        | MFGR#13    | 1037202334 |
  1096. | 1998 | BRAZIL        | MFGR#14    |  743598666 |
  1097. | 1998 | BRAZIL        | MFGR#15    |  584176304 |
  1098. | 1998 | BRAZIL        | MFGR#21    |  557259779 |
  1099. | 1998 | BRAZIL        | MFGR#22    |  535654445 |
  1100. | 1998 | BRAZIL        | MFGR#23    |  403656721 |
  1101. | 1998 | BRAZIL        | MFGR#24    | 1305217551 |
  1102. | 1998 | BRAZIL        | MFGR#25    | 1109801463 |
  1103. | 1998 | CANADA        | MFGR#11    |  936169617 |
  1104. | 1998 | CANADA        | MFGR#12    | 1017751308 |
  1105. | 1998 | CANADA        | MFGR#13    |  850046376 |
  1106. | 1998 | CANADA        | MFGR#14    |  808138010 |
  1107. | 1998 | CANADA        | MFGR#15    |  701990010 |
  1108. | 1998 | CANADA        | MFGR#21    |  402611051 |
  1109. | 1998 | CANADA        | MFGR#22    |  382705122 |
  1110. | 1998 | CANADA        | MFGR#23    |  509674722 |
  1111. | 1998 | CANADA        | MFGR#24    | 1003021250 |
  1112. | 1998 | CANADA        | MFGR#25    |  574602788 |
  1113. | 1998 | PERU          | MFGR#11    |  552608732 |
  1114. | 1998 | PERU          | MFGR#12    |  500581456 |
  1115. | 1998 | PERU          | MFGR#13    |  894607711 |
  1116. | 1998 | PERU          | MFGR#14    |  386487826 |
  1117. | 1998 | PERU          | MFGR#15    | 1044780577 |
  1118. | 1998 | PERU          | MFGR#21    |  184346232 |
  1119. | 1998 | PERU          | MFGR#22    |  674942976 |
  1120. | 1998 | PERU          | MFGR#23    |  665523956 |
  1121. | 1998 | PERU          | MFGR#24    |  631374203 |
  1122. | 1998 | PERU          | MFGR#25    |  602609608 |
  1123. | 1998 | UNITED STATES | MFGR#11    | 1230069867 |
  1124. | 1998 | UNITED STATES | MFGR#12    | 1557720319 |
  1125. | 1998 | UNITED STATES | MFGR#13    |  999206739 |
  1126. | 1998 | UNITED STATES | MFGR#14    |  605040268 |
  1127. | 1998 | UNITED STATES | MFGR#15    |  850219215 |
  1128. | 1998 | UNITED STATES | MFGR#21    | 1032550760 |
  1129. | 1998 | UNITED STATES | MFGR#22    | 1370141401 |
  1130. | 1998 | UNITED STATES | MFGR#23    | 1226632297 |
  1131. | 1998 | UNITED STATES | MFGR#24    | 1528135100 |
  1132. | 1998 | UNITED STATES | MFGR#25    | 1127867278 |
  1133. +------+---------------+------------+------------+
  1135. -- Q4.3
  1136. +------+------------+-----------+-----------+
  1137. | year | s_city     | p_brand   | profit    |
  1138. +------+------------+-----------+-----------+
  1139. | 1997 | UNITED ST0 | MFGR#1410 |  58481513 |
  1140. | 1997 | UNITED ST0 | MFGR#1412 |  33582225 |
  1141. | 1997 | UNITED ST0 | MFGR#1413 | 135625490 |
  1142. | 1997 | UNITED ST0 | MFGR#1414 |  18581969 |
  1143. | 1997 | UNITED ST0 | MFGR#142  | 164080005 |
  1144. | 1997 | UNITED ST0 | MFGR#1420 |  30831591 |
  1145. | 1997 | UNITED ST0 | MFGR#1424 |   4085253 |
  1146. | 1997 | UNITED ST0 | MFGR#1425 | 163183170 |
  1147. | 1997 | UNITED ST0 | MFGR#1427 |  87578288 |
  1148. | 1997 | UNITED ST0 | MFGR#1428 | 109488143 |
  1149. | 1997 | UNITED ST0 | MFGR#143  | 198055627 |
  1150. | 1997 | UNITED ST0 | MFGR#1430 |  52544552 |
  1151. | 1997 | UNITED ST0 | MFGR#1432 | 158742311 |
  1152. | 1997 | UNITED ST0 | MFGR#144  |  43479982 |
  1153. | 1997 | UNITED ST0 | MFGR#1440 |  40412893 |
  1154. | 1997 | UNITED ST0 | MFGR#145  | 175568435 |
  1155. | 1997 | UNITED ST1 | MFGR#141  |  11932912 |
  1156. | 1997 | UNITED ST1 | MFGR#1411 |  40637463 |
  1157. | 1997 | UNITED ST1 | MFGR#1415 |  27562355 |
  1158. | 1997 | UNITED ST1 | MFGR#1421 | 100271780 |
  1159. | 1997 | UNITED ST1 | MFGR#1422 | 103286764 |
  1160. | 1997 | UNITED ST1 | MFGR#1423 | 106114459 |
  1161. | 1997 | UNITED ST1 | MFGR#1427 | 157715681 |
  1162. | 1997 | UNITED ST1 | MFGR#1428 |  91550168 |
  1163. | 1997 | UNITED ST1 | MFGR#1430 |  56560173 |
  1164. | 1997 | UNITED ST1 | MFGR#1431 | 248448914 |
  1165. | 1997 | UNITED ST1 | MFGR#1435 |    994228 |
  1166. | 1997 | UNITED ST1 | MFGR#144  |  55729825 |
  1167. | 1997 | UNITED ST1 | MFGR#145  | 118034196 |
  1168. | 1997 | UNITED ST1 | MFGR#146  |  99170724 |
  1169. | 1997 | UNITED ST1 | MFGR#147  |   5123001 |
  1170. | 1997 | UNITED ST2 | MFGR#141  | 111908637 |
  1171. | 1997 | UNITED ST2 | MFGR#1414 |  96864725 |
  1172. | 1997 | UNITED ST2 | MFGR#1415 | 123601050 |
  1173. | 1997 | UNITED ST2 | MFGR#1421 |  21014618 |
  1174. | 1997 | UNITED ST2 | MFGR#1427 |  46524767 |
  1175. | 1997 | UNITED ST2 | MFGR#1429 |  18800062 |
  1176. | 1997 | UNITED ST2 | MFGR#1431 |  79199532 |
  1177. | 1997 | UNITED ST2 | MFGR#1432 |  53841788 |
  1178. | 1997 | UNITED ST2 | MFGR#1433 | 133842836 |
  1179. | 1997 | UNITED ST2 | MFGR#1434 |  96443006 |
  1180. | 1997 | UNITED ST2 | MFGR#1435 |  50858424 |
  1181. | 1997 | UNITED ST2 | MFGR#1438 |  64571457 |
  1182. | 1997 | UNITED ST2 | MFGR#144  |  61319000 |
  1183. | 1997 | UNITED ST2 | MFGR#146  |  69558050 |
  1184. | 1997 | UNITED ST2 | MFGR#147  |  41160961 |
  1185. | 1997 | UNITED ST2 | MFGR#149  |  31735872 |
  1186. | 1997 | UNITED ST3 | MFGR#1410 | 306449140 |
  1187. | 1997 | UNITED ST3 | MFGR#1411 | 114677189 |
  1188. | 1997 | UNITED ST3 | MFGR#1412 |  49229127 |
  1189. | 1997 | UNITED ST3 | MFGR#1413 | 174911640 |
  1190. | 1997 | UNITED ST3 | MFGR#1415 | 134932298 |
  1191. | 1997 | UNITED ST3 | MFGR#1416 |  97111854 |
  1192. | 1997 | UNITED ST3 | MFGR#1417 | 176279103 |
  1193. | 1997 | UNITED ST3 | MFGR#1418 |  70684147 |
  1194. | 1997 | UNITED ST3 | MFGR#1420 |  27591782 |
  1195. | 1997 | UNITED ST3 | MFGR#1422 |  39411253 |
  1196. | 1997 | UNITED ST3 | MFGR#1424 | 226736650 |
  1197. | 1997 | UNITED ST3 | MFGR#1426 |  63997112 |
  1198. | 1997 | UNITED ST3 | MFGR#1429 |    556053 |
  1199. | 1997 | UNITED ST3 | MFGR#143  |  73550925 |
  1200. | 1997 | UNITED ST3 | MFGR#1430 | 218807697 |
  1201. | 1997 | UNITED ST3 | MFGR#1431 |  39936281 |
  1202. | 1997 | UNITED ST3 | MFGR#1432 |  44356689 |
  1203. | 1997 | UNITED ST3 | MFGR#1435 |  49225455 |
  1204. | 1997 | UNITED ST3 | MFGR#1436 |  90326644 |
  1205. | 1997 | UNITED ST3 | MFGR#1439 |  84615817 |
  1206. | 1997 | UNITED ST3 | MFGR#144  |  59081596 |
  1207. | 1997 | UNITED ST3 | MFGR#1440 |  59601014 |
  1208. | 1997 | UNITED ST3 | MFGR#145  | 100692258 |
  1209. | 1997 | UNITED ST3 | MFGR#147  | 142417874 |
  1210. | 1997 | UNITED ST3 | MFGR#148  |  38233221 |
  1211. | 1997 | UNITED ST5 | MFGR#1416 |  62387773 |
  1212. | 1997 | UNITED ST5 | MFGR#1417 |  54974702 |
  1213. | 1997 | UNITED ST5 | MFGR#1418 |  87301086 |
  1214. | 1997 | UNITED ST5 | MFGR#1421 |   9869673 |
  1215. | 1997 | UNITED ST5 | MFGR#1422 |  58912225 |
  1216. | 1997 | UNITED ST5 | MFGR#1424 |  80038584 |
  1217. | 1997 | UNITED ST5 | MFGR#1428 |  44422717 |
  1218. | 1997 | UNITED ST5 | MFGR#1430 |  67186074 |
  1219. | 1997 | UNITED ST5 | MFGR#1433 | 105646942 |
  1220. | 1997 | UNITED ST5 | MFGR#1434 |  13923867 |
  1221. | 1997 | UNITED ST5 | MFGR#145  | 104286534 |
  1222. | 1997 | UNITED ST5 | MFGR#146  |  20965182 |
  1223. | 1997 | UNITED ST5 | MFGR#148  | 170596496 |
  1224. | 1997 | UNITED ST5 | MFGR#149  |  42639213 |
  1225. | 1997 | UNITED ST6 | MFGR#1411 |  48199726 |
  1226. | 1997 | UNITED ST6 | MFGR#1413 |  28825982 |
  1227. | 1997 | UNITED ST6 | MFGR#1414 | 107783723 |
  1228. | 1997 | UNITED ST6 | MFGR#1415 |  92119787 |
  1229. | 1997 | UNITED ST6 | MFGR#1416 |  35390328 |
  1230. | 1997 | UNITED ST6 | MFGR#1417 |  92594053 |
  1231. | 1997 | UNITED ST6 | MFGR#1418 |  67638716 |
  1232. | 1997 | UNITED ST6 | MFGR#1421 |  98608466 |
  1233. | 1997 | UNITED ST6 | MFGR#143  |  23938737 |
  1234. | 1997 | UNITED ST6 | MFGR#1432 | 104846191 |
  1235. | 1997 | UNITED ST6 | MFGR#1435 | 185809031 |
  1236. | 1997 | UNITED ST6 | MFGR#1436 |  82920407 |
  1237. | 1997 | UNITED ST6 | MFGR#1438 | 137524730 |
  1238. | 1997 | UNITED ST6 | MFGR#146  |  28124052 |
  1239. | 1997 | UNITED ST7 | MFGR#141  |  65266383 |
  1240. | 1997 | UNITED ST7 | MFGR#1411 |  78295166 |
  1241. | 1997 | UNITED ST7 | MFGR#1413 |  37554700 |
  1242. | 1997 | UNITED ST7 | MFGR#1414 |  20428356 |
  1243. | 1997 | UNITED ST7 | MFGR#1416 |  92381468 |
  1244. | 1997 | UNITED ST7 | MFGR#1418 | 105276410 |
  1245. | 1997 | UNITED ST7 | MFGR#1419 | 116086880 |
  1246. | 1997 | UNITED ST7 | MFGR#1420 |  62010492 |
  1247. | 1997 | UNITED ST7 | MFGR#1428 |  50904528 |
  1248. | 1997 | UNITED ST7 | MFGR#1430 | 103558679 |
  1249. | 1997 | UNITED ST7 | MFGR#1431 |  38342548 |
  1250. | 1997 | UNITED ST7 | MFGR#1436 |  59859992 |
  1251. | 1997 | UNITED ST7 | MFGR#1437 |  90701341 |
  1252. | 1997 | UNITED ST7 | MFGR#147  | 133840269 |
  1253. | 1997 | UNITED ST7 | MFGR#148  | 175852097 |
  1254. | 1997 | UNITED ST9 | MFGR#1411 |  62786695 |
  1255. | 1997 | UNITED ST9 | MFGR#1416 |  25354497 |
  1256. | 1997 | UNITED ST9 | MFGR#1417 |  47367797 |
  1257. | 1997 | UNITED ST9 | MFGR#1418 |  27220077 |
  1258. | 1997 | UNITED ST9 | MFGR#142  |  41015203 |
  1259. | 1997 | UNITED ST9 | MFGR#1423 |  41473506 |
  1260. | 1997 | UNITED ST9 | MFGR#1424 |  10735092 |
  1261. | 1997 | UNITED ST9 | MFGR#1425 |  27926087 |
  1262. | 1997 | UNITED ST9 | MFGR#1426 | 136645966 |
  1263. | 1997 | UNITED ST9 | MFGR#1430 |  41283531 |
  1264. | 1997 | UNITED ST9 | MFGR#1433 |    497505 |
  1265. | 1997 | UNITED ST9 | MFGR#1434 | 101147110 |
  1266. | 1997 | UNITED ST9 | MFGR#1436 |  30923170 |
  1267. | 1997 | UNITED ST9 | MFGR#145  |  18049495 |
  1268. | 1997 | UNITED ST9 | MFGR#146  |  43726737 |
  1269. | 1998 | UNITED ST0 | MFGR#1413 | 131487843 |
  1270. | 1998 | UNITED ST0 | MFGR#1426 |  52942692 |
  1271. | 1998 | UNITED ST0 | MFGR#146  |  13567224 |
  1272. | 1998 | UNITED ST1 | MFGR#1410 |  65992198 |
  1273. | 1998 | UNITED ST1 | MFGR#1416 | 115552383 |
  1274. | 1998 | UNITED ST1 | MFGR#1418 |  15646035 |
  1275. | 1998 | UNITED ST1 | MFGR#1419 | 129708776 |
  1276. | 1998 | UNITED ST1 | MFGR#1428 |  18176281 |
  1277. | 1998 | UNITED ST1 | MFGR#1431 |  17985830 |
  1278. | 1998 | UNITED ST1 | MFGR#1436 |  16714417 |
  1279. | 1998 | UNITED ST1 | MFGR#145  |  48297153 |
  1280. | 1998 | UNITED ST2 | MFGR#1418 |   9240384 |
  1281. | 1998 | UNITED ST2 | MFGR#1419 |  40909344 |
  1282. | 1998 | UNITED ST2 | MFGR#1420 |  78625306 |
  1283. | 1998 | UNITED ST2 | MFGR#1426 |  67161050 |
  1284. | 1998 | UNITED ST2 | MFGR#1430 |  19028508 |
  1285. | 1998 | UNITED ST2 | MFGR#1434 | 127804385 |
  1286. | 1998 | UNITED ST2 | MFGR#1435 |  75092689 |
  1287. | 1998 | UNITED ST2 | MFGR#1436 |  54579894 |
  1288. | 1998 | UNITED ST2 | MFGR#1440 |  29067722 |
  1289. | 1998 | UNITED ST2 | MFGR#148  |  78886426 |
  1290. | 1998 | UNITED ST3 | MFGR#141  |   4311846 |
  1291. | 1998 | UNITED ST3 | MFGR#1412 |  98979253 |
  1292. | 1998 | UNITED ST3 | MFGR#1415 | 102275672 |
  1293. | 1998 | UNITED ST3 | MFGR#1416 |  50781431 |
  1294. | 1998 | UNITED ST3 | MFGR#1419 |  37451476 |
  1295. | 1998 | UNITED ST3 | MFGR#1420 |  24660608 |
  1296. | 1998 | UNITED ST3 | MFGR#1422 |  98548762 |
  1297. | 1998 | UNITED ST3 | MFGR#1424 |  96601854 |
  1298. | 1998 | UNITED ST3 | MFGR#1425 |  74508450 |
  1299. | 1998 | UNITED ST3 | MFGR#1426 | 330583054 |
  1300. | 1998 | UNITED ST3 | MFGR#1427 |  41352585 |
  1301. | 1998 | UNITED ST3 | MFGR#1428 |  61979722 |
  1302. | 1998 | UNITED ST3 | MFGR#1429 |    869295 |
  1303. | 1998 | UNITED ST3 | MFGR#1432 |  66991135 |
  1304. | 1998 | UNITED ST3 | MFGR#146  |  35929398 |
  1305. | 1998 | UNITED ST3 | MFGR#147  |   8484972 |
  1306. | 1998 | UNITED ST3 | MFGR#149  |  11793257 |
  1307. | 1998 | UNITED ST5 | MFGR#1410 |  55951811 |
  1308. | 1998 | UNITED ST5 | MFGR#1413 |  13403140 |
  1309. | 1998 | UNITED ST5 | MFGR#142  |  24156762 |
  1310. | 1998 | UNITED ST5 | MFGR#1422 | 105826683 |
  1311. | 1998 | UNITED ST5 | MFGR#1430 |  67851607 |
  1312. | 1998 | UNITED ST5 | MFGR#1431 |  84833774 |
  1313. | 1998 | UNITED ST5 | MFGR#1434 |  45541810 |
  1314. | 1998 | UNITED ST5 | MFGR#1437 |  33353745 |
  1315. | 1998 | UNITED ST5 | MFGR#146  |  19891496 |
  1316. | 1998 | UNITED ST6 | MFGR#1413 | 135522572 |
  1317. | 1998 | UNITED ST6 | MFGR#1416 | 185707286 |
  1318. | 1998 | UNITED ST6 | MFGR#1417 |  80511133 |
  1319. | 1998 | UNITED ST6 | MFGR#1419 | 127132766 |
  1320. | 1998 | UNITED ST6 | MFGR#142  |  72629474 |
  1321. | 1998 | UNITED ST6 | MFGR#1435 | 158543190 |
  1322. | 1998 | UNITED ST7 | MFGR#1412 |  56750777 |
  1323. | 1998 | UNITED ST7 | MFGR#1424 |  89508621 |
  1324. | 1998 | UNITED ST7 | MFGR#1425 | 160377031 |
  1325. | 1998 | UNITED ST7 | MFGR#1434 |  20882477 |
  1326. | 1998 | UNITED ST7 | MFGR#146  | 100783548 |
  1327. | 1998 | UNITED ST7 | MFGR#147  |  61595522 |
  1328. | 1998 | UNITED ST9 | MFGR#1412 |   5049765 |
  1329. | 1998 | UNITED ST9 | MFGR#142  |  69919113 |
  1330. | 1998 | UNITED ST9 | MFGR#1425 |  11003199 |
  1331. | 1998 | UNITED ST9 | MFGR#1426 | 103616972 |
  1332. | 1998 | UNITED ST9 | MFGR#1435 |  18879758 |
  1333. | 1998 | UNITED ST9 | MFGR#1438 | 101903219 |
  1334. +------+------------+-----------+-----------+

多表查询运行预期结果

  1. -- Q1.1
  2. +--------------+
  3. | revenue      |
  4. +--------------+
  5. | 218453880421 |
  6. +--------------+
  8. -- Q1.2
  9. +---------+
  10. | revenue |
  11. +---------+
  12. |    NULL |
  13. +---------+
  15. -- Q1.3
  16. +-------------+
  17. | revenue     |
  18. +-------------+
  19. | 17527575453 |
  20. +-------------+
  22. -- Q2.1
  23. +------------+------+-----------+
  24. | lo_revenue | year | p_brand   |
  25. +------------+------+-----------+
  26. | 1135676414 | 1992 | MFGR#121  |
  27. | 1221327580 | 1992 | MFGR#1210 |
  28. | 1101539324 | 1992 | MFGR#1211 |
  29. | 1298411712 | 1992 | MFGR#1212 |
  30. | 1248062482 | 1992 | MFGR#1213 |
  31. | 1340976936 | 1992 | MFGR#1214 |
  32. | 1266304940 | 1992 | MFGR#1215 |
  33. | 1349693562 | 1992 | MFGR#1216 |
  34. | 1350186870 | 1992 | MFGR#1217 |
  35. | 1200404140 | 1992 | MFGR#1218 |
  36. | 1076087188 | 1992 | MFGR#1219 |
  37. | 1310653344 | 1992 | MFGR#122  |
  38. | 1080525764 | 1992 | MFGR#1220 |
  39. | 1112241266 | 1992 | MFGR#1221 |
  40. | 1181525554 | 1992 | MFGR#1222 |
  41. | 1070897302 | 1992 | MFGR#1223 |
  42. | 1407505222 | 1992 | MFGR#1224 |
  43. | 1141665736 | 1992 | MFGR#1225 |
  44. | 1228123186 | 1992 | MFGR#1226 |
  45. | 1163518776 | 1992 | MFGR#1227 |
  46. | 1289285184 | 1992 | MFGR#1228 |
  47. | 1281716860 | 1992 | MFGR#1229 |
  48. | 1579511670 | 1992 | MFGR#123  |
  49. |  937070174 | 1992 | MFGR#1230 |
  50. | 1184873312 | 1992 | MFGR#1231 |
  51. | 1328550304 | 1992 | MFGR#1232 |
  52. | 1227770200 | 1992 | MFGR#1233 |
  53. | 1334798562 | 1992 | MFGR#1234 |
  54. | 1280580140 | 1992 | MFGR#1235 |
  55. | 1003785122 | 1992 | MFGR#1236 |
  56. | 1182963006 | 1992 | MFGR#1237 |
  57. |  954847540 | 1992 | MFGR#1238 |
  58. | 1276518748 | 1992 | MFGR#1239 |
  59. | 1144708392 | 1992 | MFGR#124  |
  60. | 1480958496 | 1992 | MFGR#1240 |
  61. |  957554190 | 1992 | MFGR#125  |
  62. | 1184349232 | 1992 | MFGR#126  |
  63. | 1412303264 | 1992 | MFGR#127  |
  64. | 1084613292 | 1992 | MFGR#128  |
  65. | 1163974704 | 1992 | MFGR#129  |
  66. | 1646175404 | 1993 | MFGR#121  |
  67. | 1296321412 | 1993 | MFGR#1210 |
  68. | 1269487796 | 1993 | MFGR#1211 |
  69. | 1571278566 | 1993 | MFGR#1212 |
  70. | 1276510058 | 1993 | MFGR#1213 |
  71. | 1233674474 | 1993 | MFGR#1214 |
  72. | 1269375950 | 1993 | MFGR#1215 |
  73. | 1276707800 | 1993 | MFGR#1216 |
  74. | 1326745902 | 1993 | MFGR#1217 |
  75. | 1367971710 | 1993 | MFGR#1218 |
  76. | 1293900066 | 1993 | MFGR#1219 |
  77. | 1245065968 | 1993 | MFGR#122  |
  78. | 1061660254 | 1993 | MFGR#1220 |
  79. | 1086692674 | 1993 | MFGR#1221 |
  80. | 1513842406 | 1993 | MFGR#1222 |
  81. | 1067088700 | 1993 | MFGR#1223 |
  82. | 1831832170 | 1993 | MFGR#1224 |
  83. |  946014762 | 1993 | MFGR#1225 |
  84. | 1478072248 | 1993 | MFGR#1226 |
  85. | 1184357774 | 1993 | MFGR#1227 |
  86. | 1167014116 | 1993 | MFGR#1228 |
  87. | 1234906982 | 1993 | MFGR#1229 |
  88. | 1275727736 | 1993 | MFGR#123  |
  89. | 1251068620 | 1993 | MFGR#1230 |
  90. | 1160655270 | 1993 | MFGR#1231 |
  91. | 1394746196 | 1993 | MFGR#1232 |
  92. | 1031142832 | 1993 | MFGR#1233 |
  93. | 1303871516 | 1993 | MFGR#1234 |
  94. | 1151558960 | 1993 | MFGR#1235 |
  95. | 1183757334 | 1993 | MFGR#1236 |
  96. | 1219237152 | 1993 | MFGR#1237 |
  97. |  889228020 | 1993 | MFGR#1238 |
  98. | 1190512654 | 1993 | MFGR#1239 |
  99. | 1321172474 | 1993 | MFGR#124  |
  100. | 1577460118 | 1993 | MFGR#1240 |
  101. | 1232449078 | 1993 | MFGR#125  |
  102. | 1234253508 | 1993 | MFGR#126  |
  103. | 1308876648 | 1993 | MFGR#127  |
  104. | 1463314002 | 1993 | MFGR#128  |
  105. | 1096096790 | 1993 | MFGR#129  |
  106. | 1128811296 | 1994 | MFGR#121  |
  107. | 1290809698 | 1994 | MFGR#1210 |
  108. | 1263241270 | 1994 | MFGR#1211 |
  109. | 1136664696 | 1994 | MFGR#1212 |
  110. | 1357571714 | 1994 | MFGR#1213 |
  111. | 1068004660 | 1994 | MFGR#1214 |
  112. | 1308800484 | 1994 | MFGR#1215 |
  113. | 1117292682 | 1994 | MFGR#1216 |
  114. | 1375691282 | 1994 | MFGR#1217 |
  115. | 1093348694 | 1994 | MFGR#1218 |
  116. | 1134545884 | 1994 | MFGR#1219 |
  117. | 1319768124 | 1994 | MFGR#122  |
  118. | 1125164344 | 1994 | MFGR#1220 |
  119. | 1197237994 | 1994 | MFGR#1221 |
  120. | 1202032882 | 1994 | MFGR#1222 |
  121. | 1110268808 | 1994 | MFGR#1223 |
  122. | 1474844604 | 1994 | MFGR#1224 |
  123. | 1141491910 | 1994 | MFGR#1225 |
  124. | 1492604490 | 1994 | MFGR#1226 |
  125. | 1303414962 | 1994 | MFGR#1227 |
  126. | 1147387094 | 1994 | MFGR#1228 |
  127. | 1295836746 | 1994 | MFGR#1229 |
  128. | 1160899184 | 1994 | MFGR#123  |
  129. |  986540824 | 1994 | MFGR#1230 |
  130. | 1207092296 | 1994 | MFGR#1231 |
  131. | 1439730662 | 1994 | MFGR#1232 |
  132. | 1277964476 | 1994 | MFGR#1233 |
  133. | 1486495354 | 1994 | MFGR#1234 |
  134. | 1197361918 | 1994 | MFGR#1235 |
  135. | 1231452194 | 1994 | MFGR#1236 |
  136. | 1085139630 | 1994 | MFGR#1237 |
  137. | 1147021562 | 1994 | MFGR#1238 |
  138. | 1159711706 | 1994 | MFGR#1239 |
  139. | 1369146644 | 1994 | MFGR#124  |
  140. | 1747471474 | 1994 | MFGR#1240 |
  141. | 1120976608 | 1994 | MFGR#125  |
  142. | 1314073028 | 1994 | MFGR#126  |
  143. | 1245142366 | 1994 | MFGR#127  |
  144. | 1173691328 | 1994 | MFGR#128  |
  145. | 1069083050 | 1994 | MFGR#129  |
  146. | 1412939022 | 1995 | MFGR#121  |
  147. | 1205785606 | 1995 | MFGR#1210 |
  148. | 1290332184 | 1995 | MFGR#1211 |
  149. | 1226578566 | 1995 | MFGR#1212 |
  150. | 1199172958 | 1995 | MFGR#1213 |
  151. | 1125141608 | 1995 | MFGR#1214 |
  152. | 1345057510 | 1995 | MFGR#1215 |
  153. | 1338001944 | 1995 | MFGR#1216 |
  154. | 1450724898 | 1995 | MFGR#1217 |
  155. | 1314053270 | 1995 | MFGR#1218 |
  156. | 1039318006 | 1995 | MFGR#1219 |
  157. | 1449455482 | 1995 | MFGR#122  |
  158. | 1035912262 | 1995 | MFGR#1220 |
  159. | 1271482702 | 1995 | MFGR#1221 |
  160. | 1128736820 | 1995 | MFGR#1222 |
  161. | 1201330298 | 1995 | MFGR#1223 |
  162. | 1525400702 | 1995 | MFGR#1224 |
  163. | 1343339172 | 1995 | MFGR#1225 |
  164. | 1145137496 | 1995 | MFGR#1226 |
  165. | 1060722600 | 1995 | MFGR#1227 |
  166. | 1266714170 | 1995 | MFGR#1228 |
  167. | 1095920488 | 1995 | MFGR#1229 |
  168. | 1321422154 | 1995 | MFGR#123  |
  169. | 1205471716 | 1995 | MFGR#1230 |
  170. |  999704292 | 1995 | MFGR#1231 |
  171. | 1430601506 | 1995 | MFGR#1232 |
  172. | 1114299142 | 1995 | MFGR#1233 |
  173. | 1420046118 | 1995 | MFGR#1234 |
  174. | 1244850478 | 1995 | MFGR#1235 |
  175. | 1269131002 | 1995 | MFGR#1236 |
  176. | 1145694540 | 1995 | MFGR#1237 |
  177. | 1098637824 | 1995 | MFGR#1238 |
  178. | 1187703424 | 1995 | MFGR#1239 |
  179. | 1170843630 | 1995 | MFGR#124  |
  180. | 1414415776 | 1995 | MFGR#1240 |
  181. | 1076493744 | 1995 | MFGR#125  |
  182. | 1211598042 | 1995 | MFGR#126  |
  183. | 1331956224 | 1995 | MFGR#127  |
  184. | 1293921912 | 1995 | MFGR#128  |
  185. | 1017498802 | 1995 | MFGR#129  |
  186. | 1047758290 | 1996 | MFGR#121  |
  187. | 1287290106 | 1996 | MFGR#1210 |
  188. | 1190130678 | 1996 | MFGR#1211 |
  189. | 1349252880 | 1996 | MFGR#1212 |
  190. |  992594174 | 1996 | MFGR#1213 |
  191. | 1166499010 | 1996 | MFGR#1214 |
  192. | 1404369714 | 1996 | MFGR#1215 |
  193. | 1203618668 | 1996 | MFGR#1216 |
  194. | 1409796774 | 1996 | MFGR#1217 |
  195. | 1057686172 | 1996 | MFGR#1218 |
  196. | 1172492660 | 1996 | MFGR#1219 |
  197. | 1424220984 | 1996 | MFGR#122  |
  198. | 1036888430 | 1996 | MFGR#1220 |
  199. |  998638828 | 1996 | MFGR#1221 |
  200. | 1358938712 | 1996 | MFGR#1222 |
  201. | 1257525508 | 1996 | MFGR#1223 |
  202. | 1449689712 | 1996 | MFGR#1224 |
  203. | 1321241174 | 1996 | MFGR#1225 |
  204. | 1335349458 | 1996 | MFGR#1226 |
  205. |  967676170 | 1996 | MFGR#1227 |
  206. | 1219710782 | 1996 | MFGR#1228 |
  207. | 1317919114 | 1996 | MFGR#1229 |
  208. | 1132435704 | 1996 | MFGR#123  |
  209. | 1057759996 | 1996 | MFGR#1230 |
  210. | 1178962388 | 1996 | MFGR#1231 |
  211. | 1405611792 | 1996 | MFGR#1232 |
  212. | 1327359894 | 1996 | MFGR#1233 |
  213. | 1142298900 | 1996 | MFGR#1234 |
  214. |  957296148 | 1996 | MFGR#1235 |
  215. | 1136498730 | 1996 | MFGR#1236 |
  216. | 1185232334 | 1996 | MFGR#1237 |
  217. |  933352296 | 1996 | MFGR#1238 |
  218. | 1341387438 | 1996 | MFGR#1239 |
  219. | 1121335438 | 1996 | MFGR#124  |
  220. | 1642335900 | 1996 | MFGR#1240 |
  221. |  953728666 | 1996 | MFGR#125  |
  222. | 1116061768 | 1996 | MFGR#126  |
  223. | 1271747782 | 1996 | MFGR#127  |
  224. | 1102021236 | 1996 | MFGR#128  |
  225. | 1121141260 | 1996 | MFGR#129  |
  226. | 1174026414 | 1997 | MFGR#121  |
  227. | 1232575784 | 1997 | MFGR#1210 |
  228. | 1097177522 | 1997 | MFGR#1211 |
  229. | 1179187784 | 1997 | MFGR#1212 |
  230. |  848613340 | 1997 | MFGR#1213 |
  231. | 1023943820 | 1997 | MFGR#1214 |
  232. | 1263544492 | 1997 | MFGR#1215 |
  233. | 1384270280 | 1997 | MFGR#1216 |
  234. | 1555989914 | 1997 | MFGR#1217 |
  235. | 1414107440 | 1997 | MFGR#1218 |
  236. | 1122339054 | 1997 | MFGR#1219 |
  237. | 1329832490 | 1997 | MFGR#122  |
  238. | 1188932314 | 1997 | MFGR#1220 |
  239. | 1177696342 | 1997 | MFGR#1221 |
  240. | 1057977920 | 1997 | MFGR#1222 |
  241. | 1074196422 | 1997 | MFGR#1223 |
  242. | 1349526332 | 1997 | MFGR#1224 |
  243. |  900804584 | 1997 | MFGR#1225 |
  244. | 1402721444 | 1997 | MFGR#1226 |
  245. | 1012023140 | 1997 | MFGR#1227 |
  246. | 1171157474 | 1997 | MFGR#1228 |
  247. | 1245488032 | 1997 | MFGR#1229 |
  248. | 1293006336 | 1997 | MFGR#123  |
  249. | 1143601882 | 1997 | MFGR#1230 |
  250. | 1005203580 | 1997 | MFGR#1231 |
  251. | 1355849312 | 1997 | MFGR#1232 |
  252. | 1068911952 | 1997 | MFGR#1233 |
  253. | 1429869430 | 1997 | MFGR#1234 |
  254. | 1534302840 | 1997 | MFGR#1235 |
  255. | 1237754358 | 1997 | MFGR#1236 |
  256. | 1279276114 | 1997 | MFGR#1237 |
  257. |  803906838 | 1997 | MFGR#1238 |
  258. | 1221513428 | 1997 | MFGR#1239 |
  259. | 1086496174 | 1997 | MFGR#124  |
  260. | 1350265384 | 1997 | MFGR#1240 |
  261. |  958198730 | 1997 | MFGR#125  |
  262. | 1141393136 | 1997 | MFGR#126  |
  263. | 1166149184 | 1997 | MFGR#127  |
  264. | 1390266208 | 1997 | MFGR#128  |
  265. | 1311277552 | 1997 | MFGR#129  |
  266. |  689151850 | 1998 | MFGR#121  |
  267. |  834304832 | 1998 | MFGR#1210 |
  268. |  634136336 | 1998 | MFGR#1211 |
  269. |  748683032 | 1998 | MFGR#1212 |
  270. |  665481806 | 1998 | MFGR#1213 |
  271. |  609746004 | 1998 | MFGR#1214 |
  272. |  732202264 | 1998 | MFGR#1215 |
  273. |  758267796 | 1998 | MFGR#1216 |
  274. |  719016994 | 1998 | MFGR#1217 |
  275. |  641246668 | 1998 | MFGR#1218 |
  276. |  692365724 | 1998 | MFGR#1219 |
  277. |  624880054 | 1998 | MFGR#122  |
  278. |  696247922 | 1998 | MFGR#1220 |
  279. |  679690796 | 1998 | MFGR#1221 |
  280. |  710832322 | 1998 | MFGR#1222 |
  281. |  689779644 | 1998 | MFGR#1223 |
  282. |  793813382 | 1998 | MFGR#1224 |
  283. |  580417756 | 1998 | MFGR#1225 |
  284. |  838831414 | 1998 | MFGR#1226 |
  285. |  716932680 | 1998 | MFGR#1227 |
  286. |  503099910 | 1998 | MFGR#1228 |
  287. |  766277720 | 1998 | MFGR#1229 |
  288. |  592661122 | 1998 | MFGR#123  |
  289. |  874362486 | 1998 | MFGR#1230 |
  290. |  797888984 | 1998 | MFGR#1231 |
  291. |  848124910 | 1998 | MFGR#1232 |
  292. |  813934376 | 1998 | MFGR#1233 |
  293. |  857734480 | 1998 | MFGR#1234 |
  294. |  704555562 | 1998 | MFGR#1235 |
  295. |  723654172 | 1998 | MFGR#1236 |
  296. |  683237138 | 1998 | MFGR#1237 |
  297. |  489478462 | 1998 | MFGR#1238 |
  298. |  828303606 | 1998 | MFGR#1239 |
  299. |  660164742 | 1998 | MFGR#124  |
  300. |  830624906 | 1998 | MFGR#1240 |
  301. |  720579248 | 1998 | MFGR#125  |
  302. |  683315160 | 1998 | MFGR#126  |
  303. |  755014122 | 1998 | MFGR#127  |
  304. |  722832994 | 1998 | MFGR#128  |
  305. |  637539146 | 1998 | MFGR#129  |
  306. +------------+------+-----------+
  308. -- Q2.2
  309. +------------+------+-----------+
  310. | lo_revenue | year | p_brand   |
  311. +------------+------+-----------+
  312. | 1419049858 | 1992 | MFGR#2221 |
  313. | 1567692788 | 1992 | MFGR#2222 |
  314. | 1530104004 | 1992 | MFGR#2223 |
  315. | 1302977924 | 1992 | MFGR#2224 |
  316. | 1293057178 | 1992 | MFGR#2225 |
  317. | 1419301096 | 1992 | MFGR#2226 |
  318. | 1491112632 | 1992 | MFGR#2227 |
  319. | 1513803750 | 1992 | MFGR#2228 |
  320. | 1533042206 | 1993 | MFGR#2221 |
  321. | 1382951194 | 1993 | MFGR#2222 |
  322. | 1516441504 | 1993 | MFGR#2223 |
  323. | 1339325414 | 1993 | MFGR#2224 |
  324. | 1547708456 | 1993 | MFGR#2225 |
  325. | 1474175036 | 1993 | MFGR#2226 |
  326. | 1563935532 | 1993 | MFGR#2227 |
  327. | 1361760432 | 1993 | MFGR#2228 |
  328. | 1371555036 | 1994 | MFGR#2221 |
  329. | 1333049614 | 1994 | MFGR#2222 |
  330. | 1467987180 | 1994 | MFGR#2223 |
  331. | 1415738080 | 1994 | MFGR#2224 |
  332. | 1442503934 | 1994 | MFGR#2225 |
  333. | 1644991838 | 1994 | MFGR#2226 |
  334. | 1441674256 | 1994 | MFGR#2227 |
  335. | 1652450700 | 1994 | MFGR#2228 |
  336. | 1550874148 | 1995 | MFGR#2221 |
  337. | 1522709584 | 1995 | MFGR#2222 |
  338. | 1275665150 | 1995 | MFGR#2223 |
  339. | 1179531414 | 1995 | MFGR#2224 |
  340. | 1416580078 | 1995 | MFGR#2225 |
  341. | 1494712766 | 1995 | MFGR#2226 |
  342. | 1605005080 | 1995 | MFGR#2227 |
  343. | 1791873572 | 1995 | MFGR#2228 |
  344. | 1400020016 | 1996 | MFGR#2221 |
  345. | 1554620170 | 1996 | MFGR#2222 |
  346. | 1312190628 | 1996 | MFGR#2223 |
  347. | 1313719834 | 1996 | MFGR#2224 |
  348. | 1531641792 | 1996 | MFGR#2225 |
  349. | 1616355468 | 1996 | MFGR#2226 |
  350. | 1459126606 | 1996 | MFGR#2227 |
  351. | 1639331748 | 1996 | MFGR#2228 |
  352. | 1454684764 | 1997 | MFGR#2221 |
  353. | 1329067558 | 1997 | MFGR#2222 |
  354. | 1496576784 | 1997 | MFGR#2223 |
  355. | 1260844162 | 1997 | MFGR#2224 |
  356. | 1514782406 | 1997 | MFGR#2225 |
  357. | 1495778514 | 1997 | MFGR#2226 |
  358. | 1457715798 | 1997 | MFGR#2227 |
  359. | 1550625970 | 1997 | MFGR#2228 |
  360. |  670609008 | 1998 | MFGR#2221 |
  361. |  818694274 | 1998 | MFGR#2222 |
  362. |  918219154 | 1998 | MFGR#2223 |
  363. |  826636144 | 1998 | MFGR#2224 |
  364. |  820804190 | 1998 | MFGR#2225 |
  365. |  907030088 | 1998 | MFGR#2226 |
  366. |  781012810 | 1998 | MFGR#2227 |
  367. |  795878206 | 1998 | MFGR#2228 |
  368. +------------+------+-----------+
  370. -- Q2.3
  371. +------------+------+-----------+
  372. | lo_revenue | year | p_brand   |
  373. +------------+------+-----------+
  374. | 1452854972 | 1992 | MFGR#2239 |
  375. | 1410477918 | 1993 | MFGR#2239 |
  376. | 1328290268 | 1994 | MFGR#2239 |
  377. | 1427678672 | 1995 | MFGR#2239 |
  378. | 1456985730 | 1996 | MFGR#2239 |
  379. | 1467793064 | 1997 | MFGR#2239 |
  380. |  760511462 | 1998 | MFGR#2239 |
  381. +------------+------+-----------+
  383. -- Q3.1
  384. +-----------+-----------+------+-------------+
  385. | c_nation  | s_nation  | year | lo_revenue  |
  386. +-----------+-----------+------+-------------+
  387. | INDONESIA | INDONESIA | 1992 | 13811397976 |
  388. | CHINA     | INDONESIA | 1992 | 13232157738 |
  389. | CHINA     | CHINA     | 1992 | 12912862954 |
  390. | VIETNAM   | INDONESIA | 1992 | 12680363414 |
  391. | VIETNAM   | CHINA     | 1992 | 12665688780 |
  392. | INDONESIA | CHINA     | 1992 | 12621419066 |
  393. | INDIA     | INDONESIA | 1992 | 12477614708 |
  394. | JAPAN     | INDONESIA | 1992 | 12445131276 |
  395. | CHINA     | INDIA     | 1992 | 12379662702 |
  396. | CHINA     | JAPAN     | 1992 | 12315357786 |
  397. | JAPAN     | CHINA     | 1992 | 12134201310 |
  398. | INDIA     | CHINA     | 1992 | 12132923622 |
  399. | VIETNAM   | JAPAN     | 1992 | 11727572698 |
  400. | JAPAN     | INDIA     | 1992 | 11605499970 |
  401. | INDONESIA | INDIA     | 1992 | 11540406436 |
  402. | VIETNAM   | INDIA     | 1992 | 11397022802 |
  403. | INDONESIA | JAPAN     | 1992 | 11327531220 |
  404. | JAPAN     | JAPAN     | 1992 | 11296069422 |
  405. | INDIA     | JAPAN     | 1992 | 10843918562 |
  406. | CHINA     | VIETNAM   | 1992 | 10824644052 |
  407. | JAPAN     | VIETNAM   | 1992 | 10803385110 |
  408. | INDIA     | INDIA     | 1992 | 10722487510 |
  409. | INDONESIA | VIETNAM   | 1992 | 10605276744 |
  410. | INDIA     | VIETNAM   | 1992 | 10490661242 |
  411. | VIETNAM   | VIETNAM   | 1992 | 10223463556 |
  412. | INDONESIA | INDONESIA | 1993 | 13862726524 |
  413. | INDONESIA | CHINA     | 1993 | 13225782498 |
  414. | CHINA     | INDONESIA | 1993 | 13163026732 |
  415. | VIETNAM   | INDONESIA | 1993 | 13023278704 |
  416. | CHINA     | CHINA     | 1993 | 12889027574 |
  417. | CHINA     | INDIA     | 1993 | 12843388242 |
  418. | VIETNAM   | CHINA     | 1993 | 12827159998 |
  419. | INDIA     | INDONESIA | 1993 | 12662117188 |
  420. | JAPAN     | CHINA     | 1993 | 12584587990 |
  421. | INDIA     | CHINA     | 1993 | 12418707584 |
  422. | CHINA     | JAPAN     | 1993 | 12390933768 |
  423. | VIETNAM   | INDIA     | 1993 | 12322348954 |
  424. | INDONESIA | INDIA     | 1993 | 12303328612 |
  425. | INDONESIA | JAPAN     | 1993 | 12295210498 |
  426. | JAPAN     | INDONESIA | 1993 | 12107892626 |
  427. | INDIA     | JAPAN     | 1993 | 11990417970 |
  428. | CHINA     | VIETNAM   | 1993 | 11770046456 |
  429. | VIETNAM   | JAPAN     | 1993 | 11748533734 |
  430. | INDONESIA | VIETNAM   | 1993 | 11680575444 |
  431. | JAPAN     | INDIA     | 1993 | 11646686314 |
  432. | INDIA     | INDIA     | 1993 | 11143151598 |
  433. | VIETNAM   | VIETNAM   | 1993 | 11108322366 |
  434. | JAPAN     | JAPAN     | 1993 | 10860637166 |
  435. | JAPAN     | VIETNAM   | 1993 | 10813139306 |
  436. | INDIA     | VIETNAM   | 1993 | 10467742974 |
  437. | VIETNAM   | CHINA     | 1994 | 13419766884 |
  438. | CHINA     | CHINA     | 1994 | 13297885930 |
  439. | INDONESIA | CHINA     | 1994 | 12967201820 |
  440. | CHINA     | JAPAN     | 1994 | 12698074042 |
  441. | VIETNAM   | INDONESIA | 1994 | 12694883862 |
  442. | JAPAN     | CHINA     | 1994 | 12640018436 |
  443. | INDONESIA | INDONESIA | 1994 | 12630662172 |
  444. | CHINA     | INDIA     | 1994 | 12595165622 |
  445. | CHINA     | INDONESIA | 1994 | 12469575792 |
  446. | VIETNAM   | JAPAN     | 1994 | 12463946094 |
  447. | INDONESIA | INDIA     | 1994 | 12396824490 |
  448. | INDIA     | INDONESIA | 1994 | 12336379718 |
  449. | INDONESIA | JAPAN     | 1994 | 12282391938 |
  450. | JAPAN     | INDONESIA | 1994 | 12026069236 |
  451. | CHINA     | VIETNAM   | 1994 | 11770637466 |
  452. | INDIA     | CHINA     | 1994 | 11630045428 |
  453. | VIETNAM   | INDIA     | 1994 | 11578797382 |
  454. | JAPAN     | JAPAN     | 1994 | 11507642964 |
  455. | JAPAN     | INDIA     | 1994 | 11291637744 |
  456. | INDONESIA | VIETNAM   | 1994 | 11248692736 |
  457. | INDIA     | INDIA     | 1994 | 11169873030 |
  458. | VIETNAM   | VIETNAM   | 1994 | 10836996318 |
  459. | INDIA     | JAPAN     | 1994 | 10788269948 |
  460. | JAPAN     | VIETNAM   | 1994 | 10551643274 |
  461. | INDIA     | VIETNAM   | 1994 | 10502079630 |
  462. | CHINA     | INDONESIA | 1995 | 14149078888 |
  463. | INDONESIA | CHINA     | 1995 | 13857241240 |
  464. | CHINA     | CHINA     | 1995 | 13249333224 |
  465. | JAPAN     | CHINA     | 1995 | 13039778770 |
  466. | VIETNAM   | CHINA     | 1995 | 12665462536 |
  467. | INDONESIA | INDONESIA | 1995 | 12537062642 |
  468. | VIETNAM   | JAPAN     | 1995 | 12527914040 |
  469. | CHINA     | INDIA     | 1995 | 12493312748 |
  470. | VIETNAM   | INDIA     | 1995 | 12396883914 |
  471. | INDONESIA | INDIA     | 1995 | 12347610366 |
  472. | VIETNAM   | INDONESIA | 1995 | 12115640296 |
  473. | CHINA     | JAPAN     | 1995 | 12043708260 |
  474. | INDONESIA | JAPAN     | 1995 | 12038187742 |
  475. | INDIA     | CHINA     | 1995 | 12021065586 |
  476. | INDIA     | INDONESIA | 1995 | 11951037194 |
  477. | JAPAN     | JAPAN     | 1995 | 11904558258 |
  478. | JAPAN     | INDONESIA | 1995 | 11894001470 |
  479. | VIETNAM   | VIETNAM   | 1995 | 11509455214 |
  480. | JAPAN     | INDIA     | 1995 | 11461486252 |
  481. | INDONESIA | VIETNAM   | 1995 | 11149948132 |
  482. | INDIA     | INDIA     | 1995 | 11131991100 |
  483. | JAPAN     | VIETNAM   | 1995 | 11002627550 |
  484. | CHINA     | VIETNAM   | 1995 | 10979872126 |
  485. | INDIA     | JAPAN     | 1995 | 10938406854 |
  486. | INDIA     | VIETNAM   | 1995 | 10414126568 |
  487. | INDONESIA | INDONESIA | 1996 | 13500112566 |
  488. | CHINA     | INDONESIA | 1996 | 13314250150 |
  489. | INDONESIA | CHINA     | 1996 | 13226878224 |
  490. | CHINA     | CHINA     | 1996 | 13183395830 |
  491. | VIETNAM   | CHINA     | 1996 | 12857307780 |
  492. | VIETNAM   | INDONESIA | 1996 | 12591253464 |
  493. | JAPAN     | INDONESIA | 1996 | 12454895712 |
  494. | INDIA     | CHINA     | 1996 | 12397135638 |
  495. | INDIA     | INDONESIA | 1996 | 12378484116 |
  496. | CHINA     | INDIA     | 1996 | 12307574730 |
  497. | INDONESIA | INDIA     | 1996 | 12277621726 |
  498. | CHINA     | JAPAN     | 1996 | 12211132648 |
  499. | JAPAN     | CHINA     | 1996 | 12177971128 |
  500. | INDONESIA | JAPAN     | 1996 | 12111276444 |
  501. | VIETNAM   | JAPAN     | 1996 | 11839994300 |
  502. | VIETNAM   | VIETNAM   | 1996 | 11721684604 |
  503. | INDIA     | JAPAN     | 1996 | 11683329610 |
  504. | VIETNAM   | INDIA     | 1996 | 11614973966 |
  505. | JAPAN     | INDIA     | 1996 | 11289159232 |
  506. | JAPAN     | JAPAN     | 1996 | 11132409590 |
  507. | INDIA     | INDIA     | 1996 | 11064146206 |
  508. | INDONESIA | VIETNAM   | 1996 | 10877028774 |
  509. | CHINA     | VIETNAM   | 1996 | 10869545636 |
  510. | JAPAN     | VIETNAM   | 1996 | 10668555098 |
  511. | INDIA     | VIETNAM   | 1996 | 10587783062 |
  512. | CHINA     | INDONESIA | 1997 | 13306469392 |
  513. | INDONESIA | CHINA     | 1997 | 13154792628 |
  514. | CHINA     | CHINA     | 1997 | 12927589590 |
  515. | JAPAN     | INDONESIA | 1997 | 12858540252 |
  516. | INDONESIA | INDONESIA | 1997 | 12796855642 |
  517. | VIETNAM   | INDONESIA | 1997 | 12727166240 |
  518. | CHINA     | JAPAN     | 1997 | 12569467036 |
  519. | VIETNAM   | CHINA     | 1997 | 12328437446 |
  520. | INDIA     | CHINA     | 1997 | 12306564428 |
  521. | CHINA     | INDIA     | 1997 | 12168567966 |
  522. | INDONESIA | JAPAN     | 1997 | 12002855912 |
  523. | INDIA     | INDONESIA | 1997 | 11966878600 |
  524. | JAPAN     | CHINA     | 1997 | 11947699374 |
  525. | CHINA     | VIETNAM   | 1997 | 11816508352 |
  526. | JAPAN     | INDIA     | 1997 | 11593843984 |
  527. | JAPAN     | JAPAN     | 1997 | 11580900078 |
  528. | INDONESIA | INDIA     | 1997 | 11578734210 |
  529. | VIETNAM   | INDIA     | 1997 | 11460243216 |
  530. | INDIA     | INDIA     | 1997 | 11386057814 |
  531. | VIETNAM   | JAPAN     | 1997 | 11378690460 |
  532. | INDONESIA | VIETNAM   | 1997 | 11331356264 |
  533. | VIETNAM   | VIETNAM   | 1997 | 11240502648 |
  534. | INDIA     | JAPAN     | 1997 | 11175655826 |
  535. | JAPAN     | VIETNAM   | 1997 | 10499749228 |
  536. | INDIA     | VIETNAM   | 1997 | 10007249674 |
  537. +-----------+-----------+------+-------------+
  539. -- Q3.2
  540. +------------+------------+------+------------+
  541. | c_city     | s_city     | year | lo_revenue |
  542. +------------+------------+------+------------+
  543. | UNITED ST4 | UNITED ST1 | 1992 |  204054910 |
  544. | UNITED ST1 | UNITED ST0 | 1992 |  193978982 |
  545. | UNITED ST7 | UNITED ST0 | 1992 |  192156020 |
  546. | UNITED ST9 | UNITED ST0 | 1992 |  189626588 |
  547. | UNITED ST4 | UNITED ST0 | 1992 |  189288484 |
  548. | UNITED ST2 | UNITED ST4 | 1992 |  182361000 |
  549. | UNITED ST5 | UNITED ST0 | 1992 |  180864600 |
  550. | UNITED ST6 | UNITED ST7 | 1992 |  175316534 |
  551. | UNITED ST3 | UNITED ST9 | 1992 |  172284096 |
  552. | UNITED ST6 | UNITED ST5 | 1992 |  171765932 |
  553. | UNITED ST7 | UNITED ST3 | 1992 |  167531332 |
  554. | UNITED ST2 | UNITED ST9 | 1992 |  167411236 |
  555. | UNITED ST4 | UNITED ST6 | 1992 |  163772748 |
  556. | UNITED ST2 | UNITED ST1 | 1992 |  163678330 |
  557. | UNITED ST9 | UNITED ST1 | 1992 |  161590604 |
  558. | UNITED ST6 | UNITED ST3 | 1992 |  157556436 |
  559. | UNITED ST6 | UNITED ST0 | 1992 |  157393912 |
  560. | UNITED ST0 | UNITED ST1 | 1992 |  154534792 |
  561. | UNITED ST0 | UNITED ST0 | 1992 |  151244244 |
  562. | UNITED ST1 | UNITED ST9 | 1992 |  150734118 |
  563. | UNITED ST3 | UNITED ST1 | 1992 |  147274980 |
  564. | UNITED ST2 | UNITED ST0 | 1992 |  144420436 |
  565. | UNITED ST1 | UNITED ST7 | 1992 |  142945946 |
  566. | UNITED ST6 | UNITED ST4 | 1992 |  142173888 |
  567. | UNITED ST4 | UNITED ST4 | 1992 |  140222670 |
  568. | UNITED ST6 | UNITED ST1 | 1992 |  138817376 |
  569. | UNITED ST4 | UNITED ST3 | 1992 |  138003574 |
  570. | UNITED ST5 | UNITED ST7 | 1992 |  136667302 |
  571. | UNITED ST4 | UNITED ST9 | 1992 |  135675940 |
  572. | UNITED ST7 | UNITED ST6 | 1992 |  131026410 |
  573. | UNITED ST4 | UNITED ST5 | 1992 |  130115744 |
  574. | UNITED ST7 | UNITED ST4 | 1992 |  129801776 |
  575. | UNITED ST1 | UNITED ST1 | 1992 |  129338140 |
  576. | UNITED ST3 | UNITED ST5 | 1992 |  128478096 |
  577. | UNITED ST0 | UNITED ST9 | 1992 |  127959992 |
  578. | UNITED ST3 | UNITED ST4 | 1992 |  126289544 |
  579. | UNITED ST5 | UNITED ST6 | 1992 |  125256186 |
  580. | UNITED ST4 | UNITED ST7 | 1992 |  125058752 |
  581. | UNITED ST3 | UNITED ST0 | 1992 |  124883312 |
  582. | UNITED ST9 | UNITED ST4 | 1992 |  122979026 |
  583. | UNITED ST8 | UNITED ST6 | 1992 |  121080880 |
  584. | UNITED ST7 | UNITED ST9 | 1992 |  120652084 |
  585. | UNITED ST7 | UNITED ST7 | 1992 |  120242772 |
  586. | UNITED ST5 | UNITED ST1 | 1992 |  119890574 |
  587. | UNITED ST5 | UNITED ST4 | 1992 |  115251254 |
  588. | UNITED ST7 | UNITED ST5 | 1992 |  115133604 |
  589. | UNITED ST2 | UNITED ST5 | 1992 |  114042730 |
  590. | UNITED ST9 | UNITED ST7 | 1992 |  113766718 |
  591. | UNITED ST0 | UNITED ST3 | 1992 |  112718634 |
  592. | UNITED ST1 | UNITED ST3 | 1992 |  111454948 |
  593. | UNITED ST5 | UNITED ST3 | 1992 |  107927106 |
  594. | UNITED ST0 | UNITED ST7 | 1992 |  101166818 |
  595. | UNITED ST5 | UNITED ST9 | 1992 |  100382182 |
  596. | UNITED ST7 | UNITED ST1 | 1992 |  100334416 |
  597. | UNITED ST0 | UNITED ST8 | 1992 |   99465280 |
  598. | UNITED ST0 | UNITED ST4 | 1992 |   99353614 |
  599. | UNITED ST9 | UNITED ST3 | 1992 |   95362330 |
  600. | UNITED ST8 | UNITED ST4 | 1992 |   93514038 |
  601. | UNITED ST3 | UNITED ST3 | 1992 |   90174432 |
  602. | UNITED ST8 | UNITED ST0 | 1992 |   88737678 |
  603. | UNITED ST0 | UNITED ST6 | 1992 |   84943612 |
  604. | UNITED ST6 | UNITED ST8 | 1992 |   84927380 |
  605. | UNITED ST8 | UNITED ST7 | 1992 |   83795802 |
  606. | UNITED ST3 | UNITED ST8 | 1992 |   82551528 |
  607. | UNITED ST6 | UNITED ST9 | 1992 |   81183442 |
  608. | UNITED ST0 | UNITED ST5 | 1992 |   80241772 |
  609. | UNITED ST1 | UNITED ST4 | 1992 |   78652692 |
  610. | UNITED ST3 | UNITED ST7 | 1992 |   78057158 |
  611. | UNITED ST3 | UNITED ST6 | 1992 |   77597430 |
  612. | UNITED ST9 | UNITED ST9 | 1992 |   72096686 |
  613. | UNITED ST2 | UNITED ST8 | 1992 |   72092898 |
  614. | UNITED ST2 | UNITED ST3 | 1992 |   71963926 |
  615. | UNITED ST8 | UNITED ST1 | 1992 |   71361504 |
  616. | UNITED ST1 | UNITED ST6 | 1992 |   70809980 |
  617. | UNITED ST8 | UNITED ST5 | 1992 |   70375220 |
  618. | UNITED ST1 | UNITED ST5 | 1992 |   67942502 |
  619. | UNITED ST5 | UNITED ST8 | 1992 |   67756106 |
  620. | UNITED ST2 | UNITED ST7 | 1992 |   67405558 |
  621. | UNITED ST8 | UNITED ST3 | 1992 |   61898648 |
  622. | UNITED ST8 | UNITED ST8 | 1992 |   58618216 |
  623. | UNITED ST5 | UNITED ST5 | 1992 |   58559136 |
  624. | UNITED ST1 | UNITED ST8 | 1992 |   57131158 |
  625. | UNITED ST9 | UNITED ST5 | 1992 |   56150008 |
  626. | UNITED ST2 | UNITED ST6 | 1992 |   55627478 |
  627. | UNITED ST0 | UNITED ST2 | 1992 |   55437466 |
  628. | UNITED ST2 | UNITED ST2 | 1992 |   51487308 |
  629. | UNITED ST8 | UNITED ST9 | 1992 |   45368942 |
  630. | UNITED ST4 | UNITED ST8 | 1992 |   43856884 |
  631. | UNITED ST9 | UNITED ST8 | 1992 |   42772200 |
  632. | UNITED ST5 | UNITED ST2 | 1992 |   40991634 |
  633. | UNITED ST6 | UNITED ST6 | 1992 |   36274210 |
  634. | UNITED ST9 | UNITED ST6 | 1992 |   31759136 |
  635. | UNITED ST4 | UNITED ST2 | 1992 |   24123690 |
  636. | UNITED ST7 | UNITED ST8 | 1992 |   23791404 |
  637. | UNITED ST6 | UNITED ST2 | 1992 |   23641396 |
  638. | UNITED ST9 | UNITED ST2 | 1992 |   23246354 |
  639. | UNITED ST8 | UNITED ST2 | 1992 |   21943122 |
  640. | UNITED ST1 | UNITED ST2 | 1992 |   15413456 |
  641. | UNITED ST7 | UNITED ST2 | 1992 |    9886408 |
  642. | UNITED ST3 | UNITED ST2 | 1992 |    2194416 |
  643. | UNITED ST0 | UNITED ST9 | 1993 |  219668080 |
  644. | UNITED ST7 | UNITED ST0 | 1993 |  219576048 |
  645. | UNITED ST5 | UNITED ST0 | 1993 |  213645194 |
  646. | UNITED ST0 | UNITED ST0 | 1993 |  213485096 |
  647. | UNITED ST1 | UNITED ST0 | 1993 |  198611904 |
  648. | UNITED ST4 | UNITED ST4 | 1993 |  196300930 |
  649. | UNITED ST3 | UNITED ST4 | 1993 |  184987840 |
  650. | UNITED ST0 | UNITED ST1 | 1993 |  182393186 |
  651. | UNITED ST4 | UNITED ST1 | 1993 |  177042846 |
  652. | UNITED ST8 | UNITED ST0 | 1993 |  176712742 |
  653. | UNITED ST4 | UNITED ST7 | 1993 |  176344396 |
  654. | UNITED ST4 | UNITED ST0 | 1993 |  173836916 |
  655. | UNITED ST6 | UNITED ST3 | 1993 |  166834322 |
  656. | UNITED ST6 | UNITED ST1 | 1993 |  166691878 |
  657. | UNITED ST7 | UNITED ST9 | 1993 |  160621402 |
  658. | UNITED ST3 | UNITED ST1 | 1993 |  156460556 |
  659. | UNITED ST6 | UNITED ST7 | 1993 |  156394588 |
  660. | UNITED ST5 | UNITED ST9 | 1993 |  152573078 |
  661. | UNITED ST0 | UNITED ST3 | 1993 |  152342566 |
  662. | UNITED ST5 | UNITED ST8 | 1993 |  148718558 |
  663. | UNITED ST9 | UNITED ST1 | 1993 |  148118838 |
  664. | UNITED ST4 | UNITED ST9 | 1993 |  146593918 |
  665. | UNITED ST5 | UNITED ST1 | 1993 |  142909246 |
  666. | UNITED ST6 | UNITED ST4 | 1993 |  139293826 |
  667. | UNITED ST2 | UNITED ST1 | 1993 |  139263402 |
  668. | UNITED ST6 | UNITED ST0 | 1993 |  136495078 |
  669. | UNITED ST7 | UNITED ST7 | 1993 |  136219640 |
  670. | UNITED ST2 | UNITED ST3 | 1993 |  133944876 |
  671. | UNITED ST3 | UNITED ST0 | 1993 |  133253852 |
  672. | UNITED ST9 | UNITED ST7 | 1993 |  133250966 |
  673. | UNITED ST1 | UNITED ST8 | 1993 |  132292396 |
  674. | UNITED ST2 | UNITED ST7 | 1993 |  128370028 |
  675. | UNITED ST5 | UNITED ST4 | 1993 |  126831278 |
  676. | UNITED ST9 | UNITED ST9 | 1993 |  126521526 |
  677. | UNITED ST1 | UNITED ST4 | 1993 |  125768694 |
  678. | UNITED ST7 | UNITED ST4 | 1993 |  123313226 |
  679. | UNITED ST3 | UNITED ST6 | 1993 |  117169616 |
  680. | UNITED ST2 | UNITED ST4 | 1993 |  113300782 |
  681. | UNITED ST3 | UNITED ST5 | 1993 |  111814610 |
  682. | UNITED ST6 | UNITED ST9 | 1993 |  109801884 |
  683. | UNITED ST1 | UNITED ST7 | 1993 |  109702366 |
  684. | UNITED ST3 | UNITED ST9 | 1993 |  109525192 |
  685. | UNITED ST8 | UNITED ST6 | 1993 |  109266124 |
  686. | UNITED ST8 | UNITED ST3 | 1993 |  108099748 |
  687. | UNITED ST5 | UNITED ST7 | 1993 |  105491076 |
  688. | UNITED ST0 | UNITED ST5 | 1993 |  105402104 |
  689. | UNITED ST1 | UNITED ST9 | 1993 |  105029804 |
  690. | UNITED ST8 | UNITED ST5 | 1993 |  104475674 |
  691. | UNITED ST1 | UNITED ST3 | 1993 |  104195892 |
  692. | UNITED ST8 | UNITED ST4 | 1993 |  102838712 |
  693. | UNITED ST0 | UNITED ST6 | 1993 |  100864564 |
  694. | UNITED ST5 | UNITED ST5 | 1993 |  100714378 |
  695. | UNITED ST3 | UNITED ST7 | 1993 |  100270896 |
  696. | UNITED ST0 | UNITED ST4 | 1993 |   98520134 |
  697. | UNITED ST0 | UNITED ST7 | 1993 |   97592720 |
  698. | UNITED ST2 | UNITED ST9 | 1993 |   96377014 |
  699. | UNITED ST1 | UNITED ST1 | 1993 |   95077220 |
  700. | UNITED ST9 | UNITED ST3 | 1993 |   93887294 |
  701. | UNITED ST7 | UNITED ST5 | 1993 |   89527384 |
  702. | UNITED ST1 | UNITED ST6 | 1993 |   89457080 |
  703. | UNITED ST8 | UNITED ST1 | 1993 |   88830868 |
  704. | UNITED ST7 | UNITED ST8 | 1993 |   87805256 |
  705. | UNITED ST9 | UNITED ST6 | 1993 |   87734320 |
  706. | UNITED ST2 | UNITED ST0 | 1993 |   85690970 |
  707. | UNITED ST3 | UNITED ST8 | 1993 |   84503696 |
  708. | UNITED ST0 | UNITED ST8 | 1993 |   84005364 |
  709. | UNITED ST4 | UNITED ST8 | 1993 |   83315164 |
  710. | UNITED ST1 | UNITED ST5 | 1993 |   81387026 |
  711. | UNITED ST9 | UNITED ST5 | 1993 |   79370538 |
  712. | UNITED ST7 | UNITED ST3 | 1993 |   79047722 |
  713. | UNITED ST8 | UNITED ST8 | 1993 |   77580470 |
  714. | UNITED ST8 | UNITED ST9 | 1993 |   77032722 |
  715. | UNITED ST2 | UNITED ST5 | 1993 |   74813690 |
  716. | UNITED ST9 | UNITED ST8 | 1993 |   74369392 |
  717. | UNITED ST8 | UNITED ST7 | 1993 |   73804436 |
  718. | UNITED ST6 | UNITED ST8 | 1993 |   72913482 |
  719. | UNITED ST7 | UNITED ST1 | 1993 |   68782318 |
  720. | UNITED ST6 | UNITED ST5 | 1993 |   68458164 |
  721. | UNITED ST5 | UNITED ST3 | 1993 |   68063622 |
  722. | UNITED ST2 | UNITED ST8 | 1993 |   66890892 |
  723. | UNITED ST4 | UNITED ST3 | 1993 |   66258824 |
  724. | UNITED ST6 | UNITED ST6 | 1993 |   66101326 |
  725. | UNITED ST9 | UNITED ST0 | 1993 |   65306610 |
  726. | UNITED ST4 | UNITED ST6 | 1993 |   61398510 |
  727. | UNITED ST9 | UNITED ST4 | 1993 |   61289374 |
  728. | UNITED ST4 | UNITED ST5 | 1993 |   58239188 |
  729. | UNITED ST7 | UNITED ST6 | 1993 |   54201004 |
  730. | UNITED ST4 | UNITED ST2 | 1993 |   54025356 |
  731. | UNITED ST2 | UNITED ST6 | 1993 |   52964452 |
  732. | UNITED ST5 | UNITED ST6 | 1993 |   50715358 |
  733. | UNITED ST3 | UNITED ST3 | 1993 |   43554288 |
  734. | UNITED ST3 | UNITED ST2 | 1993 |   43118146 |
  735. | UNITED ST5 | UNITED ST2 | 1993 |   41220484 |
  736. | UNITED ST7 | UNITED ST2 | 1993 |   40438608 |
  737. | UNITED ST6 | UNITED ST2 | 1993 |   37628734 |
  738. | UNITED ST9 | UNITED ST2 | 1993 |   35436780 |
  739. | UNITED ST1 | UNITED ST2 | 1993 |   33689076 |
  740. | UNITED ST0 | UNITED ST2 | 1993 |   30084290 |
  741. | UNITED ST2 | UNITED ST2 | 1993 |   29043990 |
  742. | UNITED ST8 | UNITED ST2 | 1993 |   19968732 |
  743. | UNITED ST8 | UNITED ST0 | 1994 |  198441578 |
  744. | UNITED ST3 | UNITED ST9 | 1994 |  194952370 |
  745. | UNITED ST6 | UNITED ST1 | 1994 |  193874294 |
  746. | UNITED ST6 | UNITED ST9 | 1994 |  189366618 |
  747. | UNITED ST9 | UNITED ST1 | 1994 |  180881896 |
  748. | UNITED ST0 | UNITED ST9 | 1994 |  179730404 |
  749. | UNITED ST5 | UNITED ST7 | 1994 |  178179922 |
  750. | UNITED ST9 | UNITED ST0 | 1994 |  175341146 |
  751. | UNITED ST3 | UNITED ST1 | 1994 |  171047306 |
  752. | UNITED ST4 | UNITED ST9 | 1994 |  167644786 |
  753. | UNITED ST0 | UNITED ST0 | 1994 |  167053754 |
  754. | UNITED ST7 | UNITED ST0 | 1994 |  164531072 |
  755. | UNITED ST2 | UNITED ST1 | 1994 |  162600178 |
  756. | UNITED ST5 | UNITED ST0 | 1994 |  157296114 |
  757. | UNITED ST4 | UNITED ST7 | 1994 |  153908280 |
  758. | UNITED ST4 | UNITED ST4 | 1994 |  153674762 |
  759. | UNITED ST0 | UNITED ST1 | 1994 |  153226758 |
  760. | UNITED ST1 | UNITED ST3 | 1994 |  151984918 |
  761. | UNITED ST7 | UNITED ST1 | 1994 |  150641598 |
  762. | UNITED ST4 | UNITED ST0 | 1994 |  147438680 |
  763. | UNITED ST5 | UNITED ST1 | 1994 |  147016836 |
  764. | UNITED ST4 | UNITED ST1 | 1994 |  144439114 |
  765. | UNITED ST2 | UNITED ST9 | 1994 |  139342108 |
  766. | UNITED ST6 | UNITED ST5 | 1994 |  132923068 |
  767. | UNITED ST2 | UNITED ST3 | 1994 |  131241520 |
  768. | UNITED ST3 | UNITED ST0 | 1994 |  131045454 |
  769. | UNITED ST5 | UNITED ST3 | 1994 |  130669822 |
  770. | UNITED ST7 | UNITED ST4 | 1994 |  129557430 |
  771. | UNITED ST3 | UNITED ST4 | 1994 |  126824730 |
  772. | UNITED ST8 | UNITED ST4 | 1994 |  124283362 |
  773. | UNITED ST0 | UNITED ST4 | 1994 |  123039488 |
  774. | UNITED ST0 | UNITED ST7 | 1994 |  122961640 |
  775. | UNITED ST0 | UNITED ST6 | 1994 |  122577556 |
  776. | UNITED ST2 | UNITED ST0 | 1994 |  120364306 |
  777. | UNITED ST6 | UNITED ST4 | 1994 |  119659978 |
  778. | UNITED ST4 | UNITED ST5 | 1994 |  118794056 |
  779. | UNITED ST8 | UNITED ST9 | 1994 |  117333812 |
  780. | UNITED ST4 | UNITED ST6 | 1994 |  117266964 |
  781. | UNITED ST5 | UNITED ST5 | 1994 |  112470426 |
  782. | UNITED ST6 | UNITED ST3 | 1994 |  112246476 |
  783. | UNITED ST2 | UNITED ST4 | 1994 |  111358754 |
  784. | UNITED ST8 | UNITED ST3 | 1994 |  110407682 |
  785. | UNITED ST1 | UNITED ST1 | 1994 |  108766348 |
  786. | UNITED ST1 | UNITED ST7 | 1994 |  107706212 |
  787. | UNITED ST6 | UNITED ST0 | 1994 |  107457706 |
  788. | UNITED ST5 | UNITED ST9 | 1994 |  106734662 |
  789. | UNITED ST9 | UNITED ST9 | 1994 |  103961698 |
  790. | UNITED ST5 | UNITED ST4 | 1994 |  103599186 |
  791. | UNITED ST7 | UNITED ST9 | 1994 |  100288170 |
  792. | UNITED ST7 | UNITED ST7 | 1994 |   92892884 |
  793. | UNITED ST6 | UNITED ST6 | 1994 |   92399444 |
  794. | UNITED ST7 | UNITED ST5 | 1994 |   91790728 |
  795. | UNITED ST3 | UNITED ST3 | 1994 |   91254306 |
  796. | UNITED ST8 | UNITED ST5 | 1994 |   89106112 |
  797. | UNITED ST9 | UNITED ST4 | 1994 |   87821522 |
  798. | UNITED ST1 | UNITED ST0 | 1994 |   86450402 |
  799. | UNITED ST1 | UNITED ST9 | 1994 |   86000074 |
  800. | UNITED ST7 | UNITED ST8 | 1994 |   85552934 |
  801. | UNITED ST0 | UNITED ST5 | 1994 |   83616602 |
  802. | UNITED ST2 | UNITED ST6 | 1994 |   83052210 |
  803. | UNITED ST1 | UNITED ST4 | 1994 |   82763116 |
  804. | UNITED ST3 | UNITED ST7 | 1994 |   81870262 |
  805. | UNITED ST8 | UNITED ST1 | 1994 |   80304192 |
  806. | UNITED ST9 | UNITED ST8 | 1994 |   78557616 |
  807. | UNITED ST5 | UNITED ST6 | 1994 |   77316902 |
  808. | UNITED ST2 | UNITED ST5 | 1994 |   75280634 |
  809. | UNITED ST8 | UNITED ST7 | 1994 |   75201374 |
  810. | UNITED ST9 | UNITED ST5 | 1994 |   74293452 |
  811. | UNITED ST6 | UNITED ST7 | 1994 |   74115616 |
  812. | UNITED ST8 | UNITED ST6 | 1994 |   73553138 |
  813. | UNITED ST3 | UNITED ST6 | 1994 |   72580514 |
  814. | UNITED ST9 | UNITED ST3 | 1994 |   71693000 |
  815. | UNITED ST2 | UNITED ST8 | 1994 |   67535548 |
  816. | UNITED ST0 | UNITED ST8 | 1994 |   63690866 |
  817. | UNITED ST4 | UNITED ST3 | 1994 |   63198866 |
  818. | UNITED ST9 | UNITED ST7 | 1994 |   63172346 |
  819. | UNITED ST1 | UNITED ST6 | 1994 |   62574652 |
  820. | UNITED ST1 | UNITED ST8 | 1994 |   60490306 |
  821. | UNITED ST7 | UNITED ST3 | 1994 |   58849680 |
  822. | UNITED ST9 | UNITED ST6 | 1994 |   58425854 |
  823. | UNITED ST0 | UNITED ST3 | 1994 |   54655658 |
  824. | UNITED ST6 | UNITED ST8 | 1994 |   53185992 |
  825. | UNITED ST3 | UNITED ST5 | 1994 |   52395750 |
  826. | UNITED ST6 | UNITED ST2 | 1994 |   51618000 |
  827. | UNITED ST1 | UNITED ST5 | 1994 |   49878276 |
  828. | UNITED ST7 | UNITED ST6 | 1994 |   49263874 |
  829. | UNITED ST1 | UNITED ST2 | 1994 |   47113172 |
  830. | UNITED ST4 | UNITED ST2 | 1994 |   46071784 |
  831. | UNITED ST2 | UNITED ST7 | 1994 |   44365516 |
  832. | UNITED ST0 | UNITED ST2 | 1994 |   44035908 |
  833. | UNITED ST4 | UNITED ST8 | 1994 |   41370704 |
  834. | UNITED ST7 | UNITED ST2 | 1994 |   39310162 |
  835. | UNITED ST5 | UNITED ST8 | 1994 |   37863782 |
  836. | UNITED ST2 | UNITED ST2 | 1994 |   36137314 |
  837. | UNITED ST3 | UNITED ST8 | 1994 |   31872102 |
  838. | UNITED ST8 | UNITED ST8 | 1994 |   20046824 |
  839. | UNITED ST3 | UNITED ST2 | 1994 |   19990468 |
  840. | UNITED ST9 | UNITED ST2 | 1994 |   19401978 |
  841. | UNITED ST5 | UNITED ST2 | 1994 |   14325592 |
  842. | UNITED ST8 | UNITED ST2 | 1994 |    7579252 |
  843. | UNITED ST5 | UNITED ST1 | 1995 |  239587338 |
  844. | UNITED ST4 | UNITED ST9 | 1995 |  198980136 |
  845. | UNITED ST7 | UNITED ST0 | 1995 |  196062590 |
  846. | UNITED ST6 | UNITED ST0 | 1995 |  183436942 |
  847. | UNITED ST4 | UNITED ST1 | 1995 |  181757306 |
  848. | UNITED ST0 | UNITED ST1 | 1995 |  181527198 |
  849. | UNITED ST8 | UNITED ST9 | 1995 |  177710178 |
  850. | UNITED ST7 | UNITED ST7 | 1995 |  173143248 |
  851. | UNITED ST3 | UNITED ST0 | 1995 |  168925466 |
  852. | UNITED ST9 | UNITED ST1 | 1995 |  165877934 |
  853. | UNITED ST2 | UNITED ST4 | 1995 |  164864610 |
  854. | UNITED ST1 | UNITED ST0 | 1995 |  163353246 |
  855. | UNITED ST5 | UNITED ST4 | 1995 |  162033522 |
  856. | UNITED ST7 | UNITED ST1 | 1995 |  159928724 |
  857. | UNITED ST5 | UNITED ST3 | 1995 |  156198260 |
  858. | UNITED ST5 | UNITED ST0 | 1995 |  155231492 |
  859. | UNITED ST9 | UNITED ST9 | 1995 |  153031916 |
  860. | UNITED ST7 | UNITED ST9 | 1995 |  150635418 |
  861. | UNITED ST4 | UNITED ST4 | 1995 |  149174142 |
  862. | UNITED ST9 | UNITED ST4 | 1995 |  145051372 |
  863. | UNITED ST1 | UNITED ST9 | 1995 |  144941740 |
  864. | UNITED ST4 | UNITED ST7 | 1995 |  138528814 |
  865. | UNITED ST6 | UNITED ST3 | 1995 |  135026124 |
  866. | UNITED ST2 | UNITED ST3 | 1995 |  130436258 |
  867. | UNITED ST2 | UNITED ST9 | 1995 |  130110356 |
  868. | UNITED ST7 | UNITED ST6 | 1995 |  130041342 |
  869. | UNITED ST3 | UNITED ST1 | 1995 |  129525630 |
  870. | UNITED ST1 | UNITED ST1 | 1995 |  128398664 |
  871. | UNITED ST6 | UNITED ST9 | 1995 |  126914210 |
  872. | UNITED ST0 | UNITED ST9 | 1995 |  126506998 |
  873. | UNITED ST5 | UNITED ST9 | 1995 |  124729794 |
  874. | UNITED ST4 | UNITED ST5 | 1995 |  124163010 |
  875. | UNITED ST1 | UNITED ST7 | 1995 |  123031482 |
  876. | UNITED ST2 | UNITED ST7 | 1995 |  120000416 |
  877. | UNITED ST8 | UNITED ST6 | 1995 |  117980808 |
  878. | UNITED ST1 | UNITED ST4 | 1995 |  115071198 |
  879. | UNITED ST0 | UNITED ST3 | 1995 |  112721416 |
  880. | UNITED ST8 | UNITED ST0 | 1995 |  110463328 |
  881. | UNITED ST5 | UNITED ST7 | 1995 |  107481518 |
  882. | UNITED ST2 | UNITED ST0 | 1995 |  105121676 |
  883. | UNITED ST3 | UNITED ST7 | 1995 |  103159096 |
  884. | UNITED ST9 | UNITED ST0 | 1995 |  103097242 |
  885. | UNITED ST6 | UNITED ST6 | 1995 |  101909354 |
  886. | UNITED ST5 | UNITED ST5 | 1995 |  100788014 |
  887. | UNITED ST7 | UNITED ST4 | 1995 |   99799090 |
  888. | UNITED ST3 | UNITED ST3 | 1995 |   96316178 |
  889. | UNITED ST6 | UNITED ST4 | 1995 |   95394482 |
  890. | UNITED ST9 | UNITED ST7 | 1995 |   92929178 |
  891. | UNITED ST4 | UNITED ST0 | 1995 |   92285798 |
  892. | UNITED ST1 | UNITED ST3 | 1995 |   91646112 |
  893. | UNITED ST2 | UNITED ST1 | 1995 |   90874680 |
  894. | UNITED ST6 | UNITED ST5 | 1995 |   90856304 |
  895. | UNITED ST8 | UNITED ST5 | 1995 |   89989726 |
  896. | UNITED ST7 | UNITED ST3 | 1995 |   87399468 |
  897. | UNITED ST9 | UNITED ST6 | 1995 |   86964988 |
  898. | UNITED ST2 | UNITED ST5 | 1995 |   86764834 |
  899. | UNITED ST6 | UNITED ST8 | 1995 |   83947840 |
  900. | UNITED ST0 | UNITED ST6 | 1995 |   81437884 |
  901. | UNITED ST3 | UNITED ST5 | 1995 |   80115630 |
  902. | UNITED ST7 | UNITED ST5 | 1995 |   78030586 |
  903. | UNITED ST0 | UNITED ST0 | 1995 |   77969004 |
  904. | UNITED ST6 | UNITED ST1 | 1995 |   76656704 |
  905. | UNITED ST4 | UNITED ST6 | 1995 |   76219048 |
  906. | UNITED ST3 | UNITED ST9 | 1995 |   74729246 |
  907. | UNITED ST4 | UNITED ST3 | 1995 |   74712792 |
  908. | UNITED ST2 | UNITED ST6 | 1995 |   74292576 |
  909. | UNITED ST9 | UNITED ST5 | 1995 |   72019848 |
  910. | UNITED ST1 | UNITED ST8 | 1995 |   69837586 |
  911. | UNITED ST8 | UNITED ST1 | 1995 |   68435560 |
  912. | UNITED ST0 | UNITED ST7 | 1995 |   66790626 |
  913. | UNITED ST1 | UNITED ST5 | 1995 |   63714904 |
  914. | UNITED ST8 | UNITED ST7 | 1995 |   61836404 |
  915. | UNITED ST2 | UNITED ST8 | 1995 |   61008378 |
  916. | UNITED ST3 | UNITED ST4 | 1995 |   60844692 |
  917. | UNITED ST5 | UNITED ST6 | 1995 |   60409474 |
  918. | UNITED ST8 | UNITED ST3 | 1995 |   58699876 |
  919. | UNITED ST0 | UNITED ST4 | 1995 |   58340076 |
  920. | UNITED ST1 | UNITED ST6 | 1995 |   54278806 |
  921. | UNITED ST7 | UNITED ST8 | 1995 |   52888980 |
  922. | UNITED ST6 | UNITED ST7 | 1995 |   47667954 |
  923. | UNITED ST4 | UNITED ST8 | 1995 |   46106472 |
  924. | UNITED ST4 | UNITED ST2 | 1995 |   45574006 |
  925. | UNITED ST3 | UNITED ST8 | 1995 |   45010478 |
  926. | UNITED ST9 | UNITED ST8 | 1995 |   42585054 |
  927. | UNITED ST8 | UNITED ST4 | 1995 |   38574622 |
  928. | UNITED ST8 | UNITED ST2 | 1995 |   36565980 |
  929. | UNITED ST9 | UNITED ST3 | 1995 |   35078204 |
  930. | UNITED ST3 | UNITED ST6 | 1995 |   33477060 |
  931. | UNITED ST0 | UNITED ST8 | 1995 |   32786498 |
  932. | UNITED ST5 | UNITED ST2 | 1995 |   29902046 |
  933. | UNITED ST2 | UNITED ST2 | 1995 |   26910062 |
  934. | UNITED ST5 | UNITED ST8 | 1995 |   26693864 |
  935. | UNITED ST3 | UNITED ST2 | 1995 |   25773658 |
  936. | UNITED ST9 | UNITED ST2 | 1995 |   25306724 |
  937. | UNITED ST0 | UNITED ST5 | 1995 |   22907418 |
  938. | UNITED ST6 | UNITED ST2 | 1995 |   22727102 |
  939. | UNITED ST8 | UNITED ST8 | 1995 |   22571734 |
  940. | UNITED ST1 | UNITED ST2 | 1995 |   15983352 |
  941. | UNITED ST0 | UNITED ST2 | 1995 |    9552920 |
  942. | UNITED ST7 | UNITED ST2 | 1995 |    7947130 |
  943. | UNITED ST6 | UNITED ST0 | 1996 |  264573526 |
  944. | UNITED ST4 | UNITED ST0 | 1996 |  213795126 |
  945. | UNITED ST5 | UNITED ST0 | 1996 |  209003958 |
  946. | UNITED ST0 | UNITED ST4 | 1996 |  206457498 |
  947. | UNITED ST9 | UNITED ST1 | 1996 |  203967654 |
  948. | UNITED ST1 | UNITED ST0 | 1996 |  189723108 |
  949. | UNITED ST0 | UNITED ST1 | 1996 |  183897554 |
  950. | UNITED ST6 | UNITED ST1 | 1996 |  179411740 |
  951. | UNITED ST2 | UNITED ST1 | 1996 |  176512310 |
  952. | UNITED ST1 | UNITED ST1 | 1996 |  174531696 |
  953. | UNITED ST4 | UNITED ST7 | 1996 |  167355628 |
  954. | UNITED ST6 | UNITED ST3 | 1996 |  164336458 |
  955. | UNITED ST2 | UNITED ST7 | 1996 |  160936954 |
  956. | UNITED ST8 | UNITED ST1 | 1996 |  157943512 |
  957. | UNITED ST7 | UNITED ST4 | 1996 |  155882022 |
  958. | UNITED ST1 | UNITED ST3 | 1996 |  155221810 |
  959. | UNITED ST9 | UNITED ST9 | 1996 |  154603480 |
  960. | UNITED ST0 | UNITED ST9 | 1996 |  151870418 |
  961. | UNITED ST7 | UNITED ST0 | 1996 |  151204890 |
  962. | UNITED ST3 | UNITED ST1 | 1996 |  149493398 |
  963. | UNITED ST7 | UNITED ST7 | 1996 |  148081288 |
  964. | UNITED ST4 | UNITED ST1 | 1996 |  145639734 |
  965. | UNITED ST5 | UNITED ST9 | 1996 |  145228228 |
  966. | UNITED ST1 | UNITED ST9 | 1996 |  139647538 |
  967. | UNITED ST9 | UNITED ST4 | 1996 |  139233228 |
  968. | UNITED ST6 | UNITED ST4 | 1996 |  138592010 |
  969. | UNITED ST2 | UNITED ST0 | 1996 |  134190244 |
  970. | UNITED ST5 | UNITED ST1 | 1996 |  130692778 |
  971. | UNITED ST6 | UNITED ST9 | 1996 |  126512364 |
  972. | UNITED ST4 | UNITED ST6 | 1996 |  124378656 |
  973. | UNITED ST0 | UNITED ST0 | 1996 |  123057710 |
  974. | UNITED ST8 | UNITED ST9 | 1996 |  120933382 |
  975. | UNITED ST3 | UNITED ST0 | 1996 |  120453680 |
  976. | UNITED ST8 | UNITED ST6 | 1996 |  119493310 |
  977. | UNITED ST2 | UNITED ST3 | 1996 |  119297196 |
  978. | UNITED ST0 | UNITED ST5 | 1996 |  115525790 |
  979. | UNITED ST8 | UNITED ST7 | 1996 |  115047850 |
  980. | UNITED ST2 | UNITED ST4 | 1996 |  114974114 |
  981. | UNITED ST6 | UNITED ST7 | 1996 |  114181238 |
  982. | UNITED ST3 | UNITED ST4 | 1996 |  109676518 |
  983. | UNITED ST4 | UNITED ST9 | 1996 |  108269680 |
  984. | UNITED ST1 | UNITED ST6 | 1996 |  108112732 |
  985. | UNITED ST3 | UNITED ST7 | 1996 |  107974436 |
  986. | UNITED ST2 | UNITED ST9 | 1996 |  106982830 |
  987. | UNITED ST4 | UNITED ST8 | 1996 |  106071324 |
  988. | UNITED ST9 | UNITED ST5 | 1996 |  105651844 |
  989. | UNITED ST7 | UNITED ST3 | 1996 |  104713772 |
  990. | UNITED ST6 | UNITED ST8 | 1996 |  104273568 |
  991. | UNITED ST1 | UNITED ST5 | 1996 |  102379298 |
  992. | UNITED ST8 | UNITED ST4 | 1996 |  102066108 |
  993. | UNITED ST1 | UNITED ST4 | 1996 |  100271094 |
  994. | UNITED ST3 | UNITED ST9 | 1996 |   99224608 |
  995. | UNITED ST9 | UNITED ST0 | 1996 |   99181402 |
  996. | UNITED ST3 | UNITED ST3 | 1996 |   98527592 |
  997. | UNITED ST9 | UNITED ST7 | 1996 |   97597518 |
  998. | UNITED ST7 | UNITED ST1 | 1996 |   97568350 |
  999. | UNITED ST9 | UNITED ST6 | 1996 |   97370126 |
  1000. | UNITED ST2 | UNITED ST5 | 1996 |   94057952 |
  1001. | UNITED ST9 | UNITED ST3 | 1996 |   94042036 |
  1002. | UNITED ST2 | UNITED ST8 | 1996 |   93730226 |
  1003. | UNITED ST4 | UNITED ST3 | 1996 |   92921880 |
  1004. | UNITED ST6 | UNITED ST5 | 1996 |   92060208 |
  1005. | UNITED ST2 | UNITED ST6 | 1996 |   90833298 |
  1006. | UNITED ST8 | UNITED ST5 | 1996 |   86960946 |
  1007. | UNITED ST5 | UNITED ST5 | 1996 |   86041444 |
  1008. | UNITED ST6 | UNITED ST6 | 1996 |   85846064 |
  1009. | UNITED ST4 | UNITED ST5 | 1996 |   85616824 |
  1010. | UNITED ST3 | UNITED ST6 | 1996 |   83763256 |
  1011. | UNITED ST1 | UNITED ST7 | 1996 |   83443012 |
  1012. | UNITED ST5 | UNITED ST7 | 1996 |   81892660 |
  1013. | UNITED ST8 | UNITED ST0 | 1996 |   79690854 |
  1014. | UNITED ST8 | UNITED ST3 | 1996 |   79071880 |
  1015. | UNITED ST1 | UNITED ST8 | 1996 |   78861764 |
  1016. | UNITED ST5 | UNITED ST6 | 1996 |   76664088 |
  1017. | UNITED ST0 | UNITED ST6 | 1996 |   74464124 |
  1018. | UNITED ST7 | UNITED ST6 | 1996 |   73071256 |
  1019. | UNITED ST9 | UNITED ST8 | 1996 |   72224602 |
  1020. | UNITED ST3 | UNITED ST8 | 1996 |   67849464 |
  1021. | UNITED ST3 | UNITED ST5 | 1996 |   67434878 |
  1022. | UNITED ST5 | UNITED ST4 | 1996 |   66849718 |
  1023. | UNITED ST5 | UNITED ST3 | 1996 |   65839852 |
  1024. | UNITED ST4 | UNITED ST4 | 1996 |   65575990 |
  1025. | UNITED ST7 | UNITED ST5 | 1996 |   65568448 |
  1026. | UNITED ST5 | UNITED ST8 | 1996 |   64831364 |
  1027. | UNITED ST0 | UNITED ST7 | 1996 |   62782362 |
  1028. | UNITED ST0 | UNITED ST3 | 1996 |   59591330 |
  1029. | UNITED ST7 | UNITED ST9 | 1996 |   50056182 |
  1030. | UNITED ST7 | UNITED ST8 | 1996 |   48697702 |
  1031. | UNITED ST6 | UNITED ST2 | 1996 |   40895694 |
  1032. | UNITED ST8 | UNITED ST8 | 1996 |   32681206 |
  1033. | UNITED ST0 | UNITED ST8 | 1996 |   30336524 |
  1034. | UNITED ST4 | UNITED ST2 | 1996 |   24903734 |
  1035. | UNITED ST1 | UNITED ST2 | 1996 |   20165072 |
  1036. | UNITED ST5 | UNITED ST2 | 1996 |   17088466 |
  1037. | UNITED ST7 | UNITED ST2 | 1996 |   16780940 |
  1038. | UNITED ST9 | UNITED ST2 | 1996 |   16216070 |
  1039. | UNITED ST8 | UNITED ST2 | 1996 |   14056668 |
  1040. | UNITED ST0 | UNITED ST2 | 1996 |   13814398 |
  1041. | UNITED ST3 | UNITED ST2 | 1996 |    8623600 |
  1042. | UNITED ST5 | UNITED ST0 | 1997 |  242915532 |
  1043. | UNITED ST0 | UNITED ST9 | 1997 |  239712536 |
  1044. | UNITED ST5 | UNITED ST1 | 1997 |  213800322 |
  1045. | UNITED ST9 | UNITED ST9 | 1997 |  212445590 |
  1046. | UNITED ST5 | UNITED ST4 | 1997 |  206865854 |
  1047. | UNITED ST7 | UNITED ST1 | 1997 |  202653880 |
  1048. | UNITED ST5 | UNITED ST9 | 1997 |  194785280 |
  1049. | UNITED ST8 | UNITED ST0 | 1997 |  178869690 |
  1050. | UNITED ST1 | UNITED ST3 | 1997 |  170351276 |
  1051. | UNITED ST4 | UNITED ST1 | 1997 |  169222376 |
  1052. | UNITED ST4 | UNITED ST7 | 1997 |  169213992 |
  1053. | UNITED ST1 | UNITED ST4 | 1997 |  166185138 |
  1054. | UNITED ST0 | UNITED ST1 | 1997 |  160334278 |
  1055. | UNITED ST4 | UNITED ST9 | 1997 |  159395854 |
  1056. | UNITED ST1 | UNITED ST0 | 1997 |  155335732 |
  1057. | UNITED ST2 | UNITED ST0 | 1997 |  155182940 |
  1058. | UNITED ST1 | UNITED ST7 | 1997 |  154091444 |
  1059. | UNITED ST2 | UNITED ST7 | 1997 |  152967604 |
  1060. | UNITED ST1 | UNITED ST1 | 1997 |  152680888 |
  1061. | UNITED ST0 | UNITED ST7 | 1997 |  145154980 |
  1062. | UNITED ST4 | UNITED ST0 | 1997 |  139751608 |
  1063. | UNITED ST6 | UNITED ST3 | 1997 |  139451012 |
  1064. | UNITED ST2 | UNITED ST9 | 1997 |  139087968 |
  1065. | UNITED ST7 | UNITED ST0 | 1997 |  138708624 |
  1066. | UNITED ST9 | UNITED ST7 | 1997 |  138105260 |
  1067. | UNITED ST8 | UNITED ST3 | 1997 |  133836788 |
  1068. | UNITED ST0 | UNITED ST0 | 1997 |  132617032 |
  1069. | UNITED ST9 | UNITED ST0 | 1997 |  132133582 |
  1070. | UNITED ST2 | UNITED ST3 | 1997 |  130858906 |
  1071. | UNITED ST2 | UNITED ST1 | 1997 |  130792270 |
  1072. | UNITED ST4 | UNITED ST4 | 1997 |  125064692 |
  1073. | UNITED ST9 | UNITED ST1 | 1997 |  124836812 |
  1074. | UNITED ST3 | UNITED ST7 | 1997 |  122190600 |
  1075. | UNITED ST7 | UNITED ST4 | 1997 |  120246988 |
  1076. | UNITED ST4 | UNITED ST3 | 1997 |  119268306 |
  1077. | UNITED ST3 | UNITED ST4 | 1997 |  116712282 |
  1078. | UNITED ST6 | UNITED ST9 | 1997 |  116462526 |
  1079. | UNITED ST6 | UNITED ST4 | 1997 |  114430044 |
  1080. | UNITED ST2 | UNITED ST4 | 1997 |  114025222 |
  1081. | UNITED ST5 | UNITED ST3 | 1997 |  113579864 |
  1082. | UNITED ST9 | UNITED ST5 | 1997 |  112183840 |
  1083. | UNITED ST6 | UNITED ST0 | 1997 |  111649838 |
  1084. | UNITED ST6 | UNITED ST1 | 1997 |  110235418 |
  1085. | UNITED ST7 | UNITED ST9 | 1997 |  110079940 |
  1086. | UNITED ST5 | UNITED ST7 | 1997 |  109068630 |
  1087. | UNITED ST3 | UNITED ST1 | 1997 |  108301366 |
  1088. | UNITED ST3 | UNITED ST0 | 1997 |  108100344 |
  1089. | UNITED ST3 | UNITED ST9 | 1997 |  102740616 |
  1090. | UNITED ST1 | UNITED ST5 | 1997 |  102104220 |
  1091. | UNITED ST6 | UNITED ST7 | 1997 |   99591698 |
  1092. | UNITED ST5 | UNITED ST6 | 1997 |   98060032 |
  1093. | UNITED ST1 | UNITED ST9 | 1997 |   97888222 |
  1094. | UNITED ST3 | UNITED ST3 | 1997 |   96770466 |
  1095. | UNITED ST0 | UNITED ST5 | 1997 |   95976836 |
  1096. | UNITED ST2 | UNITED ST8 | 1997 |   92783818 |
  1097. | UNITED ST4 | UNITED ST6 | 1997 |   92473698 |
  1098. | UNITED ST9 | UNITED ST3 | 1997 |   92243448 |
  1099. | UNITED ST8 | UNITED ST9 | 1997 |   91705592 |
  1100. | UNITED ST7 | UNITED ST8 | 1997 |   90952532 |
  1101. | UNITED ST8 | UNITED ST1 | 1997 |   86568278 |
  1102. | UNITED ST7 | UNITED ST7 | 1997 |   85133206 |
  1103. | UNITED ST0 | UNITED ST4 | 1997 |   82387606 |
  1104. | UNITED ST8 | UNITED ST7 | 1997 |   81756858 |
  1105. | UNITED ST8 | UNITED ST8 | 1997 |   81498800 |
  1106. | UNITED ST2 | UNITED ST5 | 1997 |   81325772 |
  1107. | UNITED ST0 | UNITED ST3 | 1997 |   80157016 |
  1108. | UNITED ST6 | UNITED ST8 | 1997 |   75976890 |
  1109. | UNITED ST9 | UNITED ST6 | 1997 |   75193764 |
  1110. | UNITED ST6 | UNITED ST5 | 1997 |   75143576 |
  1111. | UNITED ST2 | UNITED ST2 | 1997 |   74068666 |
  1112. | UNITED ST7 | UNITED ST5 | 1997 |   73779472 |
  1113. | UNITED ST8 | UNITED ST4 | 1997 |   73201168 |
  1114. | UNITED ST3 | UNITED ST6 | 1997 |   72151688 |
  1115. | UNITED ST7 | UNITED ST3 | 1997 |   70337844 |
  1116. | UNITED ST2 | UNITED ST6 | 1997 |   68548934 |
  1117. | UNITED ST5 | UNITED ST8 | 1997 |   65821892 |
  1118. | UNITED ST3 | UNITED ST5 | 1997 |   65623926 |
  1119. | UNITED ST4 | UNITED ST8 | 1997 |   65199472 |
  1120. | UNITED ST5 | UNITED ST5 | 1997 |   65137776 |
  1121. | UNITED ST4 | UNITED ST5 | 1997 |   63991736 |
  1122. | UNITED ST9 | UNITED ST4 | 1997 |   63530956 |
  1123. | UNITED ST7 | UNITED ST2 | 1997 |   62819180 |
  1124. | UNITED ST9 | UNITED ST8 | 1997 |   62544770 |
  1125. | UNITED ST0 | UNITED ST8 | 1997 |   60482740 |
  1126. | UNITED ST3 | UNITED ST8 | 1997 |   58204440 |
  1127. | UNITED ST7 | UNITED ST6 | 1997 |   55079862 |
  1128. | UNITED ST8 | UNITED ST5 | 1997 |   53347486 |
  1129. | UNITED ST6 | UNITED ST6 | 1997 |   49966582 |
  1130. | UNITED ST0 | UNITED ST2 | 1997 |   47168458 |
  1131. | UNITED ST0 | UNITED ST6 | 1997 |   45848092 |
  1132. | UNITED ST1 | UNITED ST2 | 1997 |   41198260 |
  1133. | UNITED ST8 | UNITED ST6 | 1997 |   40146000 |
  1134. | UNITED ST1 | UNITED ST6 | 1997 |   36410652 |
  1135. | UNITED ST1 | UNITED ST8 | 1997 |   30750516 |
  1136. | UNITED ST6 | UNITED ST2 | 1997 |   29493360 |
  1137. | UNITED ST5 | UNITED ST2 | 1997 |   27726876 |
  1138. | UNITED ST8 | UNITED ST2 | 1997 |   24107412 |
  1139. | UNITED ST3 | UNITED ST2 | 1997 |   15783756 |
  1140. | UNITED ST4 | UNITED ST2 | 1997 |    5696314 |
  1141. | UNITED ST9 | UNITED ST2 | 1997 |    5323304 |
  1142. +------------+------------+------+------------+
  1144. -- Q3.3
  1145. +------------+------------+------+------------+
  1146. | c_city     | s_city     | year | lo_revenue |
  1147. +------------+------------+------+------------+
  1148. | UNITED KI1 | UNITED KI1 | 1992 |   93471990 |
  1149. | UNITED KI5 | UNITED KI1 | 1992 |   72554110 |
  1150. | UNITED KI5 | UNITED KI5 | 1992 |   50710534 |
  1151. | UNITED KI1 | UNITED KI5 | 1992 |   43835692 |
  1152. | UNITED KI5 | UNITED KI1 | 1993 |  122035214 |
  1153. | UNITED KI1 | UNITED KI1 | 1993 |   91339070 |
  1154. | UNITED KI5 | UNITED KI5 | 1993 |   68198784 |
  1155. | UNITED KI1 | UNITED KI5 | 1993 |   42888412 |
  1156. | UNITED KI5 | UNITED KI1 | 1994 |   72564326 |
  1157. | UNITED KI1 | UNITED KI1 | 1994 |   69736882 |
  1158. | UNITED KI5 | UNITED KI5 | 1994 |   69014568 |
  1159. | UNITED KI1 | UNITED KI5 | 1994 |   42443560 |
  1160. | UNITED KI5 | UNITED KI1 | 1995 |  165911792 |
  1161. | UNITED KI1 | UNITED KI1 | 1995 |   71762372 |
  1162. | UNITED KI5 | UNITED KI5 | 1995 |   41079610 |
  1163. | UNITED KI1 | UNITED KI5 | 1995 |   34353020 |
  1164. | UNITED KI5 | UNITED KI1 | 1996 |  131534098 |
  1165. | UNITED KI1 | UNITED KI1 | 1996 |  119846074 |
  1166. | UNITED KI5 | UNITED KI5 | 1996 |   92154684 |
  1167. | UNITED KI1 | UNITED KI5 | 1996 |   27400508 |
  1168. | UNITED KI1 | UNITED KI1 | 1997 |  140686266 |
  1169. | UNITED KI5 | UNITED KI1 | 1997 |  129956718 |
  1170. | UNITED KI5 | UNITED KI5 | 1997 |   54664054 |
  1171. | UNITED KI1 | UNITED KI5 | 1997 |   32821336 |
  1172. +------------+------------+------+------------+
  1174. -- Q3.4
  1175. +------------+------------+------+------------+
  1176. | c_city     | s_city     | year | lo_revenue |
  1177. +------------+------------+------+------------+
  1178. | UNITED KI5 | UNITED KI1 | 1997 |   18235692 |
  1179. | UNITED KI5 | UNITED KI5 | 1997 |   12407602 |
  1180. | UNITED KI1 | UNITED KI5 | 1997 |    3740140 |
  1181. +------------+------------+------+------------+
  1183. -- Q4.1
  1184. +------+---------------+-------------+
  1185. | year | c_nation      | profit      |
  1186. +------+---------------+-------------+
  1187. | 1992 | ARGENTINA     | 19317928938 |
  1188. | 1992 | BRAZIL        | 18453966110 |
  1189. | 1992 | CANADA        | 19286353574 |
  1190. | 1992 | PERU          | 18821353194 |
  1191. | 1992 | UNITED STATES | 19698855306 |
  1192. | 1993 | ARGENTINA     | 19952665706 |
  1193. | 1993 | BRAZIL        | 18937598458 |
  1194. | 1993 | CANADA        | 19794604840 |
  1195. | 1993 | PERU          | 18618891672 |
  1196. | 1993 | UNITED STATES | 20007970172 |
  1197. | 1994 | ARGENTINA     | 19880610430 |
  1198. | 1994 | BRAZIL        | 18697303354 |
  1199. | 1994 | CANADA        | 19165295192 |
  1200. | 1994 | PERU          | 18590530026 |
  1201. | 1994 | UNITED STATES | 19039760850 |
  1202. | 1995 | ARGENTINA     | 20287682760 |
  1203. | 1995 | BRAZIL        | 18312154700 |
  1204. | 1995 | CANADA        | 19125224320 |
  1205. | 1995 | PERU          | 19556174422 |
  1206. | 1995 | UNITED STATES | 18621130488 |
  1207. | 1996 | ARGENTINA     | 20003855790 |
  1208. | 1996 | BRAZIL        | 18336970302 |
  1209. | 1996 | CANADA        | 20123208406 |
  1210. | 1996 | PERU          | 18710271348 |
  1211. | 1996 | UNITED STATES | 19539424348 |
  1212. | 1997 | ARGENTINA     | 19709120522 |
  1213. | 1997 | BRAZIL        | 18243142094 |
  1214. | 1997 | CANADA        | 20194743556 |
  1215. | 1997 | PERU          | 18631051834 |
  1216. | 1997 | UNITED STATES | 21013447758 |
  1217. | 1998 | ARGENTINA     | 11668480814 |
  1218. | 1998 | BRAZIL        | 10712796190 |
  1219. | 1998 | CANADA        | 10846422392 |
  1220. | 1998 | PERU          | 11452371940 |
  1221. | 1998 | UNITED STATES | 12018924038 |
  1222. +------+---------------+-------------+
  1224. -- Q4.2
  1225. +------+---------------+------------+------------+
  1226. | year | s_nation      | p_category | profit     |
  1227. +------+---------------+------------+------------+
  1228. | 1997 | ARGENTINA     | MFGR#11    | 1814143132 |
  1229. | 1997 | ARGENTINA     | MFGR#12    | 1848231124 |
  1230. | 1997 | ARGENTINA     | MFGR#13    | 1945723642 |
  1231. | 1997 | ARGENTINA     | MFGR#14    | 1950820690 |
  1232. | 1997 | ARGENTINA     | MFGR#15    | 1877734750 |
  1233. | 1997 | ARGENTINA     | MFGR#21    | 2029565148 |
  1234. | 1997 | ARGENTINA     | MFGR#22    | 1746033566 |
  1235. | 1997 | ARGENTINA     | MFGR#23    | 2060714604 |
  1236. | 1997 | ARGENTINA     | MFGR#24    | 1786921158 |
  1237. | 1997 | ARGENTINA     | MFGR#25    | 2012622806 |
  1238. | 1997 | BRAZIL        | MFGR#11    | 2146438656 |
  1239. | 1997 | BRAZIL        | MFGR#12    | 1979717666 |
  1240. | 1997 | BRAZIL        | MFGR#13    | 2256960758 |
  1241. | 1997 | BRAZIL        | MFGR#14    | 2388513444 |
  1242. | 1997 | BRAZIL        | MFGR#15    | 2188838248 |
  1243. | 1997 | BRAZIL        | MFGR#21    | 1820053664 |
  1244. | 1997 | BRAZIL        | MFGR#22    | 1986284096 |
  1245. | 1997 | BRAZIL        | MFGR#23    | 2215345748 |
  1246. | 1997 | BRAZIL        | MFGR#24    | 2116027298 |
  1247. | 1997 | BRAZIL        | MFGR#25    | 1989467528 |
  1248. | 1997 | CANADA        | MFGR#11    | 1709450040 |
  1249. | 1997 | CANADA        | MFGR#12    | 1877436328 |
  1250. | 1997 | CANADA        | MFGR#13    | 1918531780 |
  1251. | 1997 | CANADA        | MFGR#14    | 2005624900 |
  1252. | 1997 | CANADA        | MFGR#15    | 1696366026 |
  1253. | 1997 | CANADA        | MFGR#21    | 1999610544 |
  1254. | 1997 | CANADA        | MFGR#22    | 1556839526 |
  1255. | 1997 | CANADA        | MFGR#23    | 1856719290 |
  1256. | 1997 | CANADA        | MFGR#24    | 1699790256 |
  1257. | 1997 | CANADA        | MFGR#25    | 1809175930 |
  1258. | 1997 | PERU          | MFGR#11    | 2200485754 |
  1259. | 1997 | PERU          | MFGR#12    | 1988730700 |
  1260. | 1997 | PERU          | MFGR#13    | 1694972210 |
  1261. | 1997 | PERU          | MFGR#14    | 1895539366 |
  1262. | 1997 | PERU          | MFGR#15    | 1998791356 |
  1263. | 1997 | PERU          | MFGR#21    | 1735846788 |
  1264. | 1997 | PERU          | MFGR#22    | 1977494918 |
  1265. | 1997 | PERU          | MFGR#23    | 2133290172 |
  1266. | 1997 | PERU          | MFGR#24    | 1871331450 |
  1267. | 1997 | PERU          | MFGR#25    | 1962908258 |
  1268. | 1997 | UNITED STATES | MFGR#11    | 2093412096 |
  1269. | 1997 | UNITED STATES | MFGR#12    | 1818427418 |
  1270. | 1997 | UNITED STATES | MFGR#13    | 2192557812 |
  1271. | 1997 | UNITED STATES | MFGR#14    | 1868564222 |
  1272. | 1997 | UNITED STATES | MFGR#15    | 1925521686 |
  1273. | 1997 | UNITED STATES | MFGR#21    | 2001352948 |
  1274. | 1997 | UNITED STATES | MFGR#22    | 2153895230 |
  1275. | 1997 | UNITED STATES | MFGR#23    | 1874576204 |
  1276. | 1997 | UNITED STATES | MFGR#24    | 2006772726 |
  1277. | 1997 | UNITED STATES | MFGR#25    | 2107332104 |
  1278. | 1998 | ARGENTINA     | MFGR#11    | 1135224454 |
  1279. | 1998 | ARGENTINA     | MFGR#12    | 1054050084 |
  1280. | 1998 | ARGENTINA     | MFGR#13    | 1165583584 |
  1281. | 1998 | ARGENTINA     | MFGR#14    | 1047452736 |
  1282. | 1998 | ARGENTINA     | MFGR#15    | 1044156534 |
  1283. | 1998 | ARGENTINA     | MFGR#21    | 1009425370 |
  1284. | 1998 | ARGENTINA     | MFGR#22    | 1012123472 |
  1285. | 1998 | ARGENTINA     | MFGR#23    | 1120959602 |
  1286. | 1998 | ARGENTINA     | MFGR#24    | 1049158236 |
  1287. | 1998 | ARGENTINA     | MFGR#25    | 1095680422 |
  1288. | 1998 | BRAZIL        | MFGR#11    | 1277156976 |
  1289. | 1998 | BRAZIL        | MFGR#12    | 1292625362 |
  1290. | 1998 | BRAZIL        | MFGR#13    | 1310323544 |
  1291. | 1998 | BRAZIL        | MFGR#14    | 1105352340 |
  1292. | 1998 | BRAZIL        | MFGR#15    | 1327625418 |
  1293. | 1998 | BRAZIL        | MFGR#21    | 1337644896 |
  1294. | 1998 | BRAZIL        | MFGR#22    | 1183583836 |
  1295. | 1998 | BRAZIL        | MFGR#23    | 1381297754 |
  1296. | 1998 | BRAZIL        | MFGR#24    | 1124724440 |
  1297. | 1998 | BRAZIL        | MFGR#25    | 1408364752 |
  1298. | 1998 | CANADA        | MFGR#11    | 1018172250 |
  1299. | 1998 | CANADA        | MFGR#12    |  976179544 |
  1300. | 1998 | CANADA        | MFGR#13    |  973066594 |
  1301. | 1998 | CANADA        | MFGR#14    | 1055674454 |
  1302. | 1998 | CANADA        | MFGR#15    | 1071738598 |
  1303. | 1998 | CANADA        | MFGR#21    |  911737302 |
  1304. | 1998 | CANADA        | MFGR#22    | 1188554616 |
  1305. | 1998 | CANADA        | MFGR#23    | 1148250140 |
  1306. | 1998 | CANADA        | MFGR#24    | 1017060848 |
  1307. | 1998 | CANADA        | MFGR#25    | 1095515984 |
  1308. | 1998 | PERU          | MFGR#11    | 1135677094 |
  1309. | 1998 | PERU          | MFGR#12    | 1081089514 |
  1310. | 1998 | PERU          | MFGR#13    | 1182663766 |
  1311. | 1998 | PERU          | MFGR#14    |  962670128 |
  1312. | 1998 | PERU          | MFGR#15    | 1140492276 |
  1313. | 1998 | PERU          | MFGR#21    | 1067466660 |
  1314. | 1998 | PERU          | MFGR#22    | 1055581312 |
  1315. | 1998 | PERU          | MFGR#23    | 1272786442 |
  1316. | 1998 | PERU          | MFGR#24    | 1178150524 |
  1317. | 1998 | PERU          | MFGR#25    | 1086502230 |
  1318. | 1998 | UNITED STATES | MFGR#11    | 1112552464 |
  1319. | 1998 | UNITED STATES | MFGR#12    | 1224771964 |
  1320. | 1998 | UNITED STATES | MFGR#13    | 1244827854 |
  1321. | 1998 | UNITED STATES | MFGR#14    | 1110013774 |
  1322. | 1998 | UNITED STATES | MFGR#15    | 1050239138 |
  1323. | 1998 | UNITED STATES | MFGR#21    | 1126813672 |
  1324. | 1998 | UNITED STATES | MFGR#22    | 1160957470 |
  1325. | 1998 | UNITED STATES | MFGR#23    | 1312160930 |
  1326. | 1998 | UNITED STATES | MFGR#24    | 1076890116 |
  1327. | 1998 | UNITED STATES | MFGR#25    | 1178223904 |
  1328. +------+---------------+------------+------------+
  1330. -- Q4.3
  1331. +------+------------+-----------+---------------+
  1332. | year | s_city     | p_brand   | profit        |
  1333. +------+------------+-----------+---------------+
  1334. | 1997 | UNITED ST1 | MFGR#1414 | 10001830.0000 |
  1335. | 1997 | UNITED ST1 | MFGR#147  | 13643806.0000 |
  1336. | 1997 | UNITED ST9 | MFGR#144  |  4953914.0000 |
  1337. | 1998 | UNITED ST0 | MFGR#1424 | 14202690.0000 |
  1338. | 1998 | UNITED ST5 | MFGR#1430 |  7742358.0000 |
  1339. +------+------------+-----------+---------------+
  1340. 5 rows in set (0.25 sec)