设为首页收藏本站
开启辅助访问 切换到窄版
搜索
第一问答网»论坛 › 中问网 › 问答 › 在linux安装infobright

在linux安装infobright

[复制链接]
查看11 | 回复9 | 2012-5-21 10:19:41 | 显示全部楼层 |阅读模式
Last login: Sun Jan 30 12:04:46 2011 from 10.6.132.43
[root@redflag11012501 ~]# cd /user1/app/oradata
[root@redflag11012501 oradata]# rpm -ivh infobright-3.4.2-p2-x86_64-eval.rpm
Preparing...
########################################### [100%]
Installing infobright 3.4.2 (x86_64_eval)
The installer will generate /tmp/ib3.4.2-install.log install trace log.
1:infobright
########################################### [100%]
Creating/Updating datadir and cachedir
Creating user mysql and group mysql
Installing default databases
Installing MySQL system tables...
OK
Filling help tables...
OK
To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/local/infobright-3.4.2-x86_64/bin/mysqladmin -u root password 'new-password'
/usr/local/infobright-3.4.2-x86_64/bin/mysqladmin -u root -h redflag11012501 password 'new-password'
Alternatively you can run:
/usr/local/infobright-3.4.2-x86_64/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default.This is
strongly recommended for production servers.
See the manual for more instructions.
You can start the MySQL daemon with:
cd /usr/local/infobright-3.4.2-x86_64 ; /usr/local/infobright-3.4.2-x86_64/bin/mysqld_safe &
You can test the MySQL daemon with mysql-test-run.pl
cd /usr/local/infobright-3.4.2-x86_64/mysql-test ; perl mysql-test-run.pl
Please report any problems with the /usr/local/infobright-3.4.2-x86_64/scripts/mysqlbug script!
The latest information about MySQL is available at http://www.mysql.com/
Support MySQL by buying support/licenses from http://shop.mysql.com/
System Physical memory: 100723(MB)
Infobright optimal ServerMainHeapSize is set to 32000(MB)
Infobright optimal LoaderMainHeapSize is set to 800(MB)
Infobright server installed into folder /usr/local/infobright
Installation log file /tmp/ib3.4.2-install.log
Installation of 3.4.2 completed!
[root@redflag11012501 oradata]#
回复

使用道具 举报

千问 | 2012-5-21 10:19:41 | 显示全部楼层
[root@redflag11012501 ~]# cp /user1/app/oradata/*lic /usr/local/infobright-3.4.2-x86_64/
[root@redflag11012501 ~]# /etc/init.d/mysqld-ib start
Starting MySQL.[确定]
[root@redflag11012501 ~]# /usr/bin/mysql-ib
Welcome to the MySQL monitor.Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.40-log build number (revision)=IB_3.4.2_DPN128_9237(iee_eval - commercial)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> create database tpch;
Query OK, 1 row affected (0.00 sec)
mysql> use tpch;
Database changed
mysql>
mysql> CREATE TABLE NATION( N_NATIONKEYINTEGER NOT NULL,
N_NAME CHAR(25) NOT NULL,
N_REGIONKEYINTEGER NOT NULL,
N_COMMENTVARCHAR(152));
Query OK, 0 rows affected (0.01 sec)
mysql> show create table nation;
ERROR 1146 (42S02): Table 'tpch.nation' doesn't exist
mysql> show create table NATION;
+--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table| Create Table

|
+--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| NATION | CREATE TABLE `NATION` (
`N_NATIONKEY` int(11) NOT NULL,
`N_NAME` char(25) COLLATE latin1_bin NOT NULL,
`N_REGIONKEY` int(11) NOT NULL,
`N_COMMENT` varchar(152) COLLATE latin1_bin DEFAULT NULL
) ENGINE=BRIGHTHOUSE DEFAULT CHARSET=latin1 COLLATE=latin1_bin |
+--------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

[root@redflag11012501 ~]# cat /user1/app/oradata/tmp/nation.tbl
0|ALGERIA|0| haggle. carefully final deposits detect slyly agai|
1|ARGENTINA|1|al foxes promise slyly according to the regular accounts. bold requests alon|
2|BRAZIL|1|y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special |
3|CANADA|1|eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold|
4|EGYPT|4|y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d|
5|ETHIOPIA|0|ven packages wake quickly. regu|
6|FRANCE|3|refully final requests. regular, ironi|
7|GERMANY|3|l platelets. regular accounts x-ray: unusual, regular acco|
8|INDIA|2|ss excuses cajole slyly across the packages. deposits print aroun|
9|INDONESIA|2| slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull|
10|IRAN|4|efully alongside of the slyly final dependencies. |
11|IRAQ|4|nic deposits boost atop the quickly final requests? quickly regula|
12|JAPAN|2|ously. final, express gifts cajole a|
13|JORDAN|4|ic deposits are blithely about the carefully regular pa|
14|KENYA|0| pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t|
15|MOROCCO|0|rns. blithely bold courts among the closely regular packages use furiously bold platelets?|
16|MOZAMBIQUE|0|s. ironic, unusual asymptotes wake blithely r|
17|PERU|1|platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun|
18|CHINA|2|c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos|
19|ROMANIA|3|ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account|
20|SAUDI ARABIA|4|ts. silent requests haggle. closely express packages sleep across the blithely|
21|VIETNAM|2|hely enticingly express accounts. even, final |
22|RUSSIA|3| requests against the platelets use never according to the quickly regular pint|
23|UNITED KINGDOM|3|eans boost carefully special requests. accounts are. carefull|
24|UNITED STATES|1|y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be|
[root@redflag11012501 ~]# /usr/bin/mysql-ib
Welcome to the MySQL monitor.Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.1.40-log build number (revision)=IB_3.4.2_DPN128_9237(iee_eval - commercial)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
mysql> use tpch
Database changed
mysql> truncate table NATION;
Query OK, 0 rows affected (0.00 sec)
mysql> load data infile '/user1/app/oradata/tmp/nation.tbl' into table NATION fields terminated by '|' lines terminated by '|\n';
Query OK, 25 rows affected (0.01 sec)
Records: 25Deleted: 0Skipped: 0Warnings: 0
mysql> select * from NATION;
+-------------+----------------+-------------+--------------------------------------------------------------------------------------------------------------------+
| N_NATIONKEY | N_NAME | N_REGIONKEY | N_COMMENT
|
+-------------+----------------+-------------+--------------------------------------------------------------------------------------------------------------------+
| 0 | ALGERIA| 0 |haggle. carefully final deposits detect slyly agai
|
| 1 | ARGENTINA| 1 | al foxes promise slyly according to the regular accounts. bold requests alon
|
| 2 | BRAZIL | 1 | y alongside of the pending deposits. carefully special packages are about the ironic forges. slyly special |
| 3 | CANADA | 1 | eas hang ironic, silent packages. slyly regular packages are furiously over the tithes. fluffily bold
|
| 4 | EGYPT
| 4 | y above the carefully unusual theodolites. final dugouts are quickly across the furiously regular d
|
| 5 | ETHIOPIA | 0 | ven packages wake quickly. regu
|
| 6 | FRANCE | 3 | refully final requests. regular, ironi
|
| 7 | GERMANY| 3 | l platelets. regular accounts x-ray: unusual, regular acco
|
| 8 | INDIA
| 2 | ss excuses cajole slyly across the packages. deposits print aroun
|
| 9 | INDONESIA| 2 |slyly express asymptotes. regular deposits haggle slyly. carefully ironic hockey players sleep blithely. carefull |
|
10 | IRAN | 4 | efully alongside of the slyly final dependencies.
|
|
11 | IRAQ | 4 | nic deposits boost atop the quickly final requests? quickly regula
|
|
12 | JAPAN
| 2 | ously. final, express gifts cajole a
|
|
13 | JORDAN | 4 | ic deposits are blithely about the carefully regular pa
|
|
14 | KENYA
| 0 |pending excuses haggle furiously deposits. pending, express pinto beans wake fluffily past t
|
|
15 | MOROCCO| 0 | rns. blithely bold courts among the closely regular packages use furiously bold platelets?
|
|
16 | MOZAMBIQUE | 0 | s. ironic, unusual asymptotes wake blithely r
|
|
17 | PERU | 1 | platelets. blithely pending dependencies use fluffily across the even pinto beans. carefully silent accoun |
|
18 | CHINA
| 2 | c dependencies. furiously express notornis sleep slyly regular accounts. ideas sleep. depos
|
|
19 | ROMANIA| 3 | ular asymptotes are about the furious multipliers. express dependencies nag above the ironically ironic account|
|
20 | SAUDI ARABIA | 4 | ts. silent requests haggle. closely express packages sleep across the blithely
|
|
21 | VIETNAM| 2 | hely enticingly express accounts. even, final
|
|
22 | RUSSIA | 3 |requests against the platelets use never according to the quickly regular pint
|
|
23 | UNITED KINGDOM | 3 | eans boost carefully special requests. accounts are. carefull
|
|
24 | UNITED STATES| 1 | y final packages. slow foxes cajole quickly. quickly silent platelets breach ironic accounts. unusual pinto be |
+-------------+----------------+-------------+--------------------------------------------------------------------------------------------------------------------+
25 rows in set (0.00 sec)
mysql>
回复

使用道具 举报

千问 | 2012-5-21 10:19:41 | 显示全部楼层
[root@redflag11012501 ~]# /usr/bin/mysql-ib
Welcome to the MySQL monitor.Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.1.40-log build number (revision)=IB_3.4.2_DPN128_9237(iee_eval - commercial)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use tpch
Database changed
mysql> CREATE TABLE REGION( R_REGIONKEYINTEGER NOT NULL,
R_NAME CHAR(25) NOT NULL,
R_COMMENTVARCHAR(152));CREATE TABLE PART( P_PARTKEY INTEGER NOT NULL,
P_NAMEVARCHAR(55) NOT NULL,
P_MFGRCHAR(25) NOT NULL,
P_BRAND CHAR(10) NOT NULL,
P_TYPEVARCHAR(25) NOT NULL,
P_SIZEINTEGER NOT NULL,
P_CONTAINER CHAR(10) NOT NULL,
P_RETAILPRICE DECIMAL(15,2) NOT NULL,
P_COMMENT VARCHAR(23) NOT NULL );CREATE TABLE SUPPLIER ( S_SUPPKEY INTEGER NOT NULL,
S_NAMECHAR(25) NOT NULL,
S_ADDRESS VARCHAR(40) NOT NULL,
S_NATIONKEY INTEGER NOT NULL,
S_PHONE CHAR(15) NOT NULL,
S_ACCTBAL DECIMAL(15,2) NOT NULL,
S_COMMENT VARCHAR(101) NOT NULL);CREATE TABLE PARTSUPP ( PS_PARTKEY INTEGER NOT NULL,
PS_SUPPKEY INTEGER NOT NULL,
PS_AVAILQTYINTEGER NOT NULL,
PS_SUPPLYCOSTDECIMAL(15,2)NOT NULL,
PS_COMMENT VARCHAR(199) NOT NULL );CREATE TABLE CUSTOMER ( C_CUSTKEY INTEGER NOT NULL,
C_NAMEVARCHAR(25) NOT NULL,
C_ADDRESS VARCHAR(40) NOT NULL,
C_NATIONKEY INTEGER NOT NULL,
C_PHONE CHAR(15) NOT NULL,
C_ACCTBAL DECIMAL(15,2) NOT NULL,
C_MKTSEGMENTCHAR(10) NOT NULL,
C_COMMENT VARCHAR(117) NOT NULL);CREATE TABLE ORDERS( O_ORDERKEY INTEGER NOT NULL,
O_CUSTKEYINTEGER NOT NULL,
O_ORDERSTATUSCHAR(1) NOT NULL,
O_TOTALPRICE DECIMAL(15,2) NOT NULL,
O_ORDERDATEDATE NOT NULL,
O_ORDERPRIORITYCHAR(15) NOT NULL,
O_CLERK
CHAR(15) NOT NULL,
O_SHIPPRIORITY INTEGER NOT NULL,
O_COMMENTVARCHAR(79) NOT NULL);CREATE TABLE LINEITEM ( L_ORDERKEYINTEGER NOT NULL,
L_PARTKEY INTEGER NOT NULL,
L_SUPPKEY INTEGER NOT NULL,
L_LINENUMBERINTEGER NOT NULL,
L_QUANTITYDECIMAL(15,2) NOT NULL,
L_EXTENDEDPRICEDECIMAL(15,2) NOT NULL,
L_DISCOUNTDECIMAL(15,2) NOT NULL,
L_TAX DECIMAL(15,2) NOT NULL,
L_RETURNFLAGCHAR(1) NOT NULL,
L_LINESTATUSCHAR(1) NOT NULL,
L_SHIPDATEDATE NOT NULL,
L_COMMITDATEDATE NOT NULL,
L_RECEIPTDATE DATE NOT NULL,
L_SHIPINSTRUCT CHAR(25) NOT NULL,
L_SHIPMODE CHAR(10) NOT NULL,
L_COMMENTVARCHAR(44) NOT NULL);
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.01 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
mysql> load data infile '/user1/app/oradata/tmp/lineitem.tbl' into table LINEITEM fields terminated by '|' lines terminated by '|\n';
Query aborted by Ctrl+C
ERROR 1317 (70100): Query execution was interrupted
mysql> set autocommit=off;
Query OK, 0 rows affected (0.00 sec)
mysql> truncate table LINEITEM;
Query OK, 0 rows affected (0.00 sec)
mysql> load data infile '/user1/app/oradata/tmp/lineitem.tbl' into table LINEITEM fields terminated by '|' lines terminated by '|\n';
Query OK, 6001215 rows affected (1 min 33.83 sec)
Records: 6001215Deleted: 0Skipped: 0Warnings: 0
mysql> commit;
Query OK, 0 rows affected (1.02 sec)
mysql> load data infile '/user1/app/oradata/tmp/customer.tbl' into table CUSTOMER fields terminated by '|' lines terminated by '|\n';
commit;
Query OK, 150000 rows affected (1.92 sec)
Records: 150000Deleted: 0Skipped: 0Warnings: 0
mysql> commit;
Query OK, 0 rows affected (1.64 sec)
mysql>
mysql> load data infile '/user1/app/oradata/tmp/orders.tbl' into table ORDERS fields terminated by '|' lines terminated by '|\n';
commit;
Query OK, 1500000 rows affected (20.29 sec)
Records: 1500000Deleted: 0Skipped: 0Warnings: 0
mysql> commit;
Query OK, 0 rows affected (1.57 sec)
mysql>
mysql> load data infile '/user1/app/oradata/tmp/partsupp.tbl' into table PARTSUPP fields terminated by '|' lines terminated by '|\n';
commit;
Query OK, 800000 rows affected (9.40 sec)
Records: 800000Deleted: 0Skipped: 0Warnings: 0
mysql> commit;
Query OK, 0 rows affected (3.73 sec)
mysql> load data infile '/user1/app/oradata/tmp/supplier.tbl' into table SUPPLIER fields terminated by '|' lines terminated by '|\n';
commit;
Query OK, 10000 rows affected (0.12 sec)
Records: 10000Deleted: 0Skipped: 0Warnings: 0
mysql> commit;
Query OK, 0 rows affected (0.22 sec)
mysql> load data infile '/user1/app/oradata/tmp/region.tbl' into table REGION fields terminated by '|' lines terminated by '|\n';
Query OK, 5 rows affected (0.00 sec)
Records: 5Deleted: 0Skipped: 0Warnings: 0
mysql> commit;
Query OK, 0 rows affected (0.02 sec)
mysql> load data infile '/user1/app/oradata/tmp/part.tbl' into table PART fields terminated by '|' lines terminated by '|\n';
commit;
Query OK, 200000 rows affected (2.60 sec)
Records: 200000Deleted: 0Skipped: 0Warnings: 0
mysql> commit;
Query OK, 0 rows affected (0.73 sec)
mysql>
回复

使用道具 举报

千问 | 2012-5-21 10:19:41 | 显示全部楼层

