DROP DATABASE IF EXISTS Text;
CREATE DATABASE Text COLLATE latin1_general_cs;
USE Text;
/* Chapter 3 */
/* share -- SHARE is a reserved word and some systems might report an error */
/* see alternative code for shr */
/* Changed book and slides to share with 6th edition */
create table share
(shrcode char(3) not null,
shrfirm varchar(20),
shrprice decimal(6,2),
shrqty decimal(8),
shrdiv decimal(5,2),
shrpe decimal(2),
constraint pk_share primary key (shrcode));
/* share -- SHARE is a reserved word and some systems might report an error */
/* shr is an alternative */
create table shr
(shrcode char(3) not null,
shrfirm varchar(20),
shrprice decimal(6,2),
shrqty decimal(8),
shrdiv decimal(5,2),
shrpe decimal(2),
constraint pk_shr primary key (shrcode));
/* alien */
create table alien
(alnum integer not null,
alname varchar(20),
alheads integer,
alcolor varchar(15),
alsmell varchar(15),
constraint pk_alien primary key (alnum));
/* Chapter 4 */
/* nation */
create table nation
(natcode char(3) not null,
natname varchar(20),
exchrate decimal(9,5),
constraint pk_nation primary key (natcode));
/* stock */
create table stock
(stkcode char(3) not null,
stkfirm varchar(20),
stkprice decimal(6,2),
stkqty decimal(8),
stkdiv decimal(5,2),
stkpe decimal(5),
natcode char(3),
constraint pk_stock primary key (stkcode),
constraint fk_has_nation foreign key (natcode) references nation(natcode));
create table person
(personid integer not null,
persfname varchar(25),
perslname varchar(25),
constraint pk_person primary key (personid));
create table car
(carid integer not null,
carcost decimal(7,2),
carsell decimal(7,2),
cartype varchar(10),
personid integer,
constraint pk_car primary key (carid),
constraint fk_soldby foreign key (personid) references person(personid));
/* sale */
create table sale
(saleno integer not null,
saledate date,
saletext varchar(50),
constraint pk_sale primary key (saleno));
/* Chapter 5 */
/* item */
create table item
(itemno integer not null,
itemname varchar(30),
itemtype char(1),
itemcolor varchar(10),
constraint pk_item primary key (itemno));
/* lineitem */
create table lineitem
(lineno integer not null,
lineqty integer,
lineprice decimal(7,2),
saleno integer not null,
itemno integer not null,
constraint pk_lineitem primary key (lineno,saleno),
constraint fk_has_sale foreign key (saleno) references sale (saleno),
constraint fk_has_item foreign key (itemno) references item (itemno));
create table donor
(donorno integer not null,
dlname varchar(15),
dfname varchar(15),
dphone decimal(4),
dstate char(2),
dcity varchar(15),
constraint pk_donor primary key (donorno));
create table year
(year integer not null,
yeargoal decimal(9),
constraint pk_year primary key (year));
create table gift
(amount decimal(8) not null,
year integer not null,
donorno integer not null,
constraint pk_gift primary key (year,donorno),
constraint fk_donatedin foreign key (year) references year(year),
constraint fk_donatedby foreign key (donorno) references donor(donorno));
/* Chapter 6 */
/* dept */
create table dept 
(deptname varchar(15) not null,
deptfloor smallint not null,
deptphone smallint not null,
empno smallint not null,
constraint pk_dept primary key(deptname)) engine=innodb;
/* emp */
create table emp
(empno integer not null,
empfname varchar(10),
empsalary decimal(7,0),
deptname varchar(15),
bossno integer,
constraint pk_emp primary key(empno),
constraint fk_belong_dept foreign key (deptname) references dept(deptname),
constraint fk_has_boss foreign key (bossno) references emp(empno))  engine=innodb;
/* monarch */
create table monarch (
	montype				varchar(5)			not null,
	monname				varchar(15),
	monnum				varchar(5),
	rgnbeg				date,
	premonname				varchar(15),
	premonnum				varchar(5),
			primary key(monname,monnum),
CONSTRAINT fk_monarch FOREIGN KEY (premonname, premonnum) 
		REFERENCES monarch (monname, monnum))		
			engine=innodb;
/* product */
create table product
(prodid integer not null,
proddesc varchar(30),
prodcost decimal(9,2),
prodprice decimal(9,2),
constraint pk_product primary key(prodid));
/* assembly */
create table assembly
(quantity integer not null,
prodid integer not null,
subprodid integer not null,
constraint pk_assembly primary key(prodid, subprodid),
CONSTRAINT fk_assembly_product FOREIGN KEY(prodid)
			 REFERENCES product(prodid),
CONSTRAINT fk_assembly_subproduct FOREIGN KEY(subprodid)
			 REFERENCES product(prodid));
