1
CREATE DATABASE IF NOT EXISTS test;
3
CREATE TABLE `customer` ( `c_custkey` int(11) NOT NULL, `c_name` varchar(25) DEFAULT NULL, `c_address` varchar(40) DEFAULT NULL, `c_nationkey` int(11) DEFAULT NULL, `c_phone` char(15) DEFAULT NULL, `c_acctbal` double DEFAULT NULL, `c_mktsegment` char(10) DEFAULT NULL, `c_comment` varchar(117) DEFAULT NULL, PRIMARY KEY (`c_custkey`), KEY `i_c_nationkey` (`c_nationkey`));
4
CREATE TABLE `lineitem` ( `l_orderkey` int(11) NOT NULL DEFAULT '0', `l_partkey` int(11) DEFAULT NULL, `l_suppkey` int(11) DEFAULT NULL, `l_linenumber` int(11) NOT NULL DEFAULT '0', `l_quantity` double DEFAULT NULL, `l_extendedprice` double DEFAULT NULL, `l_discount` double DEFAULT NULL, `l_tax` double DEFAULT NULL, `l_returnflag` char(1) DEFAULT NULL, `l_linestatus` char(1) DEFAULT NULL, `l_shipDATE` date DEFAULT NULL, `l_commitDATE` date DEFAULT NULL, `l_receiptDATE` date DEFAULT NULL, `l_shipinstruct` char(25) DEFAULT NULL, `l_shipmode` char(10) DEFAULT NULL, `l_comment` varchar(44) DEFAULT NULL, PRIMARY KEY (`l_orderkey`,`l_linenumber`), KEY `i_l_shipdate` (`l_shipDATE`), KEY `i_l_suppkey_partkey` (`l_partkey`,`l_suppkey`), KEY `i_l_partkey` (`l_partkey`), KEY `i_l_suppkey` (`l_suppkey`), KEY `i_l_receiptdate` (`l_receiptDATE`), KEY `i_l_orderkey` (`l_orderkey`), KEY `i_l_orderkey_quantity` (`l_orderkey`,`l_quantity`), KEY `i_l_commitdate` (`l_commitDATE`));
5
CREATE TABLE `nation` ( `n_nationkey` int(11) NOT NULL, `n_name` char(25) DEFAULT NULL, `n_regionkey` int(11) DEFAULT NULL, `n_comment` varchar(152) DEFAULT NULL, PRIMARY KEY (`n_nationkey`), KEY `i_n_regionkey` (`n_regionkey`));
6
CREATE TABLE `orders` ( `o_orderkey` int(11) NOT NULL, `o_custkey` int(11) DEFAULT NULL, `o_orderstatus` char(1) DEFAULT NULL, `o_totalprice` double DEFAULT NULL, `o_orderDATE` date DEFAULT NULL, `o_orderpriority` char(15) DEFAULT NULL, `o_clerk` char(15) DEFAULT NULL, `o_shippriority` int(11) DEFAULT NULL, `o_comment` varchar(79) DEFAULT NULL, PRIMARY KEY (`o_orderkey`), KEY `i_o_orderdate` (`o_orderDATE`), KEY `i_o_custkey` (`o_custkey`));
7
CREATE TABLE `part` ( `p_partkey` int(11) NOT NULL, `p_name` varchar(55) DEFAULT NULL, `p_mfgr` char(25) DEFAULT NULL, `p_brand` char(10) DEFAULT NULL, `p_type` varchar(25) DEFAULT NULL, `p_size` int(11) DEFAULT NULL, `p_container` char(10) DEFAULT NULL, `p_retailprice` double DEFAULT NULL, `p_comment` varchar(23) DEFAULT NULL, PRIMARY KEY (`p_partkey`));
8
CREATE TABLE `partsupp` ( `ps_partkey` int(11) NOT NULL DEFAULT '0', `ps_suppkey` int(11) NOT NULL DEFAULT '0', `ps_availqty` int(11) DEFAULT NULL, `ps_supplycost` double DEFAULT NULL, `ps_comment` varchar(199) DEFAULT NULL, PRIMARY KEY (`ps_partkey`,`ps_suppkey`), KEY `i_ps_partkey` (`ps_partkey`), KEY `i_ps_suppkey` (`ps_suppkey`));
9
CREATE TABLE `region` ( `r_regionkey` int(11) NOT NULL, `r_name` char(25) DEFAULT NULL, `r_comment` varchar(152) DEFAULT NULL, PRIMARY KEY (`r_regionkey`));
10
CREATE TABLE `supplier` ( `s_suppkey` int(11) NOT NULL, `s_name` char(25) DEFAULT NULL, `s_address` varchar(40) DEFAULT NULL, `s_nationkey` int(11) DEFAULT NULL, `s_phone` char(15) DEFAULT NULL, `s_acctbal` double DEFAULT NULL, `s_comment` varchar(101) DEFAULT NULL, PRIMARY KEY (`s_suppkey`), KEY `i_s_nationkey` (`s_nationkey`));
11
CREATE TABLE `time_statistics` ( `task_name` varchar(40) DEFAULT NULL, `s_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `e_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `int_time` int(11) DEFAULT NULL);
12
INSERT INTO `customer` VALUES (1,'Customer#000000001','IVhzIApeRb ot,c,E',15,'25-989-741-2988',711.56,'BUILDING','regular, regular platelets are fluffily according to the even attainments. blithely iron'),(2,'Customer#000000002','XSTf4,NCwDVaWNe6tEgvwfmRchLXak',13,'23-768-687-3665',121.65,'AUTOMOBILE','furiously special deposits solve slyly. furiously even foxes wake alongside of the furiously ironic ideas. pending'),(3,'Customer#000000003','MG9kdTD2WBHm',1,'11-719-748-3364',7498.12,'AUTOMOBILE','special packages wake. slyly reg'),(4,'Customer#000000004','XxVSJsLAGtn',4,'14-128-190-5944',2866.83,'MACHINERY','slyly final accounts sublate carefully. slyly ironic asymptotes nod across the quickly regular pack'),(5,'Customer#000000005','KvpyuHCplrB84WgAiGV6sYpZq7Tj',3,'13-750-942-6364',794.47,'HOUSEHOLD','blithely final instructions haggle; stealthy sauternes nod; carefully regu'),(6,'Customer#000000006','sKZz0CsnMD7mp4Xd0YrBvx,LREYKUWAh yVn',20,'30-114-968-4951',7638.57,'AUTOMOBILE','special deposits wake along the ironic foxes. slyly regular deposits are furiously about the blith'),(7,'Customer#000000007','TcGe5gaZNgVePxU5kRrvXBfkasDTea',18,'28-190-982-9759',9561.95,'AUTOMOBILE','theodolites kindle carefully carefully regular deposits. regular depe'),(8,'Customer#000000008','I0B10bB0AymmC, 0PrRYBCP1yGJ8xcBPmWhl5',17,'27-147-574-9335',6819.74,'BUILDING','ironic deposits are quickly after the gifts. regular dependencies hinder slyly after the quickly ex'),(9,'Customer#000000009','xKiAFTjUsCuxfeleNqefumTrjS',8,'18-338-906-3675',8324.07,'FURNITURE','deposits affix fluffily. blithely final ideas are furiously dolphins. i'),(10,'Customer#000000010','6LrEaV6KR6PLVcgl2ArL Q3rqzLzcT1 v2',5,'15-741-346-9870',2753.54,'HOUSEHOLD','bold, final frays sleep carefully special ideas. carefully final asymptotes sleep furiously against the even i'),(11,'Customer#000000011','PkWS 3HlXqwTuzrKg633BEi',23,'33-464-151-3439',-272.6,'BUILDING','furiously express packages are. regular courts play deposits. silent, ironic packages engage. furiously regular a'),(12,'Customer#000000012','9PWKuhzT4Zr1Q',13,'23-791-276-1263',3396.49,'HOUSEHOLD','deposits are accounts: fluffily even dependencies haggle fluffily slyly regular requests. theodolit'),(13,'Customer#000000013','nsXQu0oVjD7PM659uC3SRSp',3,'13-761-547-5974',3857.34,'BUILDING','ironic dependencies according to the slyly even ideas wake idl'),(14,'Customer#000000014','KXkletMlL2JQEA ',1,'11-845-129-3851',5266.3,'FURNITURE','never regular pinto beans boost bl'),(15,'Customer#000000015','YtWggXoOLdwdo7b0y,BZaGUQMLJMX1Y,EC,6Dn',23,'33-687-542-7601',2788.52,'HOUSEHOLD','fluffily bold dolphins detect quickly about the special instruction');
13
INSERT INTO `lineitem` VALUES (1,16,1,1,17,15572.17,0.04,0.02,'N','O','1996-03-13','1996-02-12','1996-03-22','DELIVER IN PERSON','TRUCK','blithely regular ideas caj'),(1,7,1,2,36,32652,0.09,0.06,'N','O','1996-04-12','1996-02-28','1996-04-20','TAKE BACK RETURN','MAIL','slyly bold pinto beans detect s'),(1,7,1,3,8,7256,0.1,0.02,'N','O','1996-01-29','1996-03-05','1996-01-31','TAKE BACK RETURN','REG AIR','deposits wake furiously dogged,'),(1,1,1,4,28,25228,0.09,0.06,'N','O','1996-04-21','1996-03-30','1996-05-16','NONE','AIR','even ideas haggle. even, bold reque'),(1,3,1,5,24,21672,0.1,0.04,'N','O','1996-03-30','1996-03-14','1996-04-01','NONE','FOB','carefully final gr'),(1,2,1,6,32,28864,0.07,0.02,'N','O','1996-01-30','1996-02-07','1996-02-03','DELIVER IN PERSON','MAIL','furiously regular accounts haggle bl'),(2,11,1,1,38,34618.38,0,0.05,'N','O','1997-01-28','1997-01-14','1997-02-02','TAKE BACK RETURN','RAIL','carefully ironic platelets against t'),(3,1,1,1,45,40545,0.06,0,'R','F','1994-02-02','1994-01-04','1994-02-23','NONE','AIR','blithely s'),(3,2,1,2,49,44198,0.1,0,'R','F','1993-11-09','1993-12-20','1993-11-24','TAKE BACK RETURN','RAIL','final, regular pinto'),(3,13,1,3,27,24651.27,0.06,0.07,'A','F','1994-01-16','1993-11-22','1994-01-23','DELIVER IN PERSON','SHIP','carefully silent pinto beans boost fur'),(3,3,1,4,2,1806,0.01,0.06,'A','F','1993-12-04','1994-01-07','1994-01-01','NONE','TRUCK','fluffily unusual deposits hag'),(3,19,1,5,28,25732.28,0.04,0,'R','F','1993-12-14','1994-01-10','1994-01-01','TAKE BACK RETURN','FOB','blithely pending platelets according'),(3,7,1,6,26,23582,0.1,0.02,'A','F','1993-10-29','1993-12-18','1993-11-04','TAKE BACK RETURN','RAIL','ideas until the unusual packages c'),(4,9,1,1,30,27270,0.03,0.08,'N','O','1996-01-10','1995-12-14','1996-01-18','DELIVER IN PERSON','REG AIR','special dependencies am'),(5,11,1,1,15,13665.15,0.02,0.04,'R','F','1994-10-31','1994-08-31','1994-11-20','NONE','AIR','unusual, even instructio'),(5,13,1,2,26,23738.26,0.07,0.08,'R','F','1994-10-16','1994-09-25','1994-10-19','NONE','FOB','blithely even accoun'),(5,4,1,3,50,45200,0.08,0.03,'A','F','1994-08-08','1994-10-13','1994-08-26','DELIVER IN PERSON','AIR','express platelets integr'),(6,14,1,1,37,33818.37,0.08,0.03,'A','F','1992-04-27','1992-05-15','1992-05-02','TAKE BACK RETURN','TRUCK','ruthlessly unusual warhorses sleep slyly af'),(7,19,1,1,12,11028.12,0.07,0.03,'N','O','1996-05-07','1996-03-13','1996-06-03','TAKE BACK RETURN','FOB','pending requests sleep furiously above'),(7,15,1,2,9,8235.09,0.08,0.08,'N','O','1996-02-01','1996-03-02','1996-02-19','TAKE BACK RETURN','SHIP','carefully spe'),(7,10,1,3,46,41860.46,0.1,0.07,'N','O','1996-01-15','1996-03-27','1996-02-03','COLLECT COD','MAIL','carefully exp'),(7,17,1,4,28,25676.28,0.03,0.04,'N','O','1996-03-21','1996-04-08','1996-04-20','NONE','FOB','final deposits are quickly. furiously even'),(7,16,1,5,38,34808.38,0.08,0.01,'N','O','1996-02-11','1996-02-24','1996-02-18','DELIVER IN PERSON','TRUCK','blithely expres'),(7,8,1,6,35,31780,0.06,0.03,'N','O','1996-01-16','1996-02-23','1996-01-22','TAKE BACK RETURN','FOB','blithely silent accoun'),(7,16,1,7,5,4580.05,0.04,0.02,'N','O','1996-02-10','1996-03-26','1996-02-13','NONE','FOB','furiously pending theodolit'),(32,9,1,1,28,25452,0.05,0.08,'N','O','1995-10-23','1995-08-27','1995-10-26','TAKE BACK RETURN','TRUCK','ironic requests dazzle. final d'),(32,20,1,2,32,29440.64,0.02,0,'N','O','1995-08-14','1995-10-07','1995-08-27','COLLECT COD','AIR','regular accounts cajole'),(32,5,1,3,2,1810,0.09,0.02,'N','O','1995-08-07','1995-10-07','1995-08-23','DELIVER IN PERSON','AIR','furiously bold deposits '),(32,1,1,4,4,3604,0.09,0.03,'N','O','1995-08-04','1995-10-01','1995-09-03','NONE','REG AIR','slyly bold requests nag. fluffily'),(32,9,1,5,44,39996,0.05,0.06,'N','O','1995-08-28','1995-08-20','1995-09-14','DELIVER IN PERSON','AIR','slyly ironic notornis bo'),(32,2,1,6,6,5412,0.04,0.03,'N','O','1995-07-21','1995-09-23','1995-07-25','COLLECT COD','RAIL','requests integrat');
14
INSERT INTO `lineitem` VALUES (33,7,1,1,31,28117,0.09,0.04,'A','F','1993-10-29','1993-12-19','1993-11-08','COLLECT COD','TRUCK','slyly even requests are f'),(33,7,1,2,32,29024,0.02,0.05,'A','F','1993-12-09','1994-01-04','1993-12-28','COLLECT COD','MAIL','special theodolites boost '),(33,14,1,3,5,4570.05,0.05,0.03,'A','F','1993-12-09','1993-12-25','1993-12-23','TAKE BACK RETURN','AIR','bold requests affix alongside of the slyly '),(33,4,1,4,41,37064,0.09,0,'R','F','1993-11-09','1994-01-24','1993-11-11','TAKE BACK RETURN','MAIL','furiously regular deposits are carefully id'),(34,9,1,1,13,11817,0,0.07,'N','O','1998-10-23','1998-09-14','1998-11-06','NONE','REG AIR','regular deposits grow. regu'),(34,9,1,2,22,19998,0.08,0.06,'N','O','1998-10-09','1998-10-16','1998-10-12','NONE','FOB','carefully idle ins'),(34,17,1,3,6,5502.06,0.02,0.06,'N','O','1998-10-30','1998-09-20','1998-11-05','NONE','FOB','furiously final ideas thrash carefully bo'),(35,1,1,1,24,21624,0.02,0,'N','O','1996-02-21','1996-01-03','1996-03-18','TAKE BACK RETURN','FOB','dolphins along the slyly ir'),(35,17,1,2,34,31178.34,0.06,0.08,'N','O','1996-01-22','1996-01-06','1996-01-27','DELIVER IN PERSON','RAIL','fluffily final deposits are bl'),(35,13,1,3,7,6391.07,0.06,0.04,'N','O','1996-01-19','1995-12-22','1996-01-29','NONE','MAIL','quickly even depo'),(35,9,1,4,25,22725,0.06,0.05,'N','O','1995-11-26','1995-12-25','1995-12-21','DELIVER IN PERSON','SHIP','slyly special excuses wake carefully ironic'),(35,12,1,5,34,31008.34,0.08,0.06,'N','O','1995-11-08','1996-01-15','1995-11-26','COLLECT COD','MAIL','quickly regular instructions try t'),(35,4,1,6,28,25312,0.03,0.02,'N','O','1996-02-01','1995-12-24','1996-02-28','COLLECT COD','RAIL','slyly final foxes haggle blithely de'),(36,12,1,1,42,38304.42,0.09,0,'N','O','1996-02-03','1996-01-21','1996-02-23','COLLECT COD','SHIP','accounts sleep furiously bli'),(37,3,1,1,40,36120,0.09,0.03,'A','F','1992-07-21','1992-08-01','1992-08-15','NONE','REG AIR','slyly final accounts caj'),(37,13,1,2,39,35607.39,0.05,0.02,'A','F','1992-07-02','1992-08-18','1992-07-28','TAKE BACK RETURN','RAIL','regular, final packages are after the'),(37,2,1,3,43,38786,0.05,0.08,'A','F','1992-07-10','1992-07-06','1992-08-02','DELIVER IN PERSON','TRUCK','fluffily f'),(38,18,1,1,44,40392.44,0.04,0.02,'N','O','1996-09-29','1996-11-17','1996-09-30','COLLECT COD','MAIL','carefully final packages'),(39,1,1,1,44,39644,0.09,0.06,'N','O','1996-11-14','1996-12-15','1996-12-12','COLLECT COD','RAIL','theodolites are bold foxes. fi'),(39,19,1,2,26,23894.26,0.08,0.04,'N','O','1996-11-04','1996-10-20','1996-11-20','NONE','FOB','carefully even instructions sleep car'),(39,7,1,3,46,41722,0.06,0.08,'N','O','1996-09-26','1996-12-19','1996-10-26','DELIVER IN PERSON','AIR','ideas cajole '),(39,3,1,4,32,28896,0.07,0.05,'N','O','1996-10-02','1996-12-19','1996-10-14','COLLECT COD','MAIL','final theodolites'),(39,6,1,5,43,38958,0.01,0.01,'N','O','1996-10-17','1996-11-14','1996-10-26','COLLECT COD','MAIL','ideas haggle '),(39,10,1,6,40,36400.4,0.06,0.05,'N','O','1996-12-08','1996-10-22','1997-01-01','COLLECT COD','AIR','enticingly even'),(64,9,1,1,21,19089,0.05,0.02,'R','F','1994-09-30','1994-09-18','1994-10-26','DELIVER IN PERSON','REG AIR','furiously regular'),(65,6,1,1,26,23556,0.03,0.03,'A','F','1995-04-20','1995-04-25','1995-05-13','NONE','TRUCK','silent, regular accounts wake careful'),(65,8,1,2,22,19976,0,0.05,'N','O','1995-07-17','1995-06-04','1995-07-19','COLLECT COD','FOB','regular, pending theodolites are'),(65,1,1,3,21,18921,0.09,0.07,'N','O','1995-07-06','1995-05-14','1995-07-31','DELIVER IN PERSON','RAIL','ironically regular theodolites ha'),(66,12,1,1,31,28272.31,0,0.08,'R','F','1994-02-19','1994-03-11','1994-02-20','TAKE BACK RETURN','RAIL','closely bo'),(66,18,1,2,41,37638.41,0.04,0.07,'A','F','1994-02-21','1994-03-01','1994-03-18','COLLECT COD','AIR','furiously final waters are sl'),(67,3,1,1,4,3612,0.09,0.04,'N','O','1997-04-17','1997-01-31','1997-04-20','NONE','SHIP','carefully final theodolites inte');
15
INSERT INTO `lineitem` VALUES (67,3,1,2,12,10836,0.09,0.05,'N','O','1997-01-27','1997-02-21','1997-02-22','NONE','REG AIR','carefully bold pa'),(67,18,1,3,5,4590.05,0.03,0.07,'N','O','1997-02-20','1997-02-12','1997-02-21','DELIVER IN PERSON','TRUCK','bold excuses wake quickly ac'),(67,9,1,4,44,39996,0.08,0.06,'N','O','1997-03-18','1997-01-29','1997-04-13','DELIVER IN PERSON','RAIL','pending ideas after the deposits cajole f'),(67,5,1,5,23,20815,0.05,0.07,'N','O','1997-04-19','1997-02-14','1997-05-06','DELIVER IN PERSON','REG AIR','unusual depos'),(67,18,1,6,29,26622.29,0.02,0.05,'N','O','1997-01-25','1997-01-27','1997-01-27','DELIVER IN PERSON','FOB','furiously regular ideas abov'),(68,1,1,1,3,2703,0.05,0.02,'N','O','1998-07-04','1998-06-05','1998-07-21','NONE','RAIL','ironic, ironic '),(68,18,1,2,46,42228.46,0.02,0.05,'N','O','1998-06-26','1998-06-07','1998-07-05','NONE','MAIL','special reque'),(68,4,1,3,46,41584,0.04,0.05,'N','O','1998-08-13','1998-07-08','1998-08-29','NONE','RAIL','blithely ironic packages sleep f'),(68,10,1,4,20,18200.2,0.07,0.01,'N','O','1998-06-27','1998-05-23','1998-07-02','NONE','REG AIR','fluffily specia'),(68,9,1,5,27,24543,0.03,0.06,'N','O','1998-06-19','1998-06-25','1998-06-29','DELIVER IN PERSON','SHIP','quickly fi'),(68,11,1,6,30,27330.3,0.05,0.06,'N','O','1998-08-11','1998-07-11','1998-08-14','NONE','RAIL','final, regular pinto beans nag a'),(68,14,1,7,41,37474.41,0.09,0.08,'N','O','1998-06-24','1998-06-27','1998-07-06','NONE','SHIP','final, bold dolph'),(69,12,1,1,48,43776.48,0.01,0.07,'A','F','1994-08-17','1994-08-11','1994-09-08','NONE','TRUCK','dependencies serve'),(69,11,1,2,32,29152.32,0.08,0.06,'A','F','1994-08-24','1994-08-17','1994-08-31','NONE','REG AIR','express attainment'),(69,14,1,3,17,15538.17,0.09,0,'A','F','1994-07-02','1994-07-07','1994-07-03','TAKE BACK RETURN','AIR','carefully regular requests sleep a'),(69,4,1,4,3,2712,0.09,0.04,'R','F','1994-06-06','1994-07-27','1994-06-15','NONE','MAIL','regular dependencies are car'),(69,10,1,5,42,38220.42,0.07,0.04,'R','F','1994-07-31','1994-07-26','1994-08-28','DELIVER IN PERSON','REG AIR','ideas are carefully pending asymptotes. '),(69,2,1,6,23,20746,0.05,0,'A','F','1994-10-03','1994-08-06','1994-10-24','NONE','SHIP','sly theodolites along th'),(70,7,1,1,8,7256,0.03,0.08,'R','F','1994-01-12','1994-02-27','1994-01-14','TAKE BACK RETURN','FOB','even pinto beans are alongside o'),(70,20,1,2,13,11960.26,0.06,0.06,'A','F','1994-03-03','1994-02-13','1994-03-26','COLLECT COD','AIR','excuses haggl'),(70,18,1,3,1,918.01,0.03,0.05,'R','F','1994-01-26','1994-03-05','1994-01-28','TAKE BACK RETURN','RAIL','even packages haggle carefull'),(70,5,1,4,11,9955,0.01,0.05,'A','F','1994-03-17','1994-03-17','1994-03-27','NONE','MAIL','regular, even pinto beans along the furious'),(70,4,1,5,37,33448,0.09,0.04,'R','F','1994-02-13','1994-03-16','1994-02-21','COLLECT COD','MAIL','fluffily even deposits nag fluffil'),(70,6,1,6,19,17214,0.06,0.03,'A','F','1994-01-26','1994-02-17','1994-02-06','TAKE BACK RETURN','SHIP','slyly special ideas after the r'),(71,7,1,1,25,22675,0.09,0.07,'N','O','1998-04-10','1998-04-22','1998-04-11','COLLECT COD','FOB','unusual platelets are'),(71,7,1,2,3,2721,0.09,0.07,'N','O','1998-05-23','1998-04-03','1998-06-02','COLLECT COD','SHIP','slyly regu'),(71,4,1,3,45,40680,0,0.07,'N','O','1998-02-23','1998-03-20','1998-03-24','DELIVER IN PERSON','SHIP','accounts lose about the iro'),(71,10,1,4,33,30030.33,0,0.01,'N','O','1998-04-12','1998-03-20','1998-04-15','NONE','FOB','pending accounts sleep furiously pinto '),(71,11,1,5,39,35529.39,0.08,0.06,'N','O','1998-01-29','1998-04-07','1998-02-18','DELIVER IN PERSON','RAIL','bravely regular packag'),(71,20,1,6,34,31280.68,0.04,0.01,'N','O','1998-03-05','1998-04-22','1998-03-30','DELIVER IN PERSON','TRUCK','quickly express ideas detect blithely acros'),(96,13,1,1,23,20999.23,0.1,0.06,'A','F','1994-07-19','1994-06-29','1994-07-25','DELIVER IN PERSON','TRUCK','furiously express f');
16
INSERT INTO `lineitem` VALUES (96,14,1,2,30,27420.3,0.01,0.06,'R','F','1994-06-03','1994-05-29','1994-06-22','DELIVER IN PERSON','TRUCK','regular ide'),(97,12,1,1,13,11856.13,0,0.02,'R','F','1993-04-01','1993-04-04','1993-04-08','NONE','TRUCK','slyly final packages affix f'),(97,5,1,2,37,33485,0.02,0.06,'A','F','1993-04-13','1993-03-30','1993-04-14','DELIVER IN PERSON','SHIP','blithely bold deposits are at th'),(97,8,1,3,19,17252,0.06,0.08,'R','F','1993-05-14','1993-03-05','1993-05-25','TAKE BACK RETURN','RAIL','permanent hockey players'),(98,5,1,1,28,25340,0.06,0.07,'A','F','1994-12-24','1994-10-25','1995-01-16','COLLECT COD','REG AIR','final, silent ideas wake fluffily regular m'),(98,11,1,2,1,911.01,0,0,'A','F','1994-12-01','1994-12-12','1994-12-15','DELIVER IN PERSON','TRUCK','carefully pen'),(98,5,1,3,14,12670,0.05,0.02,'A','F','1994-12-30','1994-11-22','1995-01-27','COLLECT COD','AIR','regular deposits wake'),(98,17,1,4,10,9170.1,0.03,0.03,'A','F','1994-10-23','1994-11-08','1994-11-09','COLLECT COD','RAIL','regular braids s'),(99,9,1,1,10,9090,0.02,0.01,'A','F','1994-05-18','1994-06-03','1994-05-23','COLLECT COD','RAIL','unusual, ironi'),(99,13,1,2,5,4565.05,0.02,0.07,'R','F','1994-05-06','1994-05-28','1994-05-20','TAKE BACK RETURN','RAIL','blithely unusual t'),(99,14,1,3,42,38388.42,0.02,0.02,'A','F','1994-04-19','1994-05-18','1994-04-20','NONE','RAIL','blithely regular deposits'),(99,11,1,4,36,32796.36,0.09,0.02,'A','F','1994-07-04','1994-04-17','1994-07-30','DELIVER IN PERSON','AIR','quickly regular packages cajole furious'),(100,7,1,1,28,25396,0.04,0.05,'N','O','1998-05-08','1998-05-13','1998-06-07','COLLECT COD','TRUCK','stealthily ironic packages according to th'),(100,12,1,2,22,20064.22,0,0.07,'N','O','1998-06-24','1998-04-12','1998-06-29','DELIVER IN PERSON','SHIP','regular depo'),(100,5,1,3,46,41630,0.03,0.04,'N','O','1998-05-02','1998-04-10','1998-05-22','TAKE BACK RETURN','SHIP','furiously regular accounts hagg'),(100,4,1,4,14,12656,0.06,0.03,'N','O','1998-05-22','1998-05-01','1998-06-03','COLLECT COD','MAIL','carefully even pinto beans after the dog'),(100,6,1,5,37,33522,0.05,0,'N','O','1998-03-06','1998-04-16','1998-03-31','TAKE BACK RETURN','TRUCK','slyly special packages nag against t'),(101,12,1,1,49,44688.49,0.1,0,'N','O','1996-06-21','1996-05-27','1996-06-29','DELIVER IN PERSON','REG AIR','carefully even '),(101,17,1,2,36,33012.36,0,0.01,'N','O','1996-05-19','1996-05-01','1996-06-04','DELIVER IN PERSON','AIR','final deposit'),(101,14,1,3,12,10968.12,0.06,0.02,'N','O','1996-03-29','1996-04-20','1996-04-12','COLLECT COD','MAIL','final packages gr'),(102,9,1,1,37,33633,0.06,0,'N','O','1997-07-24','1997-08-02','1997-08-07','TAKE BACK RETURN','SHIP','fluffily regular ideas ar'),(102,17,1,2,34,31178.34,0.03,0.08,'N','O','1997-08-09','1997-07-28','1997-08-26','TAKE BACK RETURN','SHIP','quickly express packa'),(102,19,1,3,25,22975.25,0.01,0.01,'N','O','1997-07-31','1997-07-24','1997-08-17','NONE','RAIL','instructions sleep. carefully even de'),(102,7,1,4,15,13605,0.07,0.07,'N','O','1997-06-02','1997-07-13','1997-06-04','DELIVER IN PERSON','SHIP','carefully qu'),(103,20,1,1,6,5520.12,0.03,0.05,'N','O','1996-10-11','1996-07-25','1996-10-28','NONE','FOB','carefully bold packages are slyly even'),(103,2,1,2,37,33374,0.02,0.07,'N','O','1996-09-17','1996-07-27','1996-09-20','TAKE BACK RETURN','MAIL','furiously even ideas cajole '),(103,3,1,3,23,20769,0.01,0.04,'N','O','1996-09-11','1996-09-18','1996-09-26','NONE','FOB','dolphins b'),(103,3,1,4,32,28896,0.01,0.07,'N','O','1996-07-30','1996-08-06','1996-08-04','NONE','RAIL','platelets sleep quick'),(128,11,1,1,38,34618.38,0.06,0.01,'A','F','1992-09-01','1992-08-27','1992-10-01','TAKE BACK RETURN','FOB','carefully bold ac'),(129,1,1,1,46,41446,0.08,0.02,'R','F','1993-02-15','1993-01-24','1993-03-05','COLLECT COD','TRUCK','even accounts after the'),(129,19,1,2,36,33084.36,0.01,0.02,'A','F','1992-11-25','1992-12-25','1992-12-09','TAKE BACK RETURN','REG AIR','blithely regular dolphins int');
17
INSERT INTO `lineitem` VALUES (129,4,1,3,33,29832,0.04,0.06,'A','F','1993-01-08','1993-02-14','1993-01-29','COLLECT COD','SHIP','deposits serve slyly quickly ironi'),(129,14,1,4,34,31076.34,0,0.01,'R','F','1993-01-29','1993-02-14','1993-02-10','COLLECT COD','MAIL','carefully regular foxes are furiou'),(129,4,1,5,24,21696,0.06,0,'A','F','1992-12-07','1993-01-02','1992-12-11','TAKE BACK RETURN','FOB','furiously unusual theodolites acr'),(129,8,1,6,22,19976,0.06,0.01,'R','F','1993-02-15','1993-01-31','1993-02-24','COLLECT COD','SHIP','final realms affi'),(129,17,1,7,1,917.01,0.05,0.04,'R','F','1993-01-26','1993-01-08','1993-02-24','DELIVER IN PERSON','FOB','busily express i'),(130,13,1,1,14,12782.14,0.08,0.05,'A','F','1992-08-15','1992-07-25','1992-09-13','COLLECT COD','RAIL','carefully bold theodolites '),(130,1,1,2,48,43248,0.03,0.02,'R','F','1992-07-01','1992-07-12','1992-07-24','NONE','AIR','express, stealthy frets haggle. f'),(130,2,1,3,18,16236,0.04,0.08,'A','F','1992-07-04','1992-06-14','1992-07-29','DELIVER IN PERSON','MAIL','blithely unusua'),(130,12,1,4,13,11856.13,0.09,0.02,'R','F','1992-06-26','1992-07-29','1992-07-05','NONE','FOB','carefully busy asymp'),(130,7,1,5,31,28117,0.06,0.05,'R','F','1992-09-01','1992-07-18','1992-09-02','TAKE BACK RETURN','RAIL','fluffily even pla'),(131,17,1,1,45,41265.45,0.1,0.02,'R','F','1994-09-14','1994-09-02','1994-10-04','NONE','FOB','express asymptotes eat'),(131,5,1,2,50,45250,0.02,0.04,'A','F','1994-09-17','1994-08-10','1994-09-21','NONE','SHIP','ironic asymptotes eat ruthlessl'),(131,19,1,3,4,3676.04,0.04,0.03,'A','F','1994-09-20','1994-08-30','1994-09-23','COLLECT COD','REG AIR','slyly final excuses haggle furiou'),(132,15,1,1,18,16470.18,0,0.08,'R','F','1993-07-10','1993-08-05','1993-07-13','NONE','TRUCK','bold, final asymptotes nag fluffily aga'),(132,12,1,2,43,39216.43,0.01,0.08,'R','F','1993-09-01','1993-08-16','1993-09-22','NONE','TRUCK','ironic, express deposits haggle fluffil'),(132,12,1,3,32,29184.32,0.04,0.04,'A','F','1993-07-12','1993-08-05','1993-08-05','COLLECT COD','TRUCK','furiously ironic requests'),(132,3,1,4,23,20769,0.1,0,'A','F','1993-06-16','1993-08-27','1993-06-23','DELIVER IN PERSON','AIR','blithely pending pac'),(133,11,1,1,27,24597.27,0,0.02,'N','O','1997-12-21','1998-02-23','1997-12-27','TAKE BACK RETURN','MAIL','furiously final ideas s'),(133,18,1,2,12,11016.12,0.02,0.06,'N','O','1997-12-02','1998-01-15','1997-12-29','DELIVER IN PERSON','REG AIR','finally brave dependencies could have to d'),(133,12,1,3,29,26448.29,0.09,0.08,'N','O','1998-02-28','1998-01-30','1998-03-09','DELIVER IN PERSON','RAIL','ironic, pe'),(133,9,1,4,11,9999,0.06,0.01,'N','O','1998-03-21','1998-01-15','1998-04-04','DELIVER IN PERSON','REG AIR','carefully regular '),(134,1,1,1,21,18921,0,0.03,'A','F','1992-07-17','1992-07-08','1992-07-26','COLLECT COD','SHIP','quickly final packages'),(134,17,1,2,35,32095.35,0.06,0.07,'A','F','1992-08-23','1992-06-01','1992-08-24','NONE','MAIL','slowly bold ideas haggle cl'),(134,19,1,3,26,23894.26,0.09,0.06,'A','F','1992-06-20','1992-07-12','1992-07-16','NONE','RAIL','pending accounts could have'),(134,15,1,4,47,43005.47,0.05,0,'A','F','1992-08-16','1992-07-06','1992-08-28','NONE','REG AIR','final, ironic deposits'),(134,4,1,5,12,10848,0.05,0.02,'A','F','1992-07-03','1992-06-01','1992-07-11','COLLECT COD','TRUCK','silent Tiresias cajole. furiously bo'),(134,14,1,6,12,10968.12,0,0,'A','F','1992-08-08','1992-07-07','1992-08-20','TAKE BACK RETURN','FOB','even, regular dep'),(135,11,1,1,47,42817.47,0.06,0.08,'N','O','1996-02-18','1996-01-01','1996-02-25','COLLECT COD','RAIL','final deposits wa'),(135,20,1,2,21,19320.42,0,0.07,'N','O','1996-02-11','1996-01-12','1996-02-13','DELIVER IN PERSON','SHIP','furiously express escapades against t'),(135,16,1,3,33,30228.33,0.02,0,'N','O','1996-01-03','1995-11-21','1996-02-01','TAKE BACK RETURN','MAIL','furiously fina'),(135,7,1,4,34,30838,0.02,0.03,'N','O','1996-01-12','1996-01-19','1996-02-05','NONE','TRUCK','bold, regular');
18
INSERT INTO `lineitem` VALUES (135,14,1,5,20,18280.2,0.01,0.04,'N','O','1996-01-25','1995-11-20','1996-02-09','NONE','MAIL','bold dugouts above the ironic dependenc'),(135,12,1,6,13,11856.13,0.04,0.02,'N','O','1995-11-12','1995-12-22','1995-11-17','NONE','FOB','quickly regular pack'),(160,2,1,1,36,32472,0.07,0.01,'N','O','1997-03-11','1997-03-11','1997-03-20','COLLECT COD','MAIL','foxes are blithely carefully even accounts.'),(160,9,1,2,22,19998,0,0.04,'N','O','1997-02-18','1997-03-05','1997-03-05','COLLECT COD','RAIL','slyly fina'),(160,3,1,3,34,30702,0.01,0.05,'N','O','1997-01-31','1997-03-13','1997-02-14','NONE','FOB','slyly unusual de'),(161,11,1,1,19,17309.19,0.01,0.01,'A','F','1994-12-13','1994-11-19','1994-12-26','DELIVER IN PERSON','TRUCK','carefully quiet warthogs cajole '),(162,19,1,1,2,1838.02,0.02,0.01,'N','O','1995-09-02','1995-06-17','1995-09-08','COLLECT COD','FOB','carefully ironic requests wake fluffily'),(163,17,1,1,43,39431.43,0.01,0,'N','O','1997-09-19','1997-11-19','1997-10-03','COLLECT COD','REG AIR','final accounts cajole. carefully sil'),(163,13,1,2,13,11869.13,0.01,0.04,'N','O','1997-11-11','1997-10-18','1997-12-07','DELIVER IN PERSON','TRUCK','furiously express ideas affix. requests '),(163,4,1,3,27,24408,0.04,0.08,'N','O','1997-12-26','1997-11-28','1998-01-05','COLLECT COD','REG AIR','carefully special requests are after the'),(163,20,1,4,5,4600.1,0.02,0,'N','O','1997-11-17','1997-10-09','1997-12-05','DELIVER IN PERSON','TRUCK','carefully '),(163,13,1,5,12,10956.12,0.1,0,'N','O','1997-12-18','1997-10-26','1997-12-22','COLLECT COD','TRUCK','quickly final the'),(163,20,1,6,20,18400.4,0,0.07,'N','O','1997-09-27','1997-11-15','1997-10-07','TAKE BACK RETURN','FOB','furiously bold requests a'),(164,10,1,1,26,23660.26,0.09,0.04,'A','F','1993-01-04','1992-11-21','1993-01-07','NONE','RAIL','ironic foxes bey'),(164,2,1,2,24,21648,0.05,0.05,'R','F','1992-12-22','1992-11-27','1993-01-06','NONE','AIR','ironic platelets detec'),(164,13,1,3,38,34694.38,0.03,0.06,'R','F','1992-12-04','1992-11-23','1993-01-02','TAKE BACK RETURN','AIR','furiously ironic pinto '),(164,2,1,4,32,28864,0.05,0.01,'R','F','1992-12-21','1992-12-23','1992-12-28','COLLECT COD','RAIL','unusual reque'),(164,15,1,5,43,39345.43,0.06,0.01,'R','F','1992-11-26','1993-01-03','1992-12-08','COLLECT COD','RAIL','express, ironic requests haggl'),(164,11,1,6,27,24597.27,0.1,0.04,'R','F','1992-12-23','1993-01-16','1993-01-10','DELIVER IN PERSON','AIR','furiously ironic packages detect above'),(164,1,1,7,23,20723,0.09,0.04,'A','F','1992-11-03','1992-12-02','1992-11-12','NONE','REG AIR','even accounts cajole quickly'),(165,4,1,1,3,2712,0.01,0.08,'R','F','1993-03-29','1993-03-06','1993-04-12','DELIVER IN PERSON','REG AIR','express packages are blithely. furiously e'),(165,17,1,2,43,39431.43,0.08,0.05,'R','F','1993-02-27','1993-04-19','1993-03-03','DELIVER IN PERSON','TRUCK','carefully regular warhors'),(165,6,1,3,15,13590,0,0.05,'R','F','1993-04-10','1993-03-29','1993-05-01','COLLECT COD','SHIP','depths solve slyly across th'),(165,14,1,4,49,44786.49,0.07,0.06,'A','F','1993-02-20','1993-04-02','1993-03-10','COLLECT COD','REG AIR','express in'),(165,16,1,5,27,24732.27,0.01,0.04,'R','F','1993-04-27','1993-03-04','1993-05-13','NONE','MAIL','asymptotes sublate alongside'),(166,7,1,1,37,33559,0.09,0.03,'N','O','1995-11-16','1995-10-17','1995-12-13','NONE','MAIL','furiously silent ideas sleep blith'),(166,17,1,2,13,11921.13,0.09,0.05,'N','O','1995-11-09','1995-11-18','1995-11-14','COLLECT COD','SHIP','regular, regular pinto beans sleep furi'),(166,10,1,3,41,37310.41,0.07,0.03,'N','O','1995-11-13','1995-11-07','1995-12-08','COLLECT COD','FOB','final dolphins h'),(166,5,1,4,8,7240,0.05,0.02,'N','O','1995-12-30','1995-11-29','1996-01-29','DELIVER IN PERSON','RAIL','deposits aro'),(167,11,1,1,28,25508.28,0.06,0.01,'R','F','1993-02-19','1993-02-16','1993-03-03','DELIVER IN PERSON','TRUCK','blithely even');
19
INSERT INTO `lineitem` VALUES (167,18,1,2,27,24786.27,0.09,0,'R','F','1993-05-01','1993-03-31','1993-05-31','TAKE BACK RETURN','FOB','asymptotes cajole careful'),(192,10,1,1,23,20930.23,0,0,'N','O','1998-02-05','1998-02-06','1998-03-07','TAKE BACK RETURN','AIR','regular braids are carefull'),(192,17,1,2,20,18340.2,0.07,0.01,'N','O','1998-03-13','1998-02-02','1998-03-31','TAKE BACK RETURN','REG AIR','idly ironic ideas about t'),(192,12,1,3,15,13680.15,0.09,0.01,'N','O','1998-01-30','1998-02-10','1998-02-23','TAKE BACK RETURN','TRUCK','silent, unusual accounts against t'),(192,20,1,4,2,1840.04,0.06,0.02,'N','O','1998-03-06','1998-02-03','1998-03-24','COLLECT COD','SHIP','carefully final packages print b'),(192,9,1,5,25,22725,0.02,0.03,'N','O','1998-02-15','1998-01-11','1998-03-17','COLLECT COD','TRUCK','accounts abou'),(192,15,1,6,45,41175.45,0,0.05,'N','O','1998-03-11','1998-01-09','1998-04-03','NONE','MAIL','fluffily regular requests detect car'),(193,10,1,1,9,8190.09,0.06,0.06,'A','F','1993-09-17','1993-10-08','1993-09-30','COLLECT COD','TRUCK','daring, quick packages about the slyly '),(193,16,1,2,15,13740.15,0.02,0.07,'R','F','1993-11-22','1993-10-09','1993-12-05','TAKE BACK RETURN','SHIP','pinto beans doubt f'),(193,10,1,3,23,20930.23,0.06,0.05,'A','F','1993-08-21','1993-10-11','1993-09-02','DELIVER IN PERSON','TRUCK','blithely pending dependencies ca'),(194,1,1,1,17,15317,0.05,0.04,'R','F','1992-05-24','1992-05-22','1992-05-30','COLLECT COD','AIR','carefully unusual attainment'),(194,19,1,2,1,919.01,0.04,0.06,'R','F','1992-04-30','1992-05-18','1992-05-23','NONE','REG AIR','furiously i'),(194,7,1,3,13,11791,0.08,0.08,'A','F','1992-05-07','1992-06-18','1992-05-10','NONE','AIR','regular, ironic accounts a'),(194,15,1,4,36,32940.36,0,0.05,'R','F','1992-05-21','1992-05-18','1992-05-27','TAKE BACK RETURN','RAIL','theodolites against the fluffily'),(194,6,1,5,8,7248,0.04,0,'R','F','1992-07-06','1992-06-25','1992-07-11','COLLECT COD','FOB','busy, bold ideas'),(194,15,1,6,16,14640.16,0.06,0.03,'A','F','1992-05-14','1992-06-14','1992-05-21','TAKE BACK RETURN','TRUCK','slyly unusual requests sleep furiousl'),(194,17,1,7,21,19257.21,0.02,0.01,'R','F','1992-05-06','1992-05-20','1992-05-07','COLLECT COD','REG AIR','foxes breach blit'),(195,9,1,1,6,5454,0.04,0.02,'A','F','1994-01-09','1994-03-27','1994-01-28','COLLECT COD','REG AIR','furiously silent requests '),(195,10,1,2,41,37310.41,0.05,0.07,'A','F','1994-02-24','1994-02-11','1994-03-20','NONE','TRUCK','slyly regular'),(195,9,1,3,34,30906,0.08,0.08,'R','F','1994-01-31','1994-02-11','1994-02-12','NONE','TRUCK','slyly ironic requests '),(195,9,1,4,41,37269,0.06,0.04,'R','F','1994-03-14','1994-03-13','1994-04-09','COLLECT COD','RAIL','carefully even foxes daz'),(196,14,1,1,19,17366.19,0.03,0.02,'R','F','1993-04-17','1993-05-27','1993-04-30','NONE','SHIP','carefully busy d'),(196,1,1,2,15,13515,0.03,0.04,'A','F','1993-07-05','1993-05-08','1993-07-06','TAKE BACK RETURN','SHIP','slyly close theodolites play blithely fur'),(197,10,1,1,39,35490.39,0.02,0.04,'N','O','1995-07-21','1995-07-01','1995-08-14','TAKE BACK RETURN','AIR','unusual sentiments ab'),(197,18,1,2,8,7344.08,0.09,0.02,'A','F','1995-04-17','1995-07-01','1995-04-27','DELIVER IN PERSON','SHIP','packages detect furiously'),(197,16,1,3,17,15572.17,0.06,0.02,'N','O','1995-08-02','1995-06-23','1995-08-03','COLLECT COD','REG AIR','fluffily regular packages use aga'),(197,2,1,4,25,22550,0.04,0.01,'N','F','1995-06-13','1995-05-23','1995-06-24','TAKE BACK RETURN','FOB','blithely regular deposits sleep alongside'),(197,5,1,5,14,12670,0.09,0.01,'R','F','1995-05-08','1995-05-24','1995-05-12','TAKE BACK RETURN','RAIL','regular, unusual packag'),(197,11,1,6,1,911.01,0.07,0.05,'N','O','1995-07-15','1995-06-21','1995-08-11','COLLECT COD','RAIL','slyly special accounts affix '),(198,6,1,1,33,29898,0.07,0.02,'N','O','1998-01-05','1998-03-20','1998-01-10','TAKE BACK RETURN','TRUCK','ironic excuses detect fluffily.');
20
INSERT INTO `lineitem` VALUES (198,2,1,2,20,18040,0.03,0,'N','O','1998-01-15','1998-03-31','1998-01-25','DELIVER IN PERSON','FOB','blithely final ideas '),(198,15,1,3,15,13725.15,0.04,0.02,'N','O','1998-04-12','1998-02-26','1998-04-15','COLLECT COD','MAIL','fluffily final asymptotes wake along '),(198,2,1,4,35,31570,0.08,0.02,'N','O','1998-02-27','1998-03-23','1998-03-14','TAKE BACK RETURN','RAIL','furiously reg'),(198,11,1,5,33,30063.33,0.02,0.01,'N','O','1998-03-22','1998-03-12','1998-04-14','DELIVER IN PERSON','SHIP','quickly pending acc'),(199,14,1,1,50,45700.5,0.02,0,'N','O','1996-06-12','1996-06-03','1996-07-04','DELIVER IN PERSON','MAIL','furiously fina'),(199,14,1,2,30,27420.3,0.08,0.05,'N','O','1996-03-27','1996-05-29','1996-04-14','NONE','TRUCK','furiously express instructi'),(224,16,1,1,16,14656.16,0.04,0,'A','F','1994-08-01','1994-07-30','1994-08-27','DELIVER IN PERSON','MAIL','pending pa'),(224,11,1,2,34,30974.34,0.04,0.08,'R','F','1994-07-13','1994-08-25','1994-07-31','COLLECT COD','TRUCK','ruthlessly final deposits sleep fluffil'),(224,19,1,3,41,37679.41,0.07,0.04,'A','F','1994-09-01','1994-09-15','1994-09-02','TAKE BACK RETURN','SHIP','carefully express theodolites haggle caref'),(224,17,1,4,12,11004.12,0.08,0.06,'R','F','1994-10-12','1994-08-29','1994-10-20','DELIVER IN PERSON','MAIL','slyly even asympt'),(224,10,1,5,45,40950.45,0.07,0.07,'R','F','1994-08-14','1994-09-02','1994-08-27','COLLECT COD','AIR','regular sauternes'),(224,6,1,6,4,3624,0.02,0,'R','F','1994-09-08','1994-08-24','1994-10-04','DELIVER IN PERSON','FOB','fluffily ironic accounts cajol'),(225,18,1,1,4,3672.04,0.09,0.07,'N','O','1995-08-05','1995-08-19','1995-09-03','TAKE BACK RETURN','SHIP','deposits use. reg'),(225,14,1,2,3,2742.03,0,0.08,'N','O','1995-07-25','1995-07-08','1995-08-17','DELIVER IN PERSON','REG AIR','ironic accounts accordin'),(225,20,1,3,45,41400.9,0.06,0.01,'N','O','1995-08-17','1995-08-20','1995-08-30','TAKE BACK RETURN','FOB','carefully unusual requests along the blith'),(225,15,1,4,24,21960.24,0,0.06,'N','O','1995-09-23','1995-08-05','1995-10-16','COLLECT COD','MAIL','quickly ironic packages are'),(225,1,1,5,31,27931,0.04,0.06,'N','O','1995-06-21','1995-07-24','1995-07-04','TAKE BACK RETURN','FOB','furiously ironic requests within t'),(225,14,1,6,12,10968.12,0,0,'A','F','1995-06-04','1995-07-15','1995-06-08','COLLECT COD','MAIL','furiously expr'),(225,15,1,7,44,40260.44,0.1,0.06,'N','O','1995-09-22','1995-08-16','1995-10-22','NONE','REG AIR','carefully ironic a'),(226,10,1,1,4,3640.04,0,0,'R','F','1993-03-31','1993-04-30','1993-04-10','NONE','TRUCK','furiously final instruc'),(226,14,1,2,46,42044.46,0.06,0.01,'A','F','1993-07-06','1993-04-24','1993-07-13','COLLECT COD','FOB','quickly final theodol'),(226,4,1,3,35,31640,0.09,0.03,'A','F','1993-03-31','1993-05-18','1993-04-01','NONE','RAIL','packages wake slyly. furiously unusua'),(226,5,1,4,45,40725,0.1,0.02,'R','F','1993-04-17','1993-05-27','1993-05-11','DELIVER IN PERSON','AIR','furiously even foxes was blithely sly'),(226,12,1,5,2,1824.02,0.07,0.02,'R','F','1993-03-26','1993-04-13','1993-04-20','TAKE BACK RETURN','SHIP','ironic theodolites nag. slyly f'),(226,9,1,6,48,43632,0.02,0,'A','F','1993-06-11','1993-05-15','1993-06-19','NONE','REG AIR','slyly close deposits haggle quickly under '),(226,12,1,7,14,12768.14,0.09,0,'R','F','1993-05-20','1993-06-05','1993-05-27','COLLECT COD','MAIL','ideas use carefully. silent decoys cajole'),(227,17,1,1,19,17423.19,0.05,0.06,'N','O','1995-12-10','1996-01-30','1995-12-26','NONE','RAIL','regular, final '),(227,18,1,2,24,22032.24,0.07,0.07,'N','O','1996-02-03','1995-12-24','1996-02-12','COLLECT COD','SHIP','slyly unusual theodolites wake. caref'),(228,1,1,1,3,2703,0.1,0.08,'A','F','1993-05-20','1993-04-08','1993-05-26','DELIVER IN PERSON','SHIP','regular packages detect slyly. c'),(229,9,1,1,20,18180,0.02,0.03,'R','F','1994-01-11','1994-01-31','1994-01-26','DELIVER IN PERSON','REG AIR','final accounts integrate. blithe');
21
INSERT INTO `lineitem` VALUES (229,13,1,2,29,26477.29,0.07,0,'A','F','1994-03-15','1994-03-02','1994-03-26','COLLECT COD','SHIP','slyly pending Ti'),(229,8,1,3,28,25424,0.02,0.02,'R','F','1994-02-10','1994-02-02','1994-03-10','DELIVER IN PERSON','FOB','final deposits'),(229,18,1,4,3,2754.03,0.02,0.08,'R','F','1994-03-22','1994-03-24','1994-04-04','DELIVER IN PERSON','REG AIR','slyly silent deposits sleep carefu'),(229,16,1,5,33,30228.33,0.03,0.06,'R','F','1994-03-25','1994-02-11','1994-04-13','NONE','FOB','asymptotes'),(229,11,1,6,29,26419.29,0.04,0,'R','F','1994-01-14','1994-02-16','1994-01-22','NONE','FOB','furiously fi'),(230,19,1,1,46,42274.46,0.09,0,'R','F','1994-02-03','1994-01-15','1994-02-23','TAKE BACK RETURN','SHIP','carefully even deposits boos'),(230,20,1,2,6,5520.12,0.03,0.08,'A','F','1994-01-26','1994-01-25','1994-02-13','NONE','REG AIR','quickly silent dependencies wake slyl'),(230,1,1,3,1,901,0.07,0.06,'R','F','1994-01-22','1994-01-03','1994-02-05','TAKE BACK RETURN','RAIL','furiously pending pinto beans in'),(230,1,1,4,44,39644,0.08,0.06,'R','F','1994-02-09','1994-01-18','1994-03-11','NONE','MAIL','blithely regular pinto bean'),(230,2,1,5,8,7216,0.09,0.06,'R','F','1993-11-03','1994-01-20','1993-11-11','TAKE BACK RETURN','TRUCK','furiously ironic e'),(230,4,1,6,8,7232,0,0.05,'R','F','1993-11-21','1994-01-05','1993-12-19','TAKE BACK RETURN','FOB','platelets sleep along the carefully'),(231,16,1,1,16,14656.16,0.04,0.08,'R','F','1994-11-20','1994-10-29','1994-12-17','TAKE BACK RETURN','AIR','slyly express requests are aroun'),(231,9,1,2,46,41814,0.04,0.05,'R','F','1994-12-13','1994-12-02','1994-12-14','DELIVER IN PERSON','SHIP','carefully regular dolphins'),(231,20,1,3,50,46001,0.09,0.01,'A','F','1994-12-11','1994-12-14','1994-12-13','NONE','RAIL','bold packag'),(231,6,1,4,31,28086,0.08,0.02,'A','F','1994-11-05','1994-12-27','1994-11-30','TAKE BACK RETURN','SHIP','bold requests boost carefully against the e'),(256,9,1,1,22,19998,0.09,0.02,'R','F','1994-01-12','1993-12-28','1994-01-26','COLLECT COD','FOB','slyly final dependencies acc'),(256,12,1,2,40,36480.4,0.1,0.01,'A','F','1993-11-30','1993-12-13','1993-12-02','NONE','FOB','carefully p'),(256,13,1,3,45,41085.45,0.02,0.08,'R','F','1994-01-14','1994-01-17','1994-02-10','COLLECT COD','SHIP','pending package'),(257,15,1,1,7,6405.07,0.05,0.02,'N','O','1998-06-18','1998-05-15','1998-06-27','COLLECT COD','FOB','blithely unusual inst'),(258,11,1,1,8,7288.08,0,0.07,'R','F','1994-01-20','1994-03-21','1994-02-09','NONE','REG AIR','quick theodolites above th'),(258,20,1,2,40,36800.8,0.1,0.01,'A','F','1994-03-13','1994-02-23','1994-04-05','DELIVER IN PERSON','FOB','quickly final platele'),(258,17,1,3,45,41265.45,0.07,0.07,'R','F','1994-03-04','1994-02-13','1994-03-30','DELIVER IN PERSON','TRUCK','instructions boos'),(258,14,1,4,31,28334.31,0.02,0.05,'A','F','1994-04-20','1994-03-20','1994-04-28','COLLECT COD','REG AIR','slyly pending ideas cajole. caref'),(258,4,1,5,25,22600,0.08,0.02,'A','F','1994-04-13','1994-02-26','1994-04-29','TAKE BACK RETURN','TRUCK','slyly regular r'),(258,15,1,6,36,32940.36,0.09,0.04,'A','F','1994-01-11','1994-03-04','1994-01-18','DELIVER IN PERSON','AIR','blithely ironic accounts'),(259,10,1,1,14,12740.14,0,0.08,'A','F','1993-12-17','1993-12-09','1993-12-31','COLLECT COD','SHIP','pending, pending instructions'),(259,17,1,2,14,12838.14,0.03,0.05,'R','F','1993-11-10','1993-11-20','1993-11-17','DELIVER IN PERSON','FOB','requests up the packages in'),(259,3,1,3,42,37926,0.09,0,'R','F','1993-10-20','1993-11-18','1993-11-12','NONE','TRUCK','pending pinto beans are.'),(259,20,1,4,3,2760.06,0.08,0.06,'R','F','1993-10-04','1993-11-07','1993-10-14','TAKE BACK RETURN','SHIP','packages must cajole slyly even '),(259,20,1,5,6,5520.12,0,0.05,'R','F','1993-12-05','1993-12-22','1993-12-21','COLLECT COD','TRUCK','quickly even accounts haggle carefully'),(260,16,1,1,50,45800.5,0.07,0.08,'N','O','1997-03-24','1997-02-09','1997-04-20','TAKE BACK RETURN','REG AIR','regular, regular pin');
22
INSERT INTO `lineitem` VALUES (260,19,1,2,26,23894.26,0.02,0.07,'N','O','1996-12-12','1997-02-06','1996-12-15','NONE','TRUCK','quickly even dependen'),(260,5,1,3,27,24435,0.05,0.08,'N','O','1997-03-23','1997-02-15','1997-04-22','TAKE BACK RETURN','RAIL','express theodolites should en'),(260,1,1,4,29,26129,0.1,0.06,'N','O','1997-03-15','1997-01-14','1997-04-13','NONE','MAIL','accounts haggle. final, bold requests use f'),(260,10,1,5,44,40040.44,0.01,0.05,'N','O','1997-03-26','1997-02-03','1997-04-19','DELIVER IN PERSON','MAIL','furiously final deposits among the blithely'),(261,1,1,1,34,30634,0.05,0.08,'R','F','1993-08-18','1993-09-24','1993-08-20','COLLECT COD','REG AIR','quickly even accoun'),(261,7,1,2,20,18140,0,0.06,'R','F','1993-10-21','1993-08-02','1993-11-04','DELIVER IN PERSON','RAIL','quickly final dolphins ought to are-- '),(261,18,1,3,28,25704.28,0.08,0.03,'R','F','1993-07-24','1993-08-20','1993-08-05','COLLECT COD','AIR','furiously even in'),(261,12,1,4,49,44688.49,0.04,0.05,'R','F','1993-09-12','1993-08-31','1993-10-07','COLLECT COD','SHIP','blithely express foxes nag. even fo'),(261,7,1,5,49,44443,0.01,0.08,'A','F','1993-09-29','1993-09-08','1993-10-01','COLLECT COD','SHIP','final theo'),(261,10,1,6,20,18200.2,0.06,0.06,'A','F','1993-10-15','1993-09-05','1993-11-07','NONE','AIR','pinto beans haggle ironic, bold pa'),(262,20,1,1,39,35880.78,0.01,0.05,'N','O','1996-01-15','1996-02-18','1996-01-28','COLLECT COD','RAIL','ironic deposits '),(262,7,1,2,33,29931,0.09,0.03,'N','O','1996-03-10','1996-01-31','1996-03-27','TAKE BACK RETURN','AIR','theodolites cajole slyly above the fluffil'),(262,6,1,3,35,31710,0.05,0.08,'N','O','1996-03-12','1996-02-14','1996-04-11','COLLECT COD','MAIL','quickly unusua'),(263,3,1,1,22,19866,0.06,0.08,'R','F','1994-08-24','1994-06-20','1994-09-09','NONE','FOB','pending foxes are quickly alongside of the '),(263,9,1,2,9,8181,0.08,0,'A','F','1994-07-21','1994-07-16','1994-08-08','TAKE BACK RETURN','TRUCK','express, express requests sleep quickly '),(263,15,1,3,50,45750.5,0.06,0.04,'R','F','1994-08-18','1994-07-31','1994-08-22','NONE','TRUCK','carefully expr'),(288,6,1,1,31,28086,0,0.03,'N','O','1997-03-17','1997-04-28','1997-04-06','TAKE BACK RETURN','AIR','silently reg'),(288,12,1,2,49,44688.49,0.08,0.05,'N','O','1997-04-19','1997-05-19','1997-05-18','TAKE BACK RETURN','TRUCK','blithely final '),(288,10,1,3,36,32760.36,0.02,0.02,'N','O','1997-02-22','1997-05-07','1997-03-07','TAKE BACK RETURN','TRUCK','slyly even foxes alongside of '),(288,8,1,4,19,17252,0.07,0.07,'N','O','1997-03-14','1997-04-04','1997-03-26','NONE','MAIL','special requests sleep alongside of the re'),(288,17,1,5,31,28427.31,0.1,0.04,'N','O','1997-05-29','1997-04-24','1997-06-20','TAKE BACK RETURN','RAIL','carefully express deposits wake quickly '),(289,18,1,1,25,22950.25,0.07,0.05,'N','O','1997-03-18','1997-05-05','1997-04-15','DELIVER IN PERSON','FOB','quickly regular theodolites detect a'),(289,12,1,2,6,5472.06,0.06,0.05,'N','O','1997-02-18','1997-05-08','1997-03-19','DELIVER IN PERSON','SHIP','furiously '),(289,2,1,3,44,39688,0.1,0.08,'N','O','1997-06-05','1997-04-20','1997-07-02','COLLECT COD','MAIL','slyly even deposits cajole furi'),(289,4,1,4,48,43392,0.01,0.08,'N','O','1997-03-14','1997-03-30','1997-03-24','DELIVER IN PERSON','RAIL','slyly furious accounts x-ray'),(289,5,1,5,13,11765,0.1,0.03,'N','O','1997-06-08','1997-04-06','1997-06-18','TAKE BACK RETURN','REG AIR','furiously unusual requ'),(290,1,1,1,35,31535,0.01,0.02,'R','F','1994-04-01','1994-02-05','1994-04-27','NONE','MAIL','theodolites'),(290,13,1,2,2,1826.02,0.05,0.04,'A','F','1994-01-30','1994-02-13','1994-02-21','TAKE BACK RETURN','TRUCK','unusual, special dependen'),(290,1,1,3,5,4505,0.03,0.05,'A','F','1994-01-19','1994-02-24','1994-01-27','NONE','MAIL','even frays mold. final'),(290,13,1,4,23,20999.23,0.05,0.08,'R','F','1994-03-14','1994-02-21','1994-04-09','NONE','AIR','blithely u');
23
INSERT INTO `lineitem` VALUES (291,13,1,1,21,19173.21,0.05,0.07,'A','F','1994-05-26','1994-05-10','1994-06-23','COLLECT COD','TRUCK','sly theodolites use after th'),(291,14,1,2,19,17366.19,0.08,0.02,'R','F','1994-06-14','1994-04-25','1994-06-19','NONE','REG AIR','thin dolphi'),(291,7,1,3,30,27210,0.1,0.02,'R','F','1994-03-22','1994-04-30','1994-03-24','DELIVER IN PERSON','FOB','regular pearls above t'),(292,16,1,1,8,7328.08,0.1,0.03,'R','F','1992-02-18','1992-03-30','1992-03-18','DELIVER IN PERSON','RAIL','furiously regular excuses'),(292,10,1,2,24,21840.24,0.08,0.04,'R','F','1992-03-24','1992-03-06','1992-04-20','COLLECT COD','TRUCK','ironic instructions '),(293,1,1,1,14,12614,0.02,0.05,'R','F','1992-10-19','1992-12-23','1992-11-10','DELIVER IN PERSON','SHIP','regular foxes boost furiously.'),(293,19,1,2,11,10109.11,0.1,0.04,'R','F','1992-12-24','1992-12-01','1993-01-12','COLLECT COD','MAIL','fluffily even platelets upon the special, s'),(293,12,1,3,13,11856.13,0.04,0.02,'A','F','1992-12-17','1992-12-26','1992-12-22','COLLECT COD','RAIL','dependencies nag blithely. '),(294,6,1,1,31,28086,0,0.01,'R','F','1993-08-06','1993-08-19','1993-08-13','TAKE BACK RETURN','AIR','slyly unusual ideas haggle'),(295,20,1,1,29,26680.58,0.02,0.07,'A','F','1994-11-09','1994-12-08','1994-12-07','COLLECT COD','MAIL','express deposits haggle. fluffily'),(295,10,1,2,26,23660.26,0.04,0.03,'R','F','1994-12-13','1994-11-30','1995-01-06','DELIVER IN PERSON','AIR','carefully even p'),(295,2,1,3,8,7216,0.1,0.07,'R','F','1995-01-13','1994-11-17','1995-01-25','NONE','TRUCK','ideas haggle. slyly special dolphin'),(295,7,1,4,26,23582,0.1,0.04,'A','F','1995-01-12','1994-11-22','1995-01-22','DELIVER IN PERSON','MAIL','quickly final acc'),(320,1,1,1,30,27030,0.05,0.01,'N','O','1997-12-04','1998-01-21','1997-12-13','NONE','RAIL','quickly even frets unwind carefully acc'),(320,20,1,2,13,11960.26,0.03,0,'N','O','1997-12-16','1997-12-26','1997-12-17','TAKE BACK RETURN','AIR','final, ironic packa'),(321,1,1,1,21,18921,0.01,0.08,'A','F','1993-07-18','1993-04-24','1993-08-13','TAKE BACK RETURN','REG AIR','final asymptotes haggle '),(321,15,1,2,41,37515.41,0.08,0.07,'R','F','1993-06-21','1993-06-07','1993-07-09','NONE','REG AIR','carefully final account'),(322,16,1,1,12,10992.12,0.08,0.07,'A','F','1992-06-29','1992-05-30','1992-07-11','NONE','AIR','carefully unusual instructions'),(322,5,1,2,48,43440,0.02,0.07,'A','F','1992-06-11','1992-06-16','1992-06-26','COLLECT COD','RAIL','furiously ironi'),(322,2,1,3,20,18040,0.04,0.01,'R','F','1992-04-26','1992-05-04','1992-05-22','DELIVER IN PERSON','MAIL','ironic instructions are sl'),(322,19,1,4,10,9190.1,0.06,0.03,'R','F','1992-04-12','1992-05-13','1992-04-14','DELIVER IN PERSON','AIR','busy theodolites detect fluffily'),(322,2,1,5,35,31570,0.07,0.06,'A','F','1992-07-17','1992-05-03','1992-08-14','TAKE BACK RETURN','RAIL','blithely ironic accounts are a'),(322,4,1,6,3,2712,0.08,0.05,'A','F','1992-07-03','1992-05-10','1992-07-28','NONE','AIR','deposits detect above the slyly fin'),(322,4,1,7,5,4520,0.01,0.02,'A','F','1992-04-15','1992-05-12','1992-04-26','COLLECT COD','REG AIR','ironic, express'),(323,17,1,1,50,45850.5,0.05,0.04,'A','F','1994-04-20','1994-04-25','1994-05-12','DELIVER IN PERSON','REG AIR','bold dependenc'),(323,10,1,2,18,16380.18,0.06,0.07,'R','F','1994-04-13','1994-06-02','1994-05-10','DELIVER IN PERSON','TRUCK','accounts lose slyl'),(323,15,1,3,9,8235.09,0.07,0.04,'A','F','1994-06-26','1994-06-10','1994-07-13','COLLECT COD','TRUCK','ironic, regular acco'),(324,20,1,1,26,23920.52,0.07,0.01,'R','F','1992-04-19','1992-05-28','1992-05-12','DELIVER IN PERSON','RAIL','slyly express packa'),(325,16,1,1,34,31144.34,0.09,0.04,'A','F','1993-10-28','1993-12-13','1993-11-17','TAKE BACK RETURN','MAIL','furiously pending instructions a'),(325,19,1,2,5,4595.05,0.07,0.08,'A','F','1994-01-02','1994-01-05','1994-01-04','TAKE BACK RETURN','MAIL','unusual theodolites nag quickly agai');
24
INSERT INTO `lineitem` VALUES (325,2,1,3,35,31570,0.07,0.07,'A','F','1993-12-06','1994-01-03','1993-12-26','DELIVER IN PERSON','REG AIR','regular de'),(326,18,1,1,41,37638.41,0.06,0.03,'N','O','1995-08-30','1995-07-09','1995-09-12','DELIVER IN PERSON','TRUCK','deposits cajole am'),(326,2,1,2,38,34276,0.02,0.08,'N','O','1995-09-12','1995-08-23','1995-09-14','COLLECT COD','RAIL','furiously final asymptotes boost. quickly '),(326,19,1,3,25,22975.25,0.03,0.04,'N','O','1995-08-03','1995-07-27','1995-08-16','NONE','AIR','quickly even platelets after the '),(326,9,1,4,5,4545,0.03,0.08,'N','O','1995-07-29','1995-07-13','1995-08-12','NONE','REG AIR','furiously ironic packages against the b'),(326,4,1,5,31,28024,0.04,0.08,'N','O','1995-09-27','1995-07-06','1995-10-22','NONE','TRUCK','ruthlessly ironic ins'),(326,16,1,6,41,37556.41,0.02,0,'N','O','1995-07-05','1995-07-23','1995-07-20','TAKE BACK RETURN','REG AIR','silent, express pinto beans'),(326,5,1,7,47,42535,0.04,0.04,'N','O','1995-09-16','1995-07-04','1995-10-04','NONE','REG AIR','carefully even accounts snoo'),(327,15,1,1,16,14640.16,0.03,0.01,'N','O','1995-07-05','1995-06-07','1995-07-09','TAKE BACK RETURN','TRUCK','regular packages are alongside'),(327,5,1,2,9,8145,0.09,0.05,'A','F','1995-05-24','1995-07-11','1995-06-05','NONE','AIR','theodolites play along'),(352,7,1,1,17,15419,0.07,0.05,'R','F','1994-06-02','1994-05-31','1994-06-29','NONE','FOB','fluffily regular theodolites '),(353,12,1,1,41,37392.41,0,0.06,'A','F','1994-03-25','1994-03-31','1994-03-30','DELIVER IN PERSON','AIR','blithely even theodolite'),(353,15,1,2,29,26535.29,0.09,0,'A','F','1994-01-11','1994-03-19','1994-02-09','COLLECT COD','FOB','bold, pending theodolites breach. account'),(353,14,1,3,12,10968.12,0.06,0.01,'R','F','1994-01-02','1994-03-26','1994-01-19','DELIVER IN PERSON','RAIL','carefully express reques'),(353,8,1,4,46,41768,0,0.04,'A','F','1994-04-14','1994-01-31','1994-05-05','DELIVER IN PERSON','FOB','fluffily silent '),(353,12,1,5,9,8208.09,0.02,0.02,'A','F','1994-03-15','1994-03-20','1994-03-18','TAKE BACK RETURN','RAIL','deposits haggle furiously around the caref'),(353,11,1,6,39,35529.39,0.02,0.05,'A','F','1994-01-15','1994-03-30','1994-02-01','NONE','MAIL','furiously pending requests pla'),(354,5,1,1,14,12670,0.08,0.04,'N','O','1996-04-12','1996-06-03','1996-05-08','NONE','SHIP','slyly regular accounts aga'),(354,20,1,2,24,22080.48,0.01,0.01,'N','O','1996-05-08','1996-05-17','1996-06-07','DELIVER IN PERSON','AIR','slyly even dependencies alongside of the'),(354,6,1,3,50,45300,0.08,0.05,'N','O','1996-03-21','1996-05-20','1996-04-04','COLLECT COD','TRUCK','fluffily ironic theodolites wake slyly '),(354,11,1,4,7,6377.07,0.06,0.01,'N','O','1996-05-07','1996-04-18','1996-05-24','NONE','MAIL','blithely ironic notornis wake accordi'),(354,4,1,5,18,16272,0.04,0.08,'N','O','1996-03-31','1996-05-13','1996-04-27','DELIVER IN PERSON','RAIL','quickly thin accounts ha'),(354,7,1,6,36,32652,0.03,0.02,'N','O','1996-03-19','1996-05-29','1996-03-30','NONE','AIR','carefully express requests use'),(354,1,1,7,14,12614,0.01,0.07,'N','O','1996-07-06','1996-06-08','1996-07-10','TAKE BACK RETURN','MAIL','ironic accounts sleep fur'),(355,12,1,1,31,28272.31,0.09,0.07,'A','F','1994-07-13','1994-08-18','1994-07-18','DELIVER IN PERSON','FOB','furiously express deposits h'),(355,10,1,2,41,37310.41,0.05,0,'A','F','1994-08-15','1994-07-19','1994-09-06','DELIVER IN PERSON','TRUCK','slyly bold sautern'),(356,5,1,1,4,3620,0.1,0.01,'A','F','1994-07-28','1994-08-01','1994-08-04','DELIVER IN PERSON','REG AIR','carefully ironic deposits detect r'),(356,11,1,2,48,43728.48,0.02,0.03,'R','F','1994-08-12','1994-07-31','1994-08-26','NONE','FOB','even dependencies'),(356,12,1,3,35,31920.35,0.08,0.07,'R','F','1994-10-14','1994-07-31','1994-10-23','COLLECT COD','TRUCK','express foxes sleep furi'),(356,6,1,4,41,37146,0.07,0.05,'A','F','1994-09-28','1994-09-20','1994-10-07','COLLECT COD','SHIP','blithely ironic theodolites integr');
25
INSERT INTO `lineitem` VALUES (356,13,1,5,37,33781.37,0.05,0.03,'A','F','1994-07-15','1994-08-24','1994-08-09','DELIVER IN PERSON','FOB','requests ca'),(357,12,1,1,26,23712.26,0.06,0.03,'N','O','1996-12-28','1996-11-26','1997-01-13','NONE','FOB','fluffy, even warthogs wake '),(357,19,1,2,36,33084.36,0.07,0.06,'N','O','1996-12-28','1996-11-13','1997-01-24','DELIVER IN PERSON','AIR','always ironic deposi'),(357,17,1,3,32,29344.32,0.05,0.07,'N','O','1997-01-28','1996-12-29','1997-02-14','NONE','MAIL','final deposits after the '),(358,20,1,1,41,37720.82,0.06,0.01,'A','F','1993-11-18','1993-11-14','1993-11-28','NONE','TRUCK','carefully express accounts c'),(358,19,1,2,32,29408.32,0.05,0.08,'A','F','1993-10-18','1993-12-12','1993-10-31','NONE','TRUCK','quickly even instructions wake.'),(358,17,1,3,40,36680.4,0.09,0.01,'A','F','1993-12-05','1993-11-04','1994-01-01','COLLECT COD','MAIL','furiously regul'),(358,10,1,4,15,13650.15,0.08,0.08,'A','F','1993-10-04','1993-12-17','1993-10-23','TAKE BACK RETURN','MAIL','blithely idle requests nag c'),(358,3,1,5,18,16254,0.01,0.02,'R','F','1993-10-07','1993-11-01','1993-10-26','COLLECT COD','SHIP','deposits affix slyly ideas. boldly f'),(358,17,1,6,32,29344.32,0.03,0.05,'R','F','1993-12-21','1993-11-06','1994-01-17','DELIVER IN PERSON','RAIL','fluffily blithe accounts wak'),(358,9,1,7,45,40905,0.05,0.02,'A','F','1993-12-08','1993-10-29','1993-12-30','NONE','REG AIR','silent requests along the even asymp'),(359,17,1,1,30,27510.3,0,0.08,'A','F','1995-01-06','1995-02-20','1995-01-20','TAKE BACK RETURN','AIR','special theodolites cajole. bl'),(359,2,1,2,18,16236,0,0.03,'A','F','1995-01-27','1995-03-18','1995-01-31','DELIVER IN PERSON','RAIL','accounts doubt special foxes. careful'),(359,14,1,3,17,15538.17,0.07,0.06,'A','F','1995-01-31','1995-03-18','1995-02-10','COLLECT COD','SHIP','furiously ironic accounts haggle'),(359,9,1,4,38,34542,0.1,0.08,'R','F','1995-03-30','1995-01-20','1995-04-25','DELIVER IN PERSON','RAIL','enticing somas cajole car'),(359,17,1,5,11,10087.11,0.01,0.03,'A','F','1995-02-15','1995-01-27','1995-02-18','NONE','FOB','slyly regular ideas sleep'),(359,19,1,6,23,21137.23,0.04,0.07,'R','F','1995-01-31','1995-03-11','1995-02-16','DELIVER IN PERSON','REG AIR','idly final theodolites haggle quickly. p'),(384,18,1,1,38,34884.38,0.07,0.01,'R','F','1992-06-02','1992-04-18','1992-06-10','DELIVER IN PERSON','TRUCK','carefully final '),(384,7,1,2,49,44443,0.09,0.07,'A','F','1992-04-01','1992-04-25','1992-04-18','COLLECT COD','AIR','ironic, silent accounts wake furiously '),(384,19,1,3,11,10109.11,0.02,0.08,'A','F','1992-04-02','1992-04-21','1992-04-15','COLLECT COD','MAIL','packages shall sleep fluffily! sly'),(384,10,1,4,11,10010.11,0,0.06,'R','F','1992-06-24','1992-05-29','1992-07-22','COLLECT COD','TRUCK','carefully '),(384,14,1,5,14,12796.14,0.08,0.06,'R','F','1992-06-14','1992-05-29','1992-07-05','DELIVER IN PERSON','TRUCK','bold, pending foxes boost si'),(385,17,1,1,7,6419.07,0.05,0.06,'N','O','1996-05-23','1996-05-09','1996-06-06','DELIVER IN PERSON','REG AIR','pending, regu'),(385,6,1,2,46,41676,0.08,0.07,'N','O','1996-03-29','1996-05-17','1996-04-18','NONE','REG AIR','slow notornis wake slyly quickly fin'),(386,16,1,1,39,35724.39,0.1,0.07,'A','F','1995-05-10','1995-02-28','1995-05-25','NONE','SHIP','unusual, express'),(386,7,1,2,16,14512,0.06,0.01,'A','F','1995-04-12','1995-04-18','1995-05-11','DELIVER IN PERSON','MAIL','fluffily regular packages use slyly'),(386,14,1,3,37,33818.37,0.09,0.04,'A','F','1995-05-23','1995-03-01','1995-05-25','TAKE BACK RETURN','MAIL','carefully regular foxe'),(387,14,1,1,1,914.01,0.08,0.03,'N','O','1997-05-06','1997-04-23','1997-05-10','NONE','SHIP','slyly regular courts are slyly pac'),(387,16,1,2,42,38472.42,0.07,0.05,'N','O','1997-05-25','1997-02-25','1997-05-29','DELIVER IN PERSON','RAIL','regular, blithe theo'),(387,10,1,3,40,36400.4,0.09,0.02,'N','O','1997-03-08','1997-04-18','1997-03-31','COLLECT COD','TRUCK','slyly final reque');
26
INSERT INTO `lineitem` VALUES (387,6,1,4,19,17214,0.08,0,'N','O','1997-03-14','1997-04-21','1997-04-04','NONE','REG AIR','slyly bold deposits kindle carefully'),(387,15,1,5,32,29280.32,0.08,0.06,'N','O','1997-05-02','1997-04-11','1997-05-11','DELIVER IN PERSON','TRUCK','final asymptotes sleep at the silent,'),(388,4,1,1,42,37968,0.05,0.06,'R','F','1993-02-21','1993-02-26','1993-03-15','COLLECT COD','FOB','special accounts are slyly. expres'),(388,13,1,2,46,41998.46,0.07,0.01,'A','F','1993-03-22','1993-01-26','1993-03-24','COLLECT COD','FOB','quickly even requests haggle furiously rut'),(388,7,1,3,40,36280,0.06,0.01,'A','F','1992-12-24','1993-01-28','1993-01-19','TAKE BACK RETURN','REG AIR','quickly regular packages integrate. quickl'),(389,19,1,1,2,1838.02,0.09,0,'R','F','1994-04-13','1994-04-10','1994-04-25','TAKE BACK RETURN','RAIL','ironic requests wak'),(390,11,1,1,10,9110.1,0.02,0.05,'N','O','1998-05-26','1998-07-06','1998-06-23','TAKE BACK RETURN','SHIP','slyly regular dependencies wake aft'),(390,13,1,2,17,15521.17,0.09,0.06,'N','O','1998-06-07','1998-06-14','1998-07-07','COLLECT COD','SHIP','slyly special packages haggle slyly unusual'),(390,19,1,3,46,42274.46,0.07,0.04,'N','O','1998-06-06','1998-05-20','1998-06-14','DELIVER IN PERSON','SHIP','blithely express deposits slee'),(390,15,1,4,42,38430.42,0.01,0.05,'N','O','1998-06-06','1998-06-22','1998-07-05','COLLECT COD','SHIP','express requ'),(390,13,1,5,13,11869.13,0.02,0.06,'N','O','1998-07-08','1998-05-10','1998-07-18','DELIVER IN PERSON','SHIP','special ideas afte'),(390,13,1,6,11,10043.11,0.09,0.06,'N','O','1998-05-05','1998-05-15','1998-06-01','DELIVER IN PERSON','SHIP','blithely silent'),(390,9,1,7,24,21816,0.05,0.02,'N','O','1998-04-18','1998-05-19','1998-04-28','TAKE BACK RETURN','AIR','regular, enticing theodolites r'),(391,13,1,1,14,12782.14,0.09,0.02,'R','F','1995-02-11','1995-02-03','1995-02-13','TAKE BACK RETURN','TRUCK','slyly ironic packages nag f'),(416,10,1,1,25,22750.25,0,0.05,'A','F','1993-10-11','1993-11-26','1993-10-21','DELIVER IN PERSON','TRUCK','furiously bold ideas boost furiou'),(416,12,1,2,22,20064.22,0.1,0,'R','F','1993-12-27','1993-12-17','1994-01-09','COLLECT COD','RAIL','final excuses are above the express asympt'),(416,18,1,3,25,22950.25,0.07,0.01,'R','F','1993-10-16','1993-12-03','1993-10-29','NONE','AIR','furiously bold acc'),(417,4,1,1,39,35256,0.01,0.02,'A','F','1994-05-31','1994-05-02','1994-06-06','NONE','SHIP','special accounts detect f'),(417,7,1,2,18,16326,0,0.01,'R','F','1994-03-29','1994-04-10','1994-04-26','TAKE BACK RETURN','FOB','ironic, unusual pinto beans unwind slyl'),(417,5,1,3,41,37105,0.1,0.01,'R','F','1994-04-11','1994-03-08','1994-05-06','COLLECT COD','RAIL','quick requests cajole ruthlessl'),(417,14,1,4,2,1828.02,0.01,0.03,'R','F','1994-02-13','1994-04-19','1994-03-15','DELIVER IN PERSON','SHIP','carefully regular pin'),(418,2,1,1,31,27962,0,0.03,'N','F','1995-06-05','1995-06-18','1995-06-26','COLLECT COD','FOB','carefully regula'),(418,1,1,2,1,901,0.04,0.07,'N','O','1995-06-23','1995-06-16','1995-07-23','DELIVER IN PERSON','AIR','blithely u'),(418,4,1,3,3,2712,0.04,0.06,'N','O','1995-06-29','1995-07-12','1995-07-01','COLLECT COD','AIR','special instructions wake'),(419,16,1,1,33,30228.33,0.05,0.02,'N','O','1996-11-06','1996-12-25','1996-11-20','TAKE BACK RETURN','TRUCK','final instructions hagg'),(419,7,1,2,32,29024,0.01,0.06,'N','O','1996-12-04','1996-12-04','1996-12-24','COLLECT COD','SHIP','furiously careful deposits nag '),(419,8,1,3,15,13620,0.07,0.04,'N','O','1996-12-17','1996-11-28','1996-12-19','TAKE BACK RETURN','REG AIR','blithely even'),(419,1,1,4,15,13515,0.01,0.02,'N','O','1997-01-09','1996-12-22','1997-01-25','COLLECT COD','FOB','requests above the quickly regular '),(419,15,1,5,17,15555.17,0.01,0,'N','O','1997-01-13','1996-12-20','1997-02-01','COLLECT COD','REG AIR','regular platelet'),(420,11,1,1,5,4555.05,0.04,0.03,'N','O','1995-11-04','1996-01-02','1995-11-30','NONE','REG AIR','furiously regular theodolites haggle sly');
27
INSERT INTO `lineitem` VALUES (420,17,1,2,22,20174.22,0.05,0.04,'N','O','1996-01-25','1995-12-16','1996-02-03','TAKE BACK RETURN','AIR','express pinto beans wake quickly furi'),(420,5,1,3,45,40725,0.09,0.08,'N','O','1996-01-14','1996-01-01','1996-01-26','COLLECT COD','FOB','pinto beans haggle carefully. even platele'),(420,8,1,4,12,10896,0.08,0.08,'N','O','1996-02-05','1996-01-03','1996-02-12','TAKE BACK RETURN','REG AIR','carefully regul'),(420,8,1,5,37,33596,0.02,0,'N','O','1995-11-16','1995-12-13','1995-11-19','DELIVER IN PERSON','SHIP','pending accounts are slyly final '),(420,13,1,6,40,36520.4,0.01,0.05,'N','O','1995-11-26','1995-12-26','1995-12-20','TAKE BACK RETURN','FOB','slyly regular packa'),(420,2,1,7,39,35178,0,0.08,'N','O','1995-12-09','1995-12-16','1995-12-31','DELIVER IN PERSON','REG AIR','slyly even packages affix blithely alo'),(421,14,1,1,1,914.01,0.02,0.07,'R','F','1992-05-29','1992-04-27','1992-06-09','NONE','TRUCK','final, ironic requests int'),(422,16,1,1,25,22900.25,0.1,0.07,'N','O','1997-07-01','1997-08-17','1997-07-09','DELIVER IN PERSON','SHIP','unusual, bold platelets nag fluffily about '),(422,18,1,2,10,9180.1,0.02,0.03,'N','O','1997-06-15','1997-08-04','1997-07-08','TAKE BACK RETURN','AIR','pending depend'),(422,18,1,3,46,42228.46,0.09,0,'N','O','1997-06-21','1997-07-14','1997-06-27','DELIVER IN PERSON','RAIL','slyly silent acc'),(422,17,1,4,25,22925.25,0.1,0.04,'N','O','1997-08-24','1997-07-09','1997-09-22','NONE','FOB','quickly final p'),(423,14,1,1,27,24678.27,0.06,0.03,'N','O','1996-08-20','1996-08-01','1996-08-23','TAKE BACK RETURN','SHIP','even, pending accounts a'),(448,13,1,1,4,3652.04,0,0.04,'N','O','1995-11-25','1995-10-20','1995-11-26','TAKE BACK RETURN','MAIL','even, busy excuses above the furiously si'),(448,18,1,2,46,42228.46,0.05,0,'N','O','1995-08-31','1995-09-30','1995-09-09','COLLECT COD','SHIP','carefully regular re'),(448,3,1,3,35,31605,0.1,0.08,'N','O','1995-09-27','1995-11-19','1995-10-20','COLLECT COD','REG AIR','quickly even package'),(448,17,1,4,8,7336.08,0.1,0,'N','O','1995-11-02','1995-10-16','1995-11-15','COLLECT COD','TRUCK','carefully regula'),(448,14,1,5,23,21022.23,0.02,0.05,'N','O','1995-09-26','1995-11-02','1995-10-17','NONE','SHIP','blithely ironic sentiments after the stea'),(449,16,1,1,12,10992.12,0.02,0.08,'N','O','1995-11-06','1995-08-25','1995-11-18','TAKE BACK RETURN','SHIP','accounts a'),(449,11,1,2,4,3644.04,0.1,0.06,'N','O','1995-10-27','1995-09-14','1995-11-21','DELIVER IN PERSON','FOB','bold frays haggle'),(449,1,1,3,3,2703,0.07,0.08,'N','O','1995-07-28','1995-09-11','1995-08-01','NONE','RAIL','fluffily regular deposits are sly'),(449,16,1,4,22,20152.22,0.07,0,'N','O','1995-08-17','1995-09-04','1995-09-10','COLLECT COD','FOB','sheaves sleep bl'),(450,17,1,1,42,38514.42,0.03,0,'N','F','1995-06-07','1995-05-29','1995-06-23','TAKE BACK RETURN','SHIP','silent sentiments across the '),(450,11,1,2,5,4555.05,0.03,0.02,'A','F','1995-04-02','1995-05-06','1995-04-13','TAKE BACK RETURN','TRUCK','ironic deposits'),(450,15,1,3,32,29280.32,0.06,0.03,'N','O','1995-07-02','1995-04-25','1995-07-30','TAKE BACK RETURN','SHIP','final, express requ'),(450,6,1,4,40,36240,0.05,0.03,'R','F','1995-03-20','1995-05-25','1995-04-14','NONE','RAIL','furiously dogged asymptotes'),(450,8,1,5,2,1816,0.09,0,'A','F','1995-03-11','1995-05-21','1995-03-16','COLLECT COD','AIR','even accounts haggle carefull'),(450,16,1,6,33,30228.33,0.08,0.05,'R','F','1995-05-18','1995-05-22','1995-05-23','TAKE BACK RETURN','REG AIR','fluffily final instructions '),(451,13,1,1,36,32868.36,0.02,0.06,'N','O','1998-06-18','1998-08-14','1998-06-20','TAKE BACK RETURN','AIR','hockey players wake furiou'),(451,4,1,2,42,37968,0.05,0.01,'N','O','1998-08-01','1998-08-05','1998-08-30','DELIVER IN PERSON','TRUCK','fluffily final requests haggle furiously b'),(451,9,1,3,1,909,0.07,0.05,'N','O','1998-07-13','1998-07-03','1998-08-04','DELIVER IN PERSON','AIR','bold foxes integrate? final pinto beans acc');
28
INSERT INTO `lineitem` VALUES (451,8,1,4,28,25424,0.04,0.05,'N','O','1998-06-16','1998-07-09','1998-06-17','DELIVER IN PERSON','SHIP','carefully even theodolites boost. pinto be'),(452,12,1,1,2,1824.02,0.04,0.03,'N','O','1997-12-26','1998-01-03','1998-01-12','COLLECT COD','FOB','blithely even requests integrate fu'),(453,20,1,1,45,41400.9,0.01,0,'N','O','1997-06-30','1997-08-20','1997-07-19','COLLECT COD','REG AIR','fluffily regular accounts detect '),(453,18,1,2,38,34884.38,0.08,0.04,'N','O','1997-06-30','1997-07-08','1997-07-16','DELIVER IN PERSON','REG AIR','boldly regular pinto beans haggle fu'),(453,2,1,3,38,34276,0.1,0.01,'N','O','1997-08-10','1997-07-24','1997-09-07','NONE','SHIP','pinto beans are furiously un'),(453,10,1,4,45,40950.45,0.1,0.01,'N','O','1997-09-18','1997-06-29','1997-10-14','TAKE BACK RETURN','AIR','accounts hang '),(453,3,1,5,32,28896,0.04,0.01,'N','O','1997-07-15','1997-06-27','1997-07-18','NONE','REG AIR','furiously qu'),(453,10,1,6,28,25480.28,0.07,0.07,'N','O','1997-08-16','1997-08-12','1997-08-27','NONE','MAIL','blithely regular accounts slee'),(454,12,1,1,24,21888.24,0.06,0.01,'N','O','1996-04-26','1996-03-23','1996-05-20','NONE','TRUCK','ironic asymptotes detect-- bo'),(455,16,1,1,42,38472.42,0.1,0.02,'N','O','1997-01-26','1997-01-10','1997-02-22','DELIVER IN PERSON','REG AIR','regular, silent platelets '),(455,3,1,2,44,39732,0.05,0.08,'N','O','1997-01-17','1997-02-22','1997-02-12','TAKE BACK RETURN','TRUCK','quickly express instructions'),(455,5,1,3,45,40725,0.04,0.06,'N','O','1996-12-20','1997-01-31','1997-01-07','TAKE BACK RETURN','SHIP','slyly final accounts sleep a'),(455,18,1,4,11,10098.11,0.01,0.02,'N','O','1997-03-15','1997-02-14','1997-03-26','DELIVER IN PERSON','MAIL','slyly ironic foxes above the furiou'),(480,6,1,1,22,19932,0.04,0.02,'A','F','1993-06-16','1993-07-28','1993-07-09','NONE','MAIL','foxes thrash closely according to the '),(481,2,1,1,17,15334,0.07,0.05,'A','F','1992-10-21','1992-12-09','1992-11-19','DELIVER IN PERSON','MAIL','regular theodolites try to boost dari'),(481,3,1,2,19,17157,0.08,0.01,'R','F','1993-01-09','1992-11-27','1993-01-14','TAKE BACK RETURN','AIR','carefully unusual accounts b'),(481,19,1,3,42,38598.42,0.08,0.08,'A','F','1992-11-27','1992-11-11','1992-12-08','COLLECT COD','RAIL','furiously re'),(481,9,1,4,11,9999,0.05,0.06,'A','F','1993-01-12','1992-11-17','1993-02-05','NONE','FOB','foxes are. dogge'),(481,12,1,5,31,28272.31,0.05,0.01,'A','F','1993-01-15','1992-12-31','1993-01-21','DELIVER IN PERSON','AIR','quickly ironic ideas s'),(482,14,1,1,32,29248.32,0,0.02,'N','O','1996-05-22','1996-05-14','1996-05-29','NONE','SHIP','bold instructions use slowly alongside '),(482,13,1,2,1,913.01,0.05,0.08,'N','O','1996-05-29','1996-05-20','1996-05-31','COLLECT COD','AIR','slyly even requests nag quickly around the'),(482,7,1,3,31,28117,0.04,0.03,'N','O','1996-06-01','1996-05-06','1996-06-17','NONE','MAIL','even requests use. co'),(482,20,1,4,8,7360.16,0.02,0.05,'N','O','1996-04-19','1996-05-05','1996-04-21','NONE','TRUCK','regular ac'),(482,4,1,5,46,41584,0.01,0.06,'N','O','1996-07-19','1996-06-05','1996-08-10','NONE','MAIL','carefully regul'),(482,8,1,6,19,17252,0.04,0,'N','O','1996-03-27','1996-04-25','1996-04-15','NONE','FOB','blithely pending accounts against the pe'),(483,4,1,1,8,7232,0,0.08,'N','O','1995-08-22','1995-08-23','1995-09-18','COLLECT COD','RAIL','quickly pending in'),(483,8,1,2,23,20884,0.04,0.06,'N','O','1995-07-20','1995-08-11','1995-08-04','DELIVER IN PERSON','MAIL','quickly regular acc'),(483,9,1,3,9,8181,0.04,0.03,'N','O','1995-09-10','1995-09-02','1995-09-13','NONE','AIR','unusual, final pains nag s'),(484,4,1,1,49,44296,0.1,0.02,'N','O','1997-03-06','1997-02-28','1997-03-23','COLLECT COD','TRUCK','slyly special frays haggle about '),(484,4,1,2,45,40680,0.06,0.07,'N','O','1997-04-09','1997-03-20','1997-04-19','DELIVER IN PERSON','TRUCK','even attainments alongs');
29
INSERT INTO `lineitem` VALUES (484,19,1,3,50,45950.5,0.06,0.05,'N','O','1997-01-24','1997-03-27','1997-02-22','DELIVER IN PERSON','MAIL','express accounts against the carefully '),(484,17,1,4,22,20174.22,0.07,0.03,'N','O','1997-04-29','1997-03-26','1997-05-17','TAKE BACK RETURN','SHIP','blithely ironic re'),(484,8,1,5,48,43584,0,0.05,'N','O','1997-03-05','1997-02-08','1997-03-22','TAKE BACK RETURN','MAIL','furiously regular accou'),(484,10,1,6,10,9100.1,0.01,0.08,'N','O','1997-04-06','1997-02-14','1997-04-16','COLLECT COD','FOB','slyly final'),(485,15,1,1,50,45750.5,0.01,0,'N','O','1997-03-28','1997-05-26','1997-04-18','TAKE BACK RETURN','MAIL','blithely ironic requests '),(485,3,1,2,40,36120,0.08,0.01,'N','O','1997-04-29','1997-05-08','1997-04-30','TAKE BACK RETURN','TRUCK','furiously regular requests wake. expres'),(485,14,1,3,22,20108.22,0,0.05,'N','O','1997-04-06','1997-04-27','1997-05-01','DELIVER IN PERSON','TRUCK','even ideas detect. unusual deposits are '),(486,8,1,1,36,32688,0,0.01,'N','O','1996-06-25','1996-05-06','1996-07-07','COLLECT COD','AIR','slyly express deposits among the daring'),(486,7,1,2,40,36280,0.03,0.08,'N','O','1996-05-21','1996-06-06','1996-06-07','COLLECT COD','SHIP','regular requests across the bli'),(486,14,1,3,26,23764.26,0.04,0.03,'N','O','1996-03-16','1996-05-25','1996-03-31','NONE','RAIL','quick foxes wake. blithely daring requ'),(486,8,1,4,38,34504,0.08,0.05,'N','O','1996-05-07','1996-04-26','1996-05-26','TAKE BACK RETURN','TRUCK','blithely regular packages are slyly. '),(486,3,1,5,3,2709,0.07,0.05,'N','O','1996-07-07','1996-04-20','1996-07-23','DELIVER IN PERSON','RAIL','unusual foxes boost furiou'),(486,5,1,6,46,41630,0,0.03,'N','O','1996-04-18','1996-05-02','1996-04-20','COLLECT COD','AIR','brave accou'),(487,10,1,1,47,42770.47,0.06,0.06,'R','F','1992-09-30','1992-10-08','1992-10-24','NONE','TRUCK','quickly ironic deposits wake quick'),(487,9,1,2,2,1818,0.02,0.06,'R','F','1992-10-19','1992-11-04','1992-11-11','COLLECT COD','TRUCK','slyly final th'),(512,19,1,1,19,17461.19,0.08,0.05,'N','O','1995-07-12','1995-07-11','1995-08-04','COLLECT COD','MAIL','unusual, ironic accounts bo'),(512,3,1,2,37,33411,0.01,0.04,'N','O','1995-06-20','1995-07-05','1995-07-16','NONE','RAIL','regular accounts wake quickly. furious'),(512,18,1,3,40,36720.4,0.05,0.02,'N','O','1995-07-06','1995-07-08','1995-07-08','COLLECT COD','TRUCK','express, ironic t'),(512,9,1,4,10,9090,0.09,0.02,'N','O','1995-09-16','1995-07-29','1995-10-07','NONE','AIR','forges are after the furio'),(512,7,1,5,6,5442,0.03,0.05,'R','F','1995-06-10','1995-06-21','1995-06-16','DELIVER IN PERSON','FOB','furiously unusu'),(512,4,1,6,12,10848,0.04,0,'R','F','1995-05-21','1995-08-03','1995-06-09','COLLECT COD','FOB','blithely regular platelets wake fur'),(512,6,1,7,2,1812,0.09,0.08,'N','O','1995-06-19','1995-08-13','1995-06-24','NONE','TRUCK','regular, reg'),(513,7,1,1,20,18140,0.09,0.07,'N','O','1995-07-12','1995-05-31','1995-07-31','NONE','AIR','ideas doze blithely. foxe'),(513,13,1,2,44,40172.44,0.01,0.01,'N','O','1995-07-14','1995-07-14','1995-08-12','NONE','MAIL','express, even accounts'),(514,8,1,1,21,19068,0.06,0.02,'N','O','1996-06-09','1996-05-15','1996-07-07','DELIVER IN PERSON','RAIL','fluffily special asympt'),(514,12,1,2,34,31008.34,0.08,0.02,'N','O','1996-04-14','1996-06-03','1996-04-23','COLLECT COD','REG AIR','carefully unusual dolphins are slyly at '),(514,2,1,3,6,5412,0.06,0.01,'N','O','1996-05-30','1996-06-04','1996-06-28','COLLECT COD','SHIP','quickly final packages'),(514,12,1,4,43,39216.43,0,0.08,'N','O','1996-06-07','1996-05-14','1996-07-01','TAKE BACK RETURN','FOB','carefully ironic packages n'),(515,11,1,1,10,9110.1,0.03,0.02,'A','F','1993-10-04','1993-11-03','1993-10-08','NONE','FOB','blithely bold requests '),(515,15,1,2,38,34770.38,0.1,0.07,'A','F','1993-09-19','1993-11-12','1993-10-03','DELIVER IN PERSON','SHIP','regular ideas h'),(515,19,1,3,11,10109.11,0,0.02,'R','F','1993-09-04','1993-10-02','1993-09-05','DELIVER IN PERSON','FOB','final patterns eat alo');
30
INSERT INTO `lineitem` VALUES (515,11,1,4,34,30974.34,0.09,0.03,'R','F','1993-10-03','1993-10-26','1993-10-15','DELIVER IN PERSON','REG AIR','slyly ironic requests haggle alongside'),(515,14,1,5,32,29248.32,0.01,0.07,'R','F','1993-10-10','1993-10-08','1993-11-02','TAKE BACK RETURN','FOB','bold foxes are about the final deposits. s'),(515,11,1,6,25,22775.25,0.04,0.08,'R','F','1993-11-14','1993-11-07','1993-12-03','DELIVER IN PERSON','MAIL','carefully bold accoun'),(516,3,1,1,11,9933,0.01,0.06,'N','O','1998-05-02','1998-05-23','1998-05-12','DELIVER IN PERSON','FOB','final deposits boost care'),(517,5,1,1,28,25340,0.03,0.02,'N','O','1997-04-30','1997-05-18','1997-05-17','COLLECT COD','MAIL','furiously ironic deposit'),(517,16,1,2,15,13740.15,0.02,0,'N','O','1997-04-09','1997-06-26','1997-05-01','NONE','TRUCK','blithely quick asymptotes b'),(517,5,1,3,9,8145,0.04,0,'N','O','1997-05-03','1997-06-16','1997-05-24','COLLECT COD','SHIP','fluffily final dependencies shall use '),(517,14,1,4,11,10054.11,0.06,0.02,'N','O','1997-06-20','1997-06-01','1997-06-27','NONE','REG AIR','carefully regular'),(517,3,1,5,23,20769,0,0.01,'N','O','1997-04-19','1997-05-07','1997-05-12','COLLECT COD','RAIL','accounts wake. slyly ironic Tiresias sl'),(518,17,1,1,30,27510.3,0.07,0.05,'N','O','1998-02-18','1998-03-27','1998-03-16','COLLECT COD','TRUCK','final pinto beans affix quickly carefu'),(518,9,1,2,23,20907,0.05,0.07,'N','O','1998-02-20','1998-05-05','1998-03-11','COLLECT COD','TRUCK','bold, slow ideas afte'),(518,14,1,3,12,10968.12,0.01,0.06,'N','O','1998-03-08','1998-03-31','1998-04-06','NONE','AIR','express accounts detect carefully fin'),(518,13,1,4,46,41998.46,0.07,0.02,'N','O','1998-04-07','1998-04-17','1998-04-29','NONE','MAIL','carefully '),(518,8,1,5,16,14528,0.01,0.01,'N','O','1998-03-15','1998-03-24','1998-04-08','NONE','MAIL','slyly final requests use. iron'),(518,20,1,6,39,35880.78,0.09,0.08,'N','O','1998-02-26','1998-03-17','1998-03-21','DELIVER IN PERSON','FOB','furiously ironic deposi'),(518,19,1,7,48,44112.48,0.03,0.07,'N','O','1998-03-06','1998-04-22','1998-03-14','NONE','FOB','deposits hinder along the car'),(519,16,1,1,1,916.01,0.07,0.07,'N','O','1997-12-01','1998-01-26','1997-12-23','COLLECT COD','REG AIR','regular dependencies grow '),(519,1,1,2,38,34238,0.05,0.08,'N','O','1998-02-19','1997-12-15','1998-03-19','DELIVER IN PERSON','FOB','furiously bold deposits maint'),(519,11,1,3,19,17309.19,0,0.02,'N','O','1998-01-09','1998-01-03','1998-02-06','COLLECT COD','AIR','regular ins'),(519,5,1,4,27,24435,0.08,0.06,'N','O','1997-11-20','1997-12-06','1997-12-16','DELIVER IN PERSON','REG AIR','quickly regular accounts cajo'),(519,1,1,5,13,11713,0.06,0.08,'N','O','1998-02-06','1997-12-02','1998-03-03','TAKE BACK RETURN','TRUCK','furiously ironic accounts nag quic'),(519,16,1,6,3,2748.03,0.04,0,'N','O','1998-02-01','1998-01-25','1998-02-27','TAKE BACK RETURN','FOB','ideas use carefully among the c'),(544,14,1,1,47,42958.47,0.08,0.06,'R','F','1993-03-14','1993-03-27','1993-03-27','COLLECT COD','SHIP','carefully iro'),(545,17,1,1,4,3668.04,0.02,0,'N','O','1996-02-23','1995-12-16','1996-03-21','DELIVER IN PERSON','FOB','even pinto beans nag furiously even'),(545,18,1,2,18,16524.18,0,0,'N','O','1996-02-21','1996-01-17','1996-02-26','NONE','RAIL','slyly unusual'),(546,9,1,1,16,14544,0.08,0.02,'N','O','1997-02-04','1996-12-30','1997-02-25','DELIVER IN PERSON','TRUCK','enticing accounts eat doggedly silent, e'),(547,8,1,1,44,39952,0.08,0.08,'N','O','1996-10-18','1996-08-17','1996-10-27','TAKE BACK RETURN','FOB','furiously final patterns across '),(547,14,1,2,48,43872.48,0.01,0.04,'N','O','1996-10-21','1996-08-04','1996-11-20','COLLECT COD','SHIP','platelets thrash blithely fluffily'),(547,19,1,3,3,2757.03,0.05,0.02,'N','O','1996-09-04','1996-08-01','1996-09-21','COLLECT COD','SHIP','slyly enticing theodol'),(548,20,1,1,2,1840.04,0.06,0.05,'A','F','1994-11-26','1994-11-06','1994-12-06','COLLECT COD','MAIL','express, regular ideas print. slyly i');
31
INSERT INTO `lineitem` VALUES (548,1,1,2,6,5406,0,0.08,'A','F','1995-01-18','1994-12-08','1995-02-10','NONE','TRUCK','finally silent depos'),(548,1,1,3,21,18921,0.03,0.08,'A','F','1995-01-13','1994-12-18','1995-01-25','NONE','AIR','regular ideas after the carefully'),(548,6,1,4,21,19026,0.08,0.03,'A','F','1994-10-27','1994-12-04','1994-11-21','DELIVER IN PERSON','AIR','blithely bold pinto beans are quickly even '),(548,10,1,5,19,17290.19,0,0.02,'A','F','1994-09-24','1994-11-24','1994-10-01','DELIVER IN PERSON','MAIL','carefully fina'),(548,16,1,6,32,29312.32,0.06,0.04,'A','F','1994-12-16','1994-11-20','1994-12-29','NONE','REG AIR','carefully pending requests cajo'),(549,20,1,1,18,16560.36,0.07,0.04,'R','F','1992-10-19','1992-08-12','1992-11-13','COLLECT COD','REG AIR','dogged, pending frays haggle. sly'),(549,19,1,2,38,34922.38,0.07,0.05,'A','F','1992-08-17','1992-08-28','1992-09-05','COLLECT COD','RAIL','carefully spec'),(549,7,1,3,36,32652,0.08,0.04,'R','F','1992-09-11','1992-10-11','1992-09-12','DELIVER IN PERSON','AIR','regular, regular accoun'),(549,3,1,4,18,16254,0.09,0.01,'A','F','1992-07-31','1992-09-11','1992-08-08','NONE','RAIL','unusual ideas hinder. blithely bold foxes w'),(549,3,1,5,38,34314,0.06,0.02,'R','F','1992-08-23','1992-08-12','1992-08-25','COLLECT COD','REG AIR','carefully ironi'),(550,20,1,1,31,28520.62,0.04,0.02,'N','O','1995-10-24','1995-09-27','1995-11-04','COLLECT COD','AIR','never ironic courts at the '),(551,3,1,1,8,7224,0.08,0.02,'N','O','1995-07-29','1995-07-18','1995-08-02','NONE','REG AIR','quickly pending requests around '),(551,16,1,2,20,18320.2,0,0.07,'N','O','1995-09-18','1995-08-25','1995-10-11','COLLECT COD','TRUCK','final foxes cajole. unusu'),(551,17,1,3,16,14672.16,0.07,0.06,'N','O','1995-07-29','1995-08-19','1995-08-10','COLLECT COD','MAIL','furiously regular ideas sleep '),(576,9,1,1,2,1818,0.07,0.01,'N','O','1997-05-15','1997-06-30','1997-05-28','NONE','RAIL','blithely express deposits detect blithely'),(576,4,1,2,6,5424,0.06,0.05,'N','O','1997-05-15','1997-07-26','1997-06-03','DELIVER IN PERSON','TRUCK','fluffily regula'),(576,4,1,3,6,5424,0.08,0.07,'N','O','1997-08-28','1997-06-16','1997-09-25','DELIVER IN PERSON','FOB','carefully express instructions outside'),(576,14,1,4,5,4570.05,0.03,0.07,'N','O','1997-06-11','1997-06-17','1997-07-05','NONE','REG AIR','carefully special de'),(577,3,1,1,25,22575,0.06,0.01,'A','F','1995-04-09','1995-02-20','1995-05-09','TAKE BACK RETURN','AIR','final foxes above th'),(577,7,1,2,14,12698,0.08,0.03,'R','F','1995-03-19','1995-02-25','1995-04-09','DELIVER IN PERSON','RAIL','furiously sil'),(578,16,1,1,40,36640.4,0.02,0.08,'N','O','1997-02-10','1997-03-18','1997-02-11','NONE','SHIP','quickly even dependencies haggle'),(578,19,1,2,23,21137.23,0.05,0.08,'N','O','1997-03-06','1997-03-03','1997-03-20','TAKE BACK RETURN','FOB','carefully si'),(579,16,1,1,9,8244.09,0,0.05,'N','O','1998-06-20','1998-04-28','1998-07-19','DELIVER IN PERSON','RAIL','quickly pending accounts co'),(579,4,1,2,39,35256,0.02,0.01,'N','O','1998-06-21','1998-06-03','1998-06-26','COLLECT COD','REG AIR','theodolites nod quickly. blithely expres'),(579,6,1,3,6,5436,0.03,0,'N','O','1998-04-24','1998-05-03','1998-05-08','TAKE BACK RETURN','TRUCK','even foxes lose closely even'),(579,1,1,4,41,36941,0.04,0.05,'N','O','1998-05-28','1998-05-01','1998-06-04','COLLECT COD','REG AIR','unusual, final p'),(579,2,1,5,28,25256,0,0.03,'N','O','1998-07-10','1998-05-24','1998-07-19','NONE','RAIL','final deposits should ha'),(579,17,1,6,5,4585.05,0.05,0.08,'N','O','1998-05-02','1998-04-25','1998-05-05','COLLECT COD','REG AIR','quickly ironic waters eat slyly acro'),(580,9,1,1,33,29997,0.03,0.05,'N','O','1997-10-11','1997-09-19','1997-10-16','TAKE BACK RETURN','FOB','ideas wake sl'),(580,18,1,2,31,28458.31,0.04,0.08,'N','O','1997-10-04','1997-09-08','1997-10-15','COLLECT COD','FOB','deposits wil'),(580,19,1,3,19,17461.19,0.04,0.04,'N','O','1997-07-23','1997-09-21','1997-08-15','NONE','FOB','deposits solve quickly. foxes ');
32
INSERT INTO `lineitem` VALUES (581,7,1,1,41,37187,0.09,0.07,'N','O','1997-05-26','1997-04-06','1997-06-10','TAKE BACK RETURN','MAIL','even, bold excuses about the'),(581,10,1,2,14,12740.14,0.06,0.08,'N','O','1997-05-17','1997-04-14','1997-06-08','NONE','MAIL','furiously silent depths'),(581,11,1,3,49,44639.49,0.1,0.02,'N','O','1997-02-27','1997-04-24','1997-03-10','TAKE BACK RETURN','MAIL','furiously regular theodolites wake qu'),(581,8,1,4,30,27240,0.1,0.08,'N','O','1997-06-19','1997-05-21','1997-06-22','TAKE BACK RETURN','TRUCK','even deposits wa'),(582,6,1,1,7,6342,0.07,0,'N','O','1997-11-16','1997-11-29','1997-12-10','TAKE BACK RETURN','FOB','carefully final requests sleep slyly. even,'),(582,6,1,2,49,44394,0.05,0.03,'N','O','1997-12-17','1998-01-12','1997-12-31','COLLECT COD','REG AIR','carefully regular'),(582,15,1,3,42,38430.42,0.07,0,'N','O','1997-11-15','1997-12-21','1997-12-03','COLLECT COD','SHIP','pending, spe'),(582,17,1,4,36,33012.36,0.06,0.01,'N','O','1997-12-09','1997-11-27','1997-12-26','TAKE BACK RETURN','SHIP','slyly final foxes nag permanen');
33
INSERT INTO `nation` VALUES (0,'ALGERIA',0,'final accounts wake quickly. special reques'),(1,'ARGENTINA',1,'idly final instructions cajole stealthily. regular instructions wake carefully blithely express accounts. fluffi'),(2,'BRAZIL',1,'always pending pinto beans sleep sil'),(3,'CANADA',1,'foxes among the bold requests'),(4,'EGYPT',4,'pending accounts haggle furiously. furiously bold accounts detect. platelets at the packages haggle caref'),(5,'ETHIOPIA',0,'fluffily ruthless requests integrate fluffily. pending ideas wake blithely acco'),(6,'FRANCE',3,'even requests detect near the pendin'),(7,'GERMANY',3,'blithely ironic foxes grow. quickly pending accounts are b'),(8,'INDIA',2,'ironic packages should have to are slyly around the special, ironic accounts. iron'),(9,'INDONESIA',2,'unusual excuses are quickly requests. slyly ironic accounts haggle carefully above the pendin'),(10,'IRAN',4,'blithely even accounts about the furiously regular foxes nag slyly final accounts. quickly final fo'),(11,'IRAQ',4,'express, pending deposits boost quick'),(12,'JAPAN',2,'blithely final packages cajole quickly even dependencies? blithely regular deposits haggle express, ironic re'),(13,'JORDAN',4,'blithe, express deposits boost carefully busy accounts. furiously pending depos'),(14,'KENYA',0,'ironic requests boost. quickly pending pinto beans cajole slyly slyly even deposits. ironic packages '),(15,'MOROCCO',0,'ideas according to the fluffily final pinto beans sleep furiously'),(16,'MOZAMBIQUE',0,'ironic courts wake fluffily even, bold deposi'),(17,'PERU',1,'final, final accounts sleep slyly across the requests. '),(18,'CHINA',2,'bold accounts are. slyly ironic escapades haggle acc'),(19,'ROMANIA',3,'deposits boost against the brave id'),(20,'SAUDI ARABIA',4,'fluffily final accounts wake slyly-- fi'),(21,'VIETNAM',2,'doggedly ironic requests haggle furiously ironic, ironic packages. furiously final courts wake fur'),(22,'RUSSIA',3,'slowly pending patterns x-ray quickly. ironic, even accounts haggle furiously. even, final deposits mold bl'),(23,'UNITED KINGDOM',3,'fluffily regular pinto beans breach according to the ironic dolph'),(24,'UNITED STATES',1,'blithely regular deposits serve furiously blithely regular warthogs! slyly fi');
34
INSERT INTO `orders` VALUES (1,4,'O',125405.67,'1996-01-02','5-LOW','Clerk#000000951',0,'blithely final dolphins solve-- blithely blithe packages nag blith'),(2,8,'O',36349.29,'1996-12-01','1-URGENT','Clerk#000000880',0,'quickly regular depend'),(3,13,'F',150931.2,'1993-10-14','5-LOW','Clerk#000000955',0,'deposits alongside of the dependencies are slowly about '),(4,14,'O',28568.05,'1995-10-11','5-LOW','Clerk#000000124',0,'final requests detect slyly across the blithely bold pinto beans. eve'),(5,5,'F',80601.73,'1994-07-30','5-LOW','Clerk#000000925',0,'even deposits cajole furiously. quickly spe'),(6,7,'F',32046.28,'1992-02-21','4-NOT SPECIFIED','Clerk#000000058',0,'ironically bold asymptotes sleep blithely beyond the regular, clos'),(7,4,'O',152558.13,'1996-01-10','2-HIGH','Clerk#000000470',0,'ironic, regular deposits are. ironic foxes sl'),(32,14,'O',105650.98,'1995-07-16','2-HIGH','Clerk#000000616',0,'slyly final foxes are slyly. packag'),(33,7,'F',94675.63,'1993-10-27','3-MEDIUM','Clerk#000000409',0,'packages maintain about the deposits; foxes hang after '),(34,7,'O',37861.76,'1998-07-21','3-MEDIUM','Clerk#000000223',0,'quickly express asymptotes use. carefully final packages sleep f'),(35,13,'O',136804.25,'1995-10-23','4-NOT SPECIFIED','Clerk#000000259',0,'fluffily regular pinto beans '),(36,13,'O',34857.02,'1995-11-03','1-URGENT','Clerk#000000358',0,'carefully ironic accounts nag'),(37,10,'F',108153.26,'1992-06-03','3-MEDIUM','Clerk#000000456',0,'express requests ar'),(38,13,'O',39552.27,'1996-08-21','4-NOT SPECIFIED','Clerk#000000604',0,'slyly quick pinto beans detect flu'),(39,10,'O',206557,'1996-09-20','3-MEDIUM','Clerk#000000659',0,'furiously unusual pinto beans above the furiously ironic asymptot'),(64,4,'F',18497.24,'1994-07-16','3-MEDIUM','Clerk#000000661',0,'final deposits nag. blithely special deposits a'),(65,2,'P',62932.96,'1995-03-18','1-URGENT','Clerk#000000632',0,'furiously even platelets boost ironic theodolites. even '),(66,13,'F',69196.26,'1994-01-20','5-LOW','Clerk#000000743',0,'ironic requests are quickly about the carefully unusual a'),(67,7,'O',106093.04,'1996-12-19','4-NOT SPECIFIED','Clerk#000000547',0,'regular, bold foxes across the even requests detect a'),(68,4,'O',194670.94,'1998-04-18','3-MEDIUM','Clerk#000000440',0,'stealthy decoys nag; furiously'),(69,10,'F',148183.58,'1994-06-04','4-NOT SPECIFIED','Clerk#000000330',0,'carefully regular theodolites exce'),(70,7,'F',79123.54,'1993-12-18','5-LOW','Clerk#000000322',0,'blithely unusual pack'),(71,1,'O',163564.29,'1998-01-24','4-NOT SPECIFIED','Clerk#000000271',0,'furiously ironic dolphins sleep slyly. carefully special notornis cajole c'),(96,11,'F',48808.1,'1994-04-17','2-HIGH','Clerk#000000395',0,'carefully regular accounts '),(97,4,'F',64391.69,'1993-01-29','3-MEDIUM','Clerk#000000547',0,'carefully even packages believe sly'),(98,11,'F',47837.04,'1994-09-25','1-URGENT','Clerk#000000448',0,'carefully even dinos sleep blithely. regular, bold deposits'),(99,10,'F',82598.81,'1994-03-13','4-NOT SPECIFIED','Clerk#000000973',0,'carefully regular theodolites may believe unu'),(100,14,'O',133163.64,'1998-02-28','4-NOT SPECIFIED','Clerk#000000577',0,'regular deposits sleep closely regular, regular packages. carefully si'),(101,4,'O',84078.35,'1996-03-17','3-MEDIUM','Clerk#000000419',0,'blithely ironic accounts lose slyly about the pending, regular accounts'),(102,1,'O',100788.7,'1997-05-09','2-HIGH','Clerk#000000596',0,'unusual deposits dazzle furiously blithely regular pinto beans. pending foxes'),(103,4,'O',92611.49,'1996-06-20','4-NOT SPECIFIED','Clerk#000000090',0,'carefully ironic deposits are quickly blithely even'),(128,8,'F',32866.68,'1992-06-15','1-URGENT','Clerk#000000385',0,'carefully special e'),(129,8,'F',174311.08,'1992-11-19','5-LOW','Clerk#000000859',0,'slyly bold dolphins cajole c'),(130,4,'F',110726.9,'1992-05-08','2-HIGH','Clerk#000000036',0,'slyly final accounts among'),(131,10,'F',87635.32,'1994-06-08','3-MEDIUM','Clerk#000000625',0,'special courts wake blithely accordin');
35
INSERT INTO `orders` VALUES (132,4,'F',107547.7,'1993-06-11','3-MEDIUM','Clerk#000000488',0,'ironic platelets according to the evenly regula'),(133,5,'O',72019.16,'1997-11-29','1-URGENT','Clerk#000000738',0,'slyly silent deposits haggle carefully fluffi'),(134,1,'F',137153.53,'1992-05-01','4-NOT SPECIFIED','Clerk#000000711',0,'silently even deposits wake about the fluff'),(135,7,'O',155323.55,'1995-10-21','4-NOT SPECIFIED','Clerk#000000804',0,'accounts cajole. final, pending dependencies a'),(160,10,'O',83213.58,'1996-12-19','4-NOT SPECIFIED','Clerk#000000342',0,'unusual dependencie'),(161,2,'F',17307.45,'1994-08-31','2-HIGH','Clerk#000000322',0,'ironic, even attainments cajole closely'),(162,2,'O',1819.26,'1995-05-08','3-MEDIUM','Clerk#000000378',0,'instructions nag slyly. fluffily ironic sau'),(163,10,'O',110620.77,'1997-09-05','3-MEDIUM','Clerk#000000379',0,'carefully express pinto beans serve carefully final as'),(164,1,'F',187343.51,'1992-10-21','5-LOW','Clerk#000000209',0,'fluffily unusual requests al'),(165,4,'F',124874.76,'1993-01-30','4-NOT SPECIFIED','Clerk#000000292',0,'furiously enticing accounts cajole sometimes. slyly express plat'),(166,11,'O',85600.68,'1995-09-12','2-HIGH','Clerk#000000440',0,'bold dependencies wake furiously regula'),(167,13,'F',46773.05,'1993-01-04','4-NOT SPECIFIED','Clerk#000000731',0,'express warhorses wake carefully furiously ironic deposits. c'),(192,10,'O',118667.63,'1997-11-25','5-LOW','Clerk#000000483',0,'silent requests above the furiously even pinto beans sleep bl'),(193,8,'F',43226.64,'1993-08-08','1-URGENT','Clerk#000000025',0,'slyly blithe instructions cajole carefully ironic, fina'),(194,7,'F',102564.72,'1992-04-05','3-MEDIUM','Clerk#000000352',0,'carefully dogged excuses use abou'),(195,14,'F',110408.94,'1993-12-28','3-MEDIUM','Clerk#000000216',0,'ironic, final notornis are fluffily across the carefull'),(196,7,'F',30816.03,'1993-03-17','2-HIGH','Clerk#000000988',0,'even deposits wake '),(197,4,'P',92318.21,'1995-04-07','2-HIGH','Clerk#000000969',0,'theodolites above the furiously regular deposits sleep blithely abo'),(198,13,'O',118681.66,'1998-01-02','4-NOT SPECIFIED','Clerk#000000331',0,'deposits haggle carefully after the furiously fi'),(199,7,'O',71274.49,'1996-03-07','2-HIGH','Clerk#000000489',0,'unusual, regular requests c'),(224,1,'F',137660.12,'1994-06-18','4-NOT SPECIFIED','Clerk#000000642',0,'quickly final accounts use even requests. ironic ac'),(225,4,'P',146919.84,'1995-05-25','1-URGENT','Clerk#000000177',0,'blithely express cou'),(226,13,'F',166707.37,'1993-03-10','2-HIGH','Clerk#000000756',0,'even, ironic theodolites detect fluffily final instructions-- fi'),(227,1,'O',39469.42,'1995-11-10','5-LOW','Clerk#000000919',0,'asymptotes are special, special requests. spec'),(228,5,'F',2627.31,'1993-02-25','1-URGENT','Clerk#000000562',0,'blithely ironic requests boost pending theodolites. even deposits affix fluf'),(229,13,'F',127746.71,'1993-12-29','1-URGENT','Clerk#000000628',0,'blithely thin requests along the fluffily regular packages e'),(230,11,'F',98355.79,'1993-10-27','1-URGENT','Clerk#000000520',0,'ironic, silent tithes wake carefully until the even theodolites. special'),(231,10,'F',125979.42,'1994-09-29','2-HIGH','Clerk#000000446',0,'express requests use always at the unusual deposits. silently final acc'),(256,13,'F',95207.65,'1993-10-19','4-NOT SPECIFIED','Clerk#000000834',0,'special dependencies boost furiously. pendin'),(257,13,'O',6206.5,'1998-03-28','3-MEDIUM','Clerk#000000680',0,'final, regular packages nag furiously fluffily f'),(258,5,'F',163851.98,'1993-12-29','1-URGENT','Clerk#000000167',0,'regularly ironic grouches against the quickly express p'),(259,5,'F',69835.36,'1993-09-29','4-NOT SPECIFIED','Clerk#000000601',0,'ironic packages haggle among the furiously brave deposits. final, final d'),(260,11,'O',162676.92,'1996-12-10','3-MEDIUM','Clerk#000000960',0,'quickly special ideas against the furiously final accounts affix deposits. sl');
36
INSERT INTO `orders` VALUES (261,5,'F',185715.35,'1993-06-29','3-MEDIUM','Clerk#000000310',0,'final accounts nag fluffily about'),(262,4,'O',97886.84,'1995-11-25','4-NOT SPECIFIED','Clerk#000000551',0,'express, regular theodolites wake special instructions. slyly express '),(263,13,'F',72420.16,'1994-05-17','2-HIGH','Clerk#000000088',0,'fluffily final ideas use quickly slyly final foxes? fluffily express dolphi'),(288,1,'O',148620.32,'1997-02-21','1-URGENT','Clerk#000000109',0,'quickly ruthless instructions cajole '),(289,11,'O',123689.42,'1997-02-10','3-MEDIUM','Clerk#000000103',0,'slyly express excuses d'),(290,13,'F',59781.67,'1994-01-01','4-NOT SPECIFIED','Clerk#000000735',0,'pending instructions against the furiously express d'),(291,14,'F',60764.75,'1994-03-13','1-URGENT','Clerk#000000923',0,'express requests according to the carefully regular deposits run'),(292,4,'F',27689.86,'1992-01-13','2-HIGH','Clerk#000000193',0,'furiously special theodolites wake blith'),(293,4,'F',34051.42,'1992-10-02','2-HIGH','Clerk#000000629',0,'regular instructions grow bold, u'),(294,7,'F',28366.86,'1993-07-16','3-MEDIUM','Clerk#000000499',0,'idly ironic deposits must have to haggle deposits. blithel'),(295,2,'F',80394.24,'1994-09-29','2-HIGH','Clerk#000000155',0,'doggedly final requests nag carefull'),(320,1,'O',37536.73,'1997-11-21','2-HIGH','Clerk#000000573',0,'carefully silent ideas do solve final, express instructions. quickly final p'),(321,13,'F',57160.49,'1993-03-21','3-MEDIUM','Clerk#000000289',0,'quickly silent requests affix sl'),(322,14,'F',121067.03,'1992-03-19','1-URGENT','Clerk#000000158',0,'carefully unusual pinto beans lose carefully. even instructions ac'),(323,4,'F',69740.42,'1994-03-26','1-URGENT','Clerk#000000959',0,'even, regular instructions'),(324,11,'F',22468.54,'1992-03-20','1-URGENT','Clerk#000000352',0,'regular theodolites boost quickly along the ironic, quick realms.'),(325,5,'F',65505.55,'1993-10-17','5-LOW','Clerk#000000844',0,'carefully fluffy forges about the express, ir'),(326,8,'O',208985.47,'1995-06-04','2-HIGH','Clerk#000000466',0,'regular theodolites was car'),(327,14,'P',22125.49,'1995-04-17','5-LOW','Clerk#000000992',0,'fluffily ironic deposits across the ironically regular ideas are '),(352,11,'F',15056.65,'1994-03-08','2-HIGH','Clerk#000000932',0,'regular, regular pinto beans haggle sly'),(353,1,'F',162399.44,'1993-12-31','5-LOW','Clerk#000000449',0,'even ideas haggle excuses? slyly ironic packages wake alongside of the qu'),(354,14,'O',146553.78,'1996-03-14','2-HIGH','Clerk#000000511',0,'quickly special packages inside the slyly unusual pain'),(355,8,'F',62973.62,'1994-06-14','5-LOW','Clerk#000000532',0,'carefully even instructio'),(356,14,'F',148180.61,'1994-06-30','4-NOT SPECIFIED','Clerk#000000944',0,'fluffily pending theo'),(357,7,'O',85401.24,'1996-10-09','2-HIGH','Clerk#000000301',0,'carefully bold theodolites cajole f'),(358,1,'F',199198.2,'1993-09-20','2-HIGH','Clerk#000000392',0,'deposits sublate carefully at t'),(359,8,'F',127324.5,'1994-12-19','3-MEDIUM','Clerk#000000934',0,'furiously final foxes are. regular,'),(384,13,'F',109829.99,'1992-03-03','5-LOW','Clerk#000000206',0,'regular packages haggle furiously; idle requests wake carefu'),(385,4,'O',47489.84,'1996-03-22','5-LOW','Clerk#000000600',0,'asymptotes wake silent, silent'),(386,7,'F',80185.96,'1995-01-25','2-HIGH','Clerk#000000648',0,'quickly pending instructions unwind furiously theodolites. final package'),(387,1,'O',116612.29,'1997-01-26','4-NOT SPECIFIED','Clerk#000000768',0,'blithely even accounts according to the even packag'),(388,5,'F',112127.14,'1992-12-16','4-NOT SPECIFIED','Clerk#000000356',0,'accounts wake against the braids. silent accounts snooze slyly blithely ironi'),(389,13,'F',1672.59,'1994-02-17','2-HIGH','Clerk#000000062',0,'pending, bold packages boost blithely final package'),(390,11,'O',148339.16,'1998-04-07','5-LOW','Clerk#000000404',0,'blithely even pinto beans against the ironic packages boost qu');
37
INSERT INTO `orders` VALUES (391,13,'F',11864.37,'1994-11-17','2-HIGH','Clerk#000000256',0,'furiously special deposits wake blithely. qu'),(416,5,'F',63502.71,'1993-09-27','5-LOW','Clerk#000000294',0,'excuses boost permanently around the carefully pe'),(417,7,'F',87683.22,'1994-02-06','3-MEDIUM','Clerk#000000468',0,'pending, regular pinto beans after the final, express accounts boost'),(418,10,'P',32486.09,'1995-04-13','4-NOT SPECIFIED','Clerk#000000643',0,'quiet, bold ideas a'),(419,13,'O',101969.33,'1996-10-01','3-MEDIUM','Clerk#000000376',0,'accounts sleep quickly slyly bo'),(420,10,'O',184166.19,'1995-10-31','4-NOT SPECIFIED','Clerk#000000756',0,'slyly final deposits sublate after the quickly pending deposits'),(421,4,'F',958.42,'1992-02-22','5-LOW','Clerk#000000405',0,'ironic, even account'),(422,8,'O',91205.22,'1997-05-31','4-NOT SPECIFIED','Clerk#000000049',0,'carefully even packages use'),(423,11,'O',23893.49,'1996-06-01','1-URGENT','Clerk#000000674',0,'blithely unusual dugouts play quickly along the blithely regular theo'),(448,14,'O',102869.54,'1995-08-21','3-MEDIUM','Clerk#000000597',0,'furiously even requests nag carefully. '),(449,10,'O',36566.9,'1995-07-20','2-HIGH','Clerk#000000841',0,'final, express requests sleep permanent requests. spe'),(450,5,'P',136528.89,'1995-03-05','4-NOT SPECIFIED','Clerk#000000293',0,'deposits wake regular, ironic instructions. bli'),(451,10,'O',97088.95,'1998-05-25','5-LOW','Clerk#000000048',0,'final foxes nag. regul'),(452,7,'O',1803.58,'1997-10-14','1-URGENT','Clerk#000000498',0,'theodolites should n'),(453,5,'O',196118.06,'1997-05-26','5-LOW','Clerk#000000504',0,'furiously even deposits use inside the excuses.'),(454,5,'O',20780.68,'1995-12-27','5-LOW','Clerk#000000890',0,'fluffily final accounts after the special, ironic pinto '),(455,2,'O',127721.52,'1996-12-04','1-URGENT','Clerk#000000796',0,'even instructions hagg'),(480,8,'F',19517.41,'1993-05-08','5-LOW','Clerk#000000004',0,'final accounts poach carefully. quickly final platelets boost quickly even ide'),(481,4,'F',106463.57,'1992-10-08','2-HIGH','Clerk#000000230',0,'ruthlessly ironic packages nag furiously across the slyly regula'),(482,13,'O',126345.84,'1996-03-26','1-URGENT','Clerk#000000295',0,'blithely regular as'),(483,4,'O',37151.48,'1995-07-11','2-HIGH','Clerk#000000025',0,'bold theodolites sl'),(484,7,'O',201750.69,'1997-01-03','3-MEDIUM','Clerk#000000545',0,'fluffily even deposits run foxes; regular packages afte'),(485,11,'O',99969.32,'1997-03-26','2-HIGH','Clerk#000000105',0,'regular, bold asymptotes sleep boldly. carefu'),(486,7,'O',173374.98,'1996-03-11','4-NOT SPECIFIED','Clerk#000000803',0,'quickly final foxes across the expre'),(487,11,'F',44505.02,'1992-08-18','1-URGENT','Clerk#000000086',0,'ironic, express pinto be'),(512,7,'P',113024.43,'1995-05-20','5-LOW','Clerk#000000814',0,'quickly unusual foxes was fluffily slyly even accounts. pac'),(513,7,'O',57831.32,'1995-05-01','2-HIGH','Clerk#000000522',0,'always final sentiments haggle furiously around the fluffily ruthles'),(514,8,'O',94872.5,'1996-04-04','2-HIGH','Clerk#000000094',0,'enticingly quick escapades wake slyly. final acc'),(515,14,'F',136437.01,'1993-08-29','4-NOT SPECIFIED','Clerk#000000700',0,'slyly unusual ideas subla'),(516,5,'O',10423.69,'1998-04-21','2-HIGH','Clerk#000000305',0,'quickly final foxes accord'),(517,1,'O',76972.49,'1997-04-07','5-LOW','Clerk#000000359',0,'deposits wake always slyly regular requests. blithely '),(518,14,'O',195039.9,'1998-02-08','2-HIGH','Clerk#000000768',0,'slyly even ideas hang quickly. carefully final instructi'),(519,7,'O',92053.2,'1997-10-31','1-URGENT','Clerk#000000985',0,'quick depths are! slyly express requests along the carefully ironic '),(544,10,'F',41893.09,'1993-02-17','2-HIGH','Clerk#000000145',0,'slyly ironic attainments sleep blith'),(545,7,'O',20118.85,'1995-11-07','2-HIGH','Clerk#000000537',0,'even, regular packa'),(546,14,'O',13648.08,'1996-11-01','2-HIGH','Clerk#000000041',0,'final notornis detect slyly fluffily express deposits. brav');
38
INSERT INTO `orders` VALUES (547,10,'O',87538.95,'1996-06-22','3-MEDIUM','Clerk#000000976',0,'bold instructions print fluffily carefully id'),(548,13,'F',91796.96,'1994-09-21','1-URGENT','Clerk#000000435',0,'quickly regular accounts daz'),(549,11,'F',129199.61,'1992-07-13','1-URGENT','Clerk#000000196',0,'carefully regular foxes integrate ironic, fina'),(550,4,'O',27927.38,'1995-08-02','1-URGENT','Clerk#000000204',0,'carefully even asymptotes sleep furiously sp'),(551,10,'O',40845.41,'1995-05-30','1-URGENT','Clerk#000000179',0,'unusual, final accounts use above the special excuses. final depo'),(576,4,'O',17143.74,'1997-05-13','3-MEDIUM','Clerk#000000955',0,'pending theodolites about the carefu'),(577,7,'F',33465.32,'1994-12-19','5-LOW','Clerk#000000154',0,'blithely unusual packages sl'),(578,10,'O',60466.97,'1997-01-10','5-LOW','Clerk#000000281',0,'blithely pending asymptotes wake quickly across the carefully final'),(579,7,'O',116780.04,'1998-03-11','2-HIGH','Clerk#000000862',0,'slyly even requests cajole slyly. sil'),(580,7,'O',77490.74,'1997-07-05','2-HIGH','Clerk#000000314',0,'final ideas must have to are carefully quickly furious requests'),(581,7,'O',116599.09,'1997-02-23','4-NOT SPECIFIED','Clerk#000000239',0,'carefully regular dolphins cajole ruthlessl'),(582,5,'O',116419.79,'1997-10-21','1-URGENT','Clerk#000000378',0,'quietly ironic pinto beans wake carefully. ironic accounts across the dol');
39
INSERT INTO `part` VALUES (1,'goldenrod lace spring peru powder','Manufacturer#1','Brand#13','PROMO BURNISHED COPPER',7,'JUMBO PKG',901,'final deposits s'),(2,'blush rosy metallic lemon navajo','Manufacturer#1','Brand#13','LARGE BRUSHED BRASS',1,'LG CASE',902,'final platelets hang f'),(3,'dark green antique puff wheat','Manufacturer#4','Brand#42','STANDARD POLISHED BRASS',21,'WRAP CASE',903,'unusual excuses ac'),(4,'chocolate metallic smoke ghost drab','Manufacturer#3','Brand#34','SMALL PLATED BRASS',14,'MED DRUM',904,'ironi'),(5,'forest blush chiffon thistle chocolate','Manufacturer#3','Brand#32','STANDARD POLISHED TIN',15,'SM PKG',905,'pending, spe'),(6,'white ivory azure firebrick black','Manufacturer#2','Brand#24','PROMO PLATED STEEL',4,'MED BAG',906,'pending pinto be'),(7,'blue blanched tan indian olive','Manufacturer#1','Brand#11','SMALL PLATED COPPER',45,'SM BAG',907,'blithely ironic'),(8,'ivory khaki cream midnight rosy','Manufacturer#4','Brand#44','PROMO BURNISHED TIN',41,'LG DRUM',908,'furiously eve'),(9,'thistle rose moccasin light floral','Manufacturer#4','Brand#43','SMALL BURNISHED STEEL',12,'WRAP CASE',909,'thinly even request'),(10,'floral moccasin royal powder burnished','Manufacturer#5','Brand#54','LARGE BURNISHED STEEL',44,'LG CAN',910.01,'bold, ironic '),(11,'chocolate turquoise sandy snow misty','Manufacturer#2','Brand#25','STANDARD BURNISHED NICKEL',43,'WRAP BOX',911.01,'furiousl'),(12,'peru ivory olive powder frosted','Manufacturer#3','Brand#33','MEDIUM ANODIZED STEEL',25,'JUMBO CASE',912.01,'quietly even foxes '),(13,'ghost blue olive sky gainsboro','Manufacturer#5','Brand#55','MEDIUM BURNISHED NICKEL',1,'JUMBO PACK',913.01,'platelets poach blith'),(14,'linen seashell burnished blue gainsboro','Manufacturer#1','Brand#13','SMALL POLISHED STEEL',28,'JUMBO BOX',914.01,'special, regular'),(15,'navajo dark sky turquoise royal','Manufacturer#1','Brand#15','LARGE ANODIZED BRASS',45,'LG CASE',915.01,'carefully fi'),(16,'deep brown turquoise dim papaya','Manufacturer#3','Brand#32','PROMO PLATED TIN',2,'MED PACK',916.01,'slyly final de'),(17,'burnished navy orange dodger cream','Manufacturer#4','Brand#43','ECONOMY BRUSHED STEEL',16,'LG BOX',917.01,'slyly regular do'),(18,'spring indian forest khaki midnight','Manufacturer#1','Brand#11','SMALL BURNISHED STEEL',42,'JUMBO PACK',918.01,'ironic, iro'),(19,'dodger forest floral cream black','Manufacturer#2','Brand#23','SMALL ANODIZED NICKEL',33,'WRAP BOX',919.01,'blithely pe'),(20,'bisque salmon dark blanched linen','Manufacturer#1','Brand#12','LARGE POLISHED NICKEL',48,'MED BAG',920.02,'slyly ironi');
40
INSERT INTO `partsupp` VALUES (1,1,3325,771.64,'requests after the carefully ironic ideas cajole alongside of the enticingly special accounts. fluffily regular deposits haggle about the blithely ironic deposits. regular requests sleep c'),(2,1,8895,378.49,'furiously even asymptotes are furiously regular plate'),(3,1,4651,920.92,'ironic, pending theodolites sleep slyly at the slyly final foxes. slyly ironic accounts sleep express accounts. quickly fina'),(4,1,1339,113.97,'furiously even accounts sleep. slyly regular deposits hag'),(5,1,3735,255.88,'even, ironic requests snooze blithely throughout the carefully pending deposits. busy deposits mold blithely after the furiously final pinto beans. regular, unus'),(6,1,8851,130.72,'carefully regular asymptotes wake slyly according to the quickly re'),(7,1,7454,763.98,'carefully even ideas should wake. blithely final instructions are special foxes. pending, ironic requests wake blithely about the furiously regular foxes. ironic idea'),(8,1,6834,249.63,'furiously unusual instructions use quickly. unusual deposits among the regular deposits doze unusual epitaph'),(9,1,7054,84.2,'final ideas through the requests boost quickly about the furiously regular accounts. blithely silent foxes affix carefully ironic instructions. blithely bold foxe'),(10,1,2952,996.12,'blithely even foxes nag furiously about the quickly ex'),(11,1,4540,709.87,'final packages mold after the carefully unusual requests. quickly fi'),(12,1,3610,659.73,'unusual dolphins sleep slyly. ironic deposits use fluffily. carefully unusual platelets poach slyly. evenly pending deposits nag ironi'),(13,1,612,169.44,'blithely special theodolites serve quickly. regular deposits are alongside of the fluffily sl'),(14,1,5278,650.07,'quickly even deposits doze quickly pending, bold deposits. carefully regular packages sublate carefully'),(15,1,7047,835.7,'packages haggle across the carefully express ideas. slyly bold instructions promise even, express packages. furiously ironic acc'),(16,1,5282,709.16,'final, final orbits hang slyly. blithely pending dolphins haggle. deposit'),(17,1,8555,995.35,'final deposits among the quickly unusual deposits detect unusual, final dependencies. theodolites cajole blithely. final, express depths wake blithely. slyly regular requests sleep. carefully regu'),(18,1,1125,664.17,'furiously final packages wake furiously according to the furiously even packages. fluffily even deposits unwind carefully. instructions sleep furiously; '),(19,1,1416,144.8,'silent packages impress fluffily slyly even theodolites. ironic deposits nag carefully excuses. express deposits wake slyly. '),(20,1,2927,675.54,'slyly ironic deposits nag across the carefully regular somas. regular, even foxes cajole blithely ironic accounts. dolphins cajole carefully after the blithely express foxes. unusual ');
41
INSERT INTO `region` VALUES (0,'AFRICA','special Tiresias about the furiously even dolphins are furi'),(1,'AMERICA','even, ironic theodolites according to the bold platelets wa'),(2,'ASIA','silent, bold requests sleep slyly across the quickly sly dependencies. furiously silent instructions alongside '),(3,'EUROPE','special, bold deposits haggle foxes. platelet'),(4,'MIDDLE EAST','furiously unusual packages use carefully above the unusual, exp');
42
INSERT INTO `supplier` VALUES (1,'Supplier#000000001',' N kD4on9OM Ipw3,gf0JBoQDd7tgrzrddZ',17,'27-918-335-1736',5755.94,'requests haggle carefully. accounts sublate finally. carefully ironic pa');
added
removed
tests/kewpie/randgen/conf/dbt3/dbt3-s0.0001.dump
