完成 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 1dbgen 命令会生产近 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;
  9. create table lineorder (
  10. lo_orderkey bigint,
  11. lo_linenumber int,
  12. lo_custkey int,
  13. lo_partkey int,
  14. lo_suppkey int,
  15. lo_orderdate date,
  16. lo_orderpriority char (15),
  17. lo_shippriority tinyint,
  18. lo_quantity double,
  19. lo_extendedprice double,
  20. lo_ordtotalprice double,
  21. lo_discount double,
  22. lo_revenue double,
  23. lo_supplycost double,
  24. lo_tax double,
  25. lo_commitdate date,
  26. lo_shipmode char (10)
  27. ) ;
  28. create table part (
  29. p_partkey int,
  30. p_name varchar (22),
  31. p_mfgr char (6),
  32. p_category char (7),
  33. p_brand char (9),
  34. p_color varchar (11),
  35. p_type varchar (25),
  36. p_size int,
  37. p_container char (10)
  38. ) ;
  39. create table supplier (
  40. s_suppkey int,
  41. s_name char (25),
  42. s_address varchar (25),
  43. s_city char (10),
  44. s_nation char (15),
  45. s_region char (12),
  46. s_phone char (15)
  47. ) ;
  48. create table customer (
  49. c_custkey int,
  50. c_name varchar (25),
  51. c_address varchar (25),
  52. c_city char (10),
  53. c_nation char (15),
  54. c_region char (12),
  55. c_phone char (15),
  56. c_mktsegment char (10)
  57. ) ;
  58. create table date (
  59. d_datekey date,
  60. d_date char (18),
  61. d_dayofweek char (9),
  62. d_month char (9),
  63. d_year int,
  64. d_yearmonthnum int,
  65. d_yearmonth char (7),
  66. d_daynuminweek varchar(12),
  67. d_daynuminmonth int,
  68. d_daynuminyear int,
  69. d_monthnuminyear int,
  70. d_weeknuminyear int,
  71. d_sellingseason varchar (12),
  72. d_lastdayinweekfl varchar (1),
  73. d_lastdayinmonthfl varchar (1),
  74. d_holidayfl varchar (1),
  75. d_weekdayfl varchar (1)
  76. ) ;
  77. CREATE TABLE lineorder_flat(
  78. LO_ORDERKEY bigint key,
  79. LO_LINENUMBER int,
  80. LO_CUSTKEY int,
  81. LO_PARTKEY int,
  82. LO_SUPPKEY int,
  83. LO_ORDERDATE date,
  84. LO_ORDERPRIORITY char(15),
  85. LO_SHIPPRIORITY tinyint,
  86. LO_QUANTITY double,
  87. LO_EXTENDEDPRICE double,
  88. LO_ORDTOTALPRICE double,
  89. LO_DISCOUNT double,
  90. LO_REVENUE int unsigned,
  91. LO_SUPPLYCOST int unsigned,
  92. LO_TAX double,
  93. LO_COMMITDATE date,
  94. LO_SHIPMODE char(10),
  95. C_NAME varchar(25),
  96. C_ADDRESS varchar(25),
  97. C_CITY char(10),
  98. C_NATION char(15),
  99. C_REGION char(12),
  100. C_PHONE char(15),
  101. C_MKTSEGMENT char(10),
  102. S_NAME char(25),
  103. S_ADDRESS varchar(25),
  104. S_CITY char(10),
  105. S_NATION char(15),
  106. S_REGION char(12),
  107. S_PHONE char(15),
  108. P_NAME varchar(22),
  109. P_MFGR char(6),
  110. P_CATEGORY char(7),
  111. P_BRAND char(9),
  112. P_COLOR varchar(11),
  113. P_TYPE varchar(25),
  114. P_SIZE int,
  115. P_CONTAINER char(10)
  116. );