[root@redflag11012501 ~]# /usr/bin/mysql-ib
Welcome to the MySQL monitor.Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.1.40-log build number (revision)=IB_3.4.2_DPN128_9237(iee_eval - commercial)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use tpch;
Database changed
mysql> source /user1/app/oradata/tpc-h_orig21.sql
PROMPT set to '1'
+--------------+--------------+-------------+-----------------+-------------------+---------------------+-----------+--------------+
----------+-------------+
| L_RETURNFLAG | L_LINESTATUS | SUM_QTY | SUM_BASE_PRICE| SUM_DISC_PRICE| SUM_CHARGE
| AVG_QTY | AVG_PRICE|
AVG_DISC | COUNT_ORDER |
+--------------+--------------+-------------+-----------------+-------------------+---------------------+-----------+--------------+
----------+-------------+
| A
| F
| 37734107.00 |56586554400.73 |53758257134.8700 |55909065222.827692 | 25.522006 | 38273.129735 |
0.049985 | 1478493 |
| N
| F
| 991417.00 | 1487504710.38 | 1413082168.0541 | 1469649223.194375 | 25.516472 | 38284.467761 |
0.050093 | 38854 |
| N
| O
| 73477184.00 | 110203196620.51 | 104694637634.7276 | 108886216147.035144 | 25.502542 | 38249.446708 |
0.049996 | 2881171 |
| R
| F
| 37719753.00 |56568041380.90 |53741292684.6040 |55889619119.831932 | 25.505794 | 38250.854626 |
0.050009 | 1478870 |
+--------------+--------------+-------------+-----------------+-------------------+---------------------+-----------+--------------+
----------+-------------+
4 rows in set (29.63 sec)
PROMPT set to '2'
+-----------+--------------------+--------------+-----------+----------------+------------------------------------------+-----------
------+-----------------------------------------------------------------------------------------------------+
| S_ACCTBAL | S_NAME
| N_NAME | P_PARTKEY | P_MFGR | S_ADDRESS
| S_PHONE
| S_COMMENT
|
+-----------+--------------------+--------------+-----------+----------------+------------------------------------------+-----------
------+-----------------------------------------------------------------------------------------------------+
| 9977.32 | Supplier#000007895 | EGYPT|140352 | Manufacturer#2 | NYl,i8UhxTykLxGJ2voIRn20Ugk1KTzz | 14-559-808
-3306 | mptotes near the quickly sp
|
| 9956.34 | Supplier#000005108 | IRAN | 27601 | Manufacturer#3 | d3PLCdpPP3uE4GzbbAh4bWmU 7ecOifL9e1mNnzG | 20-842-882
-7047 | ronic accounts. carefully bold accounts sleep beyond
|
| 9956.34 | Supplier#000005108 | IRAN |170073 | Manufacturer#4 | d3PLCdpPP3uE4GzbbAh4bWmU 7ecOifL9e1mNnzG | 20-842-882
-7047 | ronic accounts. carefully bold accounts sleep beyond
|
| 9947.70 | Supplier#000009151 | IRAN | 54140 | Manufacturer#3 |25lLOrzuKU8mG0xGP2SLkfo6Kfew7Kb4YuRv| 20-492-750
-3318 | s. quickly unusual requests thrash furiou
|
| 9895.96 | Supplier#000002783 | IRAQ | 20280 | Manufacturer#4 | rc rAYfUYEGG95YWvE
| 21-174-613
-1836 | ronic foxes cajole slyly against the furiously regular platelets. slyly regular platele
|
| 9895.96 | Supplier#000002783 | IRAQ | 32782 | Manufacturer#4 | rc rAYfUYEGG95YWvE
| 21-174-613
-1836 | ronic foxes cajole slyly against the furiously regular platelets. slyly regular platele
|
| 9895.14 | Supplier#000006716 | JORDAN | 86715 | Manufacturer#3 | BJaPDjafIrQQlD4cP
| 23-153-259
-3388 | ng requests against the slyly specia
|
| 9889.10 | Supplier#000007220 | EGYPT|9719 | Manufacturer#4 | ,7dILJeEhKrHly2nD2K7BXNrioZ2w
| 14-575-445
-3713 | ccording to the final realms are furiously unus
|
| 9806.52 | Supplier#000005276 | IRAQ | 57760 | Manufacturer#1 | inh0KOhRfLM7WRhdRNvJJDQx
| 21-834-496
-7360 | the slyly unusual theodolites; carefully even accounts use slyly. sl
|
| 9775.37 | Supplier#000007245 | IRAQ | 99717 | Manufacturer#5 | 5VOUnvxlJeOJ
| 21-663-724
-2985 | ic deposits about the slyly bold requests
|
| 9754.60 | Supplier#000000133 | EGYPT|137619 | Manufacturer#5 | QT,semYwdx
| 14-731-952
-5158 | he quickly express instructions
|
| 9714.60 | Supplier#000007317 | EGYPT| 69798 | Manufacturer#1 | nJGsPl2ruoq4Ydtv0fwWG385eOFV6VUokbCZ | 14-666-351
-2592 | ons integrate furiously? slyly ironic requests sl
|
| 9656.61 | Supplier#000004286 | IRAN |174285 | Manufacturer#4 | OsUz6fvS3Y8mGw2rdWmjTh0nEonjaoUduz | 20-857-469
-4413 | uthlessly closely final requests. blithely even packages sublate quick
|
| 9623.30 | Supplier#000003166 | IRAN |115632 | Manufacturer#2 | xdb6MfO7FcPZtB9
| 20-417-589
-8306 | uests cajole slyly around the final, express foxes. finall
|
| 9598.00 | Supplier#000005347 | SAUDI ARABIA |2846 | Manufacturer#2 | R UJfAVRhAKjgH
| 30-213-668
-2389 | ites. packages cajole about the furiously regular accounts. blithely unusual packages are dogg|
| 9577.42 | Supplier#000008123 | JORDAN |118122 | Manufacturer#2 | RVD,e4jMiFVi4gCAa0oH,enjjIBuV1LL1Wzm | 23-305-520
-8530 |fluffily ironic requests boost blithely quickly ironic fo
|
| 9535.76 | Supplier#000008458 | EGYPT|148457 | Manufacturer#5 | rihX1QITvV1JaC
| 14-822-547
-8952 |foxes boost furiously across the slyly express excuses. quickly ex
|
| 9535.76 | Supplier#000008458 | EGYPT|158457 | Manufacturer#5 | rihX1QITvV1JaC
| 14-822-547
-8952 |foxes boost furiously across the slyly express excuses. quickly ex
|
| 9513.31 | Supplier#000004163 | SAUDI ARABIA |101652 | Manufacturer#2 | 2VnQypC7pJPJRu6HzYRg7nAvhzckcYAQFbI| 30-544-852
-3772 | he regular requests. blithely final
|
| 9468.49 | Supplier#000006023 | JORDAN | 81006 | Manufacturer#3 | QzUNYNJKE1
| 23-467-863
-9965 | efully slyly pending hockey players. instructions nag blithely sp
|
| 9449.33 | Supplier#000009349 | IRAQ |116837 | Manufacturer#3 | oJIlkL3FqiKkYqmmIeu18HzDE0WnPpoG3R8bS| 21-197-322
-4895 | al deposits. permanent requests boost according to the special, regular ide
|
| 9445.99 | Supplier#000004274 | SAUDI ARABIA |199235 | Manufacturer#2 | VpVZ1PbArLtxZ1ryS,9 j5dzYgTC0Dy0 DWM | 30-322-776
-7259 | packages boost carefully across the carefully special sheaves. c
|
| 9444.33 | Supplier#000008145 | EGYPT|173110 | Manufacturer#1 | M7SygdLkUNK7XTG
| 14-525-780
-1695 | beans. furiously final platelets cajole quickly. furio
|
| 9324.00 | Supplier#000002707 | SAUDI ARABIA | 47698 | Manufacturer#4 | xMXO5KpIsdXt,mJ5
| 30-127-723
-4248 | tect. carefully regular deposit
|
| 9318.43 | Supplier#000000627 | IRAQ |158111 | Manufacturer#2 | k6W51QENyVPe4 6z0ajEMTkEA
| 21-632-574
-8701 | l instructions serve slyly regular deposits. carefully busy excuses cajole quickly pending d|
| 9311.16 | Supplier#000002401 | JORDAN |189882 | Manufacturer#4 | MZoiVRB8uOVheBJmKYKScBpZkLYSOe2wQIoDsIX| 23-883-970
-4369 | encies along the even deposits haggle regul
|
| 9284.57 | Supplier#000009781 | EGYPT| 87272 | Manufacturer#5 | 49NAd1iDiY4,
| 14-410-636
-4312 | its. ironic pinto beans are blithely. express depths use caref
|
| 9284.57 | Supplier#000009781 | EGYPT|197261 | Manufacturer#4 | 49NAd1iDiY4,
| 14-410-636
-4312 | its. ironic pinto beans are blithely. express depths use caref
|
| 9243.92 | Supplier#000007633 | IRAQ |147632 | Manufacturer#1 |rsl6lh6tEzOKpo6r8ph3A1OuqK zEOBs5Y7l| 21-473-187
-3309 | g ideas kindle slyly? carefully ironic deposits boost furiously special asymptotes. furiousl|
| 9214.58 | Supplier#000005477 | IRAQ | 75476 | Manufacturer#1 | fOzXmCgwtUn E2O8R8NXiDYLibNr8ThjiTJXJZ | 21-195-969
-7717 | ounts against the express ideas use slyly after the
|
| 9093.11 | Supplier#000003063 | SAUDI ARABIA |123062 | Manufacturer#2 | kBUdB0mUgc HX2EzKnh
| 30-532-979
-8127 |the slyly unusual accounts affix slyly bet
|
| 9060.44 | Supplier#000002224 | JORDAN | 14720 | Manufacturer#1 | 08hDtcJ8EUZ0nMxMrZiEiNH9RM08gIqt0DAst| 23-714-590
-7668 | accounts sleep. express, express packages sleep fluffily at the quickly ironic foxes. slyly unusu |
| 9050.12 | Supplier#000000504 | IRAN |135477 | Manufacturer#1 | P8k2mjRiRUFCJfxw7KrEdRpNNQPDxiI
| 20-322-544
-5770 | y final pinto beans. blithely regular instructions wake abo
|
| 8924.44 | Supplier#000001374 | EGYPT|136347 | Manufacturer#1 | uHLiKIkGMCK39DBiPLySDhM1
| 14-105-774
-9435 | pecial deposits along the slyly unusual excuses wake ironically
|
| 8906.10 | Supplier#000007076 | EGYPT|184557 | Manufacturer#4 | DjLJ,yEKffpT,EKIbM6ZziTtzvCbE
| 14-929-221
-6504 | nusual requests solve furiously across the carefully regular excuses. requests are quickly c|
| 8876.42 | Supplier#000004468 | IRAN |126931 | Manufacturer#1 | QxE2rvpMCkB,nto33X7a0n0FFV
| 20-536-285
-9136 | encies. slyly pending ideas boost blithely.
|
| 8855.28 | Supplier#000003075 | SAUDI ARABIA | 50569 | Manufacturer#1 | 4r1HsHGBEH88qIxsG8Dr9
| 30-700-119
-4521 | packages. carefully unusual requests wak
|
| 8843.88 | Supplier#000000218 | IRAN |155187 | Manufacturer#3 | c7CBVglgEM0XU,8bOU76GjEr5L5EXu9Uxa7U | 20-180-767
-8426 |fluffily. furiously regular instructions sleep slyly furiously regular packa
|
| 8820.62 | Supplier#000005117 | IRAN | 42612 | Manufacturer#1 | zlBi4yswhLa1yv54Mrurx6Ldl2EWiegBiH | 20-400-529
-7218 | wind: slyly special deposits affix furiously behind the quickly ironic requests. fluffily express a |
| 8797.73 | Supplier#000002322 | SAUDI ARABIA | 14818 | Manufacturer#4 | ijvybmLZ9eaW7,u4TXUiW5AxLeEQj2GpnHC2Rj | 30-373-325
-3862 | slyly about the furiously regular accounts. blithely
|
| 8797.73 | Supplier#000002322 | SAUDI ARABIA |117299 | Manufacturer#2 | ijvybmLZ9eaW7,u4TXUiW5AxLeEQj2GpnHC2Rj | 30-373-325
-3862 | slyly about the furiously regular accounts. blithely
|
| 8795.09 | Supplier#000008261 | JORDAN |130721 | Manufacturer#5 | OE8VCFunRj1dNf
| 23-540-992
-1108 | ent accounts boost fluffily pinto beans. requests detect carefully. even, ironic accoun
|
| 8788.46 | Supplier#000003437 | IRAN | 88420 | Manufacturer#4 | JfgZDO9fsP4ljfzsi,s7431Ld3A7zXtHfrF74| 20-547-871
-1712 | ickly unusual dependencies. carefully regular dolphins ha
|
| 8717.99 | Supplier#000009405 | IRAQ | 66898 | Manufacturer#4 | IY1x8B2MaqzWuk1KzA6FJua
| 21-778-728
-5704 | al packages. slyly even theodolites doubt blithely. slyly regular asymptotes a
|
| 8703.31 | Supplier#000008176 | IRAQ |165659 | Manufacturer#5 | cQBg1Bxn5LxxR h ZnF SCIZO 0XZpEsP0vkfc | 21-209-627
-8129 | e carefully even packages detect against the final, unusual ideas. blithely bold
|
| 8687.00 | Supplier#000005896 | SAUDI ARABIA |145895 | Manufacturer#5 | NwV,QYlRuz
| 30-167-592
-8264 | deposits use slyly furiously bold packages; furious
|
| 8659.37 | Supplier#000005604 | IRAN | 43099 | Manufacturer#1 | RBi1ab0lYokQsmhcPLIuKOlJ3GX0xZbYX| 20-836-715
-9065 | pecial asymptotes? carefully f
|
| 8594.80 | Supplier#000007553 | IRAN | 52542 | Manufacturer#1 | wAU2Lui w9
| 20-663-409
-7956 | old, stealthy accounts are blithely. fluffily final
|
| 8594.80 | Supplier#000007553 | IRAN |165036 | Manufacturer#1 | wAU2Lui w9
| 20-663-409
-7956 | old, stealthy accounts are blithely. fluffily final
|
| 8555.40 | Supplier#000005715 | JORDAN | 30708 | Manufacturer#4 | ZW R6zxZtBFRoeaZtQw8YifUBoqSv16hG| 23-268-174
-1595 | e blithely silent multipliers are
|
| 8553.36 | Supplier#000005418 | IRAN |132904 | Manufacturer#3 | eLGAV8u15ZX2e5pJa GEg8VBKQX9Gi1
| 20-897-164
-8136 | detect carefully ironic theodolites. silently regular packages against
|
| 8525.33 | Supplier#000003234 | SAUDI ARABIA |163233 | Manufacturer#1 | 1916uLszlZz
| 30-583-104
-8386 | eodolites? furiously regular foxes accordin
|
| 8484.29 | Supplier#000008178 | IRAQ |190620 | Manufacturer#5 | Kzuv9PrThE56fWmNR3UtwZAz
| 21-201-455
-3427 | s. ironic, special deposits cajole carefully furiously final requests. pending packages sleep quick |
| 8473.01 | Supplier#000003912 | IRAQ |133911 | Manufacturer#2 | Op7,1zt3MAxs34Qo4O W
| 21-474-809
-6508 | es. regular, brave instructions wa
|
| 8466.50 | Supplier#000000069 | EGYPT| 92541 | Manufacturer#1 | T2Dl9,f97e333eRuMi2z
| 14-491-707
-8310 | ! carefully ironic instructions nag quickly pending requests. fluffily even deposits sleep a|
| 8448.94 | Supplier#000001416 | JORDAN | 73894 | Manufacturer#5 | PYA5L32bQcST4 vGIH,VEEbSIuAxk
| 23-420-251
-7666 | inal deposits. special dependencies boost slyly final ideas. eve
|
| 8433.57 | Supplier#000006569 | SAUDI ARABIA |119035 | Manufacturer#3 | sk5AhyyRnxAczOZ76XvjGU uDEnyHQSVIQ2| 30-561-849
-3346 | os according to the permanent packages snooze bravely fu
|
| 8383.60 | Supplier#000008136 | SAUDI ARABIA |123111 | Manufacturer#4 | kXATyaEZOWdQC7fE43IquuR1HkKV8qx
| 30-268-895
-2611 | er the carefully regular depths. pinto beans detect quickly p
|
| 8377.27 | Supplier#000006837 | EGYPT| 54331 | Manufacturer#3 | vokfcIaDMaf2hG
| 14-530-767
-7768 | unts along the slyly regular instructions detect slyly unusual deposits.
|
| 8351.75 | Supplier#000007495 | IRAQ |124982 | Manufacturer#3 | 3jQQGvfs,5Aryhn0Z
| 21-953-463
-7239 |requests. carefully final accounts after the qui
|
| 8330.85 | Supplier#000006020 | IRAN | 93510 | Manufacturer#1 | U9O4ceIDl0DMRPM0vvsKKj3gzGwNkcUeusC| 20-817-604
-6561 | ly? final packages are blithely ironic ideas. carefully special packages kindle blithely expre|
| 8230.12 | Supplier#000001058 | SAUDI ARABIA |128545 | Manufacturer#4 | fJ8egP,xkLygXGv8bmtc9T1FJ
| 30-496-504
-3341 |requests haggle? regular, regular pinto beans integrate fluffily. dependenc
|
| 8208.02 | Supplier#000006883 | IRAN |111860 | Manufacturer#5 | 7Jow14LNWvnADcfBjCQZuq8AMIuu4e,kf| 20-745-172
-4921 |according to the fluffily pending packages cajole slyly carefully pending accounts. quickly|
| 8199.77 | Supplier#000002357 | SAUDI ARABIA | 27352 | Manufacturer#1 | V8x3JyiEOtAo0w
| 30-139-515
-7766 |dependencies. pending reques
|
| 8193.26 | Supplier#000003057 | IRAN | 98038 | Manufacturer#4 | nI,owTJt24PQXdzm
| 20-976-269
-2335 | aids sleep. carefully regular depths are of the blithely express depo
|
| 8175.17 | Supplier#000003172 | IRAN | 50666 | Manufacturer#1 | 8ngbGS7BQoTDmJyMa5WV9XbaM31u5FAayd2vT3 | 20-834-374
-7746 | ss deposits use furiously after the quickly final sentiments. fluffily ruthless ideas believe regu|
| 8142.90 | Supplier#000008320 | IRAQ | 53309 | Manufacturer#1 | FB TdvQvk36
| 21-388-687
-9284 | accounts wake about the slyly bold platelets. furiously ironic foxes doubt ab
|
| 8136.60 | Supplier#000005721 | SAUDI ARABIA | 85720 | Manufacturer#4 | LXqfP897JYdfIlo dNqHuY4T
| 30-202-248
-8360 | ng requests. carefully regular accounts along the
|
| 8111.40 | Supplier#000007567 | IRAN |195047 | Manufacturer#3 | 7W4k2qEVoBkRehprGliXRSYVOQEh
| 20-377-181
-7435 | gular foxes. silent attainments boost furiousl
|
| 8106.47 | Supplier#000001028 | IRAQ | 21027 | Manufacturer#4 | nOkvPq5WfeN87ASUIgQNKT2U0TUX 4WzZQ3f | 21-570-218
-8213 | riously bold accounts haggle slyly after the blithely u
|
| 8096.36 | Supplier#000002169 | IRAQ | 79661 | Manufacturer#5 | JKBnBaxV,0z4lwgBupYpPWIIaoCPUG | 21-931-513
-1870 | ely permanent pinto beans are above the requests! quickly final pearls are regular, ironic requ |
| 8081.62 | Supplier#000007075 | IRAQ | 99547 | Manufacturer#1 | 52hMohrQKM
| 21-580-554
-9032 | ecial packages. pending accounts grow carefully;
|
| 8075.30 | Supplier#000000513 | EGYPT|120512 | Manufacturer#3 | YMhcTaVkhw0nO9B,
| 14-481-495
-8505 |final requests. slyly final reque
|
| 8045.75 | Supplier#000008529 | SAUDI ARABIA | 48528 | Manufacturer#3 | l4Y,f11TYz7Ph1erL7IM9AXf0poUIrO2OS | 30-791-579
-2088 | xpress deposits are furiously. blithely regular dolphins affix blithely enticingly regular t|
| 8040.16 | Supplier#000001925 | SAUDI ARABIA | 74403 | Manufacturer#3 | Cu5Ub AAdXT
| 30-969-417
-1108 | pending packages across the regular req
|
| 8015.11 | Supplier#000003589 | IRAN |111077 | Manufacturer#1 | SeVq5mliNtWVvH0NmB
| 20-895-735
-3345 | about the bold asymptotes. slyly ironic platelets sleep aga
|
| 8008.36 | Supplier#000003366 | JORDAN |180847 | Manufacturer#4 | iev0jGXt7AL5A9cTl7GCeO0lG8S
| 23-320-193
-4544 |wake carefully pending depths. carefully regular packages cajole idly da
|
| 8007.83 | Supplier#000006266 | JORDAN |111243 | Manufacturer#2 | XWBf5Jd2V5SOurbn11Tt1
| 23-363-445
-7184 | as cajole carefully against the quickly special ac
|
| 7977.48 | Supplier#000001134 | EGYPT| 61133 | Manufacturer#5 | WkRjMQOKvjH4g4RsFZomI9UKUjTw9gq
| 14-183-918
-4545 |alongside of the orbits. pending instr
|
| 7977.48 | Supplier#000001134 | EGYPT| 73612 | Manufacturer#5 | WkRjMQOKvjH4g4RsFZomI9UKUjTw9gq
| 14-183-918
-4545 |alongside of the orbits. pending instr
|
| 7933.97 | Supplier#000002598 | JORDAN |122597 | Manufacturer#1 | tunUZrfZ3bzb0e0vhmhtmp6LR9aC
| 23-511-169
-9974 | nstructions! regular asymptotes wake above the sometimes special accounts. slyly special asympt |
| 7890.01 | Supplier#000006843 | IRAQ |134329 | Manufacturer#4 | JDyLWm,Nn8,Pkfx,9zB,iWgq 4
| 21-443-521
-5425 | al, regular pinto beans sleep furiously above the ironic, even pinto b
|
| 7874.99 | Supplier#000002457 | IRAN |164908 | Manufacturer#1 | iPOyBsGzl,I4 cRkMelt4PRpNzFx9 dkGC1Eu| 20-752-453
-1043 | ing foxes boost slyly finally express theodolites-- even, regular ideas kindle. e
|
| 7832.77 | Supplier#000009693 | IRAQ |144664 | Manufacturer#2 | ,NtpOfxQv JMEv CJZjPvD,YFL
| 21-884-330
-4663 | ly final instructions wake slyly according to the carefully express asymptotes. fluffily regul|
| 7817.89 | Supplier#000006446 | EGYPT|153930 | Manufacturer#4 | zc UqeKpg3W8Y
| 14-901-464
-2207 | ts use fluffily. furiously regular foxes around the
|
| 7809.11 | Supplier#000007873 | IRAQ |105362 | Manufacturer#2 | nqHeHayWL6GV4yrpCaUhESHiWlB75HXGxeP7Z| 21-910-520
-4230 | even ideas wake quickly across the accounts. final accounts w
|
| 7789.12 | Supplier#000006421 | EGYPT|168872 | Manufacturer#2 | AwhpC5y15ua6plU8rtMwx
| 14-514-734
-7640 | ial dependencies; regular pinto beans use after the furiously bold somas. idly dogged packages ha |
| 7788.45 | Supplier#000000413 | IRAQ | 412 | Manufacturer#1 | GAufsRQQE P,dVCZWIMEUAsm,7
| 21-875-836
-5585 |the fluffily even pinto beans. closely regular asympt
|
| 7751.80 | Supplier#000007392 | IRAN |124879 | Manufacturer#3 | JeeScPASUUcJFQbjB5BVwXb8De3VTYddzkGwBv | 20-928-350
-9877 | ular accounts detect carefully along the unusual pinto beans. final, special pla
|
| 7741.10 | Supplier#000001059 | IRAN | 36052 | Manufacturer#2 | 4tBenOMokWbWVRB8i8HwENeO cQjM9 | 20-620-710
-8984 |to the carefully special courts.
|
| 7719.51 | Supplier#000005848 | SAUDI ARABIA |163331 | Manufacturer#2 | xxheHzTSroSqvL,Jt4bni7n1
| 30-144-868
-2228 | y even epitaphs haggle fluffily along the blithely regular r
|
| 7685.78 | Supplier#000002738 | IRAQ |115204 | Manufacturer#4 | uc,zYilzDQIkEmH8dWYJE9M681TmlEPsdFCtB6NY | 21-215-533
-3433 | y even dinos sleep carefully final, final deposits. regular accounts wake sl
|
| 7656.34 | Supplier#000006909 | SAUDI ARABIA |189354 | Manufacturer#2 | f9A W4Urm31d RTFKjt1,V3
| 30-189-225
-4097 | ffily after the thinly regular instructions. quickly final deposits against th
|
| 7632.13 | Supplier#000007720 | EGYPT|122695 | Manufacturer#2 | ERjXnwOJ1vSklF,yOm66
| 14-733-939
-9211 |against the even packages. slyly special requests sleep. regular f
|
| 7631.14 | Supplier#000006814 | EGYPT|4313 | Manufacturer#4 | 83A GGXkYiww58
| 14-312-658
-3824 | zzle among the blithely sly packages. pending excuses pri
|
| 7606.44 | Supplier#000001236 | IRAN |138722 | Manufacturer#5 | qpYv0hQmP8aiXnIAm1o
| 20-247-189
-6514 | s; carefully unusual deposits affix quickly. silent cou
|
| 7601.35 | Supplier#000008443 | JORDAN |128442 | Manufacturer#2 | 4NVFgmnKNRe
| 23-767-598
-9866 | re quickly above the express,
|
| 7591.79 | Supplier#000009723 | JORDAN | 77215 | Manufacturer#5 | Q1CkkpDdlLOpCJiV,zIf,Mv86otWhxj7slGc | 23-710-907
-3873 | e fluffily even instructions. packages impress enticingly.
|
| 7570.01 | Supplier#000008141 | IRAN |100610 | Manufacturer#1 | u4oIjr7XbM
| 20-777-745
-4221 | ckages snooze about the furiously regular accounts. carefully regular epitaphs mig
|
| 7568.83 | Supplier#000003013 | EGYPT|3012 | Manufacturer#5 | LPjXyEI0Vb7,
| 14-108-315
-4034 | gside of the slyly special braids. quickly even accounts cajole amo
|
+-----------+--------------------+--------------+-----------+----------------+------------------------------------------+-----------
------+-----------------------------------------------------------------------------------------------------+
100 rows in set (29.50 sec)
PROMPT set to '3'
+------------+-------------+-------------+----------------+
| L_ORDERKEY | REVENUE | O_ORDERDATE | O_SHIPPRIORITY |
+------------+-------------+-------------+----------------+
| 885895 | 428442.5359 | 1995-03-26|
0 |
|4207744 | 392122.0251 | 1995-03-26|
0 |
|5660420 | 389343.1796 | 1995-03-08|
0 |
|3837441 | 382568.0383 | 1995-02-14|
0 |
|5006400 | 377083.4322 | 1995-03-18|
0 |
|1983815 | 373983.2402 | 1995-03-25|
0 |
|4837957 | 369585.3452 | 1995-02-21|
0 |
|2759685 | 368851.5057 | 1995-02-27|
0 |
|2500838 | 357224.2910 | 1995-03-18|
0 |
|2315457 | 354719.2327 | 1995-02-25|
0 |
+------------+-------------+-------------+----------------+
10 rows in set (1.34 sec)
PROMPT set to '4'
+-----------------+-------------+
| O_ORDERPRIORITY | ORDER_COUNT |
+-----------------+-------------+
| 1-URGENT| 10775 |
| 2-HIGH
| 10569 |
| 3-MEDIUM| 10352 |
| 4-NOT SPECIFIED | 10686 |
| 5-LOW | 10647 |
+-----------------+-------------+
5 rows in set (2 min 27.17 sec)
PROMPT set to '5'
+------------+---------------+
| N_NAME | REVENUE |
+------------+---------------+
| MOZAMBIQUE | 57836194.6976 |
| ALGERIA| 53591119.0055 |
| ETHIOPIA | 50195161.7541 |
| MOROCCO| 49685481.2805 |
| KENYA| 45423425.6432 |
+------------+---------------+
5 rows in set (1.83 sec)
PROMPT set to '6'
+---------------+
| REVENUE |
+---------------+
| 89630293.8730 |
+---------------+
1 row in set (0.55 sec)
PROMPT set to '7'
+-------------+-------------+--------+---------------+
| SUPP_NATION | CUST_NATION | L_YEAR | REVENUE |
+-------------+-------------+--------+---------------+
| CHINA | INDIA | 1995 | 53077463.1027 |
| CHINA | INDIA | 1996 | 53781151.4789 |
| INDIA | CHINA | 1995 | 55537013.4832 |
| INDIA | CHINA | 1996 | 58847136.7052 |
+-------------+-------------+--------+---------------+
4 rows in set (2.55 sec)
PROMPT set to '8'
+--------+------------+
| O_YEAR | MKT_SHARE|
+--------+------------+
| 1995 | 0.03328202 |
| 1996 | 0.04708578 |
+--------+------------+
2 rows in set (1.53 sec)
PROMPT set to '9'
+-----------+--------+---------------+
| NATION| O_YEAR | SUM_PROFIT|
+-----------+--------+---------------+
| ALGERIA | 1998 | 29645673.4750 |
| ALGERIA | 1997 | 49958434.5543 |
| ALGERIA | 1996 | 48329554.7794 |
| ALGERIA | 1995 | 47677023.3924 |
| ALGERIA | 1994 | 49534747.1588 |
| ALGERIA | 1993 | 49439307.1406 |
| ALGERIA | 1992 | 49689273.2733 |
| ARGENTINA | 1998 | 26206143.7591 |
| ARGENTINA | 1997 | 49674662.7557 |
| ARGENTINA | 1996 | 49920247.6825 |
| ARGENTINA | 1995 | 48697771.2584 |
| ARGENTINA | 1994 | 48346793.4240 |
| ARGENTINA | 1993 | 46698898.6511 |
| ARGENTINA | 1992 | 48815012.4997 |
| BRAZIL| 1998 | 27198541.5275 |
| BRAZIL| 1997 | 50261140.6340 |
| BRAZIL| 1996 | 48038385.5036 |
| BRAZIL| 1995 | 46957932.3108 |
| BRAZIL| 1994 | 44196992.2317 |
| BRAZIL| 1993 | 47945911.1628 |
| BRAZIL| 1992 | 46972153.3423 |
| CANADA| 1998 | 27715406.6099 |
| CANADA| 1997 | 48764796.8607 |
| CANADA| 1996 | 48518436.9259 |
| CANADA| 1995 | 48267289.9519 |
| CANADA| 1994 | 47225080.7821 |
| CANADA| 1993 | 47393156.6687 |
| CANADA| 1992 | 46994838.4682 |
| CHINA | 1998 | 29485768.8101 |
| CHINA | 1997 | 49046077.5904 |
| CHINA | 1996 | 50062090.5628 |
| CHINA | 1995 | 48198621.9945 |
| CHINA | 1994 | 51812830.5572 |
| CHINA | 1993 | 49556274.2987 |
| CHINA | 1992 | 50646940.6980 |
| EGYPT | 1998 | 28659722.2837 |
| EGYPT | 1997 | 47482052.3895 |
| EGYPT | 1996 | 48023177.7877 |
| EGYPT | 1995 | 45445493.7799 |
| EGYPT | 1994 | 48103591.0847 |
| EGYPT | 1993 | 47504724.0466 |
| EGYPT | 1992 | 48672222.0332 |
| ETHIOPIA| 1998 | 25835960.3587 |
| ETHIOPIA| 1997 | 45676741.8659 |
| ETHIOPIA| 1996 | 45960592.9345 |
| ETHIOPIA| 1995 | 47331981.8476 |
| ETHIOPIA| 1994 | 46271664.4757 |
| ETHIOPIA| 1993 | 44635422.9850 |
| ETHIOPIA| 1992 | 44449375.7018 |
| FRANCE| 1998 | 24551536.2202 |
| FRANCE| 1997 | 44095271.0314 |
| FRANCE| 1996 | 44896506.1605 |
| FRANCE| 1995 | 45219573.2831 |
| FRANCE| 1994 | 45696838.6786 |
| FRANCE| 1993 | 45595599.6560 |
| FRANCE| 1992 | 44435159.3305 |
| GERMANY | 1998 | 27000628.2211 |
| GERMANY | 1997 | 45544360.6774 |
| GERMANY | 1996 | 44419861.6050 |
| GERMANY | 1995 | 46139021.4611 |
| GERMANY | 1994 | 43995860.7364 |
| GERMANY | 1993 | 45345561.5025 |
| GERMANY | 1992 | 49440653.1061 |
| INDIA | 1998 | 28230691.8306 |
| INDIA | 1997 | 50856347.7133 |
| INDIA | 1996 | 49374860.7162 |
| INDIA | 1995 | 48854551.4337 |
| INDIA | 1994 | 47148725.3487 |
| INDIA | 1993 | 48851229.7623 |
| INDIA | 1992 | 48991657.2361 |
| INDONESIA | 1998 | 27833518.2201 |
| INDONESIA | 1997 | 46857139.2467 |
| INDONESIA | 1996 | 46679550.3200 |
| INDONESIA | 1995 | 47606384.7018 |
| INDONESIA | 1994 | 47785565.6361 |
| INDONESIA | 1993 | 47254486.2762 |
| INDONESIA | 1992 | 45503822.0898 |
| IRAN| 1998 | 26094469.1474 |
| IRAN| 1997 | 44164413.7948 |
| IRAN| 1996 | 44438776.8320 |
| IRAN| 1995 | 47622606.6190 |
| IRAN| 1994 | 44520042.7564 |
| IRAN| 1993 | 44659065.1938 |
| IRAN| 1992 | 45994370.4761 |
| IRAQ| 1998 | 29284920.2597 |
| IRAQ| 1997 | 50203843.5880 |
| IRAQ| 1996 | 51541834.9324 |
| IRAQ| 1995 | 51476664.6036 |
| IRAQ| 1994 | 51069635.3876 |
| IRAQ| 1993 | 50891756.3479 |
| IRAQ| 1992 | 50901434.3129 |
| JAPAN | 1998 | 23931175.7343 |
| JAPAN | 1997 | 42623339.1825 |
| JAPAN | 1996 | 40622638.5294 |
| JAPAN | 1995 | 42296339.9534 |
| JAPAN | 1994 | 42276049.3600 |
| JAPAN | 1993 | 40775541.4699 |
| JAPAN | 1992 | 38334075.0186 |
| JORDAN| 1998 | 25338322.3585 |
| JORDAN| 1997 | 43603749.8209 |
+-----------+--------+---------------+
100 rows in set (5.95 sec)
PROMPT set to '10'
+-----------+--------------------+-------------+-----------+----------------+---------------------------------------+---------------
--+----------------------------------------------------------------------------------------------------------------------+
| C_CUSTKEY | C_NAME
| REVENUE | C_ACCTBAL | N_NAME | C_ADDRESS
| C_PHONE
| C_COMMENT
|
+-----------+--------------------+-------------+-----------+----------------+---------------------------------------+---------------
--+----------------------------------------------------------------------------------------------------------------------+
|108763 | Customer#000108763 | 683768.0205 | -180.10 | UNITED KINGDOM | vco1AzEQTcuYKgyikRysXR4B3m7O54| 33-420-572-902
9 | he unusual accounts sleep after the pending deposits. fluffily final deposits wake blithe
|
| 25501 | Customer#000025501 | 668810.6109 | 7725.04 | ETHIOPIA | W556MXuoiaYCCZamJI,Rn0B4ACUGdkQ8DZ| 15-874-808-679
3 | he pending instructions wake carefully at the pinto beans. regular, final instructions along the slyly fina
|
|101998 | Customer#000101998 | 666019.9772 | 3790.89 | UNITED KINGDOM | 01c9CILnNtfOQYmZj
| 33-593-865-637
8 | ress foxes wake slyly after the bold excuses. ironic platelets are furiously carefully bold theodolites
|
| 856 | Customer#000000856 | 659357.0470 | 6988.55 | MOROCCO| X4U7LH4YtDzephie
| 25-336-316-964
1 | y bold pinto beans according to the pending foxes
|
| 78790 | Customer#000078790 | 641913.6405 | 2241.94 | ARGENTINA| Ub1PPvbnz8987sZ,HDj89yWAszt,PH| 11-834-965-840
1 | ly fluffily special deposits.
|
| 20087 | Customer#000020087 | 620624.3536 | 9948.25 | ETHIOPIA | rr3wyEfj flMHU5j7asOPP1 C hjrBbdByb5o | 15-880-746-162
0 | ets are along the carefully pending theodolites. evenly ironic requests lose above the blithel
|
|147727 | Customer#000147727 | 606904.6144 | 4288.02 | MOROCCO| dFZ WzKV2HpCrgN3V44Uj
| 25-984-579-573
5 | ackages thrash fluffily about the carefully silent
|
|142015 | Customer#000142015 | 594395.1371 | 3841.67 | UNITED KINGDOM | fr1cn7EjamsnfHHafh
| 33-699-169-532
8 | the bold deposits. slyly regular accounts ou
|
| 736 | Customer#000000736 | 594224.5810 | 9114.68 | ARGENTINA| zQNs5e2aFcVY8MigFQEBtoCaQ9e | 11-617-726-203
9 |the deposits. blithely regular asymptotes boost q
|
| 87613 | Customer#000087613 | 590153.5102 | 6474.97 | VIETNAM| KbJdnGc8rkwj
| 31-893-156-539
8 | refully. slyly special excuses about the bold deposits wake carefully against the special dependencies. slyly bold a |
| 39922 | Customer#000039922 | 584878.1134 | 7321.11 | GERMANY| Zgy4s50l2GKN4pLDPBU8m342gIw6R | 17-147-757-803
6 | y final requests. furiously final foxes cajole blithely special platelets. f
|
| 60838 | Customer#000060838 | 582559.0609 | 2454.77 | BRAZIL | 64EaJ5vMAHWJlBOxJklpNc2RJiWE
| 12-913-494-981
3 |need to boost against the slyly regular account
|
| 13753 | Customer#000013753 | 578238.1222 | 4862.56 | UNITED KINGDOM | SowrFhCvmtiq,7ZQAct v
| 33-760-731-583
2 | he express excuses cajole regular, busy accounts.
|
| 47221 | Customer#000047221 | 573866.2092 | 6385.10 | INDIA
| Rp4p8Q1tjKLv8Ht H6GLd,tG75TX
| 18-637-949-446
2 | urts. quickly pending packages according to the slyly ironic packages boost carefully idle, ironi
|
|108598 | Customer#000108598 | 569265.4847 | 7074.14 | CANADA | fDuJgSmkItSWWXCcSzvOnjK2
| 13-503-222-933
8 | uriously final deposits. unusual, silent accounts against the
|
|142549 | Customer#000142549 | 563537.2368 | 5085.99 | INDONESIA| ChqEoK43OysjdHbtKCp6dKqjNyvvi9| 19-955-562-239
8 | sleep pending courts. ironic deposits against the carefully unusual platelets cajole carefully express accounts. |
| 50476 | Customer#000050476 | 563448.8844 | 7474.49 | MOZAMBIQUE | 0iTYc0iW6eEnNUXE9uqGt0OzPV UC T,| 26-106-316-556
3 | y slyly even requests. ironic theodolites could use about the bl
|
|139823 | Customer#000139823 | 560677.1872 | 5023.03 | INDIA
| qIk4KPwtqobzgXc
| 18-166-780-610
1 | aggle. fluffily bold requests are doggedly for the slyly final packages? bravely even theodolites sleep fluff|
|113839 | Customer#000113839 | 559674.0334 | 8208.46 | GERMANY| 6i3 GKW3q8B1VZOd6RSc2nlvt
| 17-336-257-935
9 | nd furiously daring accounts. slyly bold requests nod after the requests. pending as
|
| 78658 | Customer#000078658 | 559169.0370 |-91.97 | SAUDI ARABIA | iLUNk2GNs30u0,Y
| 30-934-156-683
7 | -- carefully ironic accounts use fluffily silent platelets. silently regular
|
+-----------+--------------------+-------------+-----------+----------------+---------------------------------------+---------------
--+----------------------------------------------------------------------------------------------------------------------+
20 rows in set (2.08 sec)
PROMPT set to '11'
+------------+------------+
| PS_PARTKEY | VALUE|
+------------+------------+
|29323 | 9221002.45 |
|52576 | 9217413.96 |
|49766 | 9217377.72 |
| 151679 | 9215863.55 |
| 181947 | 9214342.18 |
| 119385 | 9213786.85 |
| 135081 | 9209718.09 |
|83978 | 9206769.00 |
|58493 | 9203135.40 |
| 144964 | 9198415.25 |
|85500 | 9195252.57 |
|73645 | 9195053.68 |
|83508 | 9190540.80 |
| 161690 | 9187804.35 |
| 183370 | 9182808.95 |
|91753 | 9175274.54 |
|52609 | 9174547.20 |
| 120057 | 9171000.59 |
| 185931 | 9164171.64 |
|82102 | 9161305.23 |
|19630 | 9155062.16 |
| 165224 | 9152124.25 |
| 154740 | 9150354.76 |
| 100829 | 9150284.84 |
| 103987 | 9138672.90 |
|67171 | 9138532.75 |
| 171065 | 9136322.58 |
|51380 | 9132167.88 |
|52450 | 9121244.16 |
| 155751 | 9118784.25 |
| 184594 | 9117730.31 |
|24216 | 9114964.74 |
| 157862 | 9114738.12 |
| 136760 | 9110375.82 |
|92147 | 9109211.02 |
| 187270 | 9106382.08 |
|67974 | 9093602.70 |
| 193831 | 9091596.86 |
| 112855 | 9087175.16 |
|65651 | 9086904.00 |
|93127 | 9082368.68 |
| 107514 | 9082027.55 |
| 108107 | 9075542.08 |
|31318 | 9073562.46 |
|24270 | 9073416.33 |
| 199133 | 9065354.80 |
| 5764 | 9061286.98 |
|42523 | 9060955.60 |
| 165732 | 9060021.82 |
|949 | 9058378.56 |
|35935 | 9057674.18 |
|29238 | 9054250.41 |
| 129645 | 9052948.80 |
| 109116 | 9051980.94 |
| 109167 | 9049261.20 |
|72824 | 9048756.60 |
| 8585 | 9045150.24 |
| 114784 | 9042522.72 |
|89678 | 9037215.04 |
| 126318 | 9032186.10 |
|38861 | 9028108.44 |
| 132558 | 9026009.72 |
|47413 | 9022491.25 |
|75089 | 9021820.22 |
| 108832 | 9017610.35 |
|91983 | 9016961.76 |
| 108465 | 9015831.00 |
| 182886 | 9015679.44 |
|46781 | 9014869.22 |
|75856 | 9010136.40 |
|68198 | 9007648.74 |
|89594 | 9005680.94 |
| 168862 | 9004252.75 |
| 181105 | 9003258.67 |
| 123707 | 8997166.08 |
|71095 | 8990989.22 |
| 6085 | 8988563.25 |
|45037 | 8987483.24 |
|63249 | 8986331.19 |
| 135839 | 8984723.05 |
|84796 | 8984434.68 |
|89085 | 8973651.25 |
|54643 | 8972526.88 |
|52390 | 8969395.50 |
|96219 | 8968255.36 |
| 4899 | 8965048.09 |
|90876 | 8962322.64 |
| 145333 | 8961170.40 |
|62572 | 8956015.80 |
|77324 | 8951793.20 |
|56448 | 8947456.32 |
|18652 | 8947424.05 |
|73000 | 8947271.52 |
|89005 | 8946713.45 |
|25737 | 8946552.42 |
|59828 | 8943585.84 |
|59614 | 8941350.90 |
| 125922 | 8937414.85 |
|43622 | 8934597.24 |
| 193081 | 8934573.44 |
+------------+------------+
100 rows in set (0.39 sec)
PROMPT set to '12'
+------------+-----------------+----------------+
| L_SHIPMODE | HIGH_LINE_COUNT | LOW_LINE_COUNT |
+------------+-----------------+----------------+
| AIR|
6293 | 9123 |
| FOB|
6224 | 9261 |
+------------+-----------------+----------------+
2 rows in set (1.26 sec)
PROMPT set to '13'
+---------+----------+
| C_COUNT | CUSTDIST |
+---------+----------+
| 0 |50005 |
| 9 | 6656 |
|10 | 6534 |
|11 | 6002 |
| 8 | 5958 |
|12 | 5650 |
|13 | 5043 |
|19 | 4785 |
| 7 | 4700 |
|18 | 4575 |
|17 | 4560 |
|20 | 4508 |
|15 | 4497 |
|14 | 4439 |
|16 | 4312 |
|21 | 4201 |
|22 | 3610 |
| 6 | 3300 |
|23 | 3184 |
|24 | 2697 |
|25 | 2081 |
| 5 | 1970 |
|26 | 1584 |
|27 | 1174 |
| 4 | 1025 |
|28 |879 |
|29 |576 |
| 3 |422 |
|30 |368 |
|31 |221 |
|32 |141 |
| 2 |136 |
|33 | 75 |
|34 | 51 |
|35 | 34 |
| 1 | 17 |
|36 | 13 |
|38 |5 |
|37 |5 |
|40 |4 |
|41 |2 |
|39 |1 |
+---------+----------+
42 rows in set (3.61 sec)
PROMPT set to '14'
+---------------+
| PROMO_REVENUE |
+---------------+
| 16.5107260405 |
+---------------+
1 row in set (0.71 sec)
PROMPT set to '15'
Query OK, 0 rows affected (0.01 sec)
+-----------+--------------------+--------------------+-----------------+---------------+
| S_SUPPKEY | S_NAME
| S_ADDRESS
| S_PHONE | TOTAL_REVENUE |
+-----------+--------------------+--------------------+-----------------+---------------+
|7979 | Supplier#000007979 | aTz0O9HIdoStxpU,8D | 19-787-181-5082 |1793806.3866 |
+-----------+--------------------+--------------------+-----------------+---------------+
1 row in set (1.40 sec)
Query OK, 0 rows affected (0.00 sec)
PROMPT set to '16'
+----------+--------------------------+--------+--------------+
| P_BRAND| P_TYPE
| P_SIZE | SUPPLIER_CNT |
+----------+--------------------------+--------+--------------+
| Brand#55 | LARGE BURNISHED TIN| 21 | 36 |
| Brand#25 | PROMO BRUSHED STEEL| 24 | 28 |
| Brand#34 | STANDARD PLATED BRASS|4 | 28 |
| Brand#55 | MEDIUM BRUSHED COPPER| 17 | 28 |
| Brand#11 | MEDIUM PLATED STEEL|5 | 24 |
| Brand#11 | STANDARD BRUSHED TIN | 23 | 24 |
| Brand#12 | MEDIUM PLATED BRASS| 21 | 24 |
| Brand#14 | ECONOMY PLATED TIN |5 | 24 |
| Brand#21 | STANDARD BRUSHED TIN | 25 | 24 |
| Brand#23 | PROMO BRUSHED TIN|5 | 24 |
| Brand#25 | LARGE PLATED STEEL | 25 | 24 |
| Brand#25 | SMALL BURNISHED COPPER | 17 | 24 |
| Brand#32 | SMALL ANODIZED BRASS |7 | 24 |
| Brand#33 | ECONOMY PLATED STEEL |7 | 24 |
| Brand#33 | LARGE POLISHED TIN | 23 | 24 |
| Brand#34 | MEDIUM POLISHED COPPER |4 | 24 |
| Brand#34 | SMALL BRUSHED TIN| 21 | 24 |
| Brand#35 | PROMO POLISHED NICKEL| 24 | 24 |
| Brand#55 | ECONOMY BURNISHED NICKEL | 21 | 24 |
| Brand#55 | SMALL POLISHED BRASS | 25 | 24 |
| Brand#21 | LARGE BURNISHED NICKEL | 21 | 23 |
| Brand#11 | ECONOMY BRUSHED STEEL|5 | 20 |
| Brand#11 | ECONOMY PLATED BRASS | 23 | 20 |
| Brand#11 | MEDIUM ANODIZED TIN|7 | 20 |
| Brand#11 | MEDIUM BRUSHED NICKEL| 24 | 20 |
| Brand#11 | PROMO BRUSHED STEEL|7 | 20 |
| Brand#11 | PROMO PLATED TIN |7 | 20 |
| Brand#11 | SMALL POLISHED BRASS |7 | 20 |
| Brand#11 | STANDARD BRUSHED NICKEL| 25 | 20 |
| Brand#12 | MEDIUM POLISHED NICKEL |4 | 20 |
| Brand#12 | SMALL BRUSHED STEEL|7 | 20 |
| Brand#13 | ECONOMY BRUSHED COPPER |5 | 20 |
| Brand#13 | SMALL BURNISHED BRASS|7 | 20 |
| Brand#13 | STANDARD PLATED NICKEL | 23 | 20 |
| Brand#14 | ECONOMY PLATED COPPER| 25 | 20 |
| Brand#14 | ECONOMY PLATED NICKEL|7 | 20 |
| Brand#15 | MEDIUM PLATED TIN| 23 | 20 |
| Brand#21 | MEDIUM BRUSHED BRASS | 17 | 20 |
| Brand#21 | PROMO ANODIZED STEEL | 21 | 20 |
| Brand#21 | SMALL BRUSHED NICKEL | 21 | 20 |
| Brand#21 | SMALL BRUSHED STEEL|5 | 20 |
| Brand#21 | SMALL BURNISHED BRASS|7 | 20 |
| Brand#21 | SMALL POLISHED NICKEL|5 | 20 |
| Brand#21 | SMALL POLISHED NICKEL| 23 | 20 |
| Brand#21 | STANDARD ANODIZED COPPER |7 | 20 |
| Brand#22 | PROMO PLATED COPPER| 21 | 20 |
| Brand#23 | ECONOMY POLISHED NICKEL| 25 | 20 |
| Brand#23 | LARGE BRUSHED NICKEL |7 | 20 |
| Brand#23 | LARGE PLATED COPPER|4 | 20 |
| Brand#23 | MEDIUM POLISHED TIN| 25 | 20 |
| Brand#23 | PROMO POLISHED STEEL | 23 | 20 |
| Brand#23 | STANDARD ANODIZED TIN| 21 | 20 |
| Brand#24 | ECONOMY ANODIZED STEEL | 21 | 20 |
| Brand#24 | LARGE ANODIZED TIN | 24 | 20 |
| Brand#24 | LARGE BRUSHED COPPER |4 | 20 |
| Brand#24 | MEDIUM POLISHED BRASS| 23 | 20 |
| Brand#24 | MEDIUM POLISHED COPPER | 23 | 20 |
| Brand#24 | PROMO ANODIZED NICKEL| 21 | 20 |
| Brand#24 | PROMO ANODIZED NICKEL| 25 | 20 |
| Brand#25 | LARGE BRUSHED TIN|7 | 20 |
| Brand#25 | LARGE PLATED COPPER| 25 | 20 |
| Brand#25 | MEDIUM ANODIZED BRASS|4 | 20 |
| Brand#25 | MEDIUM BRUSHED TIN |4 | 20 |
| Brand#25 | PROMO PLATED BRASS |4 | 20 |
| Brand#25 | SMALL BURNISHED NICKEL |4 | 20 |
| Brand#25 | STANDARD ANODIZED NICKEL |4 | 20 |
| Brand#31 | MEDIUM ANODIZED COPPER |7 | 20 |
| Brand#31 | MEDIUM BURNISHED TIN | 17 | 20 |
| Brand#31 | MEDIUM POLISHED BRASS| 17 | 20 |
| Brand#31 | MEDIUM POLISHED TIN|5 | 20 |
| Brand#31 | STANDARD PLATED COPPER |7 | 20 |
| Brand#32 | ECONOMY ANODIZED NICKEL| 24 | 20 |
| Brand#32 | LARGE BURNISHED NICKEL |7 | 20 |
| Brand#32 | PROMO BRUSHED COPPER | 21 | 20 |
| Brand#32 | STANDARD PLATED NICKEL |4 | 20 |
| Brand#33 | PROMO BURNISHED NICKEL | 25 | 20 |
| Brand#33 | PROMO POLISHED BRASS |4 | 20 |
| Brand#33 | SMALL BRUSHED COPPER | 17 | 20 |
| Brand#33 | STANDARD PLATED NICKEL |4 | 20 |
| Brand#34 | ECONOMY PLATED NICKEL| 17 | 20 |
| Brand#34 | MEDIUM ANODIZED STEEL|7 | 20 |
| Brand#35 | ECONOMY BURNISHED COPPER | 17 | 20 |
| Brand#35 | ECONOMY BURNISHED TIN| 25 | 20 |
| Brand#35 | LARGE BRUSHED STEEL|7 | 20 |
| Brand#35 | MEDIUM ANODIZED STEEL| 23 | 20 |
| Brand#35 | MEDIUM BRUSHED BRASS |5 | 20 |
| Brand#35 | PROMO POLISHED STEEL |7 | 20 |
| Brand#41 | LARGE BRUSHED NICKEL | 23 | 20 |
| Brand#41 | LARGE POLISHED COPPER|7 | 20 |
| Brand#41 | SMALL ANODIZED TIN |5 | 20 |
| Brand#41 | SMALL BRUSHED NICKEL |4 | 20 |
| Brand#41 | SMALL BURNISHED COPPER | 23 | 20 |
| Brand#41 | SMALL BURNISHED TIN| 17 | 20 |
| Brand#42 | ECONOMY BRUSHED COPPER |5 | 20 |
| Brand#42 | PROMO POLISHED NICKEL| 24 | 20 |
| Brand#42 | SMALL ANODIZED COPPER|5 | 20 |
| Brand#42 | STANDARD ANODIZED STEEL| 25 | 20 |
| Brand#42 | STANDARD BRUSHED NICKEL|4 | 20 |
| Brand#43 | ECONOMY BURNISHED BRASS| 21 | 20 |
| Brand#43 | MEDIUM PLATED COPPER |4 | 20 |
+----------+--------------------------+--------+--------------+
100 rows in set (0.60 sec)
PROMPT set to '17'
+---------------+
| AVG_YEARLY|
+---------------+
| 306647.830000 |
+---------------+
1 row in set (20 min 39.78 sec)
PROMPT set to '18'
+--------------------+-----------+------------+-------------+--------------+-----------------+
| C_NAME
| C_CUSTKEY | O_ORDERKEY | O_ORDERDATE | O_TOTALPRICE | SUM(L_QUANTITY) |
+--------------------+-----------+------------+-------------+--------------+-----------------+
| Customer#000128120 |128120 |4722021 | 1994-04-07|544089.09 |
323.00 |
| Customer#000144617 |144617 |3043270 | 1997-02-12|530604.44 |
317.00 |
| Customer#000066790 | 66790 |2199712 | 1996-09-30|515531.82 |
327.00 |
| Customer#000015619 | 15619 |3767271 | 1996-08-07|480083.96 |
318.00 |
| Customer#000148885 |148885 |2942469 | 1992-05-31|469630.44 |
313.00 |
| Customer#000147197 |147197 |1263015 | 1997-02-02|467149.67 |
320.00 |
| Customer#000117919 |117919 |2869152 | 1996-06-20|456815.92 |
317.00 |
| Customer#000126865 |126865 |4702759 | 1994-11-07|447606.65 |
320.00 |
| Customer#000036619 | 36619 |4806726 | 1995-01-17|446704.09 |
328.00 |
| Customer#000119989 |119989 |1544643 | 1997-09-20|434568.25 |
320.00 |
+--------------------+-----------+------------+-------------+--------------+-----------------+
10 rows in set (10.34 sec)
PROMPT set to '19'
+--------------+
| REVENUE|
+--------------+
| 4311492.3303 |
+--------------+
1 row in set (1.94 sec)
PROMPT set to '20'
+--------------------+------------------------------------------+
| S_NAME
| S_ADDRESS
|
+--------------------+------------------------------------------+
| Supplier#000000042 | 1Y5lwEgpe3j2vbUBYj3SwLhK62JlwEMtDC |
| Supplier#000000146 | rBDNgCr04x0sfdzD5,gFOutCiG2
|
| Supplier#000000199 | k,8F8FGDuN 3udblO
|
| Supplier#000000311 | yjGDnCKi4Wmtim H3n9p
|
| Supplier#000000367 | E Sv9brQVf43Mzz
|
| Supplier#000000383 | pGEPbc70IKUZuTiTaigKuizjt7Y5oUoDL3Bq1|
| Supplier#000000531 | fN0ix827c112YajETqxxuofrfl7v VndWB38n|
| Supplier#000000546 | YznQGwWvZbNA0O9ZV
|
| Supplier#000000680 | UhvDfdEfJh,Qbe7VZb8uSGO2TU 0jEa6nXZXE|
| Supplier#000000799 | jwFN7ZB3T9sMF
|
| Supplier#000000917 | tMr5motk0IFyIXJDwCr98QO5
|
| Supplier#000000986 | tKoJtnykz0R39BWTgglt0rZxT
|
| Supplier#000001013 | riRcntps4KEDtYScjpMIWeYF6mNnR
|
| Supplier#000001130 | gaw3h9cwNJTDhzgND3Ivew9mM
|
| Supplier#000001148 | yaK1tZuQ8Oqhnll1Doit6kM07LZhmrLw |
| Supplier#000001419 | 9wbge8NxXVd5LbIlNA,DjR0sjasMyxC7oANgSQw|
| Supplier#000001526 | bkKFtZanK27y,IzY
|
| Supplier#000001551 | eUU5Yh2vBpBKaw93MkAui6rLrkjbs9 |
| Supplier#000001666 | z4t8jiCjahT7K E8l
|
| Supplier#000001768 | Ug4jMAaK46J31Z5GFO7x
|
| Supplier#000001867 | YvNHyMcy1wYi3XN
|
| Supplier#000001872 | sGWaZk2cZDYyNazJ
|
| Supplier#000001921 | pT5jR2mpIfa4CqqHdM82Vu,Oc2A9 EUZof |
| Supplier#000001929 | 9HSveX9CpjMcvUFhEeLuaGQlb4zm2kg
|
| Supplier#000001962 | UZAdG60BMZRxwNh7dmXB N9GMgGVnW |
| Supplier#000002201 | qijUKP86TLnIMjrL
|
| Supplier#000002289 | ZNrbGM9zL7vKnvuRIOj0gY9NhEiL
|
| Supplier#000002294 | dcAWrWvBzWRQ8j2lUMRKol3Eq,4xFipvykrHfu |
| Supplier#000002338 | Zr2hwHQYmqjAq95y
|
| Supplier#000002345 | WoJC49Pg7s qEgSIeXGPePT
|
| Supplier#000002352 | 4LfoHUZjgjEbAKw TgdKcgOc4D4uCYw
|
| Supplier#000002392 | xsd6wFsVPZcnWwU1365R
|
| Supplier#000002468 | ppFYJjhM83qk
|
| Supplier#000002470 | o716ZrDQeuT17Ba GW,tcQGh0Avqd y
|
| Supplier#000002526 | 8JWRGgabYBoXKYaQlmUt28W
|
| Supplier#000002555 | GxjCAMEHTP4H
|
| Supplier#000002572 | UjDzDmFXJ bXgX UMB
|
| Supplier#000002847 | kKqzzQNY2FhfJMLQmDAh5p
|
| Supplier#000002848 | yxgyfj4kxIoLMs7kSiemccTW3N 4xxX7mT |
| Supplier#000002916 | 9kNV5lg5OgZp1EmDg7LJ0lu2tZCpFPyOeKFO |
| Supplier#000002920 | Je2a8bszf3L
|
| Supplier#000002987 | aVQPPTYTTw0VYSWfa8y
|
| Supplier#000003037 | aBPbT4XfxDheA
|
| Supplier#000003070 | F0sjr17IwdKH9B7DOZXOnM hjhOsfHy9okdsk|
| Supplier#000003080 | V3DF4DVnZlS4xVJbx049Hr3 WJRr1UroXUCJAJv|
| Supplier#000003167 | G6SS7LfQCuN1VfJ
|
| Supplier#000003179 | SsOOjSkuc957RKFt
|
| Supplier#000003182 | UCmH8hT3ESeCHU,2aIN8YxzLWvhE2c |
| Supplier#000003255 | 4TB2q kbKyVY3
|
| Supplier#000003256 | 0G6XBim3XM8Pfjh510
|
| Supplier#000003431 | r4KMmARJ,uRFYDNdHWqz,biMQqT8vxgQjlTJE2 |
| Supplier#000003478 | mRuc7TmfUuV4YK93HhggTA4lyhoQDbEEO|
| Supplier#000003498 | BsM RxD9QN6nJPzSJM
|
| Supplier#000003543 | 0E6Hi3yS3XtRbHrTG5sL
|
| Supplier#000003605 | xdRVBnukNC3QIuf,,1lbmd800P5 Gx |
| Supplier#000003610 | YjjToWCrnEe5en8pIVN92h nq1nOPyMbwroosJw|
| Supplier#000003712 | O8KIWj0KQCJ8PagC2q18
|
| Supplier#000003745 | h8Y,54J1eu9nBAQQz4
|
| Supplier#000003864 | G4A7fDgFofmhL1lXcnG,Vv6qkWuzwil
|
| Supplier#000003885 | M i ERhP9U FS,0Hi8O4
|
| Supplier#000003914 | uBG4kbR1mp6LQZCp6DlCmpzlw9sh2XnSPMT|
| Supplier#000003990 | wehBBp1RQbfxAYDASS75MsywmsKHRVdkrvNe6m |
| Supplier#000004016 | rxIU3SVvxD3en5QsvEkjq
|
| Supplier#000004075 | hK6J7VA GsAmrmRLV5EWka7h jh
|
| Supplier#000004092 | WPUH06LR5goleIM0McfrAGmxP0FdbzTFfKl8Z0X|
| Supplier#000004166 | dEGlhdQfTkadp
|
| Supplier#000004216 | Llx127Mkqt0rE3H6PLNMeOY
|
| Supplier#000004297 | KIHeBupr0uzfXq20Nk2M0Xjv
|
| Supplier#000004374 | wjl9sEGLUm
|
| Supplier#000004408 | 9PmB6KMkM2JHc7C,LNnj
|
| Supplier#000004460 | 2AqMg2cKVwauYYw8hSpKQEM0M ZuK2ZuWK3T |
| Supplier#000004492 | nkCFbmQfWzPF0WrGOEHAgG,mMrlPGdWVxXIWRSKN |
| Supplier#000004577 | nDL547QPA4p7AkEq4QurW
|
| Supplier#000004590 | fFt6dJwXmsW6OHdt5rxKTwPfNCNyCoZ
|
| Supplier#000004678 | V6Y4jcdvbV5WYKuymyJ6e59,BeHTEfnIy|
| Supplier#000004947 | dd0B6ar90BtBSFLfFiK
|
| Supplier#000004960 | 4 965jqpUhHh5
|
| Supplier#000004976 | rh2cBdhFDyoI8PzP,2rgNb0LJ
|
| Supplier#000005010 | cmYBD2RaTe9vKC0uNoC4aCEu3DOA1B |
| Supplier#000005020 | 8n8le,fK6fN1byNziZYGXTQLv8fTnjlyaM |
| Supplier#000005033 | X0TPY78Zx8uP12hWhTGGiOE8gN
|
| Supplier#000005135 | lmDG6dKYLGrlR 7pJKTtgx
|
| Supplier#000005337 | z nBSOeXSXoEf
|
| Supplier#000005338 | I4Gs7qhuOV
|
| Supplier#000005494 | u5ylCpj7F7mjMz4uXcDdE,n
|
| Supplier#000005559 | cMthDmitw2YdTFpfXkhbZqkiOqNOLfAz |
| Supplier#000005645 | R0XMxCzZ61LlSlf89ISRRYPKuHGrZxe
|
| Supplier#000005751 | yVwqlnvEUAboCZ5GUV
|
| Supplier#000005771 | wqPmXKZoucEWZM0,6s56AjHoZXi7r6skXoV U|
| Supplier#000005827 | O,abBOMPP,r4
|
| Supplier#000005904 | qR3xFuR1VfDt5XfudzZGdoAgS0HR7 xS |
| Supplier#000005936 | jXaNZ6vwnEWJ2ksLZJpjtgt0bY2a3AU
|
| Supplier#000005938 | ZRguRXXgt5uTLe8 oU6tnew7ZSNov NdhDJyuS |
| Supplier#000005942 | JYvMdHg512FjvcF
|
| Supplier#000005979 | iIIPTg3efrljRNU5zdi
|
| Supplier#000006001 | 6S RG2sY99qt8Am ZugMI1,Rvcbl
|
| Supplier#000006058 | t9uuW6i2,ZiwrLrk9S6bGRHWRC
|
| Supplier#000006286 |BqBfmh1kM,6Kp0C4fyByE2
|
| Supplier#000006306 | mSxhoCt9kzDJW00O3d5QHKvDEDqxD9RelvL|
| Supplier#000006456 | FgbEnwK,bZvQgg0
|
+--------------------+------------------------------------------+
100 rows in set (9 min 24.27 sec)
PROMPT set to '21'
+--------------------+---------+
| S_NAME
| NUMWAIT |
+--------------------+---------+
| Supplier#000006337 |22 |
| Supplier#000004266 |19 |
| Supplier#000004091 |18 |
| Supplier#000008510 |18 |
| Supplier#000008725 |18 |
| Supplier#000009825 |18 |
| Supplier#000009879 |18 |
| Supplier#000001981 |17 |
| Supplier#000006545 |17 |
| Supplier#000007362 |17 |
| Supplier#000008429 |17 |
| Supplier#000001102 |16 |
| Supplier#000002781 |16 |
| Supplier#000003693 |16 |
| Supplier#000005565 |16 |
| Supplier#000009319 |16 |
| Supplier#000000240 |15 |
| Supplier#000000930 |15 |
| Supplier#000001424 |15 |
| Supplier#000001577 |15 |
| Supplier#000001630 |15 |
| Supplier#000002278 |15 |
| Supplier#000002802 |15 |
| Supplier#000004044 |15 |
| Supplier#000004901 |15 |
| Supplier#000005246 |15 |
| Supplier#000005803 |15 |
| Supplier#000006020 |15 |
| Supplier#000007459 |15 |
| Supplier#000007878 |15 |
| Supplier#000008085 |15 |
| Supplier#000000932 |14 |
| Supplier#000001101 |14 |
| Supplier#000001264 |14 |
| Supplier#000001293 |14 |
| Supplier#000001445 |14 |
| Supplier#000002545 |14 |
| Supplier#000003565 |14 |
| Supplier#000004784 |14 |
| Supplier#000005190 |14 |
| Supplier#000005294 |14 |
| Supplier#000007392 |14 |
| Supplier#000007903 |14 |
| Supplier#000007994 |14 |
| Supplier#000008533 |14 |
| Supplier#000008805 |14 |
| Supplier#000009943 |14 |
| Supplier#000000009 |13 |
| Supplier#000000218 |13 |
| Supplier#000000286 |13 |
| Supplier#000001003 |13 |
| Supplier#000001233 |13 |
| Supplier#000001552 |13 |
| Supplier#000001652 |13 |
| Supplier#000001953 |13 |
| Supplier#000002693 |13 |
| Supplier#000002970 |13 |
| Supplier#000003166 |13 |
| Supplier#000003324 |13 |
| Supplier#000004384 |13 |
| Supplier#000004820 |13 |
| Supplier#000006078 |13 |
| Supplier#000006189 |13 |
| Supplier#000006622 |13 |
| Supplier#000006696 |13 |
| Supplier#000006717 |13 |
| Supplier#000007085 |13 |
| Supplier#000007258 |13 |
| Supplier#000007394 |13 |
| Supplier#000007507 |13 |
| Supplier#000007637 |13 |
| Supplier#000007751 |13 |
| Supplier#000008216 |13 |
| Supplier#000008514 |13 |
| Supplier#000009385 |13 |
| Supplier#000009439 |13 |
| Supplier#000009996 |13 |
| Supplier#000000299 |12 |
| Supplier#000000396 |12 |
| Supplier#000000489 |12 |
| Supplier#000000644 |12 |
| Supplier#000000830 |12 |
| Supplier#000001024 |12 |
| Supplier#000001273 |12 |
| Supplier#000001392 |12 |
| Supplier#000001677 |12 |
| Supplier#000001762 |12 |
| Supplier#000001997 |12 |
| Supplier#000002145 |12 |
| Supplier#000003098 |12 |
| Supplier#000003172 |12 |
| Supplier#000003398 |12 |
| Supplier#000003466 |12 |
| Supplier#000003568 |12 |
| Supplier#000004161 |12 |
| Supplier#000004286 |12 |
| Supplier#000005339 |12 |
| Supplier#000005418 |12 |
| Supplier#000005604 |12 |
| Supplier#000005841 |12 |
+--------------------+---------+
100 rows in set (5 hours 40 min 40.19 sec)
PROMPT set to '22'
+-----------+---------+------------+
| CNTRYCODE | NUMCUST | TOTACCTBAL |
+-----------+---------+------------+
| 12| 862 | 6454292.96 |
| 13| 889 | 6742716.75 |
| 17| 861 | 6460573.72 |
| 27| 875 | 6555087.11 |
| 29| 949 | 7163868.66 |
| 32| 917 | 6875318.26 |
| 34| 948 | 7176951.89 |
+-----------+---------+------------+
7 rows in set (17 min 8.88 sec)
22