/* Reference 2 */
create table qitem
(itemname varchar(30) not null,
itemtype char(1),
itemcolor varchar(10),
constraint pk_qitem primary key (itemname));
create table qemp
(empno integer not null,
empfname varchar(15),
empsalary decimal(6),
deptname varchar(15),
bossno integer,
constraint pk_qemp primary key (empno));
create table qdept
(deptname varchar(15) not null,
deptfloor integer,
deptphone integer,
empno integer not null,
constraint pk_qdept primary key (deptname),
constraint fk_hasboss foreign key (empno) references qemp (empno));
create table qsale
(saleno integer not null,
saleqty integer,
itemname varchar(30) not null,
deptname varchar(15) not null,
constraint pk_saleno primary key (saleno),
constraint fk_isitem foreign key (itemname) references qitem (itemname),
constraint fk_bydept foreign key (deptname) references qdept (deptname));
create table qspl
(splno integer not null,
splname varchar(25),
constraint pk_qspl primary key (splno));
create table qdel
(delno integer not null,
delqty integer not null,
itemname varchar(30) not null,
deptname varchar(15) not null,
splno integer not null,
constraint pk_qdel primary key (delno),
constraint fk_delitem foreign key (itemname) references qitem (itemname),
constraint fk_hasdept foreign key (deptname) references qdept (deptname),
constraint fk_hasspl foreign key (splno) references qspl (splno));
/* Chapter 15 */
create table exped
(transid	integer,
salesdate date,
location varchar(10),
item varchar(30),
channel varchar(10),
quantity integer,
revenue decimal(9,2),
primary key(transid));
insert into share values ('FC','Freedonia Copper',27.5,10529,1.84,16);
insert into share values ('PT','Patagonian Tea',55.25,12635,2.5,10);
insert into share values ('AR','Abyssinian Ruby',31.82,22010,1.32,13);
insert into share values ('SLG','Sri Lankan Gold',50.37,32868,2.68,16);
insert into share values ('ILZ','Indian Lead & Zinc',37.75,6390,3,12);
insert into share values ('BE','Burmese Elephant',0.07,154713,0.01,3);
insert into share values ('BS','Bolivian Sheep',12.75,231678,1.78,11);
insert into share values ('NG','Nigerian Geese',35,12323,1.68,10);
insert into share values ('CS','Canadian Sugar',52.78,4716,2.5,15);
insert into share values ('ROF','Royal Ostrich Farms',33.75,1234923,3,6);
insert into shr values ('FC','Freedonia Copper',27.5,10529,1.84,16);
insert into shr values ('PT','Patagonian Tea',55.25,12635,2.5,10);
insert into shr values ('AR','Abyssinian Ruby',31.82,22010,1.32,13);
insert into shr values ('SLG','Sri Lankan Gold',50.37,32868,2.68,16);
insert into shr values ('ILZ','Indian Lead & Zinc',37.75,6390,3,12);
insert into shr values ('BE','Burmese Elephant',0.07,154713,0.01,3);
insert into shr values ('BS','Bolivian Sheep',12.75,231678,1.78,11);
insert into shr values ('NG','Nigerian Geese',35,12323,1.68,10);
insert into shr values ('CS','Canadian Sugar',52.78,4716,2.5,15);
insert into shr values ('ROF','Royal Ostrich Farms',33.75,1234923,3,6);
insert into alien values (1,'Foozelgiga',1,'vermillion','ambrosial');
insert into alien values (2,'Koofoopsiepus',3,'amethyst','putrid');
insert into alien values (3,'Bunyippa',1,'chartreuse','perfumed');
insert into alien values (4,'Meekamuncha',7,'lavender','old cabbage');
insert into alien values (5,'Eop',0,'chartreuse','new car');
insert into nation values ('UK','United Kingdom',1);
insert into nation values ('USA','United States',0.67);
insert into nation values ('AUS','Australia',0.46);
insert into nation values ('IND','India',0.0228);
insert into stock values ('FC','Freedonia Copper',27.5,10529,1.84,16,'UK');
insert into stock values ('PT','Patagonian Tea',55.25,12635,2.5,10,'UK');
insert into stock values ('AR','Abyssinian Ruby',31.82,22010,1.32,13,'UK');
insert into stock values ('SLG','Sri Lankan Gold',50.37,32868,2.68,16,'UK');
insert into stock values ('ILZ','Indian Lead & Zinc',37.75,6390,3,12,'UK');
insert into stock values ('BE','Burmese Elephant',0.07,154713,0.01,3,'UK');
insert into stock values ('BS','Bolivian Sheep',12.75,231678,1.78,11,'UK');
insert into stock values ('NG','Nigerian Geese',35,12323,1.68,10,'UK');
insert into stock values ('CS','Canadian Sugar',52.78,4716,2.5,15,'UK');
insert into stock values ('ROF','Royal Ostrich Farms',33.75,1234923,3,6,'UK');
insert into stock values ('MG','Minnesota Gold',53.87,816122,1,25,'USA');
insert into stock values ('GP','Georgia Peach',2.35,387333,0.2,5,'USA');
insert into stock values ('NE','Narembeen Emu',12.34,45619,1,8,'AUS');
insert into stock values ('QD','Queensland Diamond',6.73,89251,0.5,7,'AUS');
insert into stock values ('IR','Indooroopilly Ruby',15.92,56147,0.5,20,'AUS');
insert into stock values ('BD','Bombay Duck',25.55,167382,1,12,'IND');
insert into person values (21,'Sheila','O''Hara');
insert into person values (2,'Gigi','Garfield');
insert into person values (63,'Barbara','Capelli');
insert into person values (74,'James','Haley');
insert into person values (5,'Nolan','Haley');
insert into person values (16,'Kwok-Kee','Tan');
insert into person values (7,'Macedonio','Gomez');
insert into person values (8,'Bruce','Bush');
insert into person values (99,'Sue','Lim');
insert into person values (10,'Kendra','Haley');
insert into car values (1,500,795,'sedan',5);
insert into car values (2,15500,14750,'coupe',8);
insert into car values (3,1255,1355,'sports',8);
insert into car values (4,950,2000,'sedan',8);
insert into car values (5,7500,9000,'sports',2);
insert into car values (6,5400,6000,'sedan',99);
insert into car values (7,10300,12000,'sedan',99);
insert into car values (8,5700,9000,'coupe',99);
insert into car values (9,9000,12000,'sports',74);
insert into car values (10,6000,6500,'sedan',63);
insert into sale values (1,'2011-01-15','Scruffy Australian - called himself Bruce');
insert into sale values (2,'2011-01-15','Man. Rather fond of hats.');
insert into sale values (3,'2011-01-15','Woman. Planning to row Atlantic - lengthwise!');
insert into sale values (4,'2011-01-15','Man. Trip to New York - thinks NY is a jungle!');
insert into sale values (5,'2011-01-16','Expedition leader for African safari.');
insert into item values (1,'Pocket knife - Nile','E','Brown');
insert into item values (2,'Pocket knife - Avon','E','Brown');
insert into item values (3,'Compass','N','-');
insert into item values (4,'Geo positioning system','N','-');
insert into item values (5,'Map measure','N','-');
insert into item values (6,'Hat - Polar explorer','C','Red');
insert into item values (7,'Hat - Polar explorer','C','White');
insert into item values (8,'Boots - snake proof','C','Green');
insert into item values (9,'Boots - snake proof','C','Black');
insert into item values (10,'Safari chair','F','Khaki');
insert into item values (11,'Hammock','F','Khaki');
insert into item values (12,'Tent - 8 person','F','Khaki');
insert into item values (13,'Tent - 2 person','F','Khaki');
insert into item values (14,'Safari cooking kit','E','-');
insert into item values (15,'Pith helmet','C','Khaki');
insert into item values (16,'Pith helmet','C','White');
insert into item values (17,'Map case','N','Brown');
insert into item values (18,'Sextant','N','-');
insert into item values (19,'Stetson','C','Black');
insert into item values (20,'Stetson','C','Brown');
insert into lineitem values (1,1,4.5,1,2);
insert into lineitem values (1,1,25,2,6);
insert into lineitem values (2,1,20,2,16);
insert into lineitem values (3,1,25,2,19);
insert into lineitem values (4,1,2.25,2,2);
insert into lineitem values (1,1,500,3,4);
insert into lineitem values (2,1,2.25,3,2);
insert into lineitem values (1,1,500,4,4);
insert into lineitem values (2,1,65,4,9);
insert into lineitem values (3,1,60,4,13);
insert into lineitem values (4,1,75,4,14);
insert into lineitem values (5,1,10,4,3);
insert into lineitem values (6,1,2.25,4,2);
insert into lineitem values (1,50,36,5,10);
insert into lineitem values (2,50,40.5,5,11);
insert into lineitem values (3,8,153,5,12);
insert into lineitem values (4,1,60,5,13);
insert into lineitem values (5,1,0,5,2);
insert into donor values (101,'Abrams','Louis',9018,'GA','London');
insert into donor values (102,'Aldinger','Dmitry',1521,'GA','Paris');
insert into donor values (103,'Beckman','Gulsen',8247,'WA','Sao Paulo');
insert into donor values (104,'Berdahl','Samuel',8149,'WI','Sydney');
insert into donor values (105,'Borneman','Joanna',1888,'MD','Bombay');
insert into donor values (106,'Brock','Scott',2142,'AL','London');
insert into donor values (107,'Buyert','Aylin',9355,'AK','New York');
insert into donor values (108,'Cetinsoy','Girwan',6346,'AZ','Rome');
insert into donor values (109,'Chisholm','John',4482,'MA','Oslo');
insert into donor values (110,'Crowder','Anthony',6513,'NC','Stockholm');
insert into donor values (111,'Dishman','Michelle',3903,'NC','Helsinki');
insert into donor values (112,'Duke','Peter',4939,'FL','Tokyo');
insert into donor values (113,'Evans','Ann',4336,'GA','Singapore');
insert into donor values (114,'Frawley','Todd',4785,'MN','Perth');
insert into donor values (115,'Guo','John',6247,'MN','Moscow');
insert into donor values (116,'Hammann','John',5369,'ND','Kabaul');
insert into donor values (117,'Hays','Cami',1352,'SD','Lima');
insert into donor values (118,'Herskowitz','Thomas',6872,'MT','London');
insert into donor values (119,'Jefts','Robert',8103,'ME','Oslo');
insert into year values (1999,5000);
insert into year values (2000,5000);
insert into year values (2001,5500);
insert into year values (2002,5000);
insert into gift values (939,2000,101);
insert into gift values (899,2000,102);
insert into gift values (111,2001,102);
insert into gift values (373,1999,101);
insert into gift values (543,1999,102);
insert into gift values (1185,1999,103);
insert into gift values (1362,2000,103);
insert into gift values (5208,2001,103);
insert into gift values (1865,2002,103);
insert into gift values (667,2000,105);
insert into gift values (60,2002,106);
insert into gift values (332,2001,107);
insert into gift values (674,2000,108);
insert into gift values (155,2001,108);
insert into gift values (838,1999,109);
insert into gift values (499,2001,109);
insert into gift values (582,1999,110);
insert into gift values (297,2000,110);
insert into gift values (84,2001,110);
insert into gift values (823,2002,110);
insert into gift values (887,1999,111);
insert into gift values (332,2000,111);
insert into gift values (882,2001,111);
insert into gift values (666,1999,112);
insert into gift values (812,2002,112);
insert into gift values (560,2001,113);
insert into gift values (223,1999,114);
insert into gift values (835,2001,114);
insert into gift values (558,2000,115);
insert into gift values (268,2000,116);
insert into gift values (345,2001,116);
insert into gift values (265,2002,116);
insert into gift values (82,1999,117);
insert into gift values (657,2002,117);
insert into gift values (17,2002,118);
insert into gift values (186,1999,119);
insert into gift values (772,2000,119);
/* dept */
insert into dept values ('Management',5,2001,1);
insert into dept values ('Marketing',1,2002,2);
insert into dept values ('Accounting',4,2003,5);
insert into dept values ('Purchasing',4,2004,7);
insert into dept values ('Personnel',1,2005,9);
/* emp */
insert into emp (empno, empfname, empsalary, deptname) values (1,'Alice',75000,'Management');
insert into emp values (2,'Ned',45000,'Marketing',1);
insert into emp values (3,'Andrew',25000,'Marketing',2);
insert into emp values (4,'Clare',22000,'Marketing',2);
insert into emp values (5,'Todd',38000,'Accounting',1);
insert into emp values (6,'Nancy',22000,'Accounting',5);
insert into emp values (7,'Brier',43000,'Purchasing',1);
insert into emp values (8,'Sarah',56000,'Purchasing',7);
insert into emp values (9,'Sophie',35000,'Personnel',1);
/* monarch */
insert into monarch (montype,monname, monnum,rgnbeg) values ('King','William','IV','1830-06-26');
insert into monarch values ('Queen','Victoria','I','1837-06-20','William','IV');
insert into monarch values ('King','Edward','VII','1901-01-22','Victoria','I');
insert into monarch values ('King','George','V','1910-05-06','Edward','VII');
insert into monarch values ('King','Edward','VIII','1936-01-20','George','V');
insert into monarch values ('King','George','VI','1936-12-11','Edward','VIII');
insert into monarch values ('Queen','Elizabeth','II','1952-02-06','George','VI');
/* product */
insert into product (prodid, proddesc, prodprice) values (1000,'Animal photography kit',725);
insert into product values (101,'35mm camera',150,300);
insert into product values (102,'Camera case',10,15);
insert into product values (103,'70-210 zoom lens',125,200);
insert into product values (104,'28-85 zoom lens',115,185);
insert into product values (105,'Photographers vest',25,40);
insert into product values (106,'Lens cleaning cloth',1,1);
insert into product values (107,'Tripod',35,45);
insert into product values (108,'24/100 ASA 35mm color neg film',0.85,1);
/* assembly */
insert into assembly values (1,1000,101);
insert into assembly values (1,1000,102);
insert into assembly values (1,1000,103);
insert into assembly values (1,1000,104);
insert into assembly values (1,1000,105);
insert into assembly values (2,1000,106);
insert into assembly values (1,1000,107);
insert into assembly values (10,1000,108);
/* qitem */
insert into qitem values ('Boots - snakeproof','C','Green');
insert into qitem values ('Camel saddle','R','Brown');
insert into qitem values ('Compass','N','-');
insert into qitem values ('Elephant polo stick','R','Bamboo');
insert into qitem values ('Exploring in 10 Easy Lessons','B','-');
insert into qitem values ('Geo positioning system','N','-');
insert into qitem values ('Hammock','F','Khaki');
insert into qitem values ('Hat - polar explorer','C','White');
insert into qitem values ('How to Win Foreign Friends','B','-');
insert into qitem values ('Map case','E','Brown');
insert into qitem values ('Map measure','N','-');
insert into qitem values ('Pith helmet','C','Khaki');
insert into qitem values ('Pocket knife - Avon','E','Brown');
insert into qitem values ('Pocket knife - Nile','E','Brown');
insert into qitem values ('Safari chair','F','Khaki');
insert into qitem values ('Safari cooking kit','F','-');
insert into qitem values ('Sextant','N','-');
insert into qitem values ('Stetson','C','Black');
insert into qitem values ('Tent - 2 person','F','Khaki');
insert into qitem values ('Tent - 8 person','F','Khaki');
insert into qemp values (1,'Alice',75000,'Management',0);
insert into qemp values (2,'Ned',45000,'Marketing',1);
insert into qemp values (3,'Andrew',25000,'Marketing',2);
insert into qemp values (4,'Clare',22000,'Marketing',2);
insert into qemp values (5,'Todd',38000,'Accounting',1);
insert into qemp values (6,'Nancy',22000,'Accounting',5);
insert into qemp values (7,'Brier',43000,'Purchasing',1);
insert into qemp values (8,'Sarah',56000,'Purchasing',7);
insert into qemp values (9,'Sophie',35000,'Personnel',1);
insert into qemp values (10,'Sanjay',15000,'Navigation',3);
insert into qemp values (11,'Rita',15000,'Books',4);
insert into qemp values (12,'Gigi',16000,'Clothes',4);
insert into qemp values (13,'Maggie',16000,'Clothes',4);
insert into qemp values (14,'Paul',11000,'Equipment',3);
insert into qemp values (15,'James',15000,'Equipment',3);
insert into qemp values (16,'Pat',15000,'Furniture',3);
insert into qemp values (17,'Mark',15000,'Recreation',3);
insert into qdept values ('Management',5,34,1);
insert into qdept values ('Books',1,81,4);
insert into qdept values ('Clothes',2,24,4);
insert into qdept values ('Equipment',3,57,3);
insert into qdept values ('Furniture',4,14,3);
insert into qdept values ('Navigation',1,41,3);
insert into qdept values ('Recreation',2,29,4);
insert into qdept values ('Accounting',5,35,5);
insert into qdept values ('Purchasing',5,36,7);
insert into qdept values ('Personnel',5,37,9);
insert into qdept values ('Marketing',5,38,2);
insert into qsale values (1001,2,'Boots - snakeproof','Clothes');
insert into qsale values (1002,1,'Pith helmet','Clothes');
insert into qsale values (1003,1,'Sextant','Navigation');
insert into qsale values (1004,3,'Hat - polar explorer','Clothes');
insert into qsale values (1005,5,'Pith helmet','Equipment');
insert into qsale values (1006,1,'Pocket knife - Nile','Clothes');
insert into qsale values (1007,1,'Pocket knife - Nile','Recreation');
insert into qsale values (1008,1,'Compass','Navigation');
insert into qsale values (1009,1,'Geo positioning system','Navigation');
insert into qsale values (1010,5,'Map measure','Navigation');
insert into qsale values (1011,1,'Geo positioning system','Books');
insert into qsale values (1012,1,'Sextant','Books');
insert into qsale values (1013,3,'Pocket knife - Nile','Books');
insert into qsale values (1014,1,'Pocket knife - Nile','Navigation');
insert into qsale values (1015,1,'Pocket knife - Nile','Equipment');
insert into qsale values (1016,1,'Sextant','Clothes');
insert into qsale values (1017,1,'Sextant','Equipment');
insert into qsale values (1018,1,'Sextant','Recreation');
insert into qsale values (1019,1,'Sextant','Furniture');
insert into qsale values (1020,1,'Pocket knife - Nile','Furniture');
insert into qsale values (1021,1,'Exploring in 10 Easy Lessons','Books');
insert into qsale values (1022,1,'How to Win Foreign Friends','Books');
insert into qsale values (1023,1,'Compass','Books');
insert into qsale values (1024,1,'Pith helmet','Books');
insert into qsale values (1025,1,'Elephant polo stick','Recreation');
insert into qsale values (1026,1,'Camel saddle','Recreation');
insert into qspl values (101,'Global Books & Maps');
insert into qspl values (102,'Nepalese Corp.');
insert into qspl values (103,'All Sports Manufacturing');
insert into qspl values (104,'Sweatshops Unlimited');
insert into qspl values (105,'All Points_ Inc.');
insert into qspl values (106,'Sao Paulo Manufacturing');
insert into qdel values (51,50,'Pocket knife - Nile','Navigation',105);
insert into qdel values (52,10,'Pocket knife - Nile','Books',105);
insert into qdel values (53,10,'Pocket knife - Nile','Clothes',105);
insert into qdel values (54,10,'Pocket knife - Nile','Equipment',105);
insert into qdel values (55,10,'Pocket knife - Nile','Furniture',105);
insert into qdel values (56,10,'Pocket knife - Nile','Recreation',105);
insert into qdel values (57,50,'Compass','Navigation',101);
insert into qdel values (58,10,'Geo positioning system','Navigation',101);
insert into qdel values (59,10,'Map measure','Navigation',101);
insert into qdel values (60,25,'Map case','Navigation',101);
insert into qdel values (61,2,'Sextant','Navigation',101);
insert into qdel values (62,1,'Sextant','Equipment',105);
insert into qdel values (63,20,'Compass','Equipment',103);
insert into qdel values (64,1,'Geo positioning system','Books',103);
insert into qdel values (65,15,'Map measure','Navigation',103);
insert into qdel values (66,1,'Sextant','Books',103);
insert into qdel values (67,5,'Sextant','Recreation',102);
insert into qdel values (68,3,'Sextant','Navigation',104);
insert into qdel values (69,5,'Boots - snakeproof','Clothes',105);
insert into qdel values (70,15,'Pith helmet','Clothes',105);
insert into qdel values (71,1,'Pith helmet','Clothes',101);
insert into qdel values (72,1,'Pith helmet','Clothes',102);
insert into qdel values (73,1,'Pith helmet','Clothes',103);
insert into qdel values (74,1,'Pith helmet','Clothes',104);
insert into qdel values (75,5,'Pith helmet','Navigation',105);
insert into qdel values (76,5,'Pith helmet','Books',105);
insert into qdel values (77,5,'Pith helmet','Equipment',105);
insert into qdel values (78,5,'Pith helmet','Furniture',105);
insert into qdel values (79,5,'Pith helmet','Recreation',105);
insert into qdel values (80,10,'Pocket knife - Nile','Navigation',102);
insert into qdel values (81,1,'Compass','Navigation',102);
insert into qdel values (82,1,'Geo positioning system','Navigation',102);
insert into qdel values (83,10,'Map measure','Navigation',102);
insert into qdel values (84,5,'Map case','Navigation',102);
insert into qdel values (85,5,'Compass','Books',102);
insert into qdel values (86,5,'Pocket knife - Avon','Recreation',102);
insert into qdel values (87,5,'Tent - 2 person','Recreation',102);
insert into qdel values (88,2,'Tent - 8 person','Recreation',102);
insert into qdel values (89,5,'Exploring in 10 Easy Lessons','Navigation',102);
insert into qdel values (90,5,'How to Win Foreign Friends','Navigation',102);
insert into qdel values (91,10,'Exploring in 10 Easy Lessons','Books',102);
insert into qdel values (92,10,'How to Win Foreign Friends','Books',102);
insert into qdel values (93,2,'Exploring in 10 Easy Lessons','Recreation',102);
insert into qdel values (94,2,'How to Win Foreign Friends','Recreation',102);
insert into qdel values (95,5,'Compass','Equipment',105);
insert into qdel values (96,2,'Boots - snakeproof','Equipment',105);
insert into qdel values (97,20,'Pith helmet','Equipment',106);
insert into qdel values (98,20,'Pocket knife - Nile','Equipment',106);
insert into qdel values (99,1,'Sextant','Equipment',106);
insert into qdel values (100,3,'Hat - polar explorer','Clothes',105);
insert into qdel values (101,3,'Stetson','Clothes',105);
insert into exped values (1,'2010-11-30','Paris','Exploring in 10 Easy Lessons','Store',4,80);
insert into exped values (2,'2010-10-20','London','Camel saddle','Catalog',3,1794);
insert into exped values (3,'2010-11-7','Paris','Compass','Store',2,16);
insert into exped values (4,'2010-7-28','London','Geo positioning system','Store',3,885);
insert into exped values (5,'2010-8-5','Paris','Hammock','Store',3,165);
insert into exped values (6,'2010-8-7','Paris','Camel saddle','Store',2,1196);
insert into exped values (7,'2010-6-27','Paris','Geo positioning system','Store',2,590);
insert into exped values (8,'2010-5-11','London','Geo positioning system','Store',5,1475);
insert into exped values (9,'2010-11-3','Paris','Hammock','Store',3,165);
insert into exped values (10,'2010-10-19','London','Camel saddle','Catalog',4,2392);
insert into exped values (11,'2010-7-16','London','Boots - snakeproof','Store',2,190);
insert into exped values (12,'2010-9-14','Paris','Geo positioning system','Store',2,590);
insert into exped values (13,'2010-12-20','London','How to Win Foreign Friends','Store',5,130);
insert into exped values (14,'2010-10-25','London','Compass','Catalog',5,40);
insert into exped values (15,'2010-3-30','New York','Map case','Store',5,75);
insert into exped values (16,'2010-9-7','Paris','Geo positioning system','Catalog',2,590);
insert into exped values (17,'2010-7-30','London','Hammock','Store',4,220);
insert into exped values (18,'2010-12-13','New York','Elephant polo stick','Store',3,1056);
insert into exped values (19,'2010-4-29','Tokyo','Camel saddle','Catalog',2,1196);
insert into exped values (20,'2010-7-10','London','Hammock','Web',5,275);
insert into exped values (21,'2010-2-7','Paris','Elephant polo stick','Catalog',5,1760);
insert into exped values (22,'2010-1-25','Paris','Hat - polar explorer','Store',3,102);
insert into exped values (23,'2010-9-15','London','How to Win Foreign Friends','Catalog',4,104);
insert into exped values (24,'2010-3-12','Paris','Hammock','Catalog',5,275);
insert into exped values (25,'2010-6-30','Sydney','Compass','Store',4,32);
insert into exped values (26,'2010-4-27','Paris','Geo positioning system','Store',4,1180);
insert into exped values (27,'2010-8-18','Paris','Camel saddle','Store',2,1196);
insert into exped values (28,'2010-9-8','London','Compass','Web',2,16);
insert into exped values (29,'2010-10-4','New York','Compass','Store',3,24);
insert into exped values (30,'2010-11-28','London','Hammock','Store',3,165);
insert into exped values (31,'2010-1-17','London','Exploring in 10 Easy Lessons','Store',2,40);
insert into exped values (32,'2010-7-14','London','Geo positioning system','Store',1,295);
insert into exped values (33,'2010-11-6','London','Camel saddle','Catalog',4,2392);
insert into exped values (34,'2010-12-4','London','Elephant polo stick','Store',3,1056);
insert into exped values (35,'2010-11-4','Sydney','Compass','Store',2,16);
insert into exped values (36,'2010-4-28','Paris','Exploring in 10 Easy Lessons','Store',3,60);
insert into exped values (37,'2010-9-25','Paris','Exploring in 10 Easy Lessons','Catalog',2,40);
insert into exped values (38,'2010-12-3','New York','Hammock','Web',4,220);
insert into exped values (39,'2010-5-21','London','Hat - polar explorer','Store',1,34);
insert into exped values (40,'2010-1-28','Paris','Compass','Store',5,40);
insert into exped values (41,'2010-1-9','Paris','Hammock','Store',4,220);
insert into exped values (42,'2010-2-27','Paris','Map case','Store',2,30);
insert into exped values (43,'2010-1-18','New York','Exploring in 10 Easy Lessons','Store',1,20);
insert into exped values (44,'2010-5-11','Paris','Hat - polar explorer','Web',1,34);
insert into exped values (45,'2010-4-4','Tokyo','How to Win Foreign Friends','Store',2,52);
insert into exped values (46,'2010-6-8','London','Hammock','Store',2,110);
insert into exped values (47,'2010-8-12','London','Hat - polar explorer','Store',1,34);
insert into exped values (48,'2010-2-5','Tokyo','Camel saddle','Store',2,1196);
insert into exped values (49,'2010-8-31','London','Camel saddle','Store',2,1196);
insert into exped values (50,'2010-5-22','Paris','Hat - polar explorer','Catalog',5,170);
insert into exped values (51,'2010-4-21','London','Elephant polo stick','Catalog',2,704);
insert into exped values (52,'2010-6-5','Tokyo','How to Win Foreign Friends','Store',5,130);
insert into exped values (53,'2010-2-10','Paris','Boots - snakeproof','Store',5,475);
insert into exped values (54,'2010-12-10','Paris','Compass','Store',4,32);
insert into exped values (55,'2010-5-3','Paris','Compass','Web',3,24);
insert into exped values (56,'2010-10-15','New York','Hat - polar explorer','Store',4,136);
insert into exped values (57,'2010-4-17','Sydney','Geo positioning system','Web',1,295);
insert into exped values (58,'2010-5-30','London','Hat - polar explorer','Catalog',3,102);
insert into exped values (59,'2010-4-18','New York','Geo positioning system','Catalog',5,1475);
insert into exped values (60,'2010-12-1','London','Elephant polo stick','Store',2,704);
insert into exped values (61,'2010-12-4','Paris','Compass','Store',3,24);
insert into exped values (62,'2010-10-18','Paris','How to Win Foreign Friends','Catalog',3,78);
insert into exped values (63,'2010-2-18','Paris','Geo positioning system','Store',1,295);
insert into exped values (64,'2010-5-19','London','Hammock','Store',4,220);
insert into exped values (65,'2010-7-3','Paris','How to Win Foreign Friends','Store',1,26);
insert into exped values (66,'2010-11-20','London','Map case','Store',3,45);
insert into exped values (67,'2010-12-1','Paris','How to Win Foreign Friends','Store',3,78);
insert into exped values (68,'2010-3-24','Tokyo','Hammock','Store',3,165);
insert into exped values (69,'2010-2-24','London','Hat - polar explorer','Store',4,136);
insert into exped values (70,'2010-12-23','New York','Hammock','Store',2,110);
insert into exped values (71,'2010-7-3','Paris','How to Win Foreign Friends','Store',4,104);
insert into exped values (72,'2010-8-28','London','Exploring in 10 Easy Lessons','Store',3,60);
insert into exped values (73,'2010-11-18','Tokyo','Compass','Store',1,8);
insert into exped values (74,'2010-10-14','Paris','Hat - polar explorer','Web',3,102);
insert into exped values (75,'2010-9-25','Paris','How to Win Foreign Friends','Store',4,104);
insert into exped values (76,'2010-5-5','Paris','Hammock','Catalog',4,220);
insert into exped values (77,'2010-5-14','Paris','Map case','Store',5,75);
insert into exped values (78,'2010-9-5','London','Exploring in 10 Easy Lessons','Store',2,40);
insert into exped values (79,'2010-7-31','Paris','Elephant polo stick','Store',3,1056);
insert into exped values (80,'2010-12-16','London','Compass','Store',2,16);
insert into exped values (81,'2010-4-18','London','Map case','Store',5,75);
insert into exped values (82,'2010-11-1','Sydney','Compass','Store',3,24);
insert into exped values (83,'2010-4-28','London','Camel saddle','Store',2,1196);
insert into exped values (84,'2010-3-4','London','Hammock','Store',4,220);
insert into exped values (85,'2010-10-16','Paris','Compass','Web',4,32);
insert into exped values (86,'2010-6-2','Paris','Map case','Store',3,45);
insert into exped values (87,'2010-4-15','Paris','Hammock','Store',5,275);
insert into exped values (88,'2010-5-15','London','Map case','Catalog',3,45);
insert into exped values (89,'2010-5-27','Paris','Hat - polar explorer','Store',2,68);
insert into exped values (90,'2010-8-26','London','Hammock','Store',4,220);
insert into exped values (91,'2010-9-26','London','Hat - polar explorer','Catalog',4,136);
insert into exped values (92,'2010-2-8','Paris','Geo positioning system','Store',3,885);
insert into exped values (93,'2010-6-26','Paris','Hat - polar explorer','Store',2,68);
insert into exped values (94,'2010-1-7','Paris','How to Win Foreign Friends','Store',2,52);
insert into exped values (95,'2010-1-22','Paris','Camel saddle','Catalog',4,2392);
insert into exped values (96,'2010-5-15','London','Elephant polo stick','Catalog',5,1760);
insert into exped values (97,'2010-9-20','Tokyo','Hammock','Store',2,110);
insert into exped values (98,'2010-3-3','London','Hammock','Store',4,220);
insert into exped values (99,'2010-1-24','London','Geo positioning system','Store',1,295);
insert into exped values (100,'2010-5-18','Tokyo','Exploring in 10 Easy Lessons','Catalog',2,40);
insert into exped values (101,'2010-11-28','London','Boots - snakeproof','Web',4,380);
insert into exped values (102,'2010-12-19','Paris','Hammock','Store',3,165);
insert into exped values (103,'2010-8-1','Paris','Geo positioning system','Catalog',3,885);
insert into exped values (104,'2010-11-9','Paris','Geo positioning system','Store',1,295);
insert into exped values (105,'2010-6-7','Paris','Geo positioning system','Catalog',2,590);
insert into exped values (106,'2010-7-17','Paris','Compass','Catalog',2,16);
insert into exped values (107,'2010-12-7','Paris','Compass','Store',2,16);
insert into exped values (108,'2010-2-15','Tokyo','Camel saddle','Store',3,1794);
insert into exped values (109,'2010-9-14','London','Geo positioning system','Store',1,295);
insert into exped values (110,'2010-12-1','Tokyo','Geo positioning system','Store',4,1180);
insert into exped values (111,'2010-4-19','Paris','How to Win Foreign Friends','Store',2,52);
insert into exped values (112,'2010-7-7','Paris','Camel saddle','Store',5,2990);
insert into exped values (113,'2010-5-26','London','Compass','Store',3,24);
insert into exped values (114,'2010-1-9','London','Hat - polar explorer','Catalog',4,136);
insert into exped values (115,'2010-1-3','London','Exploring in 10 Easy Lessons','Store',1,20);
insert into exped values (116,'2010-6-25','London','Elephant polo stick','Catalog',3,1056);
insert into exped values (117,'2010-1-10','London','Hat - polar explorer','Store',4,136);
insert into exped values (118,'2010-10-15','Paris','How to Win Foreign Friends','Store',4,104);
insert into exped values (119,'2010-6-1','London','Geo positioning system','Store',4,1180);
insert into exped values (120,'2010-11-10','Sydney','Compass','Store',2,16);
insert into exped values (121,'2010-5-15','New York','Hammock','Store',1,55);
insert into exped values (122,'2010-9-28','London','How to Win Foreign Friends','Store',3,78);
insert into exped values (123,'2010-6-28','New York','Exploring in 10 Easy Lessons','Catalog',5,100);
insert into exped values (124,'2010-7-31','London','How to Win Foreign Friends','Store',3,78);
insert into exped values (125,'2010-1-31','London','Elephant polo stick','Store',2,704);
insert into exped values (126,'2010-4-7','London','How to Win Foreign Friends','Web',4,104);
insert into exped values (127,'2010-11-13','London','Camel saddle','Store',1,598);
insert into exped values (128,'2010-6-16','London','Geo positioning system','Catalog',3,885);
insert into exped values (129,'2010-7-13','Paris','Exploring in 10 Easy Lessons','Catalog',2,40);
insert into exped values (130,'2010-12-13','Tokyo','Exploring in 10 Easy Lessons','Store',3,60);
insert into exped values (131,'2010-3-19','Paris','Hammock','Catalog',3,165);
insert into exped values (132,'2010-8-8','London','Exploring in 10 Easy Lessons','Store',4,80);
insert into exped values (133,'2010-1-6','Paris','Hammock','Store',1,55);
insert into exped values (134,'2010-3-5','London','Geo positioning system','Store',3,885);
insert into exped values (135,'2010-3-3','Paris','Camel saddle','Web',3,1794);
insert into exped values (136,'2010-11-25','Paris','How to Win Foreign Friends','Store',2,52);
insert into exped values (137,'2010-8-30','London','Geo positioning system','Store',4,1180);
insert into exped values (138,'2010-11-10','London','Compass','Store',1,8);
insert into exped values (139,'2010-9-5','New York','Exploring in 10 Easy Lessons','Store',4,80);
insert into exped values (140,'2010-9-15','Paris','Hammock','Store',2,110);
insert into exped values (141,'2010-5-30','Paris','How to Win Foreign Friends','Catalog',3,78);
insert into exped values (142,'2010-8-7','Paris','Exploring in 10 Easy Lessons','Store',4,80);
insert into exped values (143,'2010-2-17','Sydney','How to Win Foreign Friends','Store',1,26);
insert into exped values (144,'2010-5-17','London','Elephant polo stick','Web',3,1056);
insert into exped values (145,'2010-6-12','Paris','Compass','Store',2,16);
insert into exped values (146,'2010-3-17','Tokyo','Hammock','Catalog',5,275);
insert into exped values (147,'2010-2-12','London','Hat - polar explorer','Store',2,68);
insert into exped values (148,'2010-8-30','Tokyo','Elephant polo stick','Store',1,352);
insert into exped values (149,'2010-5-15','Sydney','Exploring in 10 Easy Lessons','Store',3,60);
insert into exped values (150,'2010-3-9','Paris','Hammock','Store',2,110);
insert into exped values (151,'2010-1-15','London','Geo positioning system','Store',1,295);
insert into exped values (152,'2010-11-25','Paris','Geo positioning system','Store',4,1180);
insert into exped values (153,'2010-11-22','Tokyo','Camel saddle','Store',1,598);
insert into exped values (154,'2010-6-16','London','Compass','Store',3,24);
insert into exped values (155,'2010-11-9','Tokyo','Compass','Store',3,24);
insert into exped values (156,'2010-10-27','London','Camel saddle','Store',1,598);
insert into exped values (157,'2010-5-4','Tokyo','Compass','Store',5,40);
insert into exped values (158,'2010-4-9','London','Boots - snakeproof','Store',4,380);
insert into exped values (159,'2010-11-12','Paris','Boots - snakeproof','Store',2,190);
insert into exped values (160,'2010-11-21','Tokyo','Elephant polo stick','Store',5,1760);
insert into exped values (161,'2010-4-6','Tokyo','Geo positioning system','Store',3,885);
insert into exped values (162,'2010-8-4','New York','How to Win Foreign Friends','Store',3,78);
insert into exped values (163,'2010-10-22','London','How to Win Foreign Friends','Store',2,52);
insert into exped values (164,'2010-7-6','Sydney','Exploring in 10 Easy Lessons','Store',4,80);
insert into exped values (165,'2010-8-20','Paris','Hat - polar explorer','Store',5,170);
insert into exped values (166,'2010-5-26','Tokyo','Geo positioning system','Store',4,1180);
insert into exped values (167,'2010-5-2','Sydney','Boots - snakeproof','Store',2,190);
insert into exped values (168,'2010-3-29','Paris','Compass','Store',4,32);
insert into exped values (169,'2010-8-26','London','Compass','Catalog',1,8);
insert into exped values (170,'2010-12-18','London','Exploring in 10 Easy Lessons','Catalog',2,40);
insert into exped values (171,'2010-7-5','Paris','How to Win Foreign Friends','Store',5,130);
insert into exped values (172,'2010-7-2','Paris','Map case','Store',2,30);
insert into exped values (173,'2010-7-16','Paris','How to Win Foreign Friends','Store',4,104);
insert into exped values (174,'2010-9-5','London','Boots - snakeproof','Catalog',2,190);
insert into exped values (175,'2010-6-20','Tokyo','Hat - polar explorer','Store',5,170);
insert into exped values (176,'2010-3-10','London','Exploring in 10 Easy Lessons','Store',5,100);
insert into exped values (177,'2010-5-31','Tokyo','How to Win Foreign Friends','Catalog',3,78);
insert into exped values (178,'2010-6-10','New York','How to Win Foreign Friends','Catalog',2,52);
insert into exped values (179,'2010-8-9','Tokyo','Camel saddle','Catalog',5,2990);
insert into exped values (180,'2010-7-14','Paris','Camel saddle','Store',3,1794);
insert into exped values (181,'2010-9-24','London','Elephant polo stick','Web',4,1408);
insert into exped values (182,'2010-1-30','London','Compass','Store',4,32);
insert into exped values (183,'2010-8-12','Sydney','Compass','Store',1,8);
insert into exped values (184,'2010-9-17','Tokyo','Compass','Store',4,32);
insert into exped values (185,'2010-4-6','Paris','How to Win Foreign Friends','Web',5,130);
insert into exped values (186,'2010-11-13','Paris','Exploring in 10 Easy Lessons','Store',2,40);
insert into exped values (187,'2010-11-25','London','Camel saddle','Store',4,2392);
insert into exped values (188,'2010-8-10','Tokyo','Hat - polar explorer','Store',2,68);
insert into exped values (189,'2010-11-18','London','How to Win Foreign Friends','Store',4,104);
insert into exped values (190,'2010-8-23','London','Compass','Web',3,24);
insert into exped values (191,'2010-1-17','Paris','How to Win Foreign Friends','Store',5,130);
insert into exped values (192,'2010-5-18','London','Compass','Store',1,8);
insert into exped values (193,'2010-2-16','Paris','How to Win Foreign Friends','Store',3,78);
insert into exped values (194,'2010-5-17','Paris','Hammock','Store',5,275);
insert into exped values (195,'2010-2-11','London','Exploring in 10 Easy Lessons','Store',5,100);
insert into exped values (196,'2010-6-3','Sydney','Elephant polo stick','Web',5,1760);
insert into exped values (197,'2010-1-18','Tokyo','Hammock','Store',2,110);
insert into exped values (198,'2010-4-15','Tokyo','Compass','Store',2,16);
insert into exped values (199,'2010-6-12','Paris','Elephant polo stick','Store',4,1408);
insert into exped values (200,'2010-5-25','London','Elephant polo stick','Web',1,352);
insert into exped values (201,'2010-11-3','New York','Hat - polar explorer','Store',2,68);
insert into exped values (202,'2010-6-19','Sydney','Hammock','Store',1,55);
insert into exped values (203,'2010-10-19','Sydney','Boots - snakeproof','Store',3,285);
insert into exped values (204,'2010-1-13','Paris','How to Win Foreign Friends','Store',4,104);
insert into exped values (205,'2010-6-14','Sydney','Hat - polar explorer','Store',1,34);
insert into exped values (206,'2010-7-29','Sydney','Geo positioning system','Catalog',2,590);
insert into exped values (207,'2010-12-29','New York','Camel saddle','Store',1,598);
insert into exped values (208,'2010-8-14','Sydney','How to Win Foreign Friends','Catalog',1,26);
insert into exped values (209,'2010-5-25','London','Elephant polo stick','Catalog',3,1056);
insert into exped values (210,'2010-1-14','Tokyo','Camel saddle','Catalog',3,1794);
insert into exped values (211,'2010-11-1','Sydney','Boots - snakeproof','Store',5,475);
insert into exped values (212,'2010-4-8','Paris','Geo positioning system','Store',4,1180);
insert into exped values (213,'2010-1-11','London','Map case','Store',4,60);
insert into exped values (214,'2010-6-17','London','Camel saddle','Store',2,1196);
insert into exped values (215,'2010-12-30','London','Hammock','Store',2,110);
insert into exped values (216,'2010-2-15','London','Camel saddle','Store',1,598);
insert into exped values (217,'2010-3-30','Paris','Geo positioning system','Store',3,885);
insert into exped values (218,'2010-2-22','Paris','Hammock','Store',4,220);
insert into exped values (219,'2010-9-29','London','Exploring in 10 Easy Lessons','Web',3,60);
insert into exped values (220,'2010-7-18','Paris','Hammock','Catalog',2,110);
insert into exped values (221,'2010-12-31','London','Hammock','Catalog',4,220);
insert into exped values (222,'2010-1-14','Tokyo','Geo positioning system','Store',4,1180);
insert into exped values (223,'2010-2-17','London','Elephant polo stick','Catalog',4,1408);
insert into exped values (224,'2010-10-5','London','Compass','Store',4,32);
insert into exped values (225,'2010-12-7','Sydney','How to Win Foreign Friends','Store',3,78);
insert into exped values (226,'2010-5-23','Paris','Hammock','Store',3,165);
insert into exped values (227,'2010-4-8','London','Hat - polar explorer','Store',1,34);
insert into exped values (228,'2010-11-19','London','Boots - snakeproof','Store',2,190);
insert into exped values (229,'2010-5-22','London','Map case','Store',2,30);
insert into exped values (230,'2010-4-23','New York','Geo positioning system','Store',2,590);
insert into exped values (231,'2010-6-23','Paris','Compass','Store',2,16);
insert into exped values (232,'2010-12-20','London','Hammock','Store',2,110);
insert into exped values (233,'2010-7-10','Paris','Compass','Store',3,24);
insert into exped values (234,'2010-2-15','London','Geo positioning system','Catalog',2,590);
insert into exped values (235,'2010-3-15','Paris','Camel saddle','Catalog',3,1794);
insert into exped values (236,'2010-12-23','London','Boots - snakeproof','Store',2,190);
insert into exped values (237,'2010-1-7','London','Map case','Store',2,30);
insert into exped values (238,'2010-1-13','New York','Hat - polar explorer','Web',4,136);
insert into exped values (239,'2010-5-16','Tokyo','Hammock','Store',5,275);
insert into exped values (240,'2010-5-8','Sydney','Exploring in 10 Easy Lessons','Store',4,80);
insert into exped values (241,'2010-5-26','Paris','Hammock','Catalog',1,55);
insert into exped values (242,'2010-9-22','New York','Geo positioning system','Store',3,885);
insert into exped values (243,'2010-5-28','Tokyo','Camel saddle','Store',3,1794);
insert into exped values (244,'2010-12-1','London','Exploring in 10 Easy Lessons','Store',2,40);
insert into exped values (245,'2010-2-3','London','Geo positioning system','Store',2,590);
insert into exped values (246,'2010-4-2','Tokyo','Boots - snakeproof','Store',3,285);
insert into exped values (247,'2010-1-26','Paris','Compass','Catalog',3,24);
insert into exped values (248,'2010-4-6','Paris','Geo positioning system','Web',2,590);
insert into exped values (249,'2010-8-16','New York','How to Win Foreign Friends','Store',4,104);
insert into exped values (250,'2010-4-28','New York','Elephant polo stick','Store',5,1760);
insert into exped values (251,'2010-2-26','London','Boots - snakeproof','Catalog',2,190);
insert into exped values (252,'2010-6-16','London','Boots - snakeproof','Catalog',5,475);
insert into exped values (253,'2010-2-17','London','Elephant polo stick','Store',5,1760);
insert into exped values (254,'2010-6-9','New York','How to Win Foreign Friends','Web',2,52);
insert into exped values (255,'2010-5-29','London','Map case','Store',4,60);
insert into exped values (256,'2010-3-30','Paris','Exploring in 10 Easy Lessons','Catalog',5,100);
insert into exped values (257,'2010-8-21','London','Exploring in 10 Easy Lessons','Store',3,60);
insert into exped values (258,'2010-1-23','London','Elephant polo stick','Store',3,1056);
insert into exped values (259,'2010-4-11','Paris','Elephant polo stick','Store',3,1056);
insert into exped values (260,'2010-2-10','Paris','Geo positioning system','Store',4,1180);
insert into exped values (261,'2010-12-28','Paris','Compass','Store',3,24);
insert into exped values (262,'2010-6-8','London','Hammock','Store',3,165);
insert into exped values (263,'2010-4-18','London','Boots - snakeproof','Store',2,190);
insert into exped values (264,'2010-7-6','Paris','Exploring in 10 Easy Lessons','Store',2,40);
insert into exped values (265,'2010-7-9','Sydney','Hat - polar explorer','Store',3,102);
insert into exped values (266,'2010-6-24','Tokyo','Hammock','Store',2,110);
insert into exped values (267,'2010-12-29','New York','Elephant polo stick','Store',2,704);
insert into exped values (268,'2010-3-30','London','Camel saddle','Store',3,1794);
insert into exped values (269,'2010-10-10','Paris','Geo positioning system','Store',3,885);
insert into exped values (270,'2010-6-25','Paris','Map case','Store',2,30);
insert into exped values (271,'2010-9-27','Sydney','Camel saddle','Store',4,2392);
insert into exped values (272,'2010-2-16','London','Hammock','Catalog',2,110);
insert into exped values (273,'2010-3-26','Paris','Map case','Store',4,60);
insert into exped values (274,'2010-2-9','London','Hammock','Store',5,275);
insert into exped values (275,'2010-7-23','London','Exploring in 10 Easy Lessons','Store',3,60);
insert into exped values (276,'2010-8-15','New York','Elephant polo stick','Store',3,1056);
insert into exped values (277,'2010-1-9','London','Hammock','Catalog',5,275);
insert into exped values (278,'2010-1-24','Paris','Hat - polar explorer','Web',1,34);
insert into exped values (279,'2010-2-11','Tokyo','How to Win Foreign Friends','Store',1,26);
insert into exped values (280,'2010-11-18','London','Camel saddle','Store',5,2990);
insert into exped values (281,'2010-2-13','London','Geo positioning system','Store',4,1180);
insert into exped values (282,'2010-1-25','Paris','Boots - snakeproof','Catalog',4,380);
insert into exped values (283,'2010-10-1','New York','Geo positioning system','Store',1,295);
insert into exped values (284,'2010-12-3','London','Compass','Store',2,16);
insert into exped values (285,'2010-5-21','London','Camel saddle','Catalog',5,2990);
insert into exped values (286,'2010-7-21','Paris','Camel saddle','Store',3,1794);
insert into exped values (287,'2010-4-22','Paris','Camel saddle','Store',2,1196);
insert into exped values (288,'2010-8-17','Tokyo','Hat - polar explorer','Catalog',2,68);
insert into exped values (289,'2010-2-21','Paris','Compass','Store',2,16);
insert into exped values (290,'2010-6-28','New York','Exploring in 10 Easy Lessons','Web',2,40);
insert into exped values (291,'2010-11-13','London','Compass','Store',1,8);
insert into exped values (292,'2010-9-25','New York','Map case','Catalog',2,30);
insert into exped values (293,'2010-9-27','New York','Hat - polar explorer','Store',3,102);
insert into exped values (294,'2010-11-11','Paris','Compass','Catalog',1,8);
insert into exped values (295,'2010-6-10','Paris','Elephant polo stick','Catalog',2,704);
insert into exped values (296,'2010-8-4','London','Geo positioning system','Web',4,1180);
insert into exped values (297,'2010-4-14','Sydney','Boots - snakeproof','Catalog',1,95);
insert into exped values (298,'2010-12-28','Tokyo','Geo positioning system','Catalog',4,1180);
insert into exped values (299,'2010-9-19','London','Camel saddle','Store',4,2392);
insert into exped values (300,'2010-10-14','Sydney','Elephant polo stick','Catalog',3,1056);
insert into exped values (301,'2010-5-29','New York','Hammock','Store',3,165);
insert into exped values (302,'2010-7-21','London','Elephant polo stick','Catalog',4,1408);
insert into exped values (303,'2010-9-28','London','How to Win Foreign Friends','Store',1,26);
insert into exped values (304,'2010-3-22','London','Geo positioning system','Store',2,590);
insert into exped values (305,'2010-12-1','Sydney','Camel saddle','Store',3,1794);
insert into exped values (306,'2010-12-2','New York','Compass','Store',1,8);
insert into exped values (307,'2010-3-8','London','How to Win Foreign Friends','Store',1,26);
insert into exped values (308,'2010-2-9','London','Hat - polar explorer','Store',1,34);
insert into exped values (309,'2010-10-1','Paris','Geo positioning system','Catalog',4,1180);
insert into exped values (310,'2010-11-10','London','Hammock','Store',4,220);
insert into exped values (311,'2010-5-23','New York','Hammock','Store',4,220);
insert into exped values (312,'2010-7-31','Tokyo','Camel saddle','Store',1,598);
insert into exped values (313,'2010-7-2','Paris','Geo positioning system','Store',2,590);
insert into exped values (314,'2010-2-27','Paris','How to Win Foreign Friends','Store',4,104);
insert into exped values (315,'2010-2-25','Paris','Hammock','Store',4,220);
insert into exped values (316,'2010-8-10','London','Hat - polar explorer','Web',1,34);
insert into exped values (317,'2010-3-26','London','Elephant polo stick','Store',4,1408);
insert into exped values (318,'2010-11-8','Paris','How to Win Foreign Friends','Store',4,104);
insert into exped values (319,'2010-5-15','London','Hat - polar explorer','Store',4,136);
insert into exped values (320,'2010-9-26','Paris','How to Win Foreign Friends','Store',2,52);
insert into exped values (321,'2010-10-22','Tokyo','How to Win Foreign Friends','Catalog',2,52);
insert into exped values (322,'2010-1-6','London','Elephant polo stick','Store',1,352);
insert into exped values (323,'2010-12-4','London','Hat - polar explorer','Store',1,34);
insert into exped values (324,'2010-8-2','London','Camel saddle','Store',1,598);
insert into exped values (325,'2010-7-21','London','Camel saddle','Store',5,2990);
insert into exped values (326,'2010-9-10','Paris','Elephant polo stick','Store',4,1408);
insert into exped values (327,'2010-6-11','London','Boots - snakeproof','Store',2,190);
insert into exped values (328,'2010-9-28','London','Exploring in 10 Easy Lessons','Store',4,80);
insert into exped values (329,'2010-3-21','London','Hammock','Store',4,220);
insert into exped values (330,'2010-6-8','London','Camel saddle','Store',2,1196);
insert into exped values (331,'2010-3-3','New York','Hat - polar explorer','Store',3,102);
insert into exped values (332,'2010-2-12','London','Exploring in 10 Easy Lessons','Store',2,40);
insert into exped values (333,'2010-4-24','London','How to Win Foreign Friends','Store',4,104);
insert into exped values (334,'2010-11-22','Paris','Hat - polar explorer','Store',4,136);
insert into exped values (335,'2010-12-17','New York','How to Win Foreign Friends','Store',2,52);
insert into exped values (336,'2010-6-4','London','How to Win Foreign Friends','Store',2,52);
insert into exped values (337,'2010-2-28','London','Elephant polo stick','Store',3,1056);
insert into exped values (338,'2010-1-8','London','Hammock','Store',2,110);
insert into exped values (339,'2010-10-15','London','Elephant polo stick','Catalog',3,1056);
insert into exped values (340,'2010-11-3','London','Camel saddle','Web',2,1196);
insert into exped values (341,'2010-7-11','Paris','Hammock','Store',5,275);
insert into exped values (342,'2010-5-30','Paris','Compass','Web',2,16);
insert into exped values (343,'2010-12-3','Sydney','Hammock','Store',1,55);
insert into exped values (344,'2010-1-15','New York','Compass','Catalog',3,24);
insert into exped values (345,'2010-7-30','Tokyo','Camel saddle','Store',1,598);
insert into exped values (346,'2010-11-15','Paris','Elephant polo stick','Store',3,1056);
insert into exped values (347,'2010-4-18','Tokyo','Geo positioning system','Store',4,1180);
insert into exped values (348,'2010-2-19','London','Camel saddle','Store',2,1196);
insert into exped values (349,'2010-10-16','Sydney','How to Win Foreign Friends','Store',2,52);
insert into exped values (350,'2010-4-8','London','Map case','Catalog',4,60);
insert into exped values (351,'2010-10-15','London','Exploring in 10 Easy Lessons','Store',1,20);
insert into exped values (352,'2010-8-21','Paris','Hat - polar explorer','Catalog',3,102);
insert into exped values (353,'2010-2-15','Sydney','Hat - polar explorer','Store',3,102);
insert into exped values (354,'2010-3-14','London','Boots - snakeproof','Catalog',5,475);
insert into exped values (355,'2010-8-9','New York','Elephant polo stick','Store',2,704);
insert into exped values (356,'2010-5-23','London','Hat - polar explorer','Catalog',1,34);
insert into exped values (357,'2010-5-13','New York','Camel saddle','Catalog',2,1196);
insert into exped values (358,'2010-10-24','Tokyo','Map case','Store',3,45);
insert into exped values (359,'2010-8-14','London','Exploring in 10 Easy Lessons','Store',3,60);
insert into exped values (360,'2010-11-15','London','How to Win Foreign Friends','Store',3,78);
insert into exped values (361,'2010-4-2','Paris','Exploring in 10 Easy Lessons','Store',5,100);
insert into exped values (362,'2010-5-16','London','Compass','Store',2,16);
insert into exped values (363,'2010-6-2','London','Boots - snakeproof','Store',4,380);
insert into exped values (364,'2010-12-28','London','Hammock','Catalog',2,110);
insert into exped values (365,'2010-7-20','Tokyo','Elephant polo stick','Web',2,704);
insert into exped values (366,'2010-8-29','Paris','Compass','Store',4,32);
insert into exped values (367,'2010-4-23','Paris','Camel saddle','Store',4,2392);
insert into exped values (368,'2010-4-1','London','Geo positioning system','Store',1,295);
insert into exped values (369,'2010-2-26','Paris','Geo positioning system','Store',4,1180);
insert into exped values (370,'2010-3-8','Sydney','Elephant polo stick','Store',3,1056);
insert into exped values (371,'2010-3-11','London','Geo positioning system','Catalog',3,885);
insert into exped values (372,'2010-11-24','Paris','How to Win Foreign Friends','Catalog',3,78);
insert into exped values (373,'2010-8-20','London','Hat - polar explorer','Store',3,102);
insert into exped values (374,'2010-3-21','Tokyo','Geo positioning system','Store',5,1475);
insert into exped values (375,'2010-11-26','Paris','Exploring in 10 Easy Lessons','Store',1,20);
insert into exped values (376,'2010-2-7','Sydney','Geo positioning system','Catalog',2,590);
insert into exped values (377,'2010-3-18','Paris','Hat - polar explorer','Store',2,68);
insert into exped values (378,'2010-1-20','New York','Exploring in 10 Easy Lessons','Catalog',5,100);
insert into exped values (379,'2010-9-13','London','How to Win Foreign Friends','Store',3,78);
insert into exped values (380,'2010-3-8','Tokyo','Exploring in 10 Easy Lessons','Store',5,100);
insert into exped values (381,'2010-9-5','London','Hat - polar explorer','Store',1,34);
insert into exped values (382,'2010-5-24','New York','Hammock','Web',3,165);
insert into exped values (383,'2010-7-6','Paris','Compass','Store',4,32);
insert into exped values (384,'2010-3-30','Paris','Camel saddle','Store',2,1196);
insert into exped values (385,'2010-2-19','London','Camel saddle','Store',4,2392);
insert into exped values (386,'2010-5-12','London','How to Win Foreign Friends','Store',3,78);
insert into exped values (387,'2010-11-27','London','Hat - polar explorer','Store',2,68);
insert into exped values (388,'2010-11-1','Tokyo','Compass','Store',4,32);
insert into exped values (389,'2010-4-1','Paris','Geo positioning system','Store',2,590);
insert into exped values (390,'2010-5-1','Paris','Hammock','Store',5,275);
insert into exped values (391,'2010-8-10','London','Exploring in 10 Easy Lessons','Store',3,60);
insert into exped values (392,'2010-12-7','New York','Compass','Store',1,8);
insert into exped values (393,'2010-3-24','New York','Camel saddle','Store',2,1196);
insert into exped values (394,'2010-6-8','Sydney','Exploring in 10 Easy Lessons','Store',3,60);
insert into exped values (395,'2010-12-20','Sydney','Hammock','Store',2,110);
insert into exped values (396,'2010-5-14','New York','Map case','Catalog',2,30);
insert into exped values (397,'2010-2-27','London','Exploring in 10 Easy Lessons','Store',5,100);
insert into exped values (398,'2010-6-22','New York','Exploring in 10 Easy Lessons','Store',2,40);
insert into exped values (399,'2010-6-25','Paris','Hat - polar explorer','Store',1,34);
insert into exped values (400,'2010-7-14','Tokyo','Hammock','Catalog',2,110);
insert into exped values (401,'2010-2-3','London','Elephant polo stick','Store',2,704);
insert into exped values (402,'2010-3-20','Paris','Exploring in 10 Easy Lessons','Store',5,100);
insert into exped values (403,'2010-7-5','London','Camel saddle','Store',2,1196);
insert into exped values (404,'2010-4-5','London','Hat - polar explorer','Store',5,170);
insert into exped values (405,'2010-4-18','London','Exploring in 10 Easy Lessons','Store',3,60);
insert into exped values (406,'2010-11-24','Paris','Camel saddle','Store',4,2392);
insert into exped values (407,'2010-8-3','Paris','Camel saddle','Store',4,2392);
insert into exped values (408,'2010-12-4','Paris','Elephant polo stick','Store',4,1408);
insert into exped values (409,'2010-6-2','Tokyo','How to Win Foreign Friends','Store',2,52);
insert into exped values (410,'2010-1-27','London','Elephant polo stick','Store',4,1408);
insert into exped values (411,'2010-9-19','London','Boots - snakeproof','Store',4,380);
insert into exped values (412,'2010-8-9','London','Camel saddle','Catalog',4,2392);
insert into exped values (413,'2010-4-20','New York','Boots - snakeproof','Catalog',4,380);
insert into exped values (414,'2010-6-6','London','Map case','Catalog',5,75);
insert into exped values (415,'2010-12-21','London','Exploring in 10 Easy Lessons','Store',3,60);
insert into exped values (416,'2010-12-20','Paris','How to Win Foreign Friends','Store',4,104);
insert into exped values (417,'2010-7-27','New York','Camel saddle','Catalog',4,2392);
insert into exped values (418,'2010-12-2','London','Hammock','Catalog',4,220);
insert into exped values (419,'2010-9-21','London','Elephant polo stick','Store',2,704);
insert into exped values (420,'2010-5-9','London','Compass','Store',1,8);
insert into exped values (421,'2010-8-29','London','Compass','Store',2,16);
insert into exped values (422,'2010-4-8','London','Compass','Store',3,24);
insert into exped values (423,'2010-3-31','London','Geo positioning system','Store',5,1475);
insert into exped values (424,'2010-10-31','New York','Compass','Store',2,16);
insert into exped values (425,'2010-10-16','London','Exploring in 10 Easy Lessons','Catalog',5,100);
insert into exped values (426,'2010-1-28','London','How to Win Foreign Friends','Store',2,52);
insert into exped values (427,'2010-2-12','London','Map case','Store',3,45);
insert into exped values (428,'2010-3-9','Paris','Exploring in 10 Easy Lessons','Store',4,80);
insert into exped values (429,'2010-3-30','Tokyo','Camel saddle','Store',5,2990);
insert into exped values (430,'2010-4-23','Paris','Hammock','Catalog',2,110);
insert into exped values (431,'2010-6-1','London','Elephant polo stick','Store',4,1408);
insert into exped values (432,'2010-7-17','Tokyo','Camel saddle','Store',2,1196);
insert into exped values (433,'2010-4-7','Paris','Hammock','Web',3,165);
insert into exped values (434,'2010-4-6','London','Geo positioning system','Store',1,295);
insert into exped values (435,'2010-9-30','New York','Hammock','Store',3,165);
insert into exped values (436,'2010-7-23','London','Camel saddle','Store',2,1196);
insert into exped values (437,'2010-8-4','London','Hat - polar explorer','Store',1,34);
insert into exped values (438,'2010-3-7','London','Exploring in 10 Easy Lessons','Store',3,60);
insert into exped values (439,'2010-8-28','London','Camel saddle','Store',5,2990);
insert into exped values (440,'2010-5-16','New York','How to Win Foreign Friends','Store',3,78);
insert into exped values (441,'2010-5-2','London','How to Win Foreign Friends','Store',5,130);
insert into exped values (442,'2010-12-24','London','How to Win Foreign Friends','Catalog',4,104);
insert into exped values (443,'2010-1-12','New York','Exploring in 10 Easy Lessons','Store',1,20);
insert into exped values (444,'2010-12-3','London','Elephant polo stick','Store',4,1408);
insert into exped values (445,'2010-9-3','Tokyo','How to Win Foreign Friends','Catalog',3,78);
insert into exped values (446,'2010-8-27','London','How to Win Foreign Friends','Store',5,130);
insert into exped values (447,'2010-2-21','London','Hammock','Store',5,275);
insert into exped values (448,'2010-1-29','London','Exploring in 10 Easy Lessons','Store',1,20);
insert into exped values (449,'2010-10-2','London','Camel saddle','Store',3,1794);
insert into exped values (450,'2010-11-16','Sydney','Hat - polar explorer','Store',2,68);
insert into exped values (451,'2010-7-7','New York','How to Win Foreign Friends','Web',3,78);
insert into exped values (452,'2010-7-5','New York','Elephant polo stick','Store',1,352);
insert into exped values (453,'2010-7-17','London','Compass','Web',4,32);
insert into exped values (454,'2010-3-7','London','Camel saddle','Store',3,1794);
insert into exped values (455,'2010-11-10','London','Compass','Store',3,24);
insert into exped values (456,'2010-10-22','Paris','Hammock','Store',3,165);
insert into exped values (457,'2010-8-7','Sydney','How to Win Foreign Friends','Store',4,104);
insert into exped values (458,'2010-7-1','London','Camel saddle','Store',3,1794);
insert into exped values (459,'2010-11-17','Paris','Hat - polar explorer','Store',2,68);
insert into exped values (460,'2010-8-22','Tokyo','Camel saddle','Store',3,1794);
insert into exped values (461,'2010-6-12','Paris','Camel saddle','Store',1,598);
insert into exped values (462,'2010-3-17','Tokyo','Hammock','Store',2,110);
insert into exped values (463,'2010-12-28','New York','Exploring in 10 Easy Lessons','Web',5,100);
insert into exped values (464,'2010-4-7','Paris','Hat - polar explorer','Store',3,102);
insert into exped values (465,'2010-4-11','Tokyo','Exploring in 10 Easy Lessons','Catalog',3,60);
insert into exped values (466,'2010-8-14','Paris','Boots - snakeproof','Store',2,190);
insert into exped values (467,'2010-9-9','London','Hat - polar explorer','Store',3,102);
insert into exped values (468,'2010-9-24','London','Camel saddle','Store',2,1196);
insert into exped values (469,'2010-4-1','Tokyo','Camel saddle','Catalog',3,1794);
insert into exped values (470,'2010-2-12','London','Exploring in 10 Easy Lessons','Web',3,60);
insert into exped values (471,'2010-9-30','New York','Exploring in 10 Easy Lessons','Store',5,100);
insert into exped values (472,'2010-8-19','London','Hat - polar explorer','Store',4,136);
insert into exped values (473,'2010-1-27','Paris','Hammock','Store',2,110);
insert into exped values (474,'2010-9-24','Paris','Geo positioning system','Store',4,1180);
insert into exped values (475,'2010-2-27','London','Geo positioning system','Store',2,590);
insert into exped values (476,'2010-8-25','Paris','Hammock','Store',2,110);
insert into exped values (477,'2010-3-25','Paris','Exploring in 10 Easy Lessons','Store',4,80);
insert into exped values (478,'2010-10-25','Tokyo','Elephant polo stick','Catalog',4,1408);
insert into exped values (479,'2010-8-30','London','Compass','Store',4,32);
insert into exped values (480,'2010-5-11','Sydney','Boots - snakeproof','Store',5,475);
insert into exped values (481,'2010-5-8','Sydney','Map case','Store',1,15);
insert into exped values (482,'2010-8-29','Paris','Geo positioning system','Store',4,1180);
insert into exped values (483,'2010-4-28','London','Compass','Store',1,8);
insert into exped values (484,'2010-12-5','London','Geo positioning system','Store',3,885);
insert into exped values (485,'2010-1-10','Paris','Elephant polo stick','Store',4,1408);
insert into exped values (486,'2010-11-28','London','Camel saddle','Store',1,598);
insert into exped values (487,'2010-5-16','New York','Geo positioning system','Store',1,295);
insert into exped values (488,'2010-12-10','Tokyo','Map case','Store',4,60);
insert into exped values (489,'2010-11-10','Paris','Compass','Store',1,8);
insert into exped values (490,'2010-11-27','New York','Hammock','Catalog',4,220);
insert into exped values (491,'2010-9-3','London','Hammock','Store',2,110);
insert into exped values (492,'2010-7-9','Paris','How to Win Foreign Friends','Catalog',4,104);
insert into exped values (493,'2010-2-20','Paris','Hammock','Catalog',4,220);
insert into exped values (494,'2010-8-31','Sydney','How to Win Foreign Friends','Store',4,104);
insert into exped values (495,'2010-5-19','New York','Exploring in 10 Easy Lessons','Store',1,20);
insert into exped values (496,'2010-10-29','Paris','Boots - snakeproof','Store',2,190);
insert into exped values (497,'2010-5-25','New York','How to Win Foreign Friends','Store',1,26);
insert into exped values (498,'2010-11-28','London','Exploring in 10 Easy Lessons','Catalog',4,80);
insert into exped values (499,'2010-2-18','Paris','Hat - polar explorer','Store',4,136);
insert into exped values (500,'2010-3-11','Sydney','How to Win Foreign Friends','Catalog',1,26);
insert into exped values (501,'2010-5-10','London','Camel saddle','Web',2,1196);
insert into exped values (502,'2010-3-25','London','Elephant polo stick','Store',2,704);
insert into exped values (503,'2010-10-31','London','Elephant polo stick','Store',5,1760);
insert into exped values (504,'2010-6-25','Paris','How to Win Foreign Friends','Catalog',2,52);
insert into exped values (505,'2010-11-16','London','Geo positioning system','Store',5,1475);
insert into exped values (506,'2010-7-1','Paris','Hammock','Catalog',2,110);
insert into exped values (507,'2010-10-4','Paris','Compass','Catalog',4,32);
insert into exped values (508,'2010-9-1','Paris','Exploring in 10 Easy Lessons','Catalog',2,40);
insert into exped values (509,'2010-5-20','Paris','Hat - polar explorer','Web',3,102);
insert into exped values (510,'2010-9-23','Paris','Camel saddle','Catalog',5,2990);
insert into exped values (511,'2010-9-29','London','How to Win Foreign Friends','Web',4,104);
insert into exped values (512,'2010-10-10','New York','Exploring in 10 Easy Lessons','Store',2,40);
insert into exped values (513,'2010-2-10','Paris','How to Win Foreign Friends','Catalog',4,104);
insert into exped values (514,'2010-9-29','London','Camel saddle','Catalog',4,2392);
insert into exped values (515,'2010-12-1','London','How to Win Foreign Friends','Store',2,52);
insert into exped values (516,'2010-5-12','Sydney','Compass','Catalog',4,32);
insert into exped values (517,'2010-5-15','Sydney','Map case','Store',3,45);
insert into exped values (518,'2010-3-6','Sydney','Compass','Catalog',3,24);
insert into exped values (519,'2010-8-4','Paris','Hammock','Catalog',1,55);
insert into exped values (520,'2010-11-15','London','How to Win Foreign Friends','Store',3,78);
insert into exped values (521,'2010-2-2','Paris','Geo positioning system','Store',2,590);
insert into exped values (522,'2010-10-19','New York','Exploring in 10 Easy Lessons','Store',2,40);
insert into exped values (523,'2010-3-12','Paris','Geo positioning system','Web',1,295);
insert into exped values (524,'2010-3-13','Paris','Exploring in 10 Easy Lessons','Web',2,40);
insert into exped values (525,'2010-1-21','Sydney','Compass','Store',2,16);
insert into exped values (526,'2010-3-20','London','Elephant polo stick','Store',1,352);
insert into exped values (527,'2010-8-4','London','Hat - polar explorer','Catalog',3,102);
insert into exped values (528,'2010-11-16','London','Geo positioning system','Store',3,885);
insert into exped values (529,'2010-4-27','Sydney','Hat - polar explorer','Catalog',4,136);
insert into exped values (530,'2010-2-9','Paris','Geo positioning system','Store',3,885);
insert into exped values (531,'2010-9-26','Tokyo','Compass','Store',4,32);
insert into exped values (532,'2010-9-22','London','How to Win Foreign Friends','Store',5,130);
insert into exped values (533,'2010-1-20','Paris','Camel saddle','Store',1,598);
insert into exped values (534,'2010-3-18','Sydney','Camel saddle','Store',3,1794);
insert into exped values (535,'2010-3-18','Paris','Compass','Store',2,16);
insert into exped values (536,'2010-2-2','Paris','Map case','Store',4,60);
insert into exped values (537,'2010-5-11','Paris','How to Win Foreign Friends','Store',3,78);
insert into exped values (538,'2010-1-21','Paris','Geo positioning system','Store',1,295);
insert into exped values (539,'2010-10-4','Tokyo','Elephant polo stick','Store',2,704);
insert into exped values (540,'2010-4-21','London','Compass','Store',3,24);
insert into exped values (541,'2010-4-13','Sydney','Elephant polo stick','Catalog',4,1408);
insert into exped values (542,'2010-4-23','Tokyo','Map case','Web',3,45);
insert into exped values (543,'2010-12-21','London','Hat - polar explorer','Store',3,102);
insert into exped values (544,'2010-8-1','Tokyo','Hat - polar explorer','Store',2,68);
insert into exped values (545,'2010-10-29','Paris','Exploring in 10 Easy Lessons','Store',4,80);
insert into exped values (546,'2010-8-17','New York','Exploring in 10 Easy Lessons','Store',2,40);
insert into exped values (547,'2010-12-24','London','Elephant polo stick','Store',1,352);
insert into exped values (548,'2010-8-6','Paris','Hammock','Store',2,110);
insert into exped values (549,'2010-6-20','London','Compass','Store',5,40);
insert into exped values (550,'2010-4-12','Paris','Compass','Store',5,40);
insert into exped values (551,'2010-6-13','Sydney','Hammock','Store',4,220);
insert into exped values (552,'2010-4-13','London','Map case','Store',2,30);
insert into exped values (553,'2010-6-2','Paris','Exploring in 10 Easy Lessons','Store',1,20);
insert into exped values (554,'2010-2-2','London','Geo positioning system','Store',2,590);
insert into exped values (555,'2010-10-26','Paris','Hat - polar explorer','Store',4,136);
insert into exped values (556,'2010-10-8','London','Geo positioning system','Store',5,1475);
insert into exped values (557,'2010-3-21','London','Camel saddle','Web',1,598);
insert into exped values (558,'2010-8-1','Tokyo','Boots - snakeproof','Store',5,475);
insert into exped values (559,'2010-5-6','Paris','Camel saddle','Store',5,2990);
insert into exped values (560,'2010-6-19','Tokyo','Camel saddle','Store',4,2392);
insert into exped values (561,'2010-12-25','Paris','Elephant polo stick','Store',4,1408);
insert into exped values (562,'2010-10-5','New York','Compass','Store',3,24);
insert into exped values (563,'2010-11-16','Paris','Compass','Store',5,40);
insert into exped values (564,'2010-9-19','New York','Exploring in 10 Easy Lessons','Store',4,80);
insert into exped values (565,'2010-12-4','London','Hat - polar explorer','Store',4,136);
insert into exped values (566,'2010-12-23','Tokyo','Elephant polo stick','Store',4,1408);
insert into exped values (567,'2010-12-28','London','Compass','Store',2,16);
insert into exped values (568,'2010-12-28','New York','Compass','Store',3,24);
insert into exped values (569,'2010-8-7','London','How to Win Foreign Friends','Store',5,130);
insert into exped values (570,'2010-7-1','London','How to Win Foreign Friends','Store',2,52);
insert into exped values (571,'2010-11-9','London','Elephant polo stick','Catalog',1,352);
insert into exped values (572,'2010-6-9','Paris','Exploring in 10 Easy Lessons','Store',3,60);
insert into exped values (573,'2010-12-10','Paris','Map case','Store',2,30);
insert into exped values (574,'2010-1-12','New York','Camel saddle','Store',4,2392);
insert into exped values (575,'2010-12-29','Paris','Hat - polar explorer','Store',4,136);
insert into exped values (576,'2010-5-13','London','Compass','Store',2,16);
insert into exped values (577,'2010-8-1','Paris','Boots - snakeproof','Store',3,285);
insert into exped values (578,'2010-6-5','London','Hammock','Store',4,220);
insert into exped values (579,'2010-12-16','London','Camel saddle','Store',3,1794);
insert into exped values (580,'2010-1-28','Paris','Camel saddle','Store',5,2990);
insert into exped values (581,'2010-6-10','Paris','Hammock','Store',5,275);
insert into exped values (582,'2010-8-19','New York','Compass','Store',4,32);
insert into exped values (583,'2010-11-24','London','Exploring in 10 Easy Lessons','Catalog',2,40);
insert into exped values (584,'2010-4-29','New York','Hammock','Store',5,275);
insert into exped values (585,'2010-10-19','Paris','Geo positioning system','Catalog',4,1180);
insert into exped values (586,'2010-11-20','London','Map case','Store',4,60);
insert into exped values (587,'2010-4-28','New York','Geo positioning system','Catalog',1,295);
insert into exped values (588,'2010-1-29','Paris','Boots - snakeproof','Store',4,380);
insert into exped values (589,'2010-3-24','Paris','How to Win Foreign Friends','Catalog',5,130);
insert into exped values (590,'2010-8-3','Paris','Hat - polar explorer','Store',3,102);
insert into exped values (591,'2010-6-26','London','Boots - snakeproof','Store',2,190);
insert into exped values (592,'2010-2-24','Paris','How to Win Foreign Friends','Store',4,104);
insert into exped values (593,'2010-10-12','London','Elephant polo stick','Store',4,1408);
insert into exped values (594,'2010-10-21','Paris','Compass','Store',1,8);
insert into exped values (595,'2010-12-5','Sydney','How to Win Foreign Friends','Store',2,52);
insert into exped values (596,'2010-2-8','London','Map case','Store',3,45);
insert into exped values (597,'2010-2-19','Paris','Hat - polar explorer','Store',1,34);
insert into exped values (598,'2010-2-26','Tokyo','Map case','Catalog',2,30);
insert into exped values (599,'2010-3-31','Sydney','Hammock','Catalog',2,110);
insert into exped values (600,'2010-10-14','Tokyo','How to Win Foreign Friends','Store',2,52);
insert into exped values (601,'2010-5-29','New York','Elephant polo stick','Store',2,704);
insert into exped values (602,'2010-9-2','London','Exploring in 10 Easy Lessons','Store',2,40);
insert into exped values (603,'2010-9-15','London','Camel saddle','Catalog',2,1196);
insert into exped values (604,'2010-7-1','London','Camel saddle','Store',3,1794);
insert into exped values (605,'2010-5-28','New York','How to Win Foreign Friends','Store',2,52);
insert into exped values (606,'2010-3-23','London','Exploring in 10 Easy Lessons','Store',4,80);
insert into exped values (607,'2010-3-18','Tokyo','Map case','Store',2,30);
insert into exped values (608,'2010-4-18','London','Hat - polar explorer','Store',2,68);
insert into exped values (609,'2010-1-21','London','Geo positioning system','Store',2,590);
insert into exped values (610,'2010-10-10','Paris','Compass','Store',5,40);
insert into exped values (611,'2010-7-11','Paris','Geo positioning system','Store',2,590);
insert into exped values (612,'2010-8-23','New York','Geo positioning system','Store',1,295);
insert into exped values (613,'2010-7-11','Paris','How to Win Foreign Friends','Store',2,52);
insert into exped values (614,'2010-8-13','London','Camel saddle','Store',2,1196);
insert into exped values (615,'2010-5-23','Tokyo','Geo positioning system','Store',4,1180);
insert into exped values (616,'2010-5-19','Paris','Hat - polar explorer','Catalog',5,170);
insert into exped values (617,'2010-6-16','Paris','Map case','Store',5,75);
insert into exped values (618,'2010-5-22','London','Exploring in 10 Easy Lessons','Store',1,20);
insert into exped values (619,'2010-6-5','London','Map case','Store',3,45);
insert into exped values (620,'2010-8-23','London','Hat - polar explorer','Store',5,170);
insert into exped values (621,'2010-10-13','Tokyo','Map case','Store',1,15);
insert into exped values (622,'2010-4-12','Paris','Elephant polo stick','Store',2,704);
insert into exped values (623,'2010-8-26','London','Hat - polar explorer','Catalog',2,68);
insert into exped values (624,'2010-12-28','London','Boots - snakeproof','Web',1,95);
insert into exped values (625,'2010-6-6','Paris','Elephant polo stick','Store',4,1408);
insert into exped values (626,'2010-10-1','Paris','Hat - polar explorer','Store',1,34);
insert into exped values (627,'2010-8-10','Paris','Hammock','Store',2,110);
insert into exped values (628,'2010-5-16','Sydney','Hat - polar explorer','Store',4,136);
insert into exped values (629,'2010-7-22','London','How to Win Foreign Friends','Store',1,26);
insert into exped values (630,'2010-10-29','Paris','Map case','Store',2,30);
insert into exped values (631,'2010-1-8','London','Elephant polo stick','Store',4,1408);
insert into exped values (632,'2010-2-24','London','Compass','Store',4,32);
insert into exped values (633,'2010-6-7','Paris','Camel saddle','Catalog',3,1794);
insert into exped values (634,'2010-12-29','London','How to Win Foreign Friends','Store',3,78);
insert into exped values (635,'2010-10-1','London','Camel saddle','Catalog',2,1196);
insert into exped values (636,'2010-3-4','London','Geo positioning system','Catalog',2,590);
insert into exped values (637,'2010-7-9','Paris','Hammock','Store',5,275);
insert into exped values (638,'2010-5-3','Paris','Hat - polar explorer','Store',5,170);
insert into exped values (639,'2010-1-28','Sydney','Exploring in 10 Easy Lessons','Catalog',3,60);
insert into exped values (640,'2010-4-27','London','Map case','Store',3,45);
insert into exped values (641,'2010-7-31','London','Exploring in 10 Easy Lessons','Store',2,40);
insert into exped values (642,'2010-1-27','London','Exploring in 10 Easy Lessons','Store',4,80);
insert into exped values (643,'2010-4-4','London','Geo positioning system','Catalog',1,295);
insert into exped values (644,'2010-10-20','Paris','Geo positioning system','Store',1,295);
insert into exped values (645,'2010-5-28','New York','Hat - polar explorer','Store',2,68);
insert into exped values (646,'2010-7-28','London','Camel saddle','Store',1,598);
insert into exped values (647,'2010-7-24','London','Geo positioning system','Web',1,295);
insert into exped values (648,'2010-5-23','London','Geo positioning system','Store',2,590);
insert into exped values (649,'2010-1-22','London','Hammock','Store',1,55);
insert into exped values (650,'2010-10-23','London','Geo positioning system','Store',2,590);
insert into exped values (651,'2010-4-10','Paris','Camel saddle','Store',3,1794);
insert into exped values (652,'2010-8-15','Paris','Compass','Store',5,40);
insert into exped values (653,'2010-6-15','London','Hammock','Store',3,165);
insert into exped values (654,'2010-6-24','London','Map case','Store',3,45);
insert into exped values (655,'2010-6-6','Paris','Hammock','Catalog',2,110);
insert into exped values (656,'2010-7-3','London','How to Win Foreign Friends','Store',3,78);
insert into exped values (657,'2010-11-20','London','Hat - polar explorer','Store',3,102);
insert into exped values (658,'2010-4-2','London','Map case','Catalog',1,15);
insert into exped values (659,'2010-10-11','Tokyo','Map case','Web',4,60);
insert into exped values (660,'2010-12-16','London','Elephant polo stick','Catalog',1,352);
insert into exped values (661,'2010-8-6','London','Geo positioning system','Store',1,295);
insert into exped values (662,'2010-12-9','London','Geo positioning system','Store',4,1180);
insert into exped values (663,'2010-1-6','Tokyo','How to Win Foreign Friends','Store',4,104);
insert into exped values (664,'2010-3-30','London','Geo positioning system','Store',2,590);
insert into exped values (665,'2010-12-22','Tokyo','Geo positioning system','Store',5,1475);
insert into exped values (666,'2010-1-16','London','Boots - snakeproof','Store',5,475);
insert into exped values (667,'2010-12-7','Tokyo','Hat - polar explorer','Catalog',1,34);
insert into exped values (668,'2010-10-18','Paris','Hammock','Store',4,220);
insert into exped values (669,'2010-8-23','Sydney','Exploring in 10 Easy Lessons','Catalog',5,100);
insert into exped values (670,'2010-3-22','Tokyo','Hat - polar explorer','Web',1,34);
insert into exped values (671,'2010-5-27','London','How to Win Foreign Friends','Store',2,52);
insert into exped values (672,'2010-12-8','Paris','Hammock','Store',5,275);
insert into exped values (673,'2010-3-23','New York','Geo positioning system','Catalog',1,295);
insert into exped values (674,'2010-10-19','Paris','Camel saddle','Store',4,2392);
insert into exped values (675,'2010-6-24','London','Hat - polar explorer','Store',3,102);
insert into exped values (676,'2010-9-28','Paris','Geo positioning system','Store',5,1475);
insert into exped values (677,'2010-4-7','Sydney','Elephant polo stick','Store',4,1408);
insert into exped values (678,'2010-3-6','Paris','Compass','Catalog',2,16);
insert into exped values (679,'2010-6-23','Paris','Hammock','Catalog',2,110);
insert into exped values (680,'2010-9-1','London','Exploring in 10 Easy Lessons','Store',5,100);
insert into exped values (681,'2010-10-6','London','Camel saddle','Catalog',3,1794);
insert into exped values (682,'2010-9-10','Sydney','Exploring in 10 Easy Lessons','Catalog',2,40);
insert into exped values (683,'2010-4-25','London','Boots - snakeproof','Store',1,95);
insert into exped values (684,'2010-5-7','Paris','Hat - polar explorer','Store',2,68);
insert into exped values (685,'2010-2-9','London','Hat - polar explorer','Store',2,68);
insert into exped values (686,'2010-2-12','Paris','Elephant polo stick','Store',1,352);
insert into exped values (687,'2010-9-30','Paris','Geo positioning system','Store',2,590);
insert into exped values (688,'2010-11-13','New York','Compass','Store',2,16);
insert into exped values (689,'2010-7-8','London','Hammock','Catalog',2,110);
insert into exped values (690,'2010-7-14','Paris','How to Win Foreign Friends','Store',2,52);
insert into exped values (691,'2010-12-18','New York','Camel saddle','Catalog',2,1196);
insert into exped values (692,'2010-10-25','London','Hammock','Store',2,110);
insert into exped values (693,'2010-12-15','Paris','Hat - polar explorer','Store',2,68);
insert into exped values (694,'2010-5-20','Paris','Hat - polar explorer','Catalog',1,34);
insert into exped values (695,'2010-11-4','London','Elephant polo stick','Store',4,1408);
insert into exped values (696,'2010-8-12','Paris','Elephant polo stick','Store',3,1056);
insert into exped values (697,'2010-4-22','Paris','Map case','Store',1,15);
insert into exped values (698,'2010-10-2','Paris','Hammock','Store',2,110);
insert into exped values (699,'2010-10-25','London','How to Win Foreign Friends','Store',5,130);
insert into exped values (700,'2010-9-9','Paris','Camel saddle','Catalog',4,2392);
insert into exped values (701,'2010-3-30','London','Exploring in 10 Easy Lessons','Catalog',5,100);
insert into exped values (702,'2010-1-11','London','Map case','Web',1,15);
insert into exped values (703,'2010-6-20','Paris','Hat - polar explorer','Store',2,68);
insert into exped values (704,'2010-3-15','Tokyo','Geo positioning system','Store',2,590);
insert into exped values (705,'2010-12-2','Tokyo','Hat - polar explorer','Catalog',4,136);
insert into exped values (706,'2010-9-5','Paris','How to Win Foreign Friends','Store',4,104);
insert into exped values (707,'2010-11-8','Paris','Exploring in 10 Easy Lessons','Catalog',1,20);
insert into exped values (708,'2010-9-24','London','Geo positioning system','Store',3,885);
insert into exped values (709,'2010-4-5','Sydney','Geo positioning system','Web',2,590);
insert into exped values (710,'2010-2-2','London','Exploring in 10 Easy Lessons','Store',3,60);
insert into exped values (711,'2010-4-11','Paris','Elephant polo stick','Store',5,1760);
insert into exped values (712,'2010-9-25','Sydney','Exploring in 10 Easy Lessons','Store',5,100);
insert into exped values (713,'2010-7-20','London','Hat - polar explorer','Store',3,102);
insert into exped values (714,'2010-6-23','London','Compass','Store',3,24);
insert into exped values (715,'2010-6-8','Paris','Elephant polo stick','Catalog',5,1760);
insert into exped values (716,'2010-10-30','New York','Map case','Catalog',5,75);
insert into exped values (717,'2010-1-19','Paris','Camel saddle','Store',4,2392);
insert into exped values (718,'2010-7-17','Sydney','Hammock','Catalog',5,275);
insert into exped values (719,'2010-4-14','Paris','Hat - polar explorer','Catalog',3,102);
insert into exped values (720,'2010-6-30','Sydney','Hammock','Store',5,275);
insert into exped values (721,'2010-6-8','Paris','Hat - polar explorer','Store',4,136);
insert into exped values (722,'2010-9-21','London','How to Win Foreign Friends','Catalog',2,52);
insert into exped values (723,'2010-9-29','London','How to Win Foreign Friends','Store',1,26);
insert into exped values (724,'2010-10-31','London','How to Win Foreign Friends','Store',5,130);
insert into exped values (725,'2010-10-2','Paris','Exploring in 10 Easy Lessons','Store',2,40);
insert into exped values (726,'2010-6-17','Paris','Map case','Store',3,45);
insert into exped values (727,'2010-12-25','London','Hammock','Catalog',3,165);
insert into exped values (728,'2010-5-30','London','Hat - polar explorer','Store',3,102);
insert into exped values (729,'2010-11-19','London','Boots - snakeproof','Store',2,190);
insert into exped values (730,'2010-7-24','Tokyo','Elephant polo stick','Web',3,1056);
insert into exped values (731,'2010-5-27','London','Elephant polo stick','Store',5,1760);
insert into exped values (732,'2010-3-5','London','Geo positioning system','Store',1,295);
insert into exped values (733,'2010-1-8','Paris','Hat - polar explorer','Web',1,34);
insert into exped values (734,'2010-8-1','London','Elephant polo stick','Catalog',5,1760);
insert into exped values (735,'2010-10-13','Tokyo','Map case','Store',2,30);
insert into exped values (736,'2010-2-13','Paris','Boots - snakeproof','Store',4,380);
insert into exped values (737,'2010-11-16','Sydney','Geo positioning system','Store',2,590);
insert into exped values (738,'2010-10-15','London','Boots - snakeproof','Store',3,285);
insert into exped values (739,'2010-12-5','New York','Hammock','Store',3,165);
insert into exped values (740,'2010-5-16','Sydney','Hat - polar explorer','Catalog',3,102);
insert into exped values (741,'2010-4-13','London','Geo positioning system','Catalog',4,1180);
insert into exped values (742,'2010-9-1','New York','Elephant polo stick','Catalog',2,704);
insert into exped values (743,'2010-7-23','London','Elephant polo stick','Store',2,704);
insert into exped values (744,'2010-11-28','London','Hat - polar explorer','Catalog',2,68);
insert into exped values (745,'2010-7-18','Paris','Camel saddle','Store',3,1794);
insert into exped values (746,'2010-6-21','London','Hammock','Catalog',2,110);
insert into exped values (747,'2010-10-11','Paris','How to Win Foreign Friends','Store',2,52);
insert into exped values (748,'2010-1-5','Paris','Map case','Store',2,30);
insert into exped values (749,'2010-12-7','London','Elephant polo stick','Store',2,704);
insert into exped values (750,'2010-7-17','London','Camel saddle','Store',5,2990);
insert into exped values (751,'2010-11-26','London','How to Win Foreign Friends','Catalog',4,104);
insert into exped values (752,'2010-3-23','Tokyo','Compass','Store',1,8);
insert into exped values (753,'2010-1-24','London','Elephant polo stick','Store',3,1056);
insert into exped values (754,'2010-2-24','New York','Hat - polar explorer','Store',3,102);
insert into exped values (755,'2010-12-13','London','Compass','Catalog',4,32);
insert into exped values (756,'2010-8-15','Paris','Map case','Catalog',3,45);
insert into exped values (757,'2010-9-9','Paris','Exploring in 10 Easy Lessons','Catalog',4,80);
insert into exped values (758,'2010-9-7','London','How to Win Foreign Friends','Catalog',4,104);
insert into exped values (759,'2010-6-3','London','Boots - snakeproof','Store',2,190);
insert into exped values (760,'2010-5-28','Sydney','Exploring in 10 Easy Lessons','Store',4,80);
insert into exped values (761,'2010-7-20','Sydney','How to Win Foreign Friends','Web',4,104);
insert into exped values (762,'2010-5-11','London','Elephant polo stick','Store',3,1056);
insert into exped values (763,'2010-9-15','Paris','Hat - polar explorer','Store',5,170);
insert into exped values (764,'2010-6-6','Paris','Compass','Store',5,40);
insert into exped values (765,'2010-11-28','London','Geo positioning system','Store',4,1180);
insert into exped values (766,'2010-4-4','Paris','Hammock','Web',2,110);
insert into exped values (767,'2010-11-29','Tokyo','Camel saddle','Store',1,598);
insert into exped values (768,'2010-9-3','Tokyo','Hat - polar explorer','Store',2,68);
insert into exped values (769,'2010-11-28','London','Compass','Store',3,24);
insert into exped values (770,'2010-5-3','London','Camel saddle','Store',1,598);
insert into exped values (771,'2010-12-14','London','Elephant polo stick','Store',2,704);
insert into exped values (772,'2010-9-17','London','Exploring in 10 Easy Lessons','Store',2,40);
insert into exped values (773,'2010-9-27','London','Compass','Catalog',2,16);
insert into exped values (774,'2010-3-24','London','How to Win Foreign Friends','Store',3,78);
insert into exped values (775,'2010-10-9','London','Compass','Store',3,24);
insert into exped values (776,'2010-2-10','Paris','Hat - polar explorer','Store',5,170);
insert into exped values (777,'2010-12-13','Tokyo','Geo positioning system','Store',5,1475);
insert into exped values (778,'2010-1-16','Tokyo','How to Win Foreign Friends','Catalog',3,78);
insert into exped values (779,'2010-9-22','Sydney','Elephant polo stick','Store',2,704);
insert into exped values (780,'2010-12-6','Tokyo','Hat - polar explorer','Store',3,102);
insert into exped values (781,'2010-12-12','New York','Geo positioning system','Store',4,1180);
insert into exped values (782,'2010-8-27','London','Hammock','Store',4,220);
insert into exped values (783,'2010-5-15','Sydney','Boots - snakeproof','Store',2,190);
insert into exped values (784,'2010-6-29','Sydney','Geo positioning system','Store',3,885);
insert into exped values (785,'2010-11-1','Paris','Camel saddle','Catalog',3,1794);
insert into exped values (786,'2010-12-17','New York','Elephant polo stick','Store',2,704);
insert into exped values (787,'2010-12-22','Sydney','Exploring in 10 Easy Lessons','Store',4,80);
insert into exped values (788,'2010-6-4','Paris','How to Win Foreign Friends','Store',3,78);
insert into exped values (789,'2010-6-5','Paris','Elephant polo stick','Catalog',2,704);
insert into exped values (790,'2010-1-27','New York','Geo positioning system','Store',2,590);
insert into exped values (791,'2010-10-8','Paris','Geo positioning system','Store',2,590);
insert into exped values (792,'2010-10-18','Tokyo','Geo positioning system','Store',3,885);
insert into exped values (793,'2010-7-15','London','Map case','Store',2,30);
insert into exped values (794,'2010-7-3','London','Hat - polar explorer','Store',5,170);
insert into exped values (795,'2010-6-24','Paris','How to Win Foreign Friends','Store',2,52);
insert into exped values (796,'2010-3-25','London','Map case','Catalog',3,45);
insert into exped values (797,'2010-8-2','Sydney','Map case','Store',2,30);
insert into exped values (798,'2010-9-1','Paris','Map case','Catalog',4,60);
insert into exped values (799,'2010-5-8','London','How to Win Foreign Friends','Store',2,52);
insert into exped values (800,'2010-11-30','Paris','Hat - polar explorer','Catalog',2,68);
insert into exped values (801,'2010-11-10','Paris','Hat - polar explorer','Store',2,68);
insert into exped values (802,'2010-4-23','London','Camel saddle','Store',3,1794);
insert into exped values (803,'2010-10-25','New York','Geo positioning system','Store',5,1475);
insert into exped values (804,'2010-10-11','Sydney','Geo positioning system','Store',4,1180);
insert into exped values (805,'2010-3-27','New York','Boots - snakeproof','Store',5,475);
insert into exped values (806,'2010-8-28','London','Map case','Store',4,60);
insert into exped values (807,'2010-5-20','Sydney','Hat - polar explorer','Store',2,68);
insert into exped values (808,'2010-11-2','Tokyo','How to Win Foreign Friends','Catalog',2,52);
insert into exped values (809,'2010-9-8','Paris','Geo positioning system','Web',3,885);
insert into exped values (810,'2010-9-8','London','Camel saddle','Store',2,1196);
insert into exped values (811,'2010-3-6','Tokyo','Elephant polo stick','Store',2,704);
insert into exped values (812,'2010-1-22','New York','Compass','Store',4,32);
insert into exped values (813,'2010-3-25','New York','Elephant polo stick','Store',2,704);
insert into exped values (814,'2010-6-14','Tokyo','Hammock','Store',2,110);
insert into exped values (815,'2010-12-1','London','Elephant polo stick','Web',4,1408);
insert into exped values (816,'2010-3-18','New York','Elephant polo stick','Store',3,1056);
insert into exped values (817,'2010-5-24','Tokyo','Camel saddle','Store',2,1196);
insert into exped values (818,'2010-3-5','Paris','Exploring in 10 Easy Lessons','Store',4,80);
insert into exped values (819,'2010-9-25','Tokyo','Exploring in 10 Easy Lessons','Store',2,40);
insert into exped values (820,'2010-3-22','New York','Boots - snakeproof','Store',1,95);
insert into exped values (821,'2010-4-30','Tokyo','Boots - snakeproof','Store',3,285);
insert into exped values (822,'2010-4-19','London','How to Win Foreign Friends','Catalog',1,26);
insert into exped values (823,'2010-3-4','Paris','Elephant polo stick','Store',4,1408);
insert into exped values (824,'2010-4-21','New York','Geo positioning system','Web',4,1180);
insert into exped values (825,'2010-4-24','New York','Elephant polo stick','Store',2,704);
insert into exped values (826,'2010-12-29','Tokyo','Map case','Catalog',4,60);
insert into exped values (827,'2010-7-24','Paris','Geo positioning system','Catalog',4,1180);
insert into exped values (828,'2010-2-11','Paris','How to Win Foreign Friends','Catalog',2,52);
insert into exped values (829,'2010-1-22','Paris','Hammock','Store',5,275);
insert into exped values (830,'2010-1-12','Paris','How to Win Foreign Friends','Store',2,52);
insert into exped values (831,'2010-2-28','London','Compass','Catalog',2,16);
insert into exped values (832,'2010-5-11','Paris','Geo positioning system','Store',3,885);
insert into exped values (833,'2010-12-1','Paris','Compass','Store',5,40);
insert into exped values (834,'2010-3-5','Tokyo','Hat - polar explorer','Store',3,102);
insert into exped values (835,'2010-5-11','London','Elephant polo stick','Web',1,352);
insert into exped values (836,'2010-5-23','Paris','Camel saddle','Store',3,1794);
insert into exped values (837,'2010-5-31','Paris','Map case','Store',3,45);
insert into exped values (838,'2010-2-9','London','Camel saddle','Store',5,2990);
insert into exped values (839,'2010-6-1','London','Compass','Store',4,32);
insert into exped values (840,'2010-2-1','London','Geo positioning system','Store',5,1475);
insert into exped values (841,'2010-3-27','Tokyo','Compass','Store',3,24);
insert into exped values (842,'2010-11-7','Tokyo','Compass','Store',5,40);
insert into exped values (843,'2010-12-2','London','Elephant polo stick','Store',4,1408);
insert into exped values (844,'2010-1-20','Sydney','Map case','Catalog',5,75);
insert into exped values (845,'2010-7-30','Paris','Boots - snakeproof','Catalog',5,475);
insert into exped values (846,'2010-9-26','London','Map case','Store',4,60);
insert into exped values (847,'2010-8-8','London','Hammock','Catalog',3,165);
insert into exped values (848,'2010-8-3','London','Hat - polar explorer','Store',4,136);
insert into exped values (849,'2010-1-16','London','Elephant polo stick','Store',4,1408);
insert into exped values (850,'2010-3-15','Sydney','How to Win Foreign Friends','Catalog',4,104);
insert into exped values (851,'2010-3-24','London','Exploring in 10 Easy Lessons','Store',4,80);
insert into exped values (852,'2010-5-14','New York','Camel saddle','Store',2,1196);
insert into exped values (853,'2010-10-26','London','Camel saddle','Store',1,598);
insert into exped values (854,'2010-3-30','London','Elephant polo stick','Store',4,1408);
insert into exped values (855,'2010-10-28','London','Geo positioning system','Store',2,590);
insert into exped values (856,'2010-5-7','Paris','Elephant polo stick','Store',5,1760);
insert into exped values (857,'2010-11-14','Paris','Hat - polar explorer','Store',4,136);
insert into exped values (858,'2010-12-6','London','Hammock','Store',3,165);
insert into exped values (859,'2010-5-6','London','How to Win Foreign Friends','Web',3,78);
insert into exped values (860,'2010-3-30','Tokyo','How to Win Foreign Friends','Web',4,104);
insert into exped values (861,'2010-10-16','Paris','Camel saddle','Store',3,1794);
insert into exped values (862,'2010-11-13','London','Map case','Store',2,30);
insert into exped values (863,'2010-3-2','New York','Exploring in 10 Easy Lessons','Store',2,40);
insert into exped values (864,'2010-10-18','London','Camel saddle','Catalog',5,2990);
insert into exped values (865,'2010-3-12','Sydney','Hammock','Store',5,275);
insert into exped values (866,'2010-3-10','London','Map case','Store',5,75);
insert into exped values (867,'2010-8-17','London','Hammock','Catalog',4,220);
insert into exped values (868,'2010-6-20','Paris','Camel saddle','Web',4,2392);
insert into exped values (869,'2010-12-5','London','How to Win Foreign Friends','Web',2,52);
insert into exped values (870,'2010-10-21','Paris','Hat - polar explorer','Store',3,102);
insert into exped values (871,'2010-6-19','London','Compass','Store',5,40);
insert into exped values (872,'2010-3-23','London','Geo positioning system','Store',2,590);
insert into exped values (873,'2010-8-22','London','Geo positioning system','Store',2,590);
insert into exped values (874,'2010-7-29','London','Compass','Store',1,8);
insert into exped values (875,'2010-11-13','London','Elephant polo stick','Store',3,1056);
insert into exped values (876,'2010-4-29','New York','Geo positioning system','Store',3,885);
insert into exped values (877,'2010-10-9','London','Hammock','Store',1,55);
insert into exped values (878,'2010-7-7','Paris','Geo positioning system','Catalog',2,590);
insert into exped values (879,'2010-8-13','London','How to Win Foreign Friends','Store',2,52);
insert into exped values (880,'2010-12-31','Paris','Exploring in 10 Easy Lessons','Store',3,60);
insert into exped values (881,'2010-8-12','London','Camel saddle','Store',2,1196);
insert into exped values (882,'2010-10-24','Paris','Compass','Store',5,40);
insert into exped values (883,'2010-12-7','Sydney','Compass','Store',3,24);
insert into exped values (884,'2010-9-15','Tokyo','How to Win Foreign Friends','Store',4,104);
insert into exped values (885,'2010-4-14','London','Camel saddle','Store',1,598);
insert into exped values (886,'2010-4-12','London','Elephant polo stick','Store',1,352);
insert into exped values (887,'2010-9-11','New York','Geo positioning system','Store',4,1180);
insert into exped values (888,'2010-12-10','London','Geo positioning system','Catalog',4,1180);
insert into exped values (889,'2010-5-30','New York','Exploring in 10 Easy Lessons','Catalog',2,40);
insert into exped values (890,'2010-4-8','Sydney','Geo positioning system','Store',3,885);
insert into exped values (891,'2010-4-20','Paris','How to Win Foreign Friends','Store',4,104);
insert into exped values (892,'2010-6-11','London','Compass','Store',3,24);
insert into exped values (893,'2010-3-11','London','Hat - polar explorer','Store',1,34);
insert into exped values (894,'2010-9-3','London','Compass','Store',4,32);
insert into exped values (895,'2010-12-28','Tokyo','Elephant polo stick','Store',2,704);
insert into exped values (896,'2010-9-4','Paris','Camel saddle','Catalog',2,1196);
insert into exped values (897,'2010-5-31','Paris','How to Win Foreign Friends','Catalog',2,52);
insert into exped values (898,'2010-3-26','Paris','Exploring in 10 Easy Lessons','Store',2,40);
insert into exped values (899,'2010-12-4','London','How to Win Foreign Friends','Web',2,52);
insert into exped values (900,'2010-7-14','Paris','How to Win Foreign Friends','Store',3,78);
insert into exped values (901,'2010-7-14','New York','Compass','Store',4,32);
insert into exped values (902,'2010-12-26','London','Hammock','Store',4,220);
insert into exped values (903,'2010-4-21','Sydney','Camel saddle','Catalog',1,598);
insert into exped values (904,'2010-9-3','London','Compass','Catalog',5,40);
insert into exped values (905,'2010-9-17','London','Compass','Store',1,8);
insert into exped values (906,'2010-3-26','New York','Exploring in 10 Easy Lessons','Store',4,80);
insert into exped values (907,'2010-1-16','London','Elephant polo stick','Store',3,1056);
insert into exped values (908,'2010-9-14','Sydney','Compass','Store',5,40);
insert into exped values (909,'2010-7-10','Paris','Camel saddle','Store',5,2990);
insert into exped values (910,'2010-3-6','Paris','Hammock','Catalog',5,275);
insert into exped values (911,'2010-8-9','Paris','Map case','Catalog',4,60);
insert into exped values (912,'2010-7-6','London','Compass','Store',4,32);
insert into exped values (913,'2010-5-12','London','Compass','Store',4,32);
insert into exped values (914,'2010-10-26','London','Map case','Store',2,30);
insert into exped values (915,'2010-3-15','London','Geo positioning system','Store',3,885);
insert into exped values (916,'2010-7-26','New York','Geo positioning system','Store',3,885);
insert into exped values (917,'2010-10-2','London','Geo positioning system','Store',5,1475);
insert into exped values (918,'2010-7-31','London','Elephant polo stick','Store',2,704);
insert into exped values (919,'2010-8-19','Paris','Camel saddle','Catalog',3,1794);
insert into exped values (920,'2010-2-10','London','Elephant polo stick','Store',4,1408);
insert into exped values (921,'2010-8-2','London','Camel saddle','Catalog',4,2392);
insert into exped values (922,'2010-4-17','London','How to Win Foreign Friends','Store',4,104);
insert into exped values (923,'2010-8-6','New York','Geo positioning system','Store',2,590);
insert into exped values (924,'2010-3-25','London','Boots - snakeproof','Store',3,285);
insert into exped values (925,'2010-11-24','London','Elephant polo stick','Store',2,704);
insert into exped values (926,'2010-9-21','London','Exploring in 10 Easy Lessons','Store',4,80);
insert into exped values (927,'2010-12-25','London','Camel saddle','Store',5,2990);
insert into exped values (928,'2010-6-22','London','Boots - snakeproof','Store',3,285);
insert into exped values (929,'2010-5-17','London','Elephant polo stick','Store',4,1408);
insert into exped values (930,'2010-4-30','Paris','Geo positioning system','Store',4,1180);
insert into exped values (931,'2010-8-28','London','How to Win Foreign Friends','Store',3,78);
insert into exped values (932,'2010-9-4','New York','Hammock','Store',4,220);
insert into exped values (933,'2010-4-2','London','Compass','Store',4,32);
insert into exped values (934,'2010-6-2','Paris','Geo positioning system','Store',3,885);
insert into exped values (935,'2010-9-19','London','Exploring in 10 Easy Lessons','Store',3,60);
insert into exped values (936,'2010-12-8','Sydney','Geo positioning system','Store',1,295);
insert into exped values (937,'2010-6-12','London','Hat - polar explorer','Store',3,102);
insert into exped values (938,'2010-8-7','Paris','Geo positioning system','Store',3,885);
insert into exped values (939,'2010-7-28','Sydney','Camel saddle','Store',3,1794);
insert into exped values (940,'2010-12-29','Tokyo','Exploring in 10 Easy Lessons','Store',4,80);
insert into exped values (941,'2010-1-16','London','Camel saddle','Store',4,2392);
insert into exped values (942,'2010-1-27','London','Hat - polar explorer','Store',1,34);
insert into exped values (943,'2010-12-14','Paris','Hammock','Store',1,55);
insert into exped values (944,'2010-4-26','London','Compass','Store',3,24);
insert into exped values (945,'2010-7-12','London','Camel saddle','Web',4,2392);
insert into exped values (946,'2010-1-31','London','Exploring in 10 Easy Lessons','Web',5,100);
insert into exped values (947,'2010-12-17','London','Hat - polar explorer','Store',3,102);
insert into exped values (948,'2010-7-28','Paris','Hat - polar explorer','Store',1,34);
insert into exped values (949,'2010-5-20','New York','Exploring in 10 Easy Lessons','Store',5,100);
insert into exped values (950,'2010-7-9','Paris','Hammock','Web',5,275);
insert into exped values (951,'2010-6-13','London','Compass','Store',3,24);
insert into exped values (952,'2010-10-23','London','Elephant polo stick','Store',3,1056);
insert into exped values (953,'2010-5-10','Paris','Geo positioning system','Store',4,1180);
insert into exped values (954,'2010-3-13','New York','How to Win Foreign Friends','Catalog',3,78);
insert into exped values (955,'2010-8-20','Paris','Elephant polo stick','Store',2,704);
insert into exped values (956,'2010-8-21','Paris','Elephant polo stick','Store',3,1056);
insert into exped values (957,'2010-4-14','London','Exploring in 10 Easy Lessons','Store',3,60);
insert into exped values (958,'2010-4-30','Sydney','Hammock','Store',1,55);
insert into exped values (959,'2010-9-15','London','Hammock','Store',1,55);
insert into exped values (960,'2010-10-3','Tokyo','Geo positioning system','Store',4,1180);
insert into exped values (961,'2010-12-22','New York','Map case','Catalog',2,30);
insert into exped values (962,'2010-4-2','Sydney','Exploring in 10 Easy Lessons','Store',1,20);
insert into exped values (963,'2010-5-31','Paris','Compass','Store',3,24);
insert into exped values (964,'2010-5-11','London','Boots - snakeproof','Web',1,95);
insert into exped values (965,'2010-11-1','London','Geo positioning system','Store',3,885);
insert into exped values (966,'2010-6-6','Sydney','Hat - polar explorer','Store',1,34);
insert into exped values (967,'2010-12-26','Sydney','Compass','Catalog',3,24);
insert into exped values (968,'2010-8-29','Paris','Geo positioning system','Store',2,590);
insert into exped values (969,'2010-2-6','Sydney','Exploring in 10 Easy Lessons','Store',3,60);
insert into exped values (970,'2010-11-23','Paris','Compass','Store',1,8);
insert into exped values (971,'2010-10-2','London','Geo positioning system','Store',3,885);
insert into exped values (972,'2010-2-3','Paris','Elephant polo stick','Store',5,1760);
insert into exped values (973,'2010-4-14','Tokyo','Geo positioning system','Store',2,590);
insert into exped values (974,'2010-8-8','Paris','Hammock','Store',1,55);
insert into exped values (975,'2010-6-23','Paris','Hat - polar explorer','Store',3,102);
insert into exped values (976,'2010-2-15','Tokyo','Geo positioning system','Catalog',2,590);
insert into exped values (977,'2010-4-17','London','Hat - polar explorer','Catalog',5,170);
insert into exped values (978,'2010-11-29','Paris','Hat - polar explorer','Catalog',5,170);
insert into exped values (979,'2010-3-31','Sydney','Hat - polar explorer','Store',2,68);
insert into exped values (980,'2010-6-4','Sydney','How to Win Foreign Friends','Store',1,26);
insert into exped values (981,'2010-3-29','Tokyo','Camel saddle','Store',3,1794);
insert into exped values (982,'2010-5-21','Tokyo','Hat - polar explorer','Store',4,136);
insert into exped values (983,'2010-4-27','London','Elephant polo stick','Store',3,1056);
insert into exped values (984,'2010-11-15','Sydney','Camel saddle','Store',4,2392);
insert into exped values (985,'2010-7-5','London','Camel saddle','Store',5,2990);
insert into exped values (986,'2010-9-22','London','Hammock','Store',2,110);
insert into exped values (987,'2010-4-9','London','Compass','Catalog',2,16);
insert into exped values (988,'2010-1-25','Paris','Elephant polo stick','Store',4,1408);
insert into exped values (989,'2010-6-12','London','Geo positioning system','Catalog',3,885);
insert into exped values (990,'2010-1-21','Paris','Hammock','Store',1,55);
insert into exped values (991,'2010-6-1','Paris','Hat - polar explorer','Catalog',3,102);
insert into exped values (992,'2010-2-24','New York','Map case','Store',3,45);
insert into exped values (993,'2010-3-5','Paris','Elephant polo stick','Store',2,704);
insert into exped values (994,'2010-7-14','London','Geo positioning system','Catalog',3,885);
insert into exped values (995,'2010-4-7','Paris','Hat - polar explorer','Store',2,68);
insert into exped values (996,'2010-2-10','London','Camel saddle','Catalog',5,2990);
insert into exped values (997,'2010-3-13','London','Geo positioning system','Store',4,1180);
insert into exped values (998,'2010-9-22','London','Map case','Store',5,75);
insert into exped values (999,'2010-4-23','New York','Exploring in 10 Easy Lessons','Store',4,80);
insert into exped values (1000,'2010-7-23','New York','Boots - snakeproof','Web',4,380);