4. 导入数据

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

  1. load data infile '/ssb-dbgen-path/supplier.tbl' into table supplier FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';
  2. load data infile '/ssb-dbgen-path/customer.tbl' into table customer FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';
  3. load data infile '/ssb-dbgen-path/date.tbl' into table date FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';
  4. load data infile '/ssb-dbgen-path/part.tbl' into table part FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n';
  5. 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;
  3. --Q1.2
  4. 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;
  5. --Q1.3
  6. 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;
  7. --Q2.1
  8. 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;
  9. --Q2.2
  10. 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;
  11. --Q2.3
  12. 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;
  13. --Q3.1
  14. 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;
  15. --Q3.2
  16. 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;
  17. --Q3.3
  18. 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;
  19. --Q3.4
  20. 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;
  21. --Q4.1
  22. 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;
  23. --Q4.2
  24. 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;
  25. --Q4.3
  26. 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;
  5. --Q1.2
  6. select sum(lo_revenue) as revenue
  7. from lineorder
  8. join date on lo_orderdate = d_datekey
  9. where d_yearmonthnum = 199401
  10. and lo_discount between 4 and 6
  11. and lo_quantity between 26 and 35;
  12. --Q1.3
  13. select sum(lo_revenue) as revenue
  14. from lineorder
  15. join date on lo_orderdate = d_datekey
  16. where d_weeknuminyear = 6 and year(d_datekey) = 1994
  17. and lo_discount between 5 and 7
  18. and lo_quantity between 26 and 35;
  19. --Q2.1
  20. select sum(lo_revenue) as lo_revenue, year(d_datekey) as year, p_brand
  21. from lineorder
  22. join date on lo_orderdate = d_datekey
  23. join part on lo_partkey = p_partkey
  24. join supplier on lo_suppkey = s_suppkey
  25. where p_category = 'MFGR#12' and s_region = 'AMERICA'
  26. group by year(d_datekey), p_brand
  27. order by year, p_brand;
  28. --Q2.2
  29. select sum(lo_revenue) as lo_revenue, year(d_datekey) as year, p_brand
  30. from lineorder
  31. join date on lo_orderdate = d_datekey
  32. join part on lo_partkey = p_partkey
  33. join supplier on lo_suppkey = s_suppkey
  34. where p_brand between 'MFGR#2221' and 'MFGR#2228' and s_region = 'ASIA'
  35. group by year(d_datekey), p_brand
  36. order by year, p_brand;
  37. --Q2.3
  38. select sum(lo_revenue) as lo_revenue, year(d_datekey) as year, p_brand
  39. from lineorder
  40. join date on lo_orderdate = d_datekey
  41. join part on lo_partkey = p_partkey
  42. join supplier on lo_suppkey = s_suppkey
  43. where p_brand = 'MFGR#2239' and s_region = 'EUROPE'
  44. group by year(d_datekey), p_brand
  45. order by year, p_brand;
  46. --Q3.1
  47. select c_nation, s_nation, year(d_datekey) as year, sum(lo_revenue) as lo_revenue
  48. from lineorder
  49. join date on lo_orderdate = d_datekey
  50. join customer on lo_custkey = c_custkey
  51. join supplier on lo_suppkey = s_suppkey
  52. where c_region = 'ASIA' and s_region = 'ASIA' and year(d_datekey) between 1992 and 1997
  53. group by c_nation, s_nation, year(d_datekey)
  54. order by year asc, lo_revenue desc;
  55. --Q3.2
  56. select c_city, s_city, year(d_datekey) as year, sum(lo_revenue) as lo_revenue
  57. from lineorder
  58. join date on lo_orderdate = d_datekey
  59. join customer on lo_custkey = c_custkey
  60. join supplier on lo_suppkey = s_suppkey
  61. where c_nation = 'UNITED STATES' and s_nation = 'UNITED STATES'
  62. and year(d_datekey) between 1992 and 1997
  63. group by c_city, s_city, year(d_datekey)
  64. order by year asc, lo_revenue desc;
  65. --Q3.3
  66. select c_city, s_city, year(d_datekey) as year, sum(lo_revenue) as lo_revenue
  67. from lineorder
  68. join date on lo_orderdate = d_datekey
  69. join customer on lo_custkey = c_custkey
  70. join supplier on lo_suppkey = s_suppkey
  71. where (c_city='UNITED KI1' or c_city='UNITED KI5')
  72. and (s_city='UNITED KI1' or s_city='UNITED KI5')
  73. and year(d_datekey) between 1992 and 1997
  74. group by c_city, s_city, year(d_datekey)
  75. order by year asc, lo_revenue desc;
  76. --Q3.4
  77. select c_city, s_city, year(d_datekey) as year, sum(lo_revenue) as lo_revenue
  78. from lineorder
  79. join date on lo_orderdate = d_datekey
  80. join customer on lo_custkey = c_custkey
  81. join supplier on lo_suppkey = s_suppkey
  82. where (c_city='UNITED KI1' or c_city='UNITED KI5') and (s_city='UNITED KI1' or s_city='UNITED KI5') and d_yearmonth = '199712'
  83. group by c_city, s_city, year(d_datekey)
  84. order by year(d_datekey) asc, lo_revenue desc;
  85. --Q4.1
  86. select year(d_datekey) as year, c_nation, sum(lo_revenue) - sum(lo_supplycost) as profit
  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. join part on lo_partkey = p_partkey
  92. where c_region = 'AMERICA' and s_region = 'AMERICA' and (p_mfgr = 'MFGR#1' or p_mfgr = 'MFGR#2')
  93. group by year(d_datekey), c_nation
  94. order by year, c_nation;
  95. --Q4.2
  96. select year(d_datekey) as year, s_nation, p_category, 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'
  103. and (year(d_datekey) = 1997 or year(d_datekey) = 1998)
  104. and (p_mfgr = 'MFGR#1' or p_mfgr = 'MFGR#2')
  105. group by year(d_datekey), s_nation, p_category
  106. order by year, s_nation, p_category;
  107. --Q4.3
  108. select year(d_datekey) as year, s_city, p_brand, sum(lo_revenue) - sum(lo_supplycost) as profit
  109. from lineorder
  110. join dates on lo_orderdate = d_datekey
  111. join customer on lo_custkey = c_custkey
  112. join supplier on lo_suppkey = s_suppkey
  113. join part on lo_partkey = p_partkey
  114. where
  115. (year(d_datekey) = 1997 or year(d_datekey) = 1998)
  116. and c_region = 'AMERICA'
  117. and s_nation = 'UNITED STATES'
  118. and p_category = 'MFGR#14'
  119. group by year, s_city, p_brand
  120. order by year, s_city, p_brand;

6. 运行预期结果

单表查询运行预期结果

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

多表查询运行预期结果

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