回复

使用道具 举报

千问 | 2012-5-21 10:19:41 | 显示全部楼层
/*
F:\SOFT\TPCH\QUERIES>QGEN
-- USING 1715872891 AS A SEED TO THE RNG
*/
PROMPT 1
SELECT
L_RETURNFLAG,
L_LINESTATUS,
SUM(L_QUANTITY) AS SUM_QTY,
SUM(L_EXTENDEDPRICE) AS SUM_BASE_PRICE,
SUM(L_EXTENDEDPRICE * (1 - L_DISCOUNT)) AS SUM_DISC_PRICE,
SUM(L_EXTENDEDPRICE * (1 - L_DISCOUNT) * (1 + L_TAX)) AS SUM_CHARGE,
AVG(L_QUANTITY) AS AVG_QTY,
AVG(L_EXTENDEDPRICE) AS AVG_PRICE,
AVG(L_DISCOUNT) AS AVG_DISC,
COUNT(*) AS COUNT_ORDER
FROM
LINEITEM
WHERE
L_SHIPDATEDATE '1995-03-28'
GROUP BY
L_ORDERKEY,
O_ORDERDATE,
O_SHIPPRIORITY
ORDER BY
REVENUE DESC,
O_ORDERDATE
LIMIT 10;

PROMPT 4
SELECT
O_ORDERPRIORITY,
COUNT(*) AS ORDER_COUNT
FROM
ORDERS
WHERE
O_ORDERDATE >= DATE '1997-05-01'
AND O_ORDERDATE = DATE '1996-01-01'
AND O_ORDERDATE = DATE '1996-01-01'
AND L_SHIPDATE = DATE '1993-11-01'
AND O_ORDERDATE(

SELECT

SUM(PS_SUPPLYCOST * PS_AVAILQTY) * 0.0001000000

FROM

PARTSUPP,

SUPPLIER,

NATION

WHERE

PS_SUPPKEY = S_SUPPKEY

AND S_NATIONKEY = N_NATIONKEY

AND N_NAME = 'UNITED STATES'

)
ORDER BY
VALUE DESC
LIMIT 100;

PROMPT 12
SELECT
L_SHIPMODE,
SUM(CASE

WHEN O_ORDERPRIORITY = '1-URGENT'

OR O_ORDERPRIORITY = '2-HIGH'

THEN 1

ELSE 0
END) AS HIGH_LINE_COUNT,
SUM(CASE

WHEN O_ORDERPRIORITY'1-URGENT'

AND O_ORDERPRIORITY'2-HIGH'

THEN 1

ELSE 0
END) AS LOW_LINE_COUNT
FROM
ORDERS,
LINEITEM
WHERE
O_ORDERKEY = L_ORDERKEY
AND L_SHIPMODE IN ('FOB', 'AIR')
AND L_COMMITDATE = DATE '1994-01-01'
AND L_RECEIPTDATE = DATE '1994-05-01'
AND L_SHIPDATE = DATE '1993-06-01'

AND L_SHIPDATE'Brand#51'
AND P_TYPE NOT LIKE 'STANDARD POLISHED%'
AND P_SIZE IN (17, 7, 21, 5, 24, 25, 4, 23)
AND PS_SUPPKEY NOT IN (

SELECT

S_SUPPKEY

FROM

SUPPLIER

WHERE

S_COMMENT LIKE '%Customer%Complaints%'
)
GROUP BY
P_BRAND,
P_TYPE,
P_SIZE
ORDER BY
SUPPLIER_CNT DESC,
P_BRAND,
P_TYPE,
P_SIZE
LIMIT 100;

