|
INSERT INTO CATEGORIES VALUES (1,'Beverages', 'Soft drinks, coffees, teas, beers, and ales', null); |
|
INSERT INTO CATEGORIES VALUES (2,'Condiments', 'Sweet and savory sauces, relishes, spreads, and seasonings', null); |
|
INSERT INTO CATEGORIES VALUES (3,'Confections', 'Desserts, candies, and sweet breads', null); |
|
INSERT INTO CATEGORIES VALUES (4,'Dairy Products', 'Cheeses', null); |
|
INSERT INTO CATEGORIES VALUES (5,'Grains/Cereals', 'Breads, crackers, pasta, and cereal', null); |
|
INSERT INTO CATEGORIES VALUES (6,'Meat/Poultry', 'Prepared meats', null); |
|
INSERT INTO CATEGORIES VALUES (7,'Produce', 'Dried fruit and bean curd', null); |
|
INSERT INTO CATEGORIES VALUES (8,'Seafood', 'Seaweed and fish', null); |
|
|
|
|
|
Insert Into Region Values (1,'Eastern'); |
|
|
|
Insert Into Region Values (2,'Western'); |
|
|
|
Insert Into Region Values (3,'Northern'); |
|
|
|
Insert Into Region Values (4,'Southern'); |
|
|
|
|
|
Insert Into Territories Values ('01581','Westboro',1); |
|
|
|
Insert Into Territories Values ('01730','Bedford',1); |
|
|
|
Insert Into Territories Values ('01833','Georgetow',1); |
|
|
|
Insert Into Territories Values ('02116','Boston',1); |
|
|
|
Insert Into Territories Values ('02139','Cambridge',1); |
|
|
|
Insert Into Territories Values ('02184','Braintree',1); |
|
|
|
Insert Into Territories Values ('02903','Providence',1); |
|
|
|
Insert Into Territories Values ('03049','Hollis',3); |
|
|
|
Insert Into Territories Values ('03801','Portsmouth',3); |
|
|
|
Insert Into Territories Values ('06897','Wilton',1); |
|
|
|
Insert Into Territories Values ('07960','Morristown',1); |
|
|
|
Insert Into Territories Values ('08837','Edison',1); |
|
|
|
Insert Into Territories Values ('10019','New York',1); |
|
|
|
Insert Into Territories Values ('10038','New York',1); |
|
|
|
Insert Into Territories Values ('11747','Mellvile',1); |
|
|
|
Insert Into Territories Values ('14450','Fairport',1); |
|
|
|
Insert Into Territories Values ('19428','Philadelphia',3); |
|
|
|
Insert Into Territories Values ('19713','Neward',1); |
|
|
|
Insert Into Territories Values ('20852','Rockville',1); |
|
|
|
Insert Into Territories Values ('27403','Greensboro',1); |
|
|
|
Insert Into Territories Values ('27511','Cary',1); |
|
|
|
Insert Into Territories Values ('29202','Columbia',4); |
|
|
|
Insert Into Territories Values ('30346','Atlanta',4); |
|
|
|
Insert Into Territories Values ('31406','Savannah',4); |
|
|
|
Insert Into Territories Values ('32859','Orlando',4); |
|
|
|
Insert Into Territories Values ('33607','Tampa',4); |
|
|
|
Insert Into Territories Values ('40222','Louisville',1); |
|
|
|
Insert Into Territories Values ('44122','Beachwood',3); |
|
|
|
Insert Into Territories Values ('45839','Findlay',3); |
|
|
|
Insert Into Territories Values ('48075','Southfield',3); |
|
|
|
Insert Into Territories Values ('48084','Troy',3); |
|
|
|
Insert Into Territories Values ('48304','Bloomfield Hills',3); |
|
|
|
Insert Into Territories Values ('53404','Racine',3); |
|
|
|
Insert Into Territories Values ('55113','Roseville',3); |
|
|
|
Insert Into Territories Values ('55439','Minneapolis',3); |
|
|
|
Insert Into Territories Values ('60179','Hoffman Estates',2); |
|
|
|
Insert Into Territories Values ('60601','Chicago',2); |
|
|
|
Insert Into Territories Values ('72716','Bentonville',4); |
|
|
|
Insert Into Territories Values ('75234','Dallas',4); |
|
|
|
Insert Into Territories Values ('78759','Austin',4); |
|
|
|
Insert Into Territories Values ('80202','Denver',2); |
|
|
|
Insert Into Territories Values ('80909','Colorado Springs',2); |
|
|
|
Insert Into Territories Values ('85014','Phoenix',2); |
|
|
|
Insert Into Territories Values ('85251','Scottsdale',2); |
|
|
|
Insert Into Territories Values ('90405','Santa Monica',2); |
|
|
|
Insert Into Territories Values ('94025','Menlo Park',2); |
|
|
|
Insert Into Territories Values ('94105','San Francisco',2); |
|
|
|
Insert Into Territories Values ('95008','Campbell',2); |
|
|
|
Insert Into Territories Values ('95054','Santa Clara',2); |
|
|
|
Insert Into Territories Values ('95060','Santa Cruz',2); |
|
|
|
Insert Into Territories Values ('98004','Bellevue',2); |
|
|
|
Insert Into Territories Values ('98052','Redmond',2); |
|
|
|
Insert Into Territories Values ('98104','Seattle',2); |
|
|
|
|
|
INSERT INTO EMPLOYEES |
|
VALUES (1,'Davolio','Nancy','Sales Representative','Ms.',to_date('08-DEC-48','DD-MON-RR'),to_date('01-MAY-92','DD-MON-RR'),'507 - 20th Ave. E. |
|
Apt. 2A','Seattle','WA','98122','USA','(206) 555-9857','5467',null, null, null,'http://accweb/emmployees/davolio.bmp'); |
|
INSERT INTO EMPLOYEES |
|
VALUES (2,'Fuller','Andrew','Vice President, Sales','Dr.',to_date('19-FEB-52','DD-MON-RR'),to_date('14-AUG-92','DD-MON-RR'),'908 W. Capital Way','Tacoma','WA','98401','USA','(206) 555-9482','3457',null, null, null,'http://accweb/emmployees/fuller.bmp'); |
|
INSERT INTO EMPLOYEES |
|
VALUES (3,'Leverling','Janet','Sales Representative','Ms.',to_date('30-AUG-63','DD-MON-RR'),to_date('01-APR-92','DD-MON-RR'),'722 Moss Bay Blvd.','Kirkland','WA','98033','USA','(206) 555-3412','3355',null, null,2,'http://accweb/emmployees/leverling.bmp'); |
|
INSERT INTO EMPLOYEES |
|
VALUES (4,'Peacock','Margaret','Sales Representative','Mrs.',to_date('19-SEP-37','DD-MON-RR'),to_date('03-MAY-93','DD-MON-RR'),'4110 Old Redmond Rd.','Redmond','WA','98052','USA','(206) 555-8122','5176',null, null,2,'http://accweb/emmployees/peacock.bmp'); |
|
INSERT INTO EMPLOYEES |
|
VALUES (5,'Buchanan','Steven','Sales Manager','Mr.',to_date('04-MAR-55','DD-MON-RR'),to_date('17-OCT-93','DD-MON-RR'),'14 Garrett Hill','London',null,'SW1 8JR','UK','(71) 555-4848','3453',null, null,2,'http://accweb/emmployees/buchanan.bmp'); |
|
INSERT INTO EMPLOYEES |
|
VALUES (6,'Suyama','Michael','Sales Representative','Mr.',to_date('02-JUL-63','DD-MON-RR'),to_date('17-OCT-93','DD-MON-RR'),'Coventry House |
|
Miner Rd.','London',null,'EC2 7JR','UK','(71) 555-7773','428',null, null,5,'http://accweb/emmployees/davolio.bmp'); |
|
INSERT INTO EMPLOYEES |
|
VALUES (7,'King','Robert','Sales Representative','Mr.',to_date('29-MAY-60','DD-MON-RR'),to_date('02-JAN-94','DD-MON-RR'),'Edgeham Hollow |
|
Winchester Way','London',null,'RG1 9SP','UK','(71) 555-5598','465',null, null,5,'http://accweb/emmployees/davolio.bmp'); |
|
INSERT INTO EMPLOYEES |
|
VALUES (8,'Callahan','Laura','Inside Sales Coordinator','Ms.',to_date('09-JAN-58','DD-MON-RR'),to_date('05-MAR-94','DD-MON-RR'),'4726 - 11th Ave. N.E.','Seattle','WA','98105','USA','(206) 555-1189','2344',null, null,2,'http://accweb/emmployees/davolio.bmp'); |
|
INSERT INTO EMPLOYEES |
|
VALUES (9,'Dodsworth','Anne','Sales Representative','Ms.',to_date('27-JAN-66','DD-MON-RR'),to_date('15-NOV-94','DD-MON-RR'),'7 Houndstooth Rd.','London',null,'WG2 7LT','UK','(71) 555-4444','452',null, null,5,'http://accweb/emmployees/davolio.bmp'); |
|
|
|
UPDATE EMPLOYEES SET REPORTSTO = 2 WHERE EmployeeID = 1; |
|
|
|
|
|
Insert Into EmployeeTerritories Values (1,'06897'); |
|
|
|
Insert Into EmployeeTerritories Values (1,'19713'); |
|
|
|
Insert Into EmployeeTerritories Values (2,'01581'); |
|
|
|
Insert Into EmployeeTerritories Values (2,'01730'); |
|
|
|
Insert Into EmployeeTerritories Values (2,'01833'); |
|
|
|
Insert Into EmployeeTerritories Values (2,'02116'); |
|
|
|
Insert Into EmployeeTerritories Values (2,'02139'); |
|
|
|
Insert Into EmployeeTerritories Values (2,'02184'); |
|
|
|
Insert Into EmployeeTerritories Values (2,'40222'); |
|
|
|
Insert Into EmployeeTerritories Values (3,'30346'); |
|
|
|
Insert Into EmployeeTerritories Values (3,'31406'); |
|
|
|
Insert Into EmployeeTerritories Values (3,'32859'); |
|
|
|
Insert Into EmployeeTerritories Values (3,'33607'); |
|
|
|
Insert Into EmployeeTerritories Values (4,'20852'); |
|
|
|
Insert Into EmployeeTerritories Values (4,'27403'); |
|
|
|
Insert Into EmployeeTerritories Values (4,'27511'); |
|
|
|
Insert Into EmployeeTerritories Values (5,'02903'); |
|
|
|
Insert Into EmployeeTerritories Values (5,'07960'); |
|
|
|
Insert Into EmployeeTerritories Values (5,'08837'); |
|
|
|
Insert Into EmployeeTerritories Values (5,'10019'); |
|
|
|
Insert Into EmployeeTerritories Values (5,'10038'); |
|
|
|
Insert Into EmployeeTerritories Values (5,'11747'); |
|
|
|
Insert Into EmployeeTerritories Values (5,'14450'); |
|
|
|
Insert Into EmployeeTerritories Values (6,'85014'); |
|
|
|
Insert Into EmployeeTerritories Values (6,'85251'); |
|
|
|
Insert Into EmployeeTerritories Values (6,'98004'); |
|
|
|
Insert Into EmployeeTerritories Values (6,'98052'); |
|
|
|
Insert Into EmployeeTerritories Values (6,'98104'); |
|
|
|
Insert Into EmployeeTerritories Values (7,'60179'); |
|
|
|
Insert Into EmployeeTerritories Values (7,'60601'); |
|
|
|
Insert Into EmployeeTerritories Values (7,'80202'); |
|
|
|
Insert Into EmployeeTerritories Values (7,'80909'); |
|
|
|
Insert Into EmployeeTerritories Values (7,'90405'); |
|
|
|
Insert Into EmployeeTerritories Values (7,'94025'); |
|
|
|
Insert Into EmployeeTerritories Values (7,'94105'); |
|
|
|
Insert Into EmployeeTerritories Values (7,'95008'); |
|
|
|
Insert Into EmployeeTerritories Values (7,'95054'); |
|
|
|
Insert Into EmployeeTerritories Values (7,'95060'); |
|
|
|
Insert Into EmployeeTerritories Values (8,'19428'); |
|
|
|
Insert Into EmployeeTerritories Values (8,'44122'); |
|
|
|
Insert Into EmployeeTerritories Values (8,'45839'); |
|
|
|
Insert Into EmployeeTerritories Values (8,'53404'); |
|
|
|
Insert Into EmployeeTerritories Values (9,'03049'); |
|
|
|
Insert Into EmployeeTerritories Values (9,'03801'); |
|
|
|
Insert Into EmployeeTerritories Values (9,'48075'); |
|
|
|
Insert Into EmployeeTerritories Values (9,'48084'); |
|
|
|
Insert Into EmployeeTerritories Values (9,'48304'); |
|
|
|
Insert Into EmployeeTerritories Values (9,'55113'); |
|
|
|
Insert Into EmployeeTerritories Values (9,'55439'); |
|
|
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('ALFKI','Alfreds Futterkiste','Maria Anders','Sales Representative','Obere Str. 57','Berlin',null,'12209','Germany','030-0074321','030-0076545'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('ANATR','Ana Trujillo Emparedados y helados','Ana Trujillo','Owner','Avda. de la Constitución 2222','México D.F.',null,'05021','Mexico','(5) 555-4729','(5) 555-3745'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('ANTON','Antonio Moreno Taquería','Antonio Moreno','Owner','Mataderos 2312','México D.F.',null,'05023','Mexico','(5) 555-3932',null); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('AROUT','Around the Horn','Thomas Hardy','Sales Representative','120 Hanover Sq.','London',null,'WA1 1DP','UK','(171) 555-7788','(171) 555-6750'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('BERGS','Berglunds snabbköp','Christina Berglund','Order Administrator','Berguvsvägen 8','Luleå',null,'S-958 22','Sweden','0921-12 34 65','0921-12 34 67'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('BLAUS','Blauer See Delikatessen','Hanna Moos','Sales Representative','Forsterstr. 57','Mannheim',null,'68306','Germany','0621-08460','0621-08924'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('BLONP','Blondesddsl père et fils','Frédérique Citeaux','Marketing Manager','24, place Kléber','Strasbourg',null,'67000','France','88.60.15.31','88.60.15.32'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('BOLID','Bólido Comidas preparadas','Martín Sommer','Owner','C/ Araquil, 67','Madrid',null,'28023','Spain','(91) 555 22 82','(91) 555 91 99'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('BONAP','Bon app''','Laurence Lebihan','Owner','12, rue des Bouchers','Marseille',null,'13008','France','91.24.45.40','91.24.45.41'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('BOTTM','Bottom-Dollar Markets','Elizabeth Lincoln','Accounting Manager','23 Tsawassen Blvd.','Tsawassen','BC','T2F 8M4','Canada','(604) 555-4729','(604) 555-3745'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('BSBEV','B''s Beverages','Victoria Ashworth','Sales Representative','Fauntleroy Circus','London',null,'EC2 5NT','UK','(171) 555-1212',null); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('CACTU','Cactus Comidas para llevar','Patricio Simpson','Sales Agent','Cerrito 333','Buenos Aires',null,'1010','Argentina','(1) 135-5555','(1) 135-4892'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('CENTC','Centro comercial Moctezuma','Francisco Chang','Marketing Manager','Sierras de Granada 9993','México D.F.',null,'05022','Mexico','(5) 555-3392','(5) 555-7293'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('CHOPS','Chop-suey Chinese','Yang Wang','Owner','Hauptstr. 29','Bern',null,'3012','Switzerland','0452-076545',null); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('COMMI','Comércio Mineiro','Pedro Afonso','Sales Associate','Av. dos Lusíadas, 23','Sao Paulo','SP','05432-043','Brazil','(11) 555-7647',null); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('CONSH','Consolidated Holdings','Elizabeth Brown','Sales Representative','Berkeley Gardens 12 Brewery','London',null,'WX1 6LT','UK','(171) 555-2282','(171) 555-9199'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('DRACD','Drachenblut Delikatessen','Sven Ottlieb','Order Administrator','Walserweg 21','Aachen',null,'52066','Germany','0241-039123','0241-059428'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('DUMON','Du monde entier','Janine Labrune','Owner','67, rue des Cinquante Otages','Nantes',null,'44000','France','40.67.88.88','40.67.89.89'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('EASTC','Eastern Connection','Ann Devon','Sales Agent','35 King George','London',null,'WX3 6FW','UK','(171) 555-0297','(171) 555-3373'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('ERNSH','Ernst Handel','Roland Mendel','Sales Manager','Kirchgasse 6','Graz',null,'8010','Austria','7675-3425','7675-3426'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('FAMIA','Familia Arquibaldo','Aria Cruz','Marketing Assistant','Rua Orós, 92','Sao Paulo','SP','05442-030','Brazil','(11) 555-9857',null); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('FISSA','FISSA Fabrica Inter. Salchichas S.A.','Diego Roel','Accounting Manager','C/ Moralzarzal, 86','Madrid',null,'28034','Spain','(91) 555 94 44','(91) 555 55 93'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('FOLIG','Folies gourmandes','Martine Rancé','Assistant Sales Agent','184, chaussée de Tournai','Lille',null,'59000','France','20.16.10.16','20.16.10.17'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('FOLKO','Folk och fä HB','Maria Larsson','Owner','Åkergatan 24','Bräcke',null,'S-844 67','Sweden','0695-34 67 21',null); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('FRANK','Frankenversand','Peter Franken','Marketing Manager','Berliner Platz 43','München',null,'80805','Germany','089-0877310','089-0877451'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('FRANR','France restauration','Carine Schmitt','Marketing Manager','54, rue Royale','Nantes',null,'44000','France','40.32.21.21','40.32.21.20'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('FRANS','Franchi S.p.A.','Paolo Accorti','Sales Representative','Via Monte Bianco 34','Torino',null,'10100','Italy','011-4988260','011-4988261'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('FURIB','Furia Bacalhau e Frutos do Mar','Lino Rodriguez','Sales Manager','Jardim das rosas n. 32','Lisboa',null,'1675','Portugal','(1) 354-2534','(1) 354-2535'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('GALED','Galería del gastrónomo','Eduardo Saavedra','Marketing Manager','Rambla de Cataluña, 23','Barcelona',null,'08022','Spain','(93) 203 4560','(93) 203 4561'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('GODOS','Godos Cocina Típica','José Pedro Freyre','Sales Manager','C/ Romero, 33','Sevilla',null,'41101','Spain','(95) 555 82 82',null); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('GOURL','Gourmet Lanchonetes','André Fonseca','Sales Associate','Av. Brasil, 442','Campinas','SP','04876-786','Brazil','(11) 555-9482',null); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('GREAL','Great Lakes Food Market','Howard Snyder','Marketing Manager','2732 Baker Blvd.','Eugene','OR','97403','USA','(503) 555-7555',null); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('GROSR','GROSELLA-Restaurante','Manuel Pereira','Owner','5ª Ave. Los Palos Grandes','Caracas','DF','1081','Venezuela','(2) 283-2951','(2) 283-3397'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('HANAR','Hanari Carnes','Mario Pontes','Accounting Manager','Rua do Paço, 67','Rio de Janeiro','RJ','05454-876','Brazil','(21) 555-0091','(21) 555-8765'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('HILAA','HILARION-Abastos','Carlos Hernández','Sales Representative','Carrera 22 con Ave. Carlos Soublette #8-35','San Cristóbal','Táchira','5022','Venezuela','(5) 555-1340','(5) 555-1948'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('HUNGC','Hungry Coyote Import Store','Yoshi Latimer','Sales Representative','City Center Plaza 516 Main St.','Elgin','OR','97827','USA','(503) 555-6874','(503) 555-2376'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('HUNGO','Hungry Owl All-Night Grocers','Patricia McKenna','Sales Associate','8 Johnstown Road','Cork','Co. Cork',null,'Ireland','2967 542','2967 3333'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('ISLAT','Island Trading','Helen Bennett','Marketing Manager','Garden House Crowther Way','Cowes','Isle of Wight','PO31 7PJ','UK','(198) 555-8888',null); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('KOENE','Königlich Essen','Philip Cramer','Sales Associate','Maubelstr. 90','Brandenburg',null,'14776','Germany','0555-09876',null); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('LACOR','La corne d''abondance','Daniel Tonini','Sales Representative','67, avenue de l''Europe','Versailles',null,'78000','France','30.59.84.10','30.59.85.11'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('LAMAI','La maison d''Asie','Annette Roulet','Sales Manager','1 rue Alsace-Lorraine','Toulouse',null,'31000','France','61.77.61.10','61.77.61.11'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('LAUGB','Laughing Bacchus Wine Cellars','Yoshi Tannamuri','Marketing Assistant','1900 Oak St.','Vancouver','BC','V3F 2K1','Canada','(604) 555-3392','(604) 555-7293'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('LAZYK','Lazy K Kountry Store','John Steel','Marketing Manager','12 Orchestra Terrace','Walla Walla','WA','99362','USA','(509) 555-7969','(509) 555-6221'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('LEHMS','Lehmanns Marktstand','Renate Messner','Sales Representative','Magazinweg 7','Frankfurt a.M.',null,'60528','Germany','069-0245984','069-0245874'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('LETSS','Let''s Stop N Shop','Jaime Yorres','Owner','87 Polk St. Suite 5','San Francisco','CA','94117','USA','(415) 555-5938',null); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('LILAS','LILA-Supermercado','Carlos González','Accounting Manager','Carrera 52 con Ave. Bolívar #65-98 Llano Largo','Barquisimeto','Lara','3508','Venezuela','(9) 331-6954','(9) 331-7256'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('LINOD','LINO-Delicateses','Felipe Izquierdo','Owner','Ave. 5 de Mayo Porlamar','I. de Margarita','Nueva Esparta','4980','Venezuela','(8) 34-56-12','(8) 34-93-93'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('LONEP','Lonesome Pine Restaurant','Fran Wilson','Sales Manager','89 Chiaroscuro Rd.','Portland','OR','97219','USA','(503) 555-9573','(503) 555-9646'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('MAGAA','Magazzini Alimentari Riuniti','Giovanni Rovelli','Marketing Manager','Via Ludovico il Moro 22','Bergamo',null,'24100','Italy','035-640230','035-640231'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('MAISD','Maison Dewey','Catherine Dewey','Sales Agent','Rue Joseph-Bens 532','Bruxelles',null,'B-1180','Belgium','(02) 201 24 67','(02) 201 24 68'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('MEREP','Mère Paillarde','Jean Fresnière','Marketing Assistant','43 rue St. Laurent','Montréal','Québec','H1J 1C3','Canada','(514) 555-8054','(514) 555-8055'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('MORGK','Morgenstern Gesundkost','Alexander Feuer','Marketing Assistant','Heerstr. 22','Leipzig',null,'04179','Germany','0342-023176',null); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('NORTS','North/South','Simon Crowther','Sales Associate','South House 300 Queensbridge','London',null,'SW7 1RZ','UK','(171) 555-7733','(171) 555-2530'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('OCEAN','Océano Atlántico Ltda.','Yvonne Moncada','Sales Agent','Ing. Gustavo Moncada 8585 Piso 20-A','Buenos Aires',null,'1010','Argentina','(1) 135-5333','(1) 135-5535'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('OLDWO','Old World Delicatessen','Rene Phillips','Sales Representative','2743 Bering St.','Anchorage','AK','99508','USA','(907) 555-7584','(907) 555-2880'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('OTTIK','Ottilies Käseladen','Henriette Pfalzheim','Owner','Mehrheimerstr. 369','Köln',null,'50739','Germany','0221-0644327','0221-0765721'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('PARIS','Paris spécialités','Marie Bertrand','Owner','265, boulevard Charonne','Paris',null,'75012','France','(1) 42.34.22.66','(1) 42.34.22.77'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('PERIC','Pericles Comidas clásicas','Guillermo Fernández','Sales Representative','Calle Dr. Jorge Cash 321','México D.F.',null,'05033','Mexico','(5) 552-3745','(5) 545-3745'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('PICCO','Piccolo und mehr','Georg Pipps','Sales Manager','Geislweg 14','Salzburg',null,'5020','Austria','6562-9722','6562-9723'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('PRINI','Princesa Isabel Vinhos','Isabel de Castro','Sales Representative','Estrada da saúde n. 58','Lisboa',null,'1756','Portugal','(1) 356-5634',null); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('QUEDE','Que Delícia','Bernardo Batista','Accounting Manager','Rua da Panificadora, 12','Rio de Janeiro','RJ','02389-673','Brazil','(21) 555-4252','(21) 555-4545'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('QUEEN','Queen Cozinha','Lúcia Carvalho','Marketing Assistant','Alameda dos Canàrios, 891','Sao Paulo','SP','05487-020','Brazil','(11) 555-1189',null); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('QUICK','QUICK-Stop','Horst Kloss','Accounting Manager','Taucherstraße 10','Cunewalde',null,'01307','Germany','0372-035188',null); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('RANCH','Rancho grande','Sergio Gutiérrez','Sales Representative','Av. del Libertador 900','Buenos Aires',null,'1010','Argentina','(1) 123-5555','(1) 123-5556'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('RATTC','Rattlesnake Canyon Grocery','Paula Wilson','Assistant Sales Representative','2817 Milton Dr.','Albuquerque','NM','87110','USA','(505) 555-5939','(505) 555-3620'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('REGGC','Reggiani Caseifici','Maurizio Moroni','Sales Associate','Strada Provinciale 124','Reggio Emilia',null,'42100','Italy','0522-556721','0522-556722'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('RICAR','Ricardo Adocicados','Janete Limeira','Assistant Sales Agent','Av. Copacabana, 267','Rio de Janeiro','RJ','02389-890','Brazil','(21) 555-3412',null); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('RICSU','Richter Supermarkt','Michael Holz','Sales Manager','Grenzacherweg 237','Genève',null,'1203','Switzerland','0897-034214',null); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('ROMEY','Romero y tomillo','Alejandra Camino','Accounting Manager','Gran Vía, 1','Madrid',null,'28001','Spain','(91) 745 6200','(91) 745 6210'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('SANTG','Santé Gourmet','Jonas Bergulfsen','Owner','Erling Skakkes gate 78','Stavern',null,'4110','Norway','07-98 92 35','07-98 92 47'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('SAVEA','Save-a-lot Markets','Jose Pavarotti','Sales Representative','187 Suffolk Ln.','Boise','ID','83720','USA','(208) 555-8097',null); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('SEVES','Seven Seas Imports','Hari Kumar','Sales Manager','90 Wadhurst Rd.','London',null,'OX15 4NB','UK','(171) 555-1717','(171) 555-5646'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('SIMOB','Simons bistro','Jytte Petersen','Owner','Vinbæltet 34','Kobenhavn',null,'1734','Denmark','31 12 34 56','31 13 35 57'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('SPECD','Spécialités du monde','Dominique Perrier','Marketing Manager','25, rue Lauriston','Paris',null,'75016','France','(1) 47.55.60.10','(1) 47.55.60.20'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('SPLIR','Split Rail Beer & Ale','Art Braunschweiger','Sales Manager','P.O. Box 555','Lander','WY','82520','USA','(307) 555-4680','(307) 555-6525'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('SUPRD','Suprêmes délices','Pascale Cartrain','Accounting Manager','Boulevard Tirou, 255','Charleroi',null,'B-6000','Belgium','(071) 23 67 22 20','(071) 23 67 22 21'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('THEBI','The Big Cheese','Liz Nixon','Marketing Manager','89 Jefferson Way Suite 2','Portland','OR','97201','USA','(503) 555-3612',null); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('THECR','The Cracker Box','Liu Wong','Marketing Assistant','55 Grizzly Peak Rd.','Butte','MT','59801','USA','(406) 555-5834','(406) 555-8083'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('TOMSP','Toms Spezialitäten','Karin Josephs','Marketing Manager','Luisenstr. 48','Münster',null,'44087','Germany','0251-031259','0251-035695'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('TORTU','Tortuga Restaurante','Miguel Angel Paolino','Owner','Avda. Azteca 123','México D.F.',null,'05033','Mexico','(5) 555-2933',null); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('TRADH','Tradição Hipermercados','Anabela Domingues','Sales Representative','Av. Inês de Castro, 414','Sao Paulo','SP','05634-030','Brazil','(11) 555-2167','(11) 555-2168'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('TRAIH','Trail''s Head Gourmet Provisioners','Helvetius Nagy','Sales Associate','722 DaVinci Blvd.','Kirkland','WA','98034','USA','(206) 555-8257','(206) 555-2174'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('VAFFE','Vaffeljernet','Palle Ibsen','Sales Manager','Smagsloget 45','Århus',null,'8200','Denmark','86 21 32 43','86 22 33 44'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('VICTE','Victuailles en stock','Mary Saveley','Sales Agent','2, rue du Commerce','Lyon',null,'69004','France','78.32.54.86','78.32.54.87'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('VINET','Vins et alcools Chevalier','Paul Henriot','Accounting Manager','59 rue de l''Abbaye','Reims',null,'51100','France','26.47.15.10','26.47.15.11'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('WANDK','Die Wandernde Kuh','Rita Müller','Sales Representative','Adenauerallee 900','Stuttgart',null,'70563','Germany','0711-020361','0711-035428'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('WARTH','Wartian Herkku','Pirkko Koskitalo','Accounting Manager','Torikatu 38','Oulu',null,'90110','Finland','981-443655','981-443655'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('WELLI','Wellington Importadora','Paula Parente','Sales Manager','Rua do Mercado, 12','Resende','SP','08737-363','Brazil','(14) 555-8122',null); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('WHITC','White Clover Markets','Karl Jablonski','Owner','305 - 14th Ave. S. Suite 3B','Seattle','WA','98128','USA','(206) 555-4112','(206) 555-4115'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('WILMK','Wilman Kala','Matti Karttunen','Owner/Marketing Assistant','Keskuskatu 45','Helsinki',null,'21240','Finland','90-224 8858','90-224 8858'); |
|
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('WOLZA','Wolski Zajazd','Zbyszek Piestrzeniewicz','Owner','ul. Filtrowa 68','Warszawa',null,'01-012','Poland','(26) 642-7012','(26) 642-7012'); |
|
|
|
|
|
|
|
INSERT INTO Shippers(ShipperID,CompanyName,Phone) VALUES(1,'Speedy Express','(503) 555-9831'); |
|
|
|
INSERT INTO Shippers(ShipperID,CompanyName,Phone) VALUES(2,'United Package','(503) 555-3199'); |
|
|
|
INSERT INTO Shippers(ShipperID,CompanyName,Phone) VALUES(3,'Federal Shipping','(503) 555-9931'); |
|
|
|
|
|
|
|
INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(1,'Exotic Liquids','Charlotte Cooper','Purchasing Manager','49 Gilbert St.','London',NULL,'EC1 4SD','UK','(171) 555-2222',NULL,NULL); |
|
|
|
INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(2,'New Orleans Cajun Delights','Shelley Burke','Order Administrator','P.O. Box 78934','New Orleans','LA','70117','USA','(100) 555-4822',NULL,'#CAJUN.HTM#'); |
|
|
|
INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(3,'Grandma Kelly''s Homestead','Regina Murphy','Sales Representative','707 Oxford Rd.','Ann Arbor','MI','48104','USA','(313) 555-5735','(313) 555-3349',NULL); |
|
|
|
INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(4,'Tokyo Traders','Yoshi Nagase','Marketing Manager','9-8 Sekimai Musashino-shi','Tokyo',NULL,'100','Japan','(03) 3555-5011',NULL,NULL); |
|
|
|
INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(5,'Cooperativa de Quesos ''Las Cabras''','Antonio del Valle Saavedra','Export Administrator','Calle del Rosal 4','Oviedo','Asturias','33007','Spain','(98) 598 76 54',NULL,NULL); |
|
|
|
INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(6,'Mayumi''s','Mayumi Ohno','Marketing Representative','92 Setsuko Chuo-ku','Osaka',NULL,'545','Japan','(06) 431-7877',NULL,'Mayumi''s (on the World Wide Web)#http://www.microsoft.com/accessdev/sampleapps/mayumi.htm#'); |
|
|
|
INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(7,'Pavlova, Ltd.','Ian Devling','Marketing Manager','74 Rose St. Moonie Ponds','Melbourne','Victoria','3058','Australia','(03) 444-2343','(03) 444-6588',NULL); |
|
|
|
INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(8,'Specialty Biscuits, Ltd.','Peter Wilson','Sales Representative','29 King''s Way','Manchester',NULL,'M14 GSD','UK','(161) 555-4448',NULL,NULL); |
|
|
|
INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(9,'PB Knäckebröd AB','Lars Peterson','Sales Agent','Kaloadagatan 13','Göteborg',NULL,'S-345 67','Sweden','031-987 65 43','031-987 65 91',NULL); |
|
|
|
INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(10,'Refrescos Americanas LTDA','Carlos Diaz','Marketing Manager','Av. das Americanas 12.890','Sao Paulo',NULL,'5442','Brazil','(11) 555 4640',NULL,NULL); |
|
|
|
|
|
|
|
INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(11,'Heli Süßwaren GmbH and Co. KG','Petra Winkler','Sales Manager','Tiergartenstraße 5','Berlin',NULL,'10785','Germany','(010) 9984510',NULL,NULL); |
|
|
|
INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(12,'Plutzer Lebensmittelgroßmärkte AG','Martin Bein','International Marketing Mgr.','Bogenallee 51','Frankfurt',NULL,'60439','Germany','(069) 992755',NULL,'Plutzer (on the World Wide Web)#http://www.microsoft.com/accessdev/sampleapps/plutzer.htm#'); |
|
|
|
INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(13,'Nord-Ost-Fisch Handelsgesellschaft mbH','Sven Petersen','Coordinator Foreign Markets','Frahmredder 112a','Cuxhaven',NULL,'27478','Germany','(04721) 8713','(04721) 8714',NULL); |
|
|
|
INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(14,'Formaggi Fortini s.r.l.','Elio Rossi','Sales Representative','Viale Dante, 75','Ravenna',NULL,'48100','Italy','(0544) 60323','(0544) 60603','#FORMAGGI.HTM#'); |
|
|
|
INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(15,'Norske Meierier','Beate Vileid','Marketing Manager','Hatlevegen 5','Sandvika',NULL,'1320','Norway','(0)2-953010',NULL,NULL); |
|
|
|
INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(16,'Bigfoot Breweries','Cheryl Saylor','Regional Account Rep.','3400 - 8th Avenue Suite 210','Bend','OR','97101','USA','(503) 555-9931',NULL,NULL); |
|
|
|
INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(17,'Svensk Sjöföda AB','Michael Björn','Sales Representative','Brovallavägen 231','Stockholm',NULL,'S-123 45','Sweden','08-123 45 67',NULL,NULL); |
|
|
|
INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(18,'Aux joyeux ecclésiastiques','Guylène Nodier','Sales Manager','203, Rue des Francs-Bourgeois','Paris',NULL,'75004','France','(1) 03.83.00.68','(1) 03.83.00.62',NULL); |
|
|
|
INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(19,'New England Seafood Cannery','Robb Merchant','Wholesale Account Agent','Order Processing Dept. 2100 Paul Revere Blvd.','Boston','MA','02134','USA','(617) 555-3267','(617) 555-3389',NULL); |
|
|
|
INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(20,'Leka Trading','Chandra Leka','Owner','471 Serangoon Loop, Suite #402','Singapore',NULL,'0512','Singapore','555-8787',NULL,NULL); |
|
|
|
|
|
|
|
INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(21,'Lyngbysild','Niels Petersen','Sales Manager','Lyngbysild Fiskebakken 10','Lyngby',NULL,'2800','Denmark','43844108','43844115',NULL); |
|
|
|
INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(22,'Zaanse Snoepfabriek','Dirk Luchte','Accounting Manager','Verkoop Rijnweg 22','Zaandam',NULL,'9999 ZZ','Netherlands','(12345) 1212','(12345) 1210',NULL); |
|
|
|
INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(23,'Karkki Oy','Anne Heikkonen','Product Manager','Valtakatu 12','Lappeenranta',NULL,'53120','Finland','(953) 10956',NULL,NULL); |
|
|
|
INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(24,'G''day, Mate','Wendy Mackenzie','Sales Representative','170 Prince Edward Parade Hunter''s Hill','Sydney','NSW','2042','Australia','(02) 555-5914','(02) 555-4873','G''day Mate (on the World Wide Web)#http://www.microsoft.com/accessdev/sampleapps/gdaymate.htm#'); |
|
|
|
INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(25,'Ma Maison','Jean-Guy Lauzon','Marketing Manager','2960 Rue St. Laurent','Montréal','Québec','H1J 1C3','Canada','(514) 555-9022',NULL,NULL); |
|
|
|
INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(26,'Pasta Buttini s.r.l.','Giovanni Giudici','Order Administrator','Via dei Gelsomini, 153','Salerno',NULL,'84100','Italy','(089) 6547665','(089) 6547667',NULL); |
|
|
|
INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(27,'Escargots Nouveaux','Marie Delamare','Sales Manager','22, rue H. Voiron','Montceau',NULL,'71300','France','85.57.00.07',NULL,NULL); |
|
|
|
INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(28,'Gai pâturage','Eliane Noz','Sales Representative','Bat. B 3, rue des Alpes','Annecy',NULL,'74000','France','38.76.98.06','38.76.98.58',NULL); |
|
|
|
INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(29,'Forêts d''érables','Chantal Goulet','Accounting Manager','148 rue Chasseur','Ste-Hyacinthe','Québec','J2S 7S8','Canada','(514) 555-2955','(514) 555-2921',NULL); |
|
|
|
|
|
|
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(1,'Chai',1,1,'10 boxes x 20 bags',18,39,0,10,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(2,'Chang',1,1,'24 - 12 oz bottles',19,17,40,25,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(3,'Aniseed Syrup',1,2,'12 - 550 ml bottles',10,13,70,25,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(4,'Chef Anton''s Cajun Seasoning',2,2,'48 - 6 oz jars',22,53,0,0,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(5,'Chef Anton''s Gumbo Mix',2,2,'36 boxes',21.35,0,0,0,1); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(6,'Grandma''s Boysenberry Spread',3,2,'12 - 8 oz jars',25,120,0,25,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(7,'Uncle Bob''s Organic Dried Pears',3,7,'12 - 1 lb pkgs.',30,15,0,10,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(8,'Northwoods Cranberry Sauce',3,2,'12 - 12 oz jars',40,6,0,0,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(9,'Mishi Kobe Niku',4,6,'18 - 500 g pkgs.',97,29,0,0,1); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(10,'Ikura',4,8,'12 - 200 ml jars',31,31,0,0,0); |
|
|
|
|
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(11,'Queso Cabrales',5,4,'1 kg pkg.',21,22,30,30,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(12,'Queso Manchego La Pastora',5,4,'10 - 500 g pkgs.',38,86,0,0,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(13,'Konbu',6,8,'2 kg box',6,24,0,5,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(14,'Tofu',6,7,'40 - 100 g pkgs.',23.25,35,0,0,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(15,'Genen Shouyu',6,2,'24 - 250 ml bottles',15.5,39,0,5,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(16,'Pavlova',7,3,'32 - 500 g boxes',17.45,29,0,10,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(17,'Alice Mutton',7,6,'20 - 1 kg tins',39,0,0,0,1); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(18,'Carnarvon Tigers',7,8,'16 kg pkg.',62.5,42,0,0,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(19,'Teatime Chocolate Biscuits',8,3,'10 boxes x 12 pieces',9.2,25,0,5,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(20,'Sir Rodney''s Marmalade',8,3,'30 gift boxes',81,40,0,0,0); |
|
|
|
|
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(21,'Sir Rodney''s Scones',8,3,'24 pkgs. x 4 pieces',10,3,40,5,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(22,'Gustaf''s Knäckebröd',9,5,'24 - 500 g pkgs.',21,104,0,25,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(23,'Tunnbröd',9,5,'12 - 250 g pkgs.',9,61,0,25,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(24,'Guaraná Fantástica',10,1,'12 - 355 ml cans',4.5,20,0,0,1); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(25,'NuNuCa Nuß-Nougat-Creme',11,3,'20 - 450 g glasses',14,76,0,30,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(26,'Gumbär Gummibärchen',11,3,'100 - 250 g bags',31.23,15,0,0,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(27,'Schoggi Schokolade',11,3,'100 - 100 g pieces',43.9,49,0,30,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(28,'Rössle Sauerkraut',12,7,'25 - 825 g cans',45.6,26,0,0,1); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(29,'Thüringer Rostbratwurst',12,6,'50 bags x 30 sausgs.',123.79,0,0,0,1); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(30,'Nord-Ost Matjeshering',13,8,'10 - 200 g glasses',25.89,10,0,15,0); |
|
|
|
|
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(31,'Gorgonzola Telino',14,4,'12 - 100 g pkgs',12.5,0,70,20,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(32,'Mascarpone Fabioli',14,4,'24 - 200 g pkgs.',32,9,40,25,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(33,'Geitost',15,4,'500 g',2.5,112,0,20,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(34,'Sasquatch Ale',16,1,'24 - 12 oz bottles',14,111,0,15,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(35,'Steeleye Stout',16,1,'24 - 12 oz bottles',18,20,0,15,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(36,'Inlagd Sill',17,8,'24 - 250 g jars',19,112,0,20,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(37,'Gravad lax',17,8,'12 - 500 g pkgs.',26,11,50,25,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(38,'Côte de Blaye',18,1,'12 - 75 cl bottles',263.5,17,0,15,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(39,'Chartreuse verte',18,1,'750 cc per bottle',18,69,0,5,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(40,'Boston Crab Meat',19,8,'24 - 4 oz tins',18.4,123,0,30,0); |
|
|
|
|
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(41,'Jack''s New England Clam Chowder',19,8,'12 - 12 oz cans',9.65,85,0,10,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(42,'Singaporean Hokkien Fried Mee',20,5,'32 - 1 kg pkgs.',14,26,0,0,1); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(43,'Ipoh Coffee',20,1,'16 - 500 g tins',46,17,10,25,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(44,'Gula Malacca',20,2,'20 - 2 kg bags',19.45,27,0,15,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(45,'Rogede sild',21,8,'1k pkg.',9.5,5,70,15,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(46,'Spegesild',21,8,'4 - 450 g glasses',12,95,0,0,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(47,'Zaanse koeken',22,3,'10 - 4 oz boxes',9.5,36,0,0,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(48,'Chocolade',22,3,'10 pkgs.',12.75,15,70,25,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(49,'Maxilaku',23,3,'24 - 50 g pkgs.',20,10,60,15,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(50,'Valkoinen suklaa',23,3,'12 - 100 g bars',16.25,65,0,30,0); |
|
|
|
|
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(51,'Manjimup Dried Apples',24,7,'50 - 300 g pkgs.',53,20,0,10,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(52,'Filo Mix',24,5,'16 - 2 kg boxes',7,38,0,25,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(53,'Perth Pasties',24,6,'48 pieces',32.8,0,0,0,1); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(54,'Tourtière',25,6,'16 pies',7.45,21,0,10,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(55,'Pâté chinois',25,6,'24 boxes x 2 pies',24,115,0,20,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(56,'Gnocchi di nonna Alice',26,5,'24 - 250 g pkgs.',38,21,10,30,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(57,'Ravioli Angelo',26,5,'24 - 250 g pkgs.',19.5,36,0,20,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(58,'Escargots de Bourgogne',27,8,'24 pieces',13.25,62,0,20,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(59,'Raclette Courdavault',28,4,'5 kg pkg.',55,79,0,0,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(60,'Camembert Pierrot',28,4,'15 - 300 g rounds',34,19,0,0,0); |
|
|
|
|
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(61,'Sirop d''érable',29,2,'24 - 500 ml bottles',28.5,113,0,25,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(62,'Tarte au sucre',29,3,'48 pies',49.3,17,0,0,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(63,'Vegie-spread',7,2,'15 - 625 g jars',43.9,24,0,5,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(64,'Wimmers gute Semmelknödel',12,5,'20 bags x 4 pieces',33.25,22,80,30,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(65,'Louisiana Fiery Hot Pepper Sauce',2,2,'32 - 8 oz bottles',21.05,76,0,0,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(66,'Louisiana Hot Spiced Okra',2,2,'24 - 8 oz jars',17,4,100,20,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(67,'Laughing Lumberjack Lager',16,1,'24 - 12 oz bottles',14,52,0,10,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(68,'Scottish Longbreads',8,3,'10 boxes x 8 pieces',12.5,6,10,15,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(69,'Gudbrandsdalsost',15,4,'10 kg pkg.',36,26,0,15,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(70,'Outback Lager',7,1,'24 - 355 ml bottles',15,15,10,30,0); |
|
|
|
|
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(71,'Flotemysost',15,4,'10 - 500 g pkgs.',21.5,26,0,0,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(72,'Mozzarella di Giovanni',14,4,'24 - 200 g pkgs.',34.8,14,0,0,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(73,'Röd Kaviar',17,8,'24 - 150 g jars',15,101,0,5,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(74,'Longlife Tofu',4,7,'5 kg pkg.',10,4,20,5,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(75,'Rhönbräu Klosterbier',12,1,'24 - 0.5 l bottles',7.75,125,0,25,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(76,'Lakkalikööri',23,1,'500 ml',18,57,0,20,0); |
|
|
|
INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(77,'Original Frankfurter grüne Soße',12,2,'12 boxes',13,32,0,15,0); |
|
|
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10248,'VINET',5,to_timestamp('04-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('01-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,32.38,'Vins et alcools Chevalier','59 rue de l''Abbaye','Reims','Test','51100','France'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10249,'TOMSP',6,to_timestamp('05-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('10-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,11.61,'Toms Spezialitäten','Luisenstr. 48','Münster',null,'44087','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10250,'HANAR',4,to_timestamp('08-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('05-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('12-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,65.83,'Hanari Carnes','Rua do Paço, 67','Rio de Janeiro','RJ','05454-876','Brazil'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10251,'VICTE',3,to_timestamp('08-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('05-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('15-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,41.34,'Victuailles en stock','2, rue du Commerce','Lyon',null,'69004','France'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10252,'SUPRD',4,to_timestamp('09-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('06-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('11-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,51.3,'Suprêmes délices','Boulevard Tirou, 255','Charleroi',null,'B-6000','Belgium'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10253,'HANAR',3,to_timestamp('10-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('24-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,58.17,'Hanari Carnes','Rua do Paço, 67','Rio de Janeiro','RJ','05454-876','Brazil'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10254,'CHOPS',5,to_timestamp('11-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('08-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,22.98,'Chop-suey Chinese','Hauptstr. 31','Bern',null,'3012','Switzerland'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10255,'RICSU',9,to_timestamp('12-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('15-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,148.33,'Richter Supermarkt','Starenweg 5','Genève',null,'1204','Switzerland'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10256,'WELLI',3,to_timestamp('15-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('12-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('17-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,13.97,'Wellington Importadora','Rua do Mercado, 12','Resende','SP','08737-363','Brazil'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10257,'HILAA',4,to_timestamp('16-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('22-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,81.91,'HILARION-Abastos','Carrera 22 con Ave. Carlos Soublette #8-35','San Cristóbal','Táchira','5022','Venezuela'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10258,'ERNSH',1,to_timestamp('17-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('14-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,140.51,'Ernst Handel','Kirchgasse 6','Graz',null,'8010','Austria'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10259,'CENTC',4,to_timestamp('18-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('15-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('25-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,3.25,'Centro comercial Moctezuma','Sierras de Granada 9993','México D.F.',null,'05022','Mexico'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10260,'OTTIK',4,to_timestamp('19-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('29-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,55.09,'Ottilies Käseladen','Mehrheimerstr. 369','Köln',null,'50739','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10261,'QUEDE',4,to_timestamp('19-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('30-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,3.05,'Que Delícia','Rua da Panificadora, 12','Rio de Janeiro','RJ','02389-673','Brazil'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10262,'RATTC',8,to_timestamp('22-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('19-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('25-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,48.29,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10263,'ERNSH',9,to_timestamp('23-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('20-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('31-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,146.06,'Ernst Handel','Kirchgasse 6','Graz',null,'8010','Austria'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10264,'FOLKO',6,to_timestamp('24-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('21-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,3.67,'Folk och fä HB','Åkergatan 24','Bräcke',null,'S-844 67','Sweden'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10265,'BLONP',2,to_timestamp('25-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('22-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('12-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,55.28,'Blondel père et fils','24, place Kléber','Strasbourg',null,'67000','France'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10266,'WARTH',3,to_timestamp('26-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('06-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('31-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,25.73,'Wartian Herkku','Torikatu 38','Oulu',null,'90110','Finland'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10267,'FRANK',4,to_timestamp('29-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('26-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('06-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,208.58,'Frankenversand','Berliner Platz 43','München',null,'80805','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10268,'GROSR',8,to_timestamp('30-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('27-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,66.29,'GROSELLA-Restaurante','5ª Ave. Los Palos Grandes','Caracas','DF','1081','Venezuela'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10269,'WHITC',5,to_timestamp('31-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('14-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,4.56,'White Clover Markets','1029 - 12th Ave. S.','Seattle','WA','98124','USA'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10270,'WARTH',1,to_timestamp('01-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('29-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,136.54,'Wartian Herkku','Torikatu 38','Oulu',null,'90110','Finland'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10271,'SPLIR',6,to_timestamp('01-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('29-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('30-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,4.54,'Split Rail Beer & Ale','P.O. Box 555','Lander','WY','82520','USA'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10272,'RATTC',6,to_timestamp('02-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('30-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('06-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,98.03,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10273,'QUICK',3,to_timestamp('05-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('12-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,76.07,'QUICK-Stop','Taucherstraße 10','Cunewalde',null,'01307','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10274,'VINET',6,to_timestamp('06-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,6.01,'Vins et alcools Chevalier','59 rue de l''Abbaye','Reims',null,'51100','France'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10275,'MAGAA',1,to_timestamp('07-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,26.93,'Magazzini Alimentari Riuniti','Via Ludovico il Moro 22','Bergamo',null,'24100','Italy'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10276,'TORTU',8,to_timestamp('08-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('22-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('14-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,13.84,'Tortuga Restaurante','Avda. Azteca 123','México D.F.',null,'05033','Mexico'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10277,'MORGK',2,to_timestamp('09-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('06-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,125.77,'Morgenstern Gesundkost','Heerstr. 22','Leipzig',null,'04179','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10278,'BERGS',8,to_timestamp('12-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,92.69,'Berglunds snabbköp','Berguvsvägen 8','Luleå',null,'S-958 22','Sweden'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10279,'LEHMS',8,to_timestamp('13-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('10-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,25.83,'Lehmanns Marktstand','Magazinweg 7','Frankfurt a.M.',null,'60528','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10280,'BERGS',2,to_timestamp('14-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('11-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('12-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,8.98,'Berglunds snabbköp','Berguvsvägen 8','Luleå',null,'S-958 22','Sweden'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10281,'ROMEY',4,to_timestamp('14-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('28-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('21-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,2.94,'Romero y tomillo','Gran Vía, 1','Madrid',null,'28001','Spain'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10282,'ROMEY',4,to_timestamp('15-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('12-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('21-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,12.69,'Romero y tomillo','Gran Vía, 1','Madrid',null,'28001','Spain'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10283,'LILAS',3,to_timestamp('16-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,84.81,'LILA-Supermercado','Carrera 52 con Ave. Bolívar #65-98 Llano Largo','Barquisimeto','Lara','3508','Venezuela'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10284,'LEHMS',4,to_timestamp('19-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('27-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,76.56,'Lehmanns Marktstand','Magazinweg 7','Frankfurt a.M.',null,'60528','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10285,'QUICK',1,to_timestamp('20-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('17-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('26-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,76.83,'QUICK-Stop','Taucherstraße 10','Cunewalde',null,'01307','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10286,'QUICK',8,to_timestamp('21-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('30-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,229.24,'QUICK-Stop','Taucherstraße 10','Cunewalde',null,'01307','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10287,'RICAR',8,to_timestamp('22-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('19-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('28-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,12.76,'Ricardo Adocicados','Av. Copacabana, 267','Rio de Janeiro','RJ','02389-890','Brazil'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10288,'REGGC',4,to_timestamp('23-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('20-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,7.45,'Reggiani Caseifici','Strada Provinciale 124','Reggio Emilia',null,'42100','Italy'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10289,'BSBEV',7,to_timestamp('26-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('28-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,22.77,'B''s Beverages','Fauntleroy Circus','London',null,'EC2 5NT','UK'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10290,'COMMI',8,to_timestamp('27-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('24-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,79.7,'Comércio Mineiro','Av. dos Lusíadas, 23','Sao Paulo','SP','05432-043','Brazil'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10291,'QUEDE',6,to_timestamp('27-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('24-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,6.4,'Que Delícia','Rua da Panificadora, 12','Rio de Janeiro','RJ','02389-673','Brazil'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10292,'TRADH',1,to_timestamp('28-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('25-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,1.35,'Tradiçao Hipermercados','Av. Inês de Castro, 414','Sao Paulo','SP','05634-030','Brazil'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10293,'TORTU',1,to_timestamp('29-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('26-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('11-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,21.18,'Tortuga Restaurante','Avda. Azteca 123','México D.F.',null,'05033','Mexico'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10294,'RATTC',4,to_timestamp('30-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('27-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('05-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,147.26,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10295,'VINET',2,to_timestamp('02-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('30-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('10-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,1.15,'Vins et alcools Chevalier','59 rue de l''Abbaye','Reims',null,'51100','France'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10296,'LILAS',6,to_timestamp('03-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('01-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('11-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,0.12,'LILA-Supermercado','Carrera 52 con Ave. Bolívar #65-98 Llano Largo','Barquisimeto','Lara','3508','Venezuela'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10297,'BLONP',5,to_timestamp('04-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('10-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,5.74,'Blondel père et fils','24, place Kléber','Strasbourg',null,'67000','France'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10298,'HUNGO',6,to_timestamp('05-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('11-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,168.22,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',null,'Ireland'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10299,'RICAR',4,to_timestamp('06-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,29.76,'Ricardo Adocicados','Av. Copacabana, 267','Rio de Janeiro','RJ','02389-890','Brazil'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10300,'MAGAA',2,to_timestamp('09-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('07-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,17.68,'Magazzini Alimentari Riuniti','Via Ludovico il Moro 22','Bergamo',null,'24100','Italy'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10301,'WANDK',8,to_timestamp('09-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('07-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('17-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,45.08,'Die Wandernde Kuh','Adenauerallee 900','Stuttgart',null,'70563','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10302,'SUPRD',4,to_timestamp('10-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('08-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,6.27,'Suprêmes délices','Boulevard Tirou, 255','Charleroi',null,'B-6000','Belgium'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10303,'GODOS',7,to_timestamp('11-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,107.83,'Godos Cocina Típica','C/ Romero, 33','Sevilla',null,'41101','Spain'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10304,'TORTU',1,to_timestamp('12-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('10-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('17-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,63.79,'Tortuga Restaurante','Avda. Azteca 123','México D.F.',null,'05033','Mexico'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10305,'OLDWO',8,to_timestamp('13-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('11-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,257.62,'Old World Delicatessen','2743 Bering St.','Anchorage','AK','99508','USA'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10306,'ROMEY',1,to_timestamp('16-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('14-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,7.56,'Romero y tomillo','Gran Vía, 1','Madrid',null,'28001','Spain'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10307,'LONEP',2,to_timestamp('17-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('15-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('25-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,0.56,'Lonesome Pine Restaurant','89 Chiaroscuro Rd.','Portland','OR','97219','USA'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10308,'ANATR',7,to_timestamp('18-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('24-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,1.61,'Ana Trujillo Emparedados y helados','Avda. de la Constitución 2222','México D.F.',null,'05021','Mexico'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10309,'HUNGO',3,to_timestamp('19-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('17-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,47.3,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',null,'Ireland'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10310,'THEBI',8,to_timestamp('20-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('27-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,17.52,'The Big Cheese','89 Jefferson Way Suite 2','Portland','OR','97201','USA'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10311,'DUMON',1,to_timestamp('20-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('26-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,24.69,'Du monde entier','67, rue des Cinquante Otages','Nantes',null,'44000','France'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10312,'WANDK',2,to_timestamp('23-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('21-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,40.26,'Die Wandernde Kuh','Adenauerallee 900','Stuttgart',null,'70563','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10313,'QUICK',2,to_timestamp('24-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('22-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,1.96,'QUICK-Stop','Taucherstraße 10','Cunewalde',null,'01307','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10314,'RATTC',1,to_timestamp('25-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,74.16,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10315,'ISLAT',4,to_timestamp('26-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('24-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,41.76,'Island Trading','Garden House Crowther Way','Cowes','Isle of Wight','PO31 7PJ','UK'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10316,'RATTC',1,to_timestamp('27-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('25-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('08-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,150.15,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10317,'LONEP',6,to_timestamp('30-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('28-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('10-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,12.69,'Lonesome Pine Restaurant','89 Chiaroscuro Rd.','Portland','OR','97219','USA'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10318,'ISLAT',8,to_timestamp('01-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('29-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,4.73,'Island Trading','Garden House Crowther Way','Cowes','Isle of Wight','PO31 7PJ','UK'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10319,'TORTU',7,to_timestamp('02-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('30-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('11-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,64.5,'Tortuga Restaurante','Avda. Azteca 123','México D.F.',null,'05033','Mexico'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10320,'WARTH',5,to_timestamp('03-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('17-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,34.57,'Wartian Herkku','Torikatu 38','Oulu',null,'90110','Finland'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10321,'ISLAT',3,to_timestamp('03-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('31-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('11-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,3.43,'Island Trading','Garden House Crowther Way','Cowes','Isle of Wight','PO31 7PJ','UK'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10322,'PERIC',7,to_timestamp('04-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('01-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,0.4,'Pericles Comidas clásicas','Calle Dr. Jorge Cash 321','México D.F.',null,'05033','Mexico'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10323,'KOENE',4,to_timestamp('07-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('14-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,4.88,'Königlich Essen','Maubelstr. 90','Brandenburg',null,'14776','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10324,'SAVEA',9,to_timestamp('08-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('05-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('10-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,214.27,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10325,'KOENE',1,to_timestamp('09-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('14-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,64.86,'Königlich Essen','Maubelstr. 90','Brandenburg',null,'14776','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10326,'BOLID',4,to_timestamp('10-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('07-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('14-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,77.92,'Bólido Comidas preparadas','C/ Araquil, 67','Madrid',null,'28023','Spain'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10327,'FOLKO',2,to_timestamp('11-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('08-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('14-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,63.36,'Folk och fä HB','Åkergatan 24','Bräcke',null,'S-844 67','Sweden'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10328,'FURIB',4,to_timestamp('14-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('11-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('17-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,87.03,'Furia Bacalhau e Frutos do Mar','Jardim das rosas n. 32','Lisboa',null,'1675','Portugal'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10329,'SPLIR',4,to_timestamp('15-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('26-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,191.67,'Split Rail Beer & Ale','P.O. Box 555','Lander','WY','82520','USA'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10330,'LILAS',3,to_timestamp('16-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('28-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,12.75,'LILA-Supermercado','Carrera 52 con Ave. Bolívar #65-98 Llano Largo','Barquisimeto','Lara','3508','Venezuela'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10331,'BONAP',9,to_timestamp('16-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('27-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('21-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,10.19,'Bon app''','12, rue des Bouchers','Marseille',null,'13008','France'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10332,'MEREP',3,to_timestamp('17-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('28-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('21-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,52.84,'Mère Paillarde','43 rue St. Laurent','Montréal','Québec','H1J 1C3','Canada'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10333,'WARTH',5,to_timestamp('18-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('15-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('25-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,0.59,'Wartian Herkku','Torikatu 38','Oulu',null,'90110','Finland'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10334,'VICTE',8,to_timestamp('21-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('28-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,8.56,'Victuailles en stock','2, rue du Commerce','Lyon',null,'69004','France'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10335,'HUNGO',7,to_timestamp('22-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('19-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('24-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,42.11,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',null,'Ireland'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10336,'PRINI',7,to_timestamp('23-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('20-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('25-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,15.51,'Princesa Isabel Vinhos','Estrada da saúde n. 58','Lisboa',null,'1756','Portugal'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10337,'FRANK',4,to_timestamp('24-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('21-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('29-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,108.26,'Frankenversand','Berliner Platz 43','München',null,'80805','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10338,'OLDWO',4,to_timestamp('25-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('22-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('29-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,84.21,'Old World Delicatessen','2743 Bering St.','Anchorage','AK','99508','USA'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10339,'MEREP',2,to_timestamp('28-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('25-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,15.66,'Mère Paillarde','43 rue St. Laurent','Montréal','Québec','H1J 1C3','Canada'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10340,'BONAP',1,to_timestamp('29-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('26-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('08-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,166.31,'Bon app''','12, rue des Bouchers','Marseille',null,'13008','France'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10341,'SIMOB',7,to_timestamp('29-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('26-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('05-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,26.78,'Simons bistro','Vinbæltet 34','Kobenhavn',null,'1734','Denmark'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10342,'FRANK',4,to_timestamp('30-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,54.83,'Frankenversand','Berliner Platz 43','München',null,'80805','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10343,'LEHMS',4,to_timestamp('31-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('28-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('06-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,110.37,'Lehmanns Marktstand','Magazinweg 7','Frankfurt a.M.',null,'60528','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10344,'WHITC',4,to_timestamp('01-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('29-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('05-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,23.29,'White Clover Markets','1029 - 12th Ave. S.','Seattle','WA','98124','USA'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10345,'QUICK',2,to_timestamp('04-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('11-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,249.06,'QUICK-Stop','Taucherstraße 10','Cunewalde',null,'01307','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10346,'RATTC',3,to_timestamp('05-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('17-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('08-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,142.08,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10347,'FAMIA',4,to_timestamp('06-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('08-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,3.1,'Familia Arquibaldo','Rua Orós, 92','Sao Paulo','SP','05442-030','Brazil'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10348,'WANDK',4,to_timestamp('07-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('05-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('15-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,0.78,'Die Wandernde Kuh','Adenauerallee 900','Stuttgart',null,'70563','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10349,'SPLIR',7,to_timestamp('08-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('06-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('15-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,8.63,'Split Rail Beer & Ale','P.O. Box 555','Lander','WY','82520','USA'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10350,'LAMAI',6,to_timestamp('11-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,64.19,'La maison d''Asie','1 rue Alsace-Lorraine','Toulouse',null,'31000','France'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10351,'ERNSH',1,to_timestamp('11-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('20-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,162.33,'Ernst Handel','Kirchgasse 6','Graz',null,'8010','Austria'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10352,'FURIB',3,to_timestamp('12-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('26-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,1.3,'Furia Bacalhau e Frutos do Mar','Jardim das rosas n. 32','Lisboa',null,'1675','Portugal'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10353,'PICCO',7,to_timestamp('13-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('11-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('25-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,360.63,'Piccolo und mehr','Geislweg 14','Salzburg',null,'5020','Austria'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10354,'PERIC',8,to_timestamp('14-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('12-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('20-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,53.8,'Pericles Comidas clásicas','Calle Dr. Jorge Cash 321','México D.F.',null,'05033','Mexico'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10355,'AROUT',6,to_timestamp('15-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('20-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,41.95,'Around the Horn','Brook Farm Stratford St. Mary','Colchester','Essex','CO7 6JX','UK'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10356,'WANDK',6,to_timestamp('18-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('27-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,36.71,'Die Wandernde Kuh','Adenauerallee 900','Stuttgart',null,'70563','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10357,'LILAS',1,to_timestamp('19-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('17-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,34.88,'LILA-Supermercado','Carrera 52 con Ave. Bolívar #65-98 Llano Largo','Barquisimeto','Lara','3508','Venezuela'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10358,'LAMAI',5,to_timestamp('20-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('27-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,19.64,'La maison d''Asie','1 rue Alsace-Lorraine','Toulouse',null,'31000','France'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10359,'SEVES',5,to_timestamp('21-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('19-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('26-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,288.43,'Seven Seas Imports','90 Wadhurst Rd.','London',null,'OX15 4NB','UK'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10360,'BLONP',4,to_timestamp('22-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('20-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,131.7,'Blondel père et fils','24, place Kléber','Strasbourg',null,'67000','France'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10361,'QUICK',1,to_timestamp('22-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('20-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,183.17,'QUICK-Stop','Taucherstraße 10','Cunewalde',null,'01307','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10362,'BONAP',3,to_timestamp('25-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('28-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,96.04,'Bon app''','12, rue des Bouchers','Marseille',null,'13008','France'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10363,'DRACD',4,to_timestamp('26-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('24-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,30.54,'Drachenblut Delikatessen','Walserweg 21','Aachen',null,'52066','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10364,'EASTC',1,to_timestamp('26-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('07-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,71.97,'Eastern Connection','35 King George','London',null,'WX3 6FW','UK'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10365,'ANTON',3,to_timestamp('27-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('25-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,22,'Antonio Moreno Taquería','Mataderos 2312','México D.F.',null,'05023','Mexico'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10366,'GALED',8,to_timestamp('28-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('30-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,10.14,'Galería del gastronómo','Rambla de Cataluña, 23','Barcelona',null,'8022','Spain'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10367,'VAFFE',7,to_timestamp('28-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('26-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,13.55,'Vaffeljernet','Smagsloget 45','Århus',null,'8200','Denmark'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10368,'ERNSH',2,to_timestamp('29-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('27-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,101.95,'Ernst Handel','Kirchgasse 6','Graz',null,'8010','Austria'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10369,'SPLIR',8,to_timestamp('02-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('30-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,195.68,'Split Rail Beer & Ale','P.O. Box 555','Lander','WY','82520','USA'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10370,'CHOPS',6,to_timestamp('03-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('31-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('27-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,1.17,'Chop-suey Chinese','Hauptstr. 31','Bern',null,'3012','Switzerland'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10371,'LAMAI',1,to_timestamp('03-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('31-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('24-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,0.45,'La maison d''Asie','1 rue Alsace-Lorraine','Toulouse',null,'31000','France'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10372,'QUEEN',5,to_timestamp('04-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('01-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,890.78,'Queen Cozinha','Alameda dos Canàrios, 891','Sao Paulo','SP','05487-020','Brazil'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10373,'HUNGO',4,to_timestamp('05-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('11-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,124.12,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',null,'Ireland'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10374,'WOLZA',1,to_timestamp('05-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,3.94,'Wolski Zajazd','ul. Filtrowa 68','Warszawa',null,'01-012','Poland'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10500,'LAMAI',6,to_timestamp('09-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('07-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('17-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,42.68,'La maison d''Asie','1 rue Alsace-Lorraine','Toulouse',null,'31000','France'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10501,'BLAUS',9,to_timestamp('09-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('07-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,8.85,'Blauer See Delikatessen','Forsterstr. 57','Mannheim',null,'68306','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10502,'PERIC',2,to_timestamp('10-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('08-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('29-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,69.32,'Pericles Comidas clásicas','Calle Dr. Jorge Cash 321','México D.F.',null,'05033','Mexico'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10503,'HUNGO',6,to_timestamp('11-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,16.74,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',null,'Ireland'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10504,'WHITC',4,to_timestamp('11-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,59.13,'White Clover Markets','1029 - 12th Ave. S.','Seattle','WA','98124','USA'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10505,'MEREP',3,to_timestamp('14-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('12-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('21-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,7.13,'Mère Paillarde','43 rue St. Laurent','Montréal','Québec','H1J 1C3','Canada'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10506,'KOENE',9,to_timestamp('15-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,21.19,'Königlich Essen','Maubelstr. 90','Brandenburg',null,'14776','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10507,'ANTON',7,to_timestamp('15-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('22-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,47.45,'Antonio Moreno Taquería','Mataderos 2312','México D.F.',null,'05023','Mexico'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10508,'OTTIK',1,to_timestamp('16-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('14-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,4.99,'Ottilies Käseladen','Mehrheimerstr. 369','Köln',null,'50739','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10509,'BLAUS',4,to_timestamp('17-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('15-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('29-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,0.15,'Blauer See Delikatessen','Forsterstr. 57','Mannheim',null,'68306','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10510,'SAVEA',6,to_timestamp('18-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('28-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,367.63,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10511,'BONAP',4,to_timestamp('18-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('21-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,350.64,'Bon app''','12, rue des Bouchers','Marseille',null,'13008','France'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10512,'FAMIA',7,to_timestamp('21-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('19-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('24-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,3.53,'Familia Arquibaldo','Rua Orós, 92','Sao Paulo','SP','05442-030','Brazil'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10513,'WANDK',7,to_timestamp('22-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('28-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,105.65,'Die Wandernde Kuh','Adenauerallee 900','Stuttgart',null,'70563','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10514,'ERNSH',3,to_timestamp('22-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('20-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,789.95,'Ernst Handel','Kirchgasse 6','Graz',null,'8010','Austria'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10515,'QUICK',2,to_timestamp('23-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('07-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,204.47,'QUICK-Stop','Taucherstraße 10','Cunewalde',null,'01307','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10516,'HUNGO',2,to_timestamp('24-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('22-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('01-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,62.78,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',null,'Ireland'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10517,'NORTS',3,to_timestamp('24-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('22-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('29-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,32.07,'North/South','South House 300 Queensbridge','London',null,'SW7 1RZ','UK'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10518,'TORTU',4,to_timestamp('25-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('05-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,218.15,'Tortuga Restaurante','Avda. Azteca 123','México D.F.',null,'05033','Mexico'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10519,'CHOPS',6,to_timestamp('28-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('26-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('01-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,91.76,'Chop-suey Chinese','Hauptstr. 31','Bern',null,'3012','Switzerland'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10520,'SANTG',7,to_timestamp('29-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('27-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('01-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,13.37,'Santé Gourmet','Erling Skakkes gate 78','Stavern',null,'4110','Norway'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10521,'CACTU',8,to_timestamp('29-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('27-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,17.22,'Cactus Comidas para llevar','Cerrito 333','Buenos Aires',null,'1010','Argentina'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10522,'LEHMS',4,to_timestamp('30-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('28-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('06-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,45.33,'Lehmanns Marktstand','Magazinweg 7','Frankfurt a.M.',null,'60528','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10523,'SEVES',7,to_timestamp('01-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('29-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('30-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,77.63,'Seven Seas Imports','90 Wadhurst Rd.','London',null,'OX15 4NB','UK'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10524,'BERGS',1,to_timestamp('01-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('29-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('07-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,244.79,'Berglunds snabbköp','Berguvsvägen 8','Luleå',null,'S-958 22','Sweden'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10525,'BONAP',1,to_timestamp('02-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('30-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,11.06,'Bon app''','12, rue des Bouchers','Marseille',null,'13008','France'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10526,'WARTH',4,to_timestamp('05-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('15-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,58.59,'Wartian Herkku','Torikatu 38','Oulu',null,'90110','Finland'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10527,'QUICK',7,to_timestamp('05-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('07-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,41.9,'QUICK-Stop','Taucherstraße 10','Cunewalde',null,'01307','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10528,'GREAL',6,to_timestamp('06-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('20-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,3.35,'Great Lakes Food Market','2732 Baker Blvd.','Eugene','OR','97403','USA'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10529,'MAISD',5,to_timestamp('07-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,66.69,'Maison Dewey','Rue Joseph-Bens 532','Bruxelles',null,'B-1180','Belgium'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10530,'PICCO',3,to_timestamp('08-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('05-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('12-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,339.22,'Piccolo und mehr','Geislweg 14','Salzburg',null,'5020','Austria'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10531,'OCEAN',7,to_timestamp('08-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('05-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('19-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,8.12,'Océano Atlántico Ltda.','Ing. Gustavo Moncada 8585 Piso 20-A','Buenos Aires',null,'1010','Argentina'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10532,'EASTC',7,to_timestamp('09-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('06-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('12-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,74.46,'Eastern Connection','35 King George','London',null,'WX3 6FW','UK'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10533,'FOLKO',8,to_timestamp('12-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('22-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,188.04,'Folk och fä HB','Åkergatan 24','Bräcke',null,'S-844 67','Sweden'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10534,'LEHMS',8,to_timestamp('12-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('14-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,27.94,'Lehmanns Marktstand','Magazinweg 7','Frankfurt a.M.',null,'60528','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10535,'ANTON',4,to_timestamp('13-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('10-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('21-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,15.64,'Antonio Moreno Taquería','Mataderos 2312','México D.F.',null,'05023','Mexico'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10536,'LEHMS',3,to_timestamp('14-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('11-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('06-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,58.88,'Lehmanns Marktstand','Magazinweg 7','Frankfurt a.M.',null,'60528','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10537,'RICSU',1,to_timestamp('14-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('28-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('19-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,78.85,'Richter Supermarkt','Starenweg 5','Genève',null,'1204','Switzerland'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10538,'BSBEV',9,to_timestamp('15-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('12-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,4.87,'B''s Beverages','Fauntleroy Circus','London',null,'EC2 5NT','UK'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10539,'BSBEV',6,to_timestamp('16-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,12.36,'B''s Beverages','Fauntleroy Circus','London',null,'EC2 5NT','UK'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10540,'QUICK',3,to_timestamp('19-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,1007.64,'QUICK-Stop','Taucherstraße 10','Cunewalde',null,'01307','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10541,'HANAR',2,to_timestamp('19-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('29-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,68.65,'Hanari Carnes','Rua do Paço, 67','Rio de Janeiro','RJ','05454-876','Brazil'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10542,'KOENE',1,to_timestamp('20-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('17-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('26-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,10.95,'Königlich Essen','Maubelstr. 90','Brandenburg',null,'14776','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10543,'LILAS',8,to_timestamp('21-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,48.17,'LILA-Supermercado','Carrera 52 con Ave. Bolívar #65-98 Llano Largo','Barquisimeto','Lara','3508','Venezuela'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10544,'LONEP',4,to_timestamp('21-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('30-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,24.91,'Lonesome Pine Restaurant','89 Chiaroscuro Rd.','Portland','OR','97219','USA'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10545,'LAZYK',8,to_timestamp('22-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('19-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('26-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,11.92,'Lazy K Kountry Store','12 Orchestra Terrace','Walla Walla','WA','99362','USA'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10546,'VICTE',1,to_timestamp('23-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('20-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('27-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,194.72,'Victuailles en stock','2, rue du Commerce','Lyon',null,'69004','France'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10547,'SEVES',3,to_timestamp('23-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('20-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,178.43,'Seven Seas Imports','90 Wadhurst Rd.','London',null,'OX15 4NB','UK'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10548,'TOMSP',3,to_timestamp('26-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,1.43,'Toms Spezialitäten','Luisenstr. 48','Münster',null,'44087','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10549,'QUICK',5,to_timestamp('27-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('10-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('30-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,171.24,'QUICK-Stop','Taucherstraße 10','Cunewalde',null,'01307','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10550,'GODOS',7,to_timestamp('28-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('25-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('06-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,4.32,'Godos Cocina Típica','C/ Romero, 33','Sevilla',null,'41101','Spain'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10551,'FURIB',4,to_timestamp('28-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-JUL-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('06-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,72.95,'Furia Bacalhau e Frutos do Mar','Jardim das rosas n. 32','Lisboa',null,'1675','Portugal'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10552,'HILAA',2,to_timestamp('29-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('26-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('05-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,83.22,'HILARION-Abastos','Carrera 22 con Ave. Carlos Soublette #8-35','San Cristóbal','Táchira','5022','Venezuela'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10553,'WARTH',2,to_timestamp('30-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('27-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,149.49,'Wartian Herkku','Torikatu 38','Oulu',null,'90110','Finland'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10554,'OTTIK',4,to_timestamp('30-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('27-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('05-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,120.97,'Ottilies Käseladen','Mehrheimerstr. 369','Köln',null,'50739','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10555,'SAVEA',6,to_timestamp('02-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('30-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,252.49,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10556,'SIMOB',2,to_timestamp('03-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('15-JUL-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,9.8,'Simons bistro','Vinbæltet 34','Kobenhavn',null,'1734','Denmark'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10557,'LEHMS',9,to_timestamp('03-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('17-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('06-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,96.72,'Lehmanns Marktstand','Magazinweg 7','Frankfurt a.M.',null,'60528','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10558,'AROUT',1,to_timestamp('04-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-JUL-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('10-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,72.97,'Around the Horn','Brook Farm Stratford St. Mary','Colchester','Essex','CO7 6JX','UK'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10559,'BLONP',6,to_timestamp('05-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-JUL-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,8.05,'Blondel père et fils','24, place Kléber','Strasbourg',null,'67000','France'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10560,'FRANK',8,to_timestamp('06-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-JUL-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,36.65,'Frankenversand','Berliner Platz 43','München',null,'80805','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10561,'FOLKO',2,to_timestamp('06-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-JUL-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,242.21,'Folk och fä HB','Åkergatan 24','Bräcke',null,'S-844 67','Sweden'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10562,'REGGC',1,to_timestamp('09-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('07-JUL-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('12-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,22.95,'Reggiani Caseifici','Strada Provinciale 124','Reggio Emilia',null,'42100','Italy'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10563,'RICAR',2,to_timestamp('10-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('22-JUL-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('24-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,60.43,'Ricardo Adocicados','Av. Copacabana, 267','Rio de Janeiro','RJ','02389-890','Brazil'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10375,'HUNGC',3,to_timestamp('06-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,20.12,'Hungry Coyote Import Store','City Center Plaza 516 Main St.','Elgin','OR','97827','USA'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10376,'MEREP',1,to_timestamp('09-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('06-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,20.39,'Mère Paillarde','43 rue St. Laurent','Montréal','Québec','H1J 1C3','Canada'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10377,'SEVES',1,to_timestamp('09-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('06-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,22.21,'Seven Seas Imports','90 Wadhurst Rd.','London',null,'OX15 4NB','UK'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10378,'FOLKO',5,to_timestamp('10-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('07-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('19-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,5.44,'Folk och fä HB','Åkergatan 24','Bräcke',null,'S-844 67','Sweden'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10379,'QUEDE',2,to_timestamp('11-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('08-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,45.03,'Que Delícia','Rua da Panificadora, 12','Rio de Janeiro','RJ','02389-673','Brazil'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10380,'HUNGO',8,to_timestamp('12-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,35.03,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',null,'Ireland'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10381,'LILAS',3,to_timestamp('12-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,7.99,'LILA-Supermercado','Carrera 52 con Ave. Bolívar #65-98 Llano Largo','Barquisimeto','Lara','3508','Venezuela'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10382,'ERNSH',4,to_timestamp('13-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('10-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,94.77,'Ernst Handel','Kirchgasse 6','Graz',null,'8010','Austria'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10383,'AROUT',8,to_timestamp('16-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,34.24,'Around the Horn','Brook Farm Stratford St. Mary','Colchester','Essex','CO7 6JX','UK'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10384,'BERGS',3,to_timestamp('16-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('20-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,168.64,'Berglunds snabbköp','Berguvsvägen 8','Luleå',null,'S-958 22','Sweden'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10385,'SPLIR',1,to_timestamp('17-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('14-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,30.96,'Split Rail Beer & Ale','P.O. Box 555','Lander','WY','82520','USA'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10386,'FAMIA',9,to_timestamp('18-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('01-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('25-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,13.99,'Familia Arquibaldo','Rua Orós, 92','Sao Paulo','SP','05442-030','Brazil'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10387,'SANTG',1,to_timestamp('18-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('15-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('20-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,93.63,'Santé Gourmet','Erling Skakkes gate 78','Stavern',null,'4110','Norway'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10388,'SEVES',2,to_timestamp('19-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('20-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,34.86,'Seven Seas Imports','90 Wadhurst Rd.','London',null,'OX15 4NB','UK'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10389,'BOTTM',4,to_timestamp('20-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('17-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('24-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,47.42,'Bottom-Dollar Markets','23 Tsawassen Blvd.','Tsawassen','BC','T2F 8M4','Canada'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10390,'ERNSH',6,to_timestamp('23-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('20-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('26-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,126.38,'Ernst Handel','Kirchgasse 6','Graz',null,'8010','Austria'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10391,'DRACD',3,to_timestamp('23-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('20-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('31-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,5.45,'Drachenblut Delikatessen','Walserweg 21','Aachen',null,'52066','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10392,'PICCO',2,to_timestamp('24-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('21-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('01-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,122.46,'Piccolo und mehr','Geislweg 14','Salzburg',null,'5020','Austria'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10393,'SAVEA',1,to_timestamp('25-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('22-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,126.56,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10394,'HUNGC',1,to_timestamp('25-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('22-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,30.34,'Hungry Coyote Import Store','City Center Plaza 516 Main St.','Elgin','OR','97827','USA'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10395,'HILAA',6,to_timestamp('26-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,184.41,'HILARION-Abastos','Carrera 22 con Ave. Carlos Soublette #8-35','San Cristóbal','Táchira','5022','Venezuela'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10396,'FRANK',1,to_timestamp('27-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('10-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('06-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,135.35,'Frankenversand','Berliner Platz 43','München',null,'80805','Germany'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10397,'PRINI',5,to_timestamp('27-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('24-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,60.26,'Princesa Isabel Vinhos','Estrada da saúde n. 58','Lisboa',null,'1756','Portugal'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10398,'SAVEA',2,to_timestamp('30-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('27-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,89.16,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10399,'VAFFE',8,to_timestamp('31-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('14-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('08-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,27.36,'Vaffeljernet','Smagsloget 45','Århus',null,'8200','Denmark'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10400,'EASTC',1,to_timestamp('01-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('29-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,83.93,'Eastern Connection','35 King George','London',null,'WX3 6FW','UK'); |
|
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10401,'RATTC',1,to_timestamp('01-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('29-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('10-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,12.51,'Rattlesnake Canyon Grocery','2817 Milton |