PROMPT 17
SELECT
SUM(L_EXTENDEDPRICE) / 7.0 AS AVG_YEARLY
FROM
LINEITEM,
PART
WHERE
P_PARTKEY = L_PARTKEY
AND P_BRAND = 'Brand#11'
AND P_CONTAINER = 'LG PKG'
AND L_QUANTITY312
)
AND C_CUSTKEY = O_CUSTKEY
AND O_ORDERKEY = L_ORDERKEY
GROUP BY
C_NAME,
C_CUSTKEY,
O_ORDERKEY,
O_ORDERDATE,
O_TOTALPRICE
ORDER BY
O_TOTALPRICE DESC,
O_ORDERDATE
LIMIT 100;

PROMPT 19
SELECT
SUM(L_EXTENDEDPRICE* (1 - L_DISCOUNT)) AS REVENUE
FROM
LINEITEM,
PART
WHERE
(

P_PARTKEY = L_PARTKEY

AND P_BRAND = 'Brand#25'

AND P_CONTAINER IN ('SM CASE', 'SM BOX', 'SM PACK', 'SM PKG')

AND L_QUANTITY >= 10 AND L_QUANTITY = 20 AND L_QUANTITY = 23 AND L_QUANTITY(

SELECT

0.5 * SUM(L_QUANTITY)

FROM

LINEITEM

WHERE

L_PARTKEY = PS_PARTKEY

AND L_SUPPKEY = PS_SUPPKEY

AND L_SHIPDATE >= DATE '1995-01-01'

AND L_SHIPDATEL1.L_COMMITDATE
AND EXISTS (

SELECT

*

FROM

LINEITEM L2

WHERE

L2.L_ORDERKEY = L1.L_ORDERKEY

AND L2.L_SUPPKEYL1.L_SUPPKEY
)
AND NOT EXISTS (

SELECT

*

FROM

LINEITEM L3

WHERE

L3.L_ORDERKEY = L1.L_ORDERKEY

AND L3.L_SUPPKEYL1.L_SUPPKEY

AND L3.L_RECEIPTDATE > L3.L_COMMITDATE
)
AND S_NATIONKEY = N_NATIONKEY
AND N_NAME = 'IRAN'
GROUP BY
S_NAME
ORDER BY
NUMWAIT DESC,
S_NAME
LIMIT 100;

PROMPT 22
SELECT
CNTRYCODE,
COUNT(*) AS NUMCUST,
SUM(C_ACCTBAL) AS TOTACCTBAL
FROM
(

SELECT

SUBSTRING(C_PHONE FROM 1 FOR 2) AS CNTRYCODE,

C_ACCTBAL

FROM

CUSTOMER

WHERE

SUBSTRING(C_PHONE FROM 1 FOR 2) IN

('32', '12', '13', '29', '34', '17', '27')

AND C_ACCTBAL > (

SELECT

AVG(C_ACCTBAL)

FROM

CUSTOMER

WHERE

C_ACCTBAL > 0.00

AND SUBSTRING(C_PHONE FROM 1 FOR 2) IN

('32', '12', '13', '29', '34', '17', '27')

)

AND NOT EXISTS (

SELECT

*

FROM

ORDERS

WHERE

O_CUSTKEY = C_CUSTKEY

)
) AS CUSTSALE
GROUP BY
CNTRYCODE
ORDER BY
CNTRYCODE
LIMIT 100;
回复

使用道具 举报

千问 | 2012-5-21 10:19:41 | 显示全部楼层
[root@redflag11012501 ~]# /usr/bin/mysql-ib
Welcome to the MySQL monitor.Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 5.1.40-log build number (revision)=IB_3.4.2_DPN128_9237(iee_eval - commercial)
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> use tpch;
Database changed
mysql> source /user1/app/oradata/tpch_fix_up.sql
PROMPT set to '1'
+--------------+--------------+-------------+-----------------+-------------------+-----------------+-----------+--------------+----
------+-------------+
| L_RETURNFLAG | L_LINESTATUS | SUM_QTY | SUM_BASE_PRICE| SUM_DISC_PRICE| SUM_CHARGE| AVG_QTY | AVG_PRICE| AVG
_DISC | COUNT_ORDER |
+--------------+--------------+-------------+-----------------+-------------------+-----------------+-----------+--------------+----
------+-------------+
| A
| F
| 37734107.00 |56586554400.73 |53758257134.8700 |55909065222.82 | 25.522006 | 38273.129735 | 0.0
49985 | 1478493 |
| N
| F
| 991417.00 | 1487504710.38 | 1413082168.0541 | 1469649223.19 | 25.516472 | 38284.467761 | 0.0
50093 | 38854 |
| N
| O
| 73477184.00 | 110203196620.51 | 104694637634.7276 | 108886216147.03 | 25.502542 | 38249.446708 | 0.0
49996 | 2881171 |
| R
| F
| 37719753.00 |56568041380.90 |53741292684.6040 |55889619119.83 | 25.505794 | 38250.854626 | 0.0
50009 | 1478870 |
+--------------+--------------+-------------+-----------------+-------------------+-----------------+-----------+--------------+----
------+-------------+
4 rows in set (24.13 sec)
PROMPT set to '2B2'
+-----------+--------------------+--------------+-----------+----------------+------------------------------------------+-----------
------+-----------------------------------------------------------------------------------------------------+
| S_ACCTBAL | S_NAME
| N_NAME | P_PARTKEY | P_MFGR | S_ADDRESS
| S_PHONE
| S_COMMENT
|
+-----------+--------------------+--------------+-----------+----------------+------------------------------------------+-----------
------+-----------------------------------------------------------------------------------------------------+
| 9977.32 | Supplier#000007895 | EGYPT|140352 | Manufacturer#2 | NYl,i8UhxTykLxGJ2voIRn20Ugk1KTzz | 14-559-808
-3306 | mptotes near the quickly sp
|
| 9956.34 | Supplier#000005108 | IRAN | 27601 | Manufacturer#3 | d3PLCdpPP3uE4GzbbAh4bWmU 7ecOifL9e1mNnzG | 20-842-882
-7047 | ronic accounts. carefully bold accounts sleep beyond
|
| 9956.34 | Supplier#000005108 | IRAN |170073 | Manufacturer#4 | d3PLCdpPP3uE4GzbbAh4bWmU 7ecOifL9e1mNnzG | 20-842-882
-7047 | ronic accounts. carefully bold accounts sleep beyond
|
| 9947.70 | Supplier#000009151 | IRAN | 54140 | Manufacturer#3 |25lLOrzuKU8mG0xGP2SLkfo6Kfew7Kb4YuRv| 20-492-750
-3318 | s. quickly unusual requests thrash furiou
|
| 9895.96 | Supplier#000002783 | IRAQ | 20280 | Manufacturer#4 | rc rAYfUYEGG95YWvE
| 21-174-613
-1836 | ronic foxes cajole slyly against the furiously regular platelets. slyly regular platele
|
| 9895.96 | Supplier#000002783 | IRAQ | 32782 | Manufacturer#4 | rc rAYfUYEGG95YWvE
| 21-174-613
-1836 | ronic foxes cajole slyly against the furiously regular platelets. slyly regular platele
|
| 9895.14 | Supplier#000006716 | JORDAN | 86715 | Manufacturer#3 | BJaPDjafIrQQlD4cP
| 23-153-259
-3388 | ng requests against the slyly specia
|
| 9889.10 | Supplier#000007220 | EGYPT|9719 | Manufacturer#4 | ,7dILJeEhKrHly2nD2K7BXNrioZ2w
| 14-575-445
-3713 | ccording to the final realms are furiously unus
|
| 9806.52 | Supplier#000005276 | IRAQ | 57760 | Manufacturer#1 | inh0KOhRfLM7WRhdRNvJJDQx
| 21-834-496
-7360 | the slyly unusual theodolites; carefully even accounts use slyly. sl
|
| 9775.37 | Supplier#000007245 | IRAQ | 99717 | Manufacturer#5 | 5VOUnvxlJeOJ
| 21-663-724
-2985 | ic deposits about the slyly bold requests
|
| 9754.60 | Supplier#000000133 | EGYPT|137619 | Manufacturer#5 | QT,semYwdx
| 14-731-952
-5158 | he quickly express instructions
|
| 9714.60 | Supplier#000007317 | EGYPT| 69798 | Manufacturer#1 | nJGsPl2ruoq4Ydtv0fwWG385eOFV6VUokbCZ | 14-666-351
-2592 | ons integrate furiously? slyly ironic requests sl
|
| 9656.61 | Supplier#000004286 | IRAN |174285 | Manufacturer#4 | OsUz6fvS3Y8mGw2rdWmjTh0nEonjaoUduz | 20-857-469
-4413 | uthlessly closely final requests. blithely even packages sublate quick
|
| 9623.30 | Supplier#000003166 | IRAN |115632 | Manufacturer#2 | xdb6MfO7FcPZtB9
| 20-417-589
-8306 | uests cajole slyly around the final, express foxes. finall
|
| 9598.00 | Supplier#000005347 | SAUDI ARABIA |2846 | Manufacturer#2 | R UJfAVRhAKjgH
| 30-213-668
-2389 | ites. packages cajole about the furiously regular accounts. blithely unusual packages are dogg|
| 9577.42 | Supplier#000008123 | JORDAN |118122 | Manufacturer#2 | RVD,e4jMiFVi4gCAa0oH,enjjIBuV1LL1Wzm | 23-305-520
-8530 |fluffily ironic requests boost blithely quickly ironic fo
|
| 9535.76 | Supplier#000008458 | EGYPT|148457 | Manufacturer#5 | rihX1QITvV1JaC
| 14-822-547
-8952 |foxes boost furiously across the slyly express excuses. quickly ex
|
| 9535.76 | Supplier#000008458 | EGYPT|158457 | Manufacturer#5 | rihX1QITvV1JaC
| 14-822-547
-8952 |foxes boost furiously across the slyly express excuses. quickly ex
|
| 9513.31 | Supplier#000004163 | SAUDI ARABIA |101652 | Manufacturer#2 | 2VnQypC7pJPJRu6HzYRg7nAvhzckcYAQFbI| 30-544-852
-3772 | he regular requests. blithely final
|
| 9468.49 | Supplier#000006023 | JORDAN | 81006 | Manufacturer#3 | QzUNYNJKE1
| 23-467-863
-9965 | efully slyly pending hockey players. instructions nag blithely sp
|
| 9449.33 | Supplier#000009349 | IRAQ |116837 | Manufacturer#3 | oJIlkL3FqiKkYqmmIeu18HzDE0WnPpoG3R8bS| 21-197-322
-4895 | al deposits. permanent requests boost according to the special, regular ide
|
| 9445.99 | Supplier#000004274 | SAUDI ARABIA |199235 | Manufacturer#2 | VpVZ1PbArLtxZ1ryS,9 j5dzYgTC0Dy0 DWM | 30-322-776
-7259 | packages boost carefully across the carefully special sheaves. c
|
| 9444.33 | Supplier#000008145 | EGYPT|173110 | Manufacturer#1 | M7SygdLkUNK7XTG
| 14-525-780
-1695 | beans. furiously final platelets cajole quickly. furio
|
| 9324.00 | Supplier#000002707 | SAUDI ARABIA | 47698 | Manufacturer#4 | xMXO5KpIsdXt,mJ5
| 30-127-723
-4248 | tect. carefully regular deposit
|
| 9318.43 | Supplier#000000627 | IRAQ |158111 | Manufacturer#2 | k6W51QENyVPe4 6z0ajEMTkEA
| 21-632-574
-8701 | l instructions serve slyly regular deposits. carefully busy excuses cajole quickly pending d|
| 9311.16 | Supplier#000002401 | JORDAN |189882 | Manufacturer#4 | MZoiVRB8uOVheBJmKYKScBpZkLYSOe2wQIoDsIX| 23-883-970
-4369 | encies along the even deposits haggle regul
|
| 9284.57 | Supplier#000009781 | EGYPT| 87272 | Manufacturer#5 | 49NAd1iDiY4,
| 14-410-636
-4312 | its. ironic pinto beans are blithely. express depths use caref
|
| 9284.57 | Supplier#000009781 | EGYPT|197261 | Manufacturer#4 | 49NAd1iDiY4,
| 14-410-636
-4312 | its. ironic pinto beans are blithely. express depths use caref
|
| 9243.92 | Supplier#000007633 | IRAQ |147632 | Manufacturer#1 |rsl6lh6tEzOKpo6r8ph3A1OuqK zEOBs5Y7l| 21-473-187
-3309 | g ideas kindle slyly? carefully ironic deposits boost furiously special asymptotes. furiousl|
| 9214.58 | Supplier#000005477 | IRAQ | 75476 | Manufacturer#1 | fOzXmCgwtUn E2O8R8NXiDYLibNr8ThjiTJXJZ | 21-195-969
-7717 | ounts against the express ideas use slyly after the
|
| 9093.11 | Supplier#000003063 | SAUDI ARABIA |123062 | Manufacturer#2 | kBUdB0mUgc HX2EzKnh
| 30-532-979
-8127 |the slyly unusual accounts affix slyly bet
|
| 9060.44 | Supplier#000002224 | JORDAN | 14720 | Manufacturer#1 | 08hDtcJ8EUZ0nMxMrZiEiNH9RM08gIqt0DAst| 23-714-590
-7668 | accounts sleep. express, express packages sleep fluffily at the quickly ironic foxes. slyly unusu |
| 9050.12 | Supplier#000000504 | IRAN |135477 | Manufacturer#1 | P8k2mjRiRUFCJfxw7KrEdRpNNQPDxiI
| 20-322-544
-5770 | y final pinto beans. blithely regular instructions wake abo
|
| 8924.44 | Supplier#000001374 | EGYPT|136347 | Manufacturer#1 | uHLiKIkGMCK39DBiPLySDhM1
| 14-105-774
-9435 | pecial deposits along the slyly unusual excuses wake ironically
|
| 8906.10 | Supplier#000007076 | EGYPT|184557 | Manufacturer#4 | DjLJ,yEKffpT,EKIbM6ZziTtzvCbE
| 14-929-221
-6504 | nusual requests solve furiously across the carefully regular excuses. requests are quickly c|
| 8876.42 | Supplier#000004468 | IRAN |126931 | Manufacturer#1 | QxE2rvpMCkB,nto33X7a0n0FFV
| 20-536-285
-9136 | encies. slyly pending ideas boost blithely.
|
| 8855.28 | Supplier#000003075 | SAUDI ARABIA | 50569 | Manufacturer#1 | 4r1HsHGBEH88qIxsG8Dr9
| 30-700-119
-4521 | packages. carefully unusual requests wak
|
| 8843.88 | Supplier#000000218 | IRAN |155187 | Manufacturer#3 | c7CBVglgEM0XU,8bOU76GjEr5L5EXu9Uxa7U | 20-180-767
-8426 |fluffily. furiously regular instructions sleep slyly furiously regular packa
|
| 8820.62 | Supplier#000005117 | IRAN | 42612 | Manufacturer#1 | zlBi4yswhLa1yv54Mrurx6Ldl2EWiegBiH | 20-400-529
-7218 | wind: slyly special deposits affix furiously behind the quickly ironic requests. fluffily express a |
| 8797.73 | Supplier#000002322 | SAUDI ARABIA | 14818 | Manufacturer#4 | ijvybmLZ9eaW7,u4TXUiW5AxLeEQj2GpnHC2Rj | 30-373-325
-3862 | slyly about the furiously regular accounts. blithely
|
| 8797.73 | Supplier#000002322 | SAUDI ARABIA |117299 | Manufacturer#2 | ijvybmLZ9eaW7,u4TXUiW5AxLeEQj2GpnHC2Rj | 30-373-325
-3862 | slyly about the furiously regular accounts. blithely
|
| 8795.09 | Supplier#000008261 | JORDAN |130721 | Manufacturer#5 | OE8VCFunRj1dNf
| 23-540-992
-1108 | ent accounts boost fluffily pinto beans. requests detect carefully. even, ironic accoun
|
| 8788.46 | Supplier#000003437 | IRAN | 88420 | Manufacturer#4 | JfgZDO9fsP4ljfzsi,s7431Ld3A7zXtHfrF74| 20-547-871
-1712 | ickly unusual dependencies. carefully regular dolphins ha
|
| 8717.99 | Supplier#000009405 | IRAQ | 66898 | Manufacturer#4 | IY1x8B2MaqzWuk1KzA6FJua
| 21-778-728
-5704 | al packages. slyly even theodolites doubt blithely. slyly regular asymptotes a
|
| 8703.31 | Supplier#000008176 | IRAQ |165659 | Manufacturer#5 | cQBg1Bxn5LxxR h ZnF SCIZO 0XZpEsP0vkfc | 21-209-627
-8129 | e carefully even packages detect against the final, unusual ideas. blithely bold
|
| 8687.00 | Supplier#000005896 | SAUDI ARABIA |145895 | Manufacturer#5 | NwV,QYlRuz
| 30-167-592
-8264 | deposits use slyly furiously bold packages; furious
|
| 8659.37 | Supplier#000005604 | IRAN | 43099 | Manufacturer#1 | RBi1ab0lYokQsmhcPLIuKOlJ3GX0xZbYX| 20-836-715
-9065 | pecial asymptotes? carefully f
|
| 8594.80 | Supplier#000007553 | IRAN | 52542 | Manufacturer#1 | wAU2Lui w9
| 20-663-409
-7956 | old, stealthy accounts are blithely. fluffily final
|
| 8594.80 | Supplier#000007553 | IRAN |165036 | Manufacturer#1 | wAU2Lui w9
| 20-663-409
-7956 | old, stealthy accounts are blithely. fluffily final
|
| 8555.40 | Supplier#000005715 | JORDAN | 30708 | Manufacturer#4 | ZW R6zxZtBFRoeaZtQw8YifUBoqSv16hG| 23-268-174
-1595 | e blithely silent multipliers are
|
| 8553.36 | Supplier#000005418 | IRAN |132904 | Manufacturer#3 | eLGAV8u15ZX2e5pJa GEg8VBKQX9Gi1
| 20-897-164
-8136 | detect carefully ironic theodolites. silently regular packages against
|
| 8525.33 | Supplier#000003234 | SAUDI ARABIA |163233 | Manufacturer#1 | 1916uLszlZz
| 30-583-104
-8386 | eodolites? furiously regular foxes accordin
|
| 8484.29 | Supplier#000008178 | IRAQ |190620 | Manufacturer#5 | Kzuv9PrThE56fWmNR3UtwZAz
| 21-201-455
-3427 | s. ironic, special deposits cajole carefully furiously final requests. pending packages sleep quick |
| 8473.01 | Supplier#000003912 | IRAQ |133911 | Manufacturer#2 | Op7,1zt3MAxs34Qo4O W
| 21-474-809
-6508 | es. regular, brave instructions wa
|
| 8466.50 | Supplier#000000069 | EGYPT| 92541 | Manufacturer#1 | T2Dl9,f97e333eRuMi2z
| 14-491-707
-8310 | ! carefully ironic instructions nag quickly pending requests. fluffily even deposits sleep a|
| 8448.94 | Supplier#000001416 | JORDAN | 73894 | Manufacturer#5 | PYA5L32bQcST4 vGIH,VEEbSIuAxk
| 23-420-251
-7666 | inal deposits. special dependencies boost slyly final ideas. eve
|
| 8433.57 | Supplier#000006569 | SAUDI ARABIA |119035 | Manufacturer#3 | sk5AhyyRnxAczOZ76XvjGU uDEnyHQSVIQ2| 30-561-849
-3346 | os according to the permanent packages snooze bravely fu
|
| 8383.60 | Supplier#000008136 | SAUDI ARABIA |123111 | Manufacturer#4 | kXATyaEZOWdQC7fE43IquuR1HkKV8qx
| 30-268-895
-2611 | er the carefully regular depths. pinto beans detect quickly p
|
| 8377.27 | Supplier#000006837 | EGYPT| 54331 | Manufacturer#3 | vokfcIaDMaf2hG
| 14-530-767
-7768 | unts along the slyly regular instructions detect slyly unusual deposits.
|
| 8351.75 | Supplier#000007495 | IRAQ |124982 | Manufacturer#3 | 3jQQGvfs,5Aryhn0Z
| 21-953-463
-7239 |requests. carefully final accounts after the qui
|
| 8330.85 | Supplier#000006020 | IRAN | 93510 | Manufacturer#1 | U9O4ceIDl0DMRPM0vvsKKj3gzGwNkcUeusC| 20-817-604
-6561 | ly? final packages are blithely ironic ideas. carefully special packages kindle blithely expre|
| 8230.12 | Supplier#000001058 | SAUDI ARABIA |128545 | Manufacturer#4 | fJ8egP,xkLygXGv8bmtc9T1FJ
| 30-496-504
-3341 |requests haggle? regular, regular pinto beans integrate fluffily. dependenc
|
| 8208.02 | Supplier#000006883 | IRAN |111860 | Manufacturer#5 | 7Jow14LNWvnADcfBjCQZuq8AMIuu4e,kf| 20-745-172
-4921 |according to the fluffily pending packages cajole slyly carefully pending accounts. quickly|
| 8199.77 | Supplier#000002357 | SAUDI ARABIA | 27352 | Manufacturer#1 | V8x3JyiEOtAo0w
| 30-139-515
-7766 |dependencies. pending reques
|
| 8193.26 | Supplier#000003057 | IRAN | 98038 | Manufacturer#4 | nI,owTJt24PQXdzm
| 20-976-269
-2335 | aids sleep. carefully regular depths are of the blithely express depo
|
| 8175.17 | Supplier#000003172 | IRAN | 50666 | Manufacturer#1 | 8ngbGS7BQoTDmJyMa5WV9XbaM31u5FAayd2vT3 | 20-834-374
-7746 | ss deposits use furiously after the quickly final sentiments. fluffily ruthless ideas believe regu|
| 8142.90 | Supplier#000008320 | IRAQ | 53309 | Manufacturer#1 | FB TdvQvk36
| 21-388-687
-9284 | accounts wake about the slyly bold platelets. furiously ironic foxes doubt ab
|
| 8136.60 | Supplier#000005721 | SAUDI ARABIA | 85720 | Manufacturer#4 | LXqfP897JYdfIlo dNqHuY4T
| 30-202-248
-8360 | ng requests. carefully regular accounts along the
|
| 8111.40 | Supplier#000007567 | IRAN |195047 | Manufacturer#3 | 7W4k2qEVoBkRehprGliXRSYVOQEh
| 20-377-181
-7435 | gular foxes. silent attainments boost furiousl
|
| 8106.47 | Supplier#000001028 | IRAQ | 21027 | Manufacturer#4 | nOkvPq5WfeN87ASUIgQNKT2U0TUX 4WzZQ3f | 21-570-218
-8213 | riously bold accounts haggle slyly after the blithely u
|
| 8096.36 | Supplier#000002169 | IRAQ | 79661 | Manufacturer#5 | JKBnBaxV,0z4lwgBupYpPWIIaoCPUG | 21-931-513
-1870 | ely permanent pinto beans are above the requests! quickly final pearls are regular, ironic requ |
| 8081.62 | Supplier#000007075 | IRAQ | 99547 | Manufacturer#1 | 52hMohrQKM
| 21-580-554
-9032 | ecial packages. pending accounts grow carefully;
|
| 8075.30 | Supplier#000000513 | EGYPT|120512 | Manufacturer#3 | YMhcTaVkhw0nO9B,
| 14-481-495
-8505 |final requests. slyly final reque
|
| 8045.75 | Supplier#000008529 | SAUDI ARABIA | 48528 | Manufacturer#3 | l4Y,f11TYz7Ph1erL7IM9AXf0poUIrO2OS | 30-791-579
-2088 | xpress deposits are furiously. blithely regular dolphins affix blithely enticingly regular t|
| 8040.16 | Supplier#000001925 | SAUDI ARABIA | 74403 | Manufacturer#3 | Cu5Ub AAdXT
| 30-969-417
-1108 | pending packages across the regular req
|
| 8015.11 | Supplier#000003589 | IRAN |111077 | Manufacturer#1 | SeVq5mliNtWVvH0NmB
| 20-895-735
-3345 | about the bold asymptotes. slyly ironic platelets sleep aga
|
| 8008.36 | Supplier#000003366 | JORDAN |180847 | Manufacturer#4 | iev0jGXt7AL5A9cTl7GCeO0lG8S
| 23-320-193
-4544 |wake carefully pending depths. carefully regular packages cajole idly da
|
| 8007.83 | Supplier#000006266 | JORDAN |111243 | Manufacturer#2 | XWBf5Jd2V5SOurbn11Tt1
| 23-363-445
-7184 | as cajole carefully against the quickly special ac
|
| 7977.48 | Supplier#000001134 | EGYPT| 61133 | Manufacturer#5 | WkRjMQOKvjH4g4RsFZomI9UKUjTw9gq
| 14-183-918
-4545 |alongside of the orbits. pending instr
|
| 7977.48 | Supplier#000001134 | EGYPT| 73612 | Manufacturer#5 | WkRjMQOKvjH4g4RsFZomI9UKUjTw9gq
| 14-183-918
-4545 |alongside of the orbits. pending instr
|
| 7933.97 | Supplier#000002598 | JORDAN |122597 | Manufacturer#1 | tunUZrfZ3bzb0e0vhmhtmp6LR9aC
| 23-511-169
-9974 | nstructions! regular asymptotes wake above the sometimes special accounts. slyly special asympt |
| 7890.01 | Supplier#000006843 | IRAQ |134329 | Manufacturer#4 | JDyLWm,Nn8,Pkfx,9zB,iWgq 4
| 21-443-521
-5425 | al, regular pinto beans sleep furiously above the ironic, even pinto b
|
| 7874.99 | Supplier#000002457 | IRAN |164908 | Manufacturer#1 | iPOyBsGzl,I4 cRkMelt4PRpNzFx9 dkGC1Eu| 20-752-453
-1043 | ing foxes boost slyly finally express theodolites-- even, regular ideas kindle. e
|
| 7832.77 | Supplier#000009693 | IRAQ |144664 | Manufacturer#2 | ,NtpOfxQv JMEv CJZjPvD,YFL
| 21-884-330
-4663 | ly final instructions wake slyly according to the carefully express asymptotes. fluffily regul|
| 7817.89 | Supplier#000006446 | EGYPT|153930 | Manufacturer#4 | zc UqeKpg3W8Y
| 14-901-464
-2207 | ts use fluffily. furiously regular foxes around the
|
| 7809.11 | Supplier#000007873 | IRAQ |105362 | Manufacturer#2 | nqHeHayWL6GV4yrpCaUhESHiWlB75HXGxeP7Z| 21-910-520
-4230 | even ideas wake quickly across the accounts. final accounts w
|
| 7789.12 | Supplier#000006421 | EGYPT|168872 | Manufacturer#2 | AwhpC5y15ua6plU8rtMwx
| 14-514-734
-7640 | ial dependencies; regular pinto beans use after the furiously bold somas. idly dogged packages ha |
| 7788.45 | Supplier#000000413 | IRAQ | 412 | Manufacturer#1 | GAufsRQQE P,dVCZWIMEUAsm,7
| 21-875-836
-5585 |the fluffily even pinto beans. closely regular asympt
|
| 7751.80 | Supplier#000007392 | IRAN |124879 | Manufacturer#3 | JeeScPASUUcJFQbjB5BVwXb8De3VTYddzkGwBv | 20-928-350
-9877 | ular accounts detect carefully along the unusual pinto beans. final, special pla
|
| 7741.10 | Supplier#000001059 | IRAN | 36052 | Manufacturer#2 | 4tBenOMokWbWVRB8i8HwENeO cQjM9 | 20-620-710
-8984 |to the carefully special courts.
|
| 7719.51 | Supplier#000005848 | SAUDI ARABIA |163331 | Manufacturer#2 | xxheHzTSroSqvL,Jt4bni7n1
| 30-144-868
-2228 | y even epitaphs haggle fluffily along the blithely regular r
|
| 7685.78 | Supplier#000002738 | IRAQ |115204 | Manufacturer#4 | uc,zYilzDQIkEmH8dWYJE9M681TmlEPsdFCtB6NY | 21-215-533
-3433 | y even dinos sleep carefully final, final deposits. regular accounts wake sl
|
| 7656.34 | Supplier#000006909 | SAUDI ARABIA |189354 | Manufacturer#2 | f9A W4Urm31d RTFKjt1,V3
| 30-189-225
-4097 | ffily after the thinly regular instructions. quickly final deposits against th
|
| 7632.13 | Supplier#000007720 | EGYPT|122695 | Manufacturer#2 | ERjXnwOJ1vSklF,yOm66
| 14-733-939
-9211 |against the even packages. slyly special requests sleep. regular f
|
| 7631.14 | Supplier#000006814 | EGYPT|4313 | Manufacturer#4 | 83A GGXkYiww58
| 14-312-658
-3824 | zzle among the blithely sly packages. pending excuses pri
|
| 7606.44 | Supplier#000001236 | IRAN |138722 | Manufacturer#5 | qpYv0hQmP8aiXnIAm1o
| 20-247-189
-6514 | s; carefully unusual deposits affix quickly. silent cou
|
| 7601.35 | Supplier#000008443 | JORDAN |128442 | Manufacturer#2 | 4NVFgmnKNRe
| 23-767-598
-9866 | re quickly above the express,
|
| 7591.79 | Supplier#000009723 | JORDAN | 77215 | Manufacturer#5 | Q1CkkpDdlLOpCJiV,zIf,Mv86otWhxj7slGc | 23-710-907
-3873 | e fluffily even instructions. packages impress enticingly.
|
| 7570.01 | Supplier#000008141 | IRAN |100610 | Manufacturer#1 | u4oIjr7XbM
| 20-777-745
-4221 | ckages snooze about the furiously regular accounts. carefully regular epitaphs mig
|
| 7568.83 | Supplier#000003013 | EGYPT|3012 | Manufacturer#5 | LPjXyEI0Vb7,
| 14-108-315
-4034 | gside of the slyly special braids. quickly even accounts cajole amo
|
+-----------+--------------------+--------------+-----------+----------------+------------------------------------------+-----------
------+-----------------------------------------------------------------------------------------------------+
100 rows in set (1.05 sec)
PROMPT set to '4B'
+-----------------+-------------+
| O_ORDERPRIORITY | ORDER_COUNT |
+-----------------+-------------+
| 1-URGENT| 10775 |
| 2-HIGH
| 10569 |
| 3-MEDIUM| 10352 |
| 4-NOT SPECIFIED | 10686 |
| 5-LOW | 10647 |
+-----------------+-------------+
5 rows in set (3.17 sec)
PROMPT set to '4C'
+-----------------+-------------+
| O_ORDERPRIORITY | ORDER_COUNT |
+-----------------+-------------+
| 1-URGENT| 10775 |
| 2-HIGH
| 10569 |
| 3-MEDIUM| 10352 |
| 4-NOT SPECIFIED | 10686 |
| 5-LOW | 10647 |
+-----------------+-------------+
5 rows in set (5.52 sec)
PROMPT set to '10B'
+-----------+--------------------+-------------+-----------+----------------+---------------------------------------+---------------
--+----------------------------------------------------------------------------------------------------------------------+
| C_CUSTKEY | C_NAME
| REVENUE | C_ACCTBAL | N_NAME | C_ADDRESS
| C_PHONE
| C_COMMENT
|
+-----------+--------------------+-------------+-----------+----------------+---------------------------------------+---------------
--+----------------------------------------------------------------------------------------------------------------------+
|108763 | Customer#000108763 | 683768.0205 | -180.10 | UNITED KINGDOM | vco1AzEQTcuYKgyikRysXR4B3m7O54| 33-420-572-902
9 | he unusual accounts sleep after the pending deposits. fluffily final deposits wake blithe
|
| 25501 | Customer#000025501 | 668810.6109 | 7725.04 | ETHIOPIA | W556MXuoiaYCCZamJI,Rn0B4ACUGdkQ8DZ| 15-874-808-679
3 | he pending instructions wake carefully at the pinto beans. regular, final instructions along the slyly fina
|
|101998 | Customer#000101998 | 666019.9772 | 3790.89 | UNITED KINGDOM | 01c9CILnNtfOQYmZj
| 33-593-865-637
8 | ress foxes wake slyly after the bold excuses. ironic platelets are furiously carefully bold theodolites
|
| 856 | Customer#000000856 | 659357.0470 | 6988.55 | MOROCCO| X4U7LH4YtDzephie
| 25-336-316-964
1 | y bold pinto beans according to the pending foxes
|
| 78790 | Customer#000078790 | 641913.6405 | 2241.94 | ARGENTINA| Ub1PPvbnz8987sZ,HDj89yWAszt,PH| 11-834-965-840
1 | ly fluffily special deposits.
|
| 20087 | Customer#000020087 | 620624.3536 | 9948.25 | ETHIOPIA | rr3wyEfj flMHU5j7asOPP1 C hjrBbdByb5o | 15-880-746-162
0 | ets are along the carefully pending theodolites. evenly ironic requests lose above the blithel
|
|147727 | Customer#000147727 | 606904.6144 | 4288.02 | MOROCCO| dFZ WzKV2HpCrgN3V44Uj
| 25-984-579-573
5 | ackages thrash fluffily about the carefully silent
|
|142015 | Customer#000142015 | 594395.1371 | 3841.67 | UNITED KINGDOM | fr1cn7EjamsnfHHafh
| 33-699-169-532
8 | the bold deposits. slyly regular accounts ou
|
| 736 | Customer#000000736 | 594224.5810 | 9114.68 | ARGENTINA| zQNs5e2aFcVY8MigFQEBtoCaQ9e | 11-617-726-203
9 |the deposits. blithely regular asymptotes boost q
|
| 87613 | Customer#000087613 | 590153.5102 | 6474.97 | VIETNAM| KbJdnGc8rkwj
| 31-893-156-539
8 | refully. slyly special excuses about the bold deposits wake carefully against the special dependencies. slyly bold a |
| 39922 | Customer#000039922 | 584878.1134 | 7321.11 | GERMANY| Zgy4s50l2GKN4pLDPBU8m342gIw6R | 17-147-757-803
6 | y final requests. furiously final foxes cajole blithely special platelets. f
|
| 60838 | Customer#000060838 | 582559.0609 | 2454.77 | BRAZIL | 64EaJ5vMAHWJlBOxJklpNc2RJiWE
| 12-913-494-981
3 |need to boost against the slyly regular account
|
| 13753 | Customer#000013753 | 578238.1222 | 4862.56 | UNITED KINGDOM | SowrFhCvmtiq,7ZQAct v
| 33-760-731-583
2 | he express excuses cajole regular, busy accounts.
|
| 47221 | Customer#000047221 | 573866.2092 | 6385.10 | INDIA
| Rp4p8Q1tjKLv8Ht H6GLd,tG75TX
| 18-637-949-446
2 | urts. quickly pending packages according to the slyly ironic packages boost carefully idle, ironi
|
|108598 | Customer#000108598 | 569265.4847 | 7074.14 | CANADA | fDuJgSmkItSWWXCcSzvOnjK2
| 13-503-222-933
8 | uriously final deposits. unusual, silent accounts against the
|
|142549 | Customer#000142549 | 563537.2368 | 5085.99 | INDONESIA| ChqEoK43OysjdHbtKCp6dKqjNyvvi9| 19-955-562-239
8 | sleep pending courts. ironic deposits against the carefully unusual platelets cajole carefully express accounts. |
| 50476 | Customer#000050476 | 563448.8844 | 7474.49 | MOZAMBIQUE | 0iTYc0iW6eEnNUXE9uqGt0OzPV UC T,| 26-106-316-556
3 | y slyly even requests. ironic theodolites could use about the bl
|
|139823 | Customer#000139823 | 560677.1872 | 5023.03 | INDIA
| qIk4KPwtqobzgXc
| 18-166-780-610
1 | aggle. fluffily bold requests are doggedly for the slyly final packages? bravely even theodolites sleep fluff|
|113839 | Customer#000113839 | 559674.0334 | 8208.46 | GERMANY| 6i3 GKW3q8B1VZOd6RSc2nlvt
| 17-336-257-935
9 | nd furiously daring accounts. slyly bold requests nod after the requests. pending as
|
| 78658 | Customer#000078658 | 559169.0370 |-91.97 | SAUDI ARABIA | iLUNk2GNs30u0,Y
| 30-934-156-683
7 | -- carefully ironic accounts use fluffily silent platelets. silently regular
|
+-----------+--------------------+-------------+-----------+----------------+---------------------------------------+---------------
--+----------------------------------------------------------------------------------------------------------------------+
20 rows in set (5.80 sec)
PROMPT set to '13C'
+---------+----------+
| C_COUNT | CUSTDIST |
+---------+----------+
| 0 |50005 |
| 9 | 6656 |
|10 | 6534 |
|11 | 6002 |
| 8 | 5958 |
|12 | 5650 |
|13 | 5043 |
|19 | 4785 |
| 7 | 4700 |
|18 | 4575 |
|17 | 4560 |
|20 | 4508 |
|15 | 4497 |
|14 | 4439 |
|16 | 4312 |
|21 | 4201 |
|22 | 3610 |
| 6 | 3300 |
|23 | 3184 |
|24 | 2697 |
|25 | 2081 |
| 5 | 1970 |
|26 | 1584 |
|27 | 1174 |
| 4 | 1025 |
|28 |879 |
|29 |576 |
| 3 |422 |
|30 |368 |
|31 |221 |
|32 |141 |
| 2 |136 |
|33 | 75 |
|34 | 51 |
|35 | 34 |
| 1 | 17 |
|36 | 13 |
|38 |5 |
|37 |5 |
|40 |4 |
|41 |2 |
|39 |1 |
+---------+----------+
42 rows in set (3.21 sec)
PROMPT set to '17B'
+------------+
| AVG_YEARLY |
+------------+
| NULL |
+------------+
1 row in set (1.47 sec)
PROMPT set to '17C'
+------------+
| AVG_YEARLY |
+------------+
| NULL |
+------------+
1 row in set (1.45 sec)
PROMPT set to '18C'
ERROR 1248 (42000): Every derived table must have its own alias
PROMPT set to '20B'
+--------------------+------------------------------------------+
| S_NAME
| S_ADDRESS
|
+--------------------+------------------------------------------+
| Supplier#000000042 | 1Y5lwEgpe3j2vbUBYj3SwLhK62JlwEMtDC |
| Supplier#000000146 | rBDNgCr04x0sfdzD5,gFOutCiG2
|
| Supplier#000000199 | k,8F8FGDuN 3udblO
|
| Supplier#000000311 | yjGDnCKi4Wmtim H3n9p
|
| Supplier#000000367 | E Sv9brQVf43Mzz
|
| Supplier#000000383 | pGEPbc70IKUZuTiTaigKuizjt7Y5oUoDL3Bq1|
| Supplier#000000531 | fN0ix827c112YajETqxxuofrfl7v VndWB38n|
| Supplier#000000546 | YznQGwWvZbNA0O9ZV
|
| Supplier#000000680 | UhvDfdEfJh,Qbe7VZb8uSGO2TU 0jEa6nXZXE|
| Supplier#000000799 | jwFN7ZB3T9sMF
|
| Supplier#000000917 | tMr5motk0IFyIXJDwCr98QO5
|
| Supplier#000000986 | tKoJtnykz0R39BWTgglt0rZxT
|
| Supplier#000001013 | riRcntps4KEDtYScjpMIWeYF6mNnR
|
| Supplier#000001130 | gaw3h9cwNJTDhzgND3Ivew9mM
|
| Supplier#000001148 | yaK1tZuQ8Oqhnll1Doit6kM07LZhmrLw |
| Supplier#000001419 | 9wbge8NxXVd5LbIlNA,DjR0sjasMyxC7oANgSQw|
| Supplier#000001526 | bkKFtZanK27y,IzY
|
| Supplier#000001551 | eUU5Yh2vBpBKaw93MkAui6rLrkjbs9 |
| Supplier#000001666 | z4t8jiCjahT7K E8l
|
| Supplier#000001768 | Ug4jMAaK46J31Z5GFO7x
|
| Supplier#000001867 | YvNHyMcy1wYi3XN
|
| Supplier#000001872 | sGWaZk2cZDYyNazJ
|
| Supplier#000001921 | pT5jR2mpIfa4CqqHdM82Vu,Oc2A9 EUZof |
| Supplier#000001929 | 9HSveX9CpjMcvUFhEeLuaGQlb4zm2kg
|
| Supplier#000001962 | UZAdG60BMZRxwNh7dmXB N9GMgGVnW |
| Supplier#000002201 | qijUKP86TLnIMjrL
|
| Supplier#000002289 | ZNrbGM9zL7vKnvuRIOj0gY9NhEiL
|
| Supplier#000002294 | dcAWrWvBzWRQ8j2lUMRKol3Eq,4xFipvykrHfu |
| Supplier#000002338 | Zr2hwHQYmqjAq95y
|
| Supplier#000002345 | WoJC49Pg7s qEgSIeXGPePT
|
| Supplier#000002352 | 4LfoHUZjgjEbAKw TgdKcgOc4D4uCYw
|
| Supplier#000002392 | xsd6wFsVPZcnWwU1365R
|
| Supplier#000002468 | ppFYJjhM83qk
|
| Supplier#000002470 | o716ZrDQeuT17Ba GW,tcQGh0Avqd y
|
| Supplier#000002526 | 8JWRGgabYBoXKYaQlmUt28W
|
| Supplier#000002555 | GxjCAMEHTP4H
|
| Supplier#000002572 | UjDzDmFXJ bXgX UMB
|
| Supplier#000002847 | kKqzzQNY2FhfJMLQmDAh5p
|
| Supplier#000002848 | yxgyfj4kxIoLMs7kSiemccTW3N 4xxX7mT |
| Supplier#000002916 | 9kNV5lg5OgZp1EmDg7LJ0lu2tZCpFPyOeKFO |
| Supplier#000002920 | Je2a8bszf3L
|
| Supplier#000002987 | aVQPPTYTTw0VYSWfa8y
|
| Supplier#000003037 | aBPbT4XfxDheA
|
| Supplier#000003070 | F0sjr17IwdKH9B7DOZXOnM hjhOsfHy9okdsk|
| Supplier#000003080 | V3DF4DVnZlS4xVJbx049Hr3 WJRr1UroXUCJAJv|
| Supplier#000003167 | G6SS7LfQCuN1VfJ
|
| Supplier#000003179 | SsOOjSkuc957RKFt
|
| Supplier#000003182 | UCmH8hT3ESeCHU,2aIN8YxzLWvhE2c |
| Supplier#000003255 | 4TB2q kbKyVY3
|
| Supplier#000003256 | 0G6XBim3XM8Pfjh510
|
| Supplier#000003431 | r4KMmARJ,uRFYDNdHWqz,biMQqT8vxgQjlTJE2 |
| Supplier#000003478 | mRuc7TmfUuV4YK93HhggTA4lyhoQDbEEO|
| Supplier#000003498 | BsM RxD9QN6nJPzSJM
|
| Supplier#000003543 | 0E6Hi3yS3XtRbHrTG5sL
|
| Supplier#000003605 | xdRVBnukNC3QIuf,,1lbmd800P5 Gx |
| Supplier#000003610 | YjjToWCrnEe5en8pIVN92h nq1nOPyMbwroosJw|
| Supplier#000003712 | O8KIWj0KQCJ8PagC2q18
|
| Supplier#000003745 | h8Y,54J1eu9nBAQQz4
|
| Supplier#000003864 | G4A7fDgFofmhL1lXcnG,Vv6qkWuzwil
|
| Supplier#000003885 | M i ERhP9U FS,0Hi8O4
|
| Supplier#000003914 | uBG4kbR1mp6LQZCp6DlCmpzlw9sh2XnSPMT|
| Supplier#000003990 | wehBBp1RQbfxAYDASS75MsywmsKHRVdkrvNe6m |
| Supplier#000004016 | rxIU3SVvxD3en5QsvEkjq
|
| Supplier#000004075 | hK6J7VA GsAmrmRLV5EWka7h jh
|
| Supplier#000004092 | WPUH06LR5goleIM0McfrAGmxP0FdbzTFfKl8Z0X|
| Supplier#000004166 | dEGlhdQfTkadp
|
| Supplier#000004216 | Llx127Mkqt0rE3H6PLNMeOY
|
| Supplier#000004297 | KIHeBupr0uzfXq20Nk2M0Xjv
|
| Supplier#000004374 | wjl9sEGLUm
|
| Supplier#000004408 | 9PmB6KMkM2JHc7C,LNnj
|
| Supplier#000004460 | 2AqMg2cKVwauYYw8hSpKQEM0M ZuK2ZuWK3T |
| Supplier#000004492 | nkCFbmQfWzPF0WrGOEHAgG,mMrlPGdWVxXIWRSKN |
| Supplier#000004577 | nDL547QPA4p7AkEq4QurW
|
| Supplier#000004590 | fFt6dJwXmsW6OHdt5rxKTwPfNCNyCoZ
|
| Supplier#000004678 | V6Y4jcdvbV5WYKuymyJ6e59,BeHTEfnIy|
| Supplier#000004947 | dd0B6ar90BtBSFLfFiK
|
| Supplier#000004960 | 4 965jqpUhHh5
|
| Supplier#000004976 | rh2cBdhFDyoI8PzP,2rgNb0LJ
|
| Supplier#000005010 | cmYBD2RaTe9vKC0uNoC4aCEu3DOA1B |
| Supplier#000005020 | 8n8le,fK6fN1byNziZYGXTQLv8fTnjlyaM |
| Supplier#000005033 | X0TPY78Zx8uP12hWhTGGiOE8gN
|
| Supplier#000005135 | lmDG6dKYLGrlR 7pJKTtgx
|
| Supplier#000005337 | z nBSOeXSXoEf
|
| Supplier#000005338 | I4Gs7qhuOV
|
| Supplier#000005494 | u5ylCpj7F7mjMz4uXcDdE,n
|
| Supplier#000005559 | cMthDmitw2YdTFpfXkhbZqkiOqNOLfAz |
| Supplier#000005645 | R0XMxCzZ61LlSlf89ISRRYPKuHGrZxe
|
| Supplier#000005751 | yVwqlnvEUAboCZ5GUV
|
| Supplier#000005771 | wqPmXKZoucEWZM0,6s56AjHoZXi7r6skXoV U|
| Supplier#000005827 | O,abBOMPP,r4
|
| Supplier#000005904 | qR3xFuR1VfDt5XfudzZGdoAgS0HR7 xS |
| Supplier#000005936 | jXaNZ6vwnEWJ2ksLZJpjtgt0bY2a3AU
|
| Supplier#000005938 | ZRguRXXgt5uTLe8 oU6tnew7ZSNov NdhDJyuS |
| Supplier#000005942 | JYvMdHg512FjvcF
|
| Supplier#000005979 | iIIPTg3efrljRNU5zdi
|
| Supplier#000006001 | 6S RG2sY99qt8Am ZugMI1,Rvcbl
|
| Supplier#000006058 | t9uuW6i2,ZiwrLrk9S6bGRHWRC
|
| Supplier#000006286 |BqBfmh1kM,6Kp0C4fyByE2
|
| Supplier#000006306 | mSxhoCt9kzDJW00O3d5QHKvDEDqxD9RelvL|
| Supplier#000006456 | FgbEnwK,bZvQgg0
|
+--------------------+------------------------------------------+
100 rows in set (0.82 sec)
PROMPT set to '21B'
+--------------------+---------+
| S_NAME
| NUMWAIT |
+--------------------+---------+
| Supplier#000006337 |22 |
| Supplier#000004266 |19 |
| Supplier#000004091 |18 |
| Supplier#000008510 |18 |
| Supplier#000008725 |18 |
| Supplier#000009825 |18 |
| Supplier#000009879 |18 |
| Supplier#000001981 |17 |
| Supplier#000006545 |17 |
| Supplier#000007362 |17 |
| Supplier#000008429 |17 |
| Supplier#000001102 |16 |
| Supplier#000002781 |16 |
| Supplier#000003693 |16 |
| Supplier#000005565 |16 |
| Supplier#000009319 |16 |
| Supplier#000000240 |15 |
| Supplier#000000930 |15 |
| Supplier#000001424 |15 |
| Supplier#000001577 |15 |
| Supplier#000001630 |15 |
| Supplier#000002278 |15 |
| Supplier#000002802 |15 |
| Supplier#000004044 |15 |
| Supplier#000004901 |15 |
| Supplier#000005246 |15 |
| Supplier#000005803 |15 |
| Supplier#000006020 |15 |
| Supplier#000007459 |15 |
| Supplier#000007878 |15 |
| Supplier#000008085 |15 |
| Supplier#000000932 |14 |
| Supplier#000001101 |14 |
| Supplier#000001264 |14 |
| Supplier#000001293 |14 |
| Supplier#000001445 |14 |
| Supplier#000002545 |14 |
| Supplier#000003565 |14 |
| Supplier#000004784 |14 |
| Supplier#000005190 |14 |
| Supplier#000005294 |14 |
| Supplier#000007392 |14 |
| Supplier#000007903 |14 |
| Supplier#000007994 |14 |
| Supplier#000008533 |14 |
| Supplier#000008805 |14 |
| Supplier#000009943 |14 |
| Supplier#000000009 |13 |
| Supplier#000000218 |13 |
| Supplier#000000286 |13 |
| Supplier#000001003 |13 |
| Supplier#000001233 |13 |
| Supplier#000001552 |13 |
| Supplier#000001652 |13 |
| Supplier#000001953 |13 |
| Supplier#000002693 |13 |
| Supplier#000002970 |13 |
| Supplier#000003166 |13 |
| Supplier#000003324 |13 |
| Supplier#000004384 |13 |
| Supplier#000004820 |13 |
| Supplier#000006078 |13 |
| Supplier#000006189 |13 |
| Supplier#000006622 |13 |
| Supplier#000006696 |13 |
| Supplier#000006717 |13 |
| Supplier#000007085 |13 |
| Supplier#000007258 |13 |
| Supplier#000007394 |13 |
| Supplier#000007507 |13 |
| Supplier#000007637 |13 |
| Supplier#000007751 |13 |
| Supplier#000008216 |13 |
| Supplier#000008514 |13 |
| Supplier#000009385 |13 |
| Supplier#000009439 |13 |
| Supplier#000009996 |13 |
| Supplier#000000299 |12 |
| Supplier#000000396 |12 |
| Supplier#000000489 |12 |
| Supplier#000000644 |12 |
| Supplier#000000830 |12 |
| Supplier#000001024 |12 |
| Supplier#000001273 |12 |
| Supplier#000001392 |12 |
| Supplier#000001677 |12 |
| Supplier#000001762 |12 |
| Supplier#000001997 |12 |
| Supplier#000002145 |12 |
| Supplier#000003098 |12 |
| Supplier#000003172 |12 |
| Supplier#000003398 |12 |
| Supplier#000003466 |12 |
| Supplier#000003568 |12 |
| Supplier#000004161 |12 |
| Supplier#000004286 |12 |
| Supplier#000005339 |12 |
| Supplier#000005418 |12 |
| Supplier#000005604 |12 |
| Supplier#000005841 |12 |
+--------------------+---------+
100 rows in set (8.28 sec)
PROMPT set to '22B'
+-----------+---------+------------+
| CNTRYCODE | NUMCUST | TOTACCTBAL |
+-----------+---------+------------+
| 12| 862 | 6454292.96 |
| 13| 889 | 6742716.75 |
| 17| 861 | 6460573.72 |
| 27| 875 | 6555087.11 |
| 29| 949 | 7163868.66 |
| 32| 917 | 6875318.26 |
| 34| 948 | 7176951.89 |
+-----------+---------+------------+
7 rows in set (0.94 sec)
22B
22BPROMPT 21B
PROMPT set to '21B'
21BSELECT S_NAME ,COUNT(*) AS NUMWAIT FROM
-> (SELECT
-> S_NAME,L_SUPPKEY ,L_ORDERKEY
-> -- COUNT(*) AS NUMWAIT
-> FROM
-> SUPPLIER,
-> LINEITEM L1,
-> ORDERS,
-> NATION
-> WHERE
-> S_SUPPKEY = L1.L_SUPPKEY
-> AND O_ORDERKEY = L1.L_ORDERKEY
-> AND O_ORDERSTATUS = 'F'
-> AND L1.L_RECEIPTDATE > L1.L_COMMITDATE
-> AND S_NATIONKEY = N_NATIONKEY
-> AND N_NAME = 'IRAN'
-> ) L1
-> WHERE EXISTS (
->
SELECT
->
*
->
FROM
->
LINEITEM L2
->
WHERE
->
L2.L_ORDERKEY = L1.L_ORDERKEY
->
AND L2.L_SUPPKEYL1.L_SUPPKEY
-> )
-> AND NOT EXISTS (
->
SELECT
->
*
->
FROM
->
LINEITEM L3
->
WHERE
->
L3.L_ORDERKEY = L1.L_ORDERKEY
->
AND L3.L_SUPPKEYL1.L_SUPPKEY
->
AND L3.L_RECEIPTDATE > L3.L_COMMITDATE
-> )
-> GROUP BY
-> S_NAME
-> ORDER BY
-> NUMWAIT DESC,
-> S_NAME
-> LIMIT 100;
Query aborted by Ctrl+C
ERROR 1105 (HY000): Stopped by user.
21BPROMPT 18C
PROMPT set to '18C'
18C
18CSELECT
-> C_NAME,
-> C_CUSTKEY,
-> O_ORDERKEY,
-> O_ORDERDATE,
-> O_TOTALPRICE,
-> SUM_L_QUANTITY
-> FROM
-> CUSTOMER,
-> ORDERS,
->
( SELECT
->
L_ORDERKEY,SUM(L_QUANTITY)SUM_L_QUANTITY
->
FROM
->
LINEITEM
->
GROUP BY
->
L_ORDERKEY HAVING
->
SUM(L_QUANTITY) > 312
-> )LINEITEM
-> WHERE
-> C_CUSTKEY = O_CUSTKEY
-> AND O_ORDERKEY = L_ORDERKEY
-> ORDER BY
-> O_TOTALPRICE DESC,
-> O_ORDERDATE
-> LIMIT 100;
+--------------------+-----------+------------+-------------+--------------+----------------+
| C_NAME
| C_CUSTKEY | O_ORDERKEY | O_ORDERDATE | O_TOTALPRICE | SUM_L_QUANTITY |
+--------------------+-----------+------------+-------------+--------------+----------------+
| Customer#000128120 |128120 |4722021 | 1994-04-07|544089.09 | 323.00 |
| Customer#000144617 |144617 |3043270 | 1997-02-12|530604.44 | 317.00 |
| Customer#000066790 | 66790 |2199712 | 1996-09-30|515531.82 | 327.00 |
| Customer#000015619 | 15619 |3767271 | 1996-08-07|480083.96 | 318.00 |
| Customer#000148885 |148885 |2942469 | 1992-05-31|469630.44 | 313.00 |
| Customer#000147197 |147197 |1263015 | 1997-02-02|467149.67 | 320.00 |
| Customer#000117919 |117919 |2869152 | 1996-06-20|456815.92 | 317.00 |
| Customer#000126865 |126865 |4702759 | 1994-11-07|447606.65 | 320.00 |
| Customer#000036619 | 36619 |4806726 | 1995-01-17|446704.09 | 328.00 |
| Customer#000119989 |119989 |1544643 | 1997-09-20|434568.25 | 320.00 |
+--------------------+-----------+------------+-------------+--------------+----------------+
10 rows in set (10.09 sec)
回复

使用道具 举报

千问 | 2012-5-21 10:19:41 | 显示全部楼层
PROMPT 1
SELECT L_RETURNFLAG,
L_LINESTATUS, SUM_QTY, SUM_BASE_PRICE,SUM_DISC_PRICE,SUM_CHARGE,
SUM_QTY/COUNT_ORDER AVG_QTY,
SUM_BASE_PRICE/COUNT_ORDER AVG_PRICE,
AVG_DISC,
COUNT_ORDER
FROM(
SELECT
L_RETURNFLAG,
L_LINESTATUS,
SUM(L_QUANTITY) AS SUM_QTY,
SUM(L_EXTENDEDPRICE) AS SUM_BASE_PRICE,
SUM(L_EXTENDEDPRICE * (1 - L_DISCOUNT)) AS SUM_DISC_PRICE,
SUM(L_EXTENDEDPRICE * (1 - L_DISCOUNT) * (1 + L_TAX)) AS SUM_CHARGE,
-- AVG(L_QUANTITY) AS AVG_QTY,
-- AVG(L_EXTENDEDPRICE) AS AVG_PRICE,
AVG(L_DISCOUNT) AS AVG_DISC,
COUNT(*) AS COUNT_ORDER
FROM
LINEITEM
WHERE
L_SHIPDATE = DATE '1997-05-01'
AND O_ORDERDATE = DATE '1997-05-01'
AND O_ORDERDATE = DATE '1997-05-01'
AND O_ORDERDATE = DATE '1993-11-01'
AND O_ORDERDATE312
)LINEITEM
WHERE
C_CUSTKEY = O_CUSTKEY
AND O_ORDERKEY = L_ORDERKEY
ORDER BY
O_TOTALPRICE DESC,
O_ORDERDATE
LIMIT 100;

PROMPT 20B
SELECT S_NAME,S_ADDRESS
FROM SUPPLIER, NATION
WHERE S_SUPPKEY IN (SELECT PS_SUPPKEY

FROM PARTSUPP

,(SELECT L_PARTKEY,L_SUPPKEY, SUM(L_QUANTITY) L_QUANTITY_SUM

FROM LINEITEM,PART

WHERE L_PARTKEY = P_PARTKEY AND P_NAME LIKE 'tomato%'

AND L_SHIPDATE >= DATE '1995-01-01'

AND L_SHIPDATE0.5*L_QUANTITY_SUM

)
AND S_NATIONKEY = N_NATIONKEY
AND N_NAME = 'RUSSIA'
ORDER BY S_NAME
LIMIT 100;
PROMPT 21B
SELECTS_NAME,

COUNT(*) AS NUMWAIT
FROM ( SELECT S_NAME

,L1.L_ORDERKEY,L1.L_LINENUMBER

FROMSUPPLIER,

LINEITEM L1,

LINEITEM L3,

ORDERS,

NATION
WHERE

S_SUPPKEY = L1.L_SUPPKEY

AND O_ORDERKEY = L1.L_ORDERKEY

AND O_ORDERSTATUS = 'F'

AND L1.L_RECEIPTDATE > L1.L_COMMITDATE

AND S_NATIONKEY = N_NATIONKEY

AND N_NAME = 'IRAN'

AND L3.L_ORDERKEY=L1.L_ORDERKEY AND L3.L_SUPPKEYL1.L_SUPPKEY
GROUP BY S_NAME

,L1.L_ORDERKEY,L1.L_LINENUMBER
HAVING SUM(CASEWHEN L3.L_RECEIPTDATE>L3.L_COMMITDATE THEN 1 ELSE 0 END)=0

)N
GROUP BY S_NAME
ORDER BY
NUMWAIT DESC,
S_NAME
LIMIT 100;
PROMPT 22B
SELECT
CNTRYCODE,
COUNT(*) AS NUMCUST,
SUM(C_ACCTBAL) AS TOTACCTBAL
FROM
(SELECT * FROM (

SELECT

SUBSTR(C_PHONE ,1,2) AS CNTRYCODE,C_CUSTKEY,

C_ACCTBAL

FROM

CUSTOMER

WHERE

SUBSTR(C_PHONE ,1,2) IN

('32', '12', '13', '29', '34', '17', '27')
)T LEFT JOIN ORDERS ON(O_CUSTKEY = C_CUSTKEY)

WHERE C_ACCTBAL > (

SELECT

AVG(C_ACCTBAL)

FROM

(

SELECT

SUBSTR(C_PHONE ,1,2) AS CNTRYCODE,C_CUSTKEY,

C_ACCTBAL

FROM

CUSTOMER

WHERE

SUBSTR(C_PHONE ,1,2) IN

('32', '12', '13', '29', '34', '17', '27')
)T

WHERE

C_ACCTBAL > 0.00

)

AND O_CUSTKEY IS NULL
) CUSTSALE
GROUP BY
CNTRYCODE
ORDER BY
CNTRYCODE
;
回复

使用道具 举报

千问 | 2012-5-21 10:19:41 | 显示全部楼层
PROMPT 17B
SELECT
SUM(L_EXTENDEDPRICE) / 7.0 AS AVG_YEARLY
FROM
LINEITEM,
PART
WHERE
P_PARTKEY = L_PARTKEY
AND P_BRAND = 'Brand#11'
AND P_CONTAINER = 'LG PKG'
AND L_QUANTITYuse tpch;
Database changed
mysql> PROMPT 17B
PROMPT set to '17B'
17BSELECT
-> SUM(L_EXTENDEDPRICE) / 7.0 AS AVG_YEARLY
-> FROM
-> LINEITEM,
-> PART
-> WHERE
-> P_PARTKEY = L_PARTKEY
-> AND P_BRAND = 'Brand#11'
-> AND P_CONTAINER = 'LG PKG'
-> AND L_QUANTITY
SELECT
->
0.2 * AVG(L_QUANTITY)
->
FROM
->
(SELECT L_PARTKEY,L_QUANTITY FROM
->
LINEITEM
->
WHERE
->
L_PARTKEY IN (SELECT P_PARTKEY FROM PART WHERE P_BRAND = 'Brand#11'AND P_CONTAINER = 'LG PKG')
->
)A
->
WHERE A.L_PARTKEY=P_PARTKEY
-> )
-> ;
+---------------+
| AVG_YEARLY|
+---------------+
| 306647.830000 |
+---------------+
1 row in set (18.22 sec)
17BPROMPT 17C
PROMPT set to '17C'
17CSELECT
-> SUM(L_EXTENDEDPRICE) / 7.0 AS AVG_YEARLY
-> FROM (SELECT L_EXTENDEDPRICE,L_PARTKEY ,L_QUANTITY
-> FROM
->
LINEITEM,
->
PART
-> WHERE
-> P_PARTKEY = L_PARTKEY
-> AND P_BRAND = 'Brand#11'
-> AND P_CONTAINER = 'LG PKG'
-> )B
-> ,(SELECT L_PARTKEY,0.2 * AVG(L_QUANTITY) P2AVG_L_QUANTITY
-> FROM
-> (SELECT L_PARTKEY,L_QUANTITY FROM
->
LINEITEM
-> WHERE
->
L_PARTKEY IN (SELECT P_PARTKEY FROM PART WHERE P_BRAND = 'Brand#11'AND P_CONTAINER = 'LG PKG')
-> )A
-> GROUP BY L_PARTKEY
-> )C
-> WHERE B.L_PARTKEY=C.L_PARTKEY AND B.L_QUANTITY;
+---------------+
| AVG_YEARLY|
+---------------+
| 306647.830000 |
+---------------+
1 row in set (2.36 sec)
17C
回复

使用道具 举报

千问 | 2012-5-21 10:19:41 | 显示全部楼层
[root@redflag11012501 ~]# du /usr/local/info*
0 /usr/local/infobright
20/usr/local/infobright-3.4.2-x86_64/scripts
344 /usr/local/infobright-3.4.2-x86_64/lib/mysql/plugin
50524 /usr/local/infobright-3.4.2-x86_64/lib/mysql
53492 /usr/local/infobright-3.4.2-x86_64/lib
444 /usr/local/infobright-3.4.2-x86_64/include/mysql
448 /usr/local/infobright-3.4.2-x86_64/include
204 /usr/local/infobright-3.4.2-x86_64/support-files
106728/usr/local/infobright-3.4.2-x86_64/bin
2296/usr/local/infobright-3.4.2-x86_64/libexec
88/usr/local/infobright-3.4.2-x86_64/data/tpch/NATION.bht
64/usr/local/infobright-3.4.2-x86_64/data/tpch/REGION.bht
7828/usr/local/infobright-3.4.2-x86_64/data/tpch/CUSTOMER.bht
21800 /usr/local/infobright-3.4.2-x86_64/data/tpch/PARTSUPP.bht
27368 /usr/local/infobright-3.4.2-x86_64/data/tpch/ORDERS.bht
632 /usr/local/infobright-3.4.2-x86_64/data/tpch/SUPPLIER.bht
3072/usr/local/infobright-3.4.2-x86_64/data/tpch/PART.bht
119040/usr/local/infobright-3.4.2-x86_64/data/tpch/LINEITEM.bht
179996/usr/local/infobright-3.4.2-x86_64/data/tpch
4 /usr/local/infobright-3.4.2-x86_64/data/test
968 /usr/local/infobright-3.4.2-x86_64/data/mysql
103368/usr/local/infobright-3.4.2-x86_64/data/ssb/LINEORDER.bht
980 /usr/local/infobright-3.4.2-x86_64/data/ssb/CUSTOMER.bht
292 /usr/local/infobright-3.4.2-x86_64/data/ssb/DATES.bht
172 /usr/local/infobright-3.4.2-x86_64/data/ssb/SUPPLIER.bht
1916/usr/local/infobright-3.4.2-x86_64/data/ssb/PART.bht
106796/usr/local/infobright-3.4.2-x86_64/data/ssb
1112/usr/local/infobright-3.4.2-x86_64/data/BH_RSI_Repository
289020/usr/local/infobright-3.4.2-x86_64/data
回复

使用道具 举报

千问 | 2012-5-21 10:19:41 | 显示全部楼层
[root@redflag11012501 ~]# /etc/init.d/mysqld-ib stop
Shutting down MySQL.[确定]
[root@redflag11012501 ~]#
[root@redflag11012501 ~]# /usr/local/infobright-3.4.2-x86_64/postconfig.sh
Infobright post configuration
--------------------------------------
Please run this script from inside the installed folder.
[root@redflag11012501 ~]#
[root@redflag11012501 ~]# cd /usr/local/infobright-3.4.2-x86_64/
[root@redflag11012501 infobright-3.4.2-x86_64]# ./postconfig.sh
Infobright post configuration
--------------------------------------
Do you want to move current datadir [/usr/local/infobright-3.4.2-x86_64/data]? [y/n]:y
Give new datadir path:/app/oradata^H^H^H^H^[[D^[[D
[root@redflag11012501 infobright-3.4.2-x86_64]# ./postconfig.sh
Infobright post configuration
--------------------------------------
Do you want to move current datadir [/usr/local/infobright-3.4.2-x86_64/data]? [y/n]:y
Give new datadir path:/user1/app/data
Do you want to move current CacheFolder [ /usr/local/infobright-3.4.2-x86_64/cache]? [y/n]:n
Do you want to change current socket [/tmp/mysql-ib.sock]? [y/n]:n
Do you want to change current port [5029]? [y/n]:n
--------------------------------------
New datadir is going to be /user1/app/data
--------------------------------------
Please confirm to proceed? [y/n]:y
Copying /usr/local/infobright-3.4.2-x86_64/data to /user1/app/data ...Done.
Removing old /usr/local/infobright-3.4.2-x86_64/data ...Done.
Done!
[root@redflag11012501 infobright-3.4.2-x86_64]# du /user1/app/data
4 /user1/app/data/test
968 /user1/app/data/mysql
27368 /user1/app/data/tpch/ORDERS.bht
88/user1/app/data/tpch/NATION.bht
7828/user1/app/data/tpch/CUSTOMER.bht
64/user1/app/data/tpch/REGION.bht
21800 /user1/app/data/tpch/PARTSUPP.bht
3072/user1/app/data/tpch/PART.bht
632 /user1/app/data/tpch/SUPPLIER.bht
119040/user1/app/data/tpch/LINEITEM.bht
179996/user1/app/data/tpch
980 /user1/app/data/ssb/CUSTOMER.bht
103368/user1/app/data/ssb/LINEORDER.bht
1916/user1/app/data/ssb/PART.bht
172 /user1/app/data/ssb/SUPPLIER.bht
292 /user1/app/data/ssb/DATES.bht
106796/user1/app/data/ssb
1112/user1/app/data/BH_RSI_Repository
289016/user1/app/data
[root@redflag11012501 infobright-3.4.2-x86_64]# cd ~
[root@redflag11012501 ~]# /etc/init.d/mysqld-ib start
Starting MySQL.[确定]
回复

使用道具 举报

返回列表 发新帖
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

千问

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
回复楼主 返回列表
热门排行