sampledata.script

A complete business intelligence platform that includes reporting, analysis (OLAP), dashboards, data

INSERT INTO QUADRANT_ACTUALS VALUES('Southern','Professional Services','SVP Services',3793000,3818000,25000)
INSERT INTO QUADRANT_ACTUALS VALUES('Southern','Professional Services','Services Mgr',4333400,4318000,-15400)
INSERT INTO QUADRANT_ACTUALS VALUES('Southern','Professional Services','Senior Consultant',3721780,3718000,-3780)
INSERT INTO QUADRANT_ACTUALS VALUES('Southern','Professional Services','Staff Consultant',3465490,3618000,152510)
INSERT INTO QUADRANT_ACTUALS VALUES('Southern','Professional Services','Trainer',3436200,2918000,-518200)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Sales','District Manager',700000,688250,-11750)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Sales','Senior Sales Rep',421200,421299,99)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Sales','Sales Rep',690000,678675,-11325)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Sales','Account Executive',290000,295675,5675)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Sales','Pre-Sales',650000,640375,-9625)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Executive Management','CEO',500000,478750,-21250)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Executive Management','SVP WW Operations',249800,239184,-10616)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Executive Management','SVP Strategic Development',226000,216395,-9605)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Executive Management','SVP Partnerships',531780,509179,-22601)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Finance','CFO',831800,814449,-17351)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Finance','Administrative Assistant',918400,897368,-21032)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Finance','IS',531780,527179,-4601)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Finance','Controller',531200,526624,-4576)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Finance','Payroll',226000,234395,8395)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Human Resource','Administration',500000,496750,-3250)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Human Resource','SVP HR',538000,533135,-4865)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Human Resource','HR Generalists',961000,938158,-22842)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Human Resource','HR Training',271200,277674,6474)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Human Resource','Sexual Harassment',471200,469174,-2026)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Human Resource','EOE',470800,468791,-2009)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Marketing & Communication','CMO',918400,897368,-21032)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Marketing & Communication','Product Marketing Mgr',716400,703953,-12447)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Marketing & Communication','Analyst Relations',250000,257375,7375)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Marketing & Communication','Press Relations',421310,421404,94)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Marketing & Communication','Graphics',850000,831875,-18125)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Marketing & Communication','Writer',284000,289930,5930)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Product Development','CTO',284000,289930,5930)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Product Development','VP Engineering',249800,257184,7384)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Product Development','Senior Engineer',831800,814449,-17351)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Product Development','Engineer',720000,707400,-12600)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Product Development','QA Manager',237200,245119,7919)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Product Development','QA Engineer',226000,234395,8395)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Professional Services','SVP Services',3793000,3818000,25000)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Professional Services','Services Mgr',4333400,4418000,84600)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Professional Services','Senior Consultant',3721780,3718000,-3780)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Professional Services','Staff Consultant',3465490,3336206,-129284)
INSERT INTO QUADRANT_ACTUALS VALUES('Western','Professional Services','Trainer',3436200,2918000,-518200)
INSERT INTO DEPARTMENT_MANAGERS VALUES('Central','Joe Pentaho','[e-mail]')
INSERT INTO DEPARTMENT_MANAGERS VALUES('Eastern','Suzy Pentaho','[e-mail]')
INSERT INTO DEPARTMENT_MANAGERS VALUES('Western','Pat Pentaho','[e-mail]')
INSERT INTO DEPARTMENT_MANAGERS VALUES('Southern','Tiffany Pentaho','[e-mail]')
INSERT INTO CUSTOMERS VALUES(103,'Atelier graphique','Schmitt','Carine','40.32.2555','54, rue Royale',NULL,'Nantes',NULL,'44000','France',1370,21000.0)
INSERT INTO CUSTOMERS VALUES(112,'Signal Gift Stores','King','Sue','7025551838','8489 Strong St.',NULL,'Las Vegas','NV','83030','USA',1166,71800.0)
INSERT INTO CUSTOMERS VALUES(114,'Australian Collectors, Co.','Ferguson','Peter','03 9520 4555','636 St Kilda Road','Level 3','Melbourne','Victoria','3004','Australia',1611,117300.0)
INSERT INTO CUSTOMERS VALUES(119,'La Rochelle Gifts','Labrune','Janine','40.67.8555','67, rue des Cinquante Otages',NULL,'Nantes',NULL,'44000','France',1370,118200.0)
INSERT INTO CUSTOMERS VALUES(121,'Baane Mini Imports','Bergulfsen','Jonas','07-98 9555','Erling Skakkes gate 78',NULL,'Stavern',NULL,'4110','Norway',1504,81700.0)
INSERT INTO CUSTOMERS VALUES(124,'Mini Gifts Distributors Ltd.','Nelson','Valarie','4155551450','5677 Strong St.',NULL,'San Rafael','CA','97562','USA',1165,210500.0)
INSERT INTO CUSTOMERS VALUES(125,'Havel & Zbyszek Co','Piestrzeniewicz','Zbyszek','(26) 642-7555','ul. Filtrowa 68',NULL,'Warszawa',NULL,'01-012','Poland',NULL,0.0)
INSERT INTO CUSTOMERS VALUES(128,'Blauer See Auto, Co.','Keitel','Roland','[phone]','Lyonerstr. 34',NULL,'Frankfurt',NULL,'60528','Germany',1504,59700.0)
INSERT INTO CUSTOMERS VALUES(129,'Mini Wheels Co.','Murphy','Julie','6505555787','5557 North Pendale Street',NULL,'San Francisco','CA','94217','USA',1165,64600.0)
INSERT INTO CUSTOMERS VALUES(131,'Land of Toys Inc.','Yu','Kwai','2125557818','897 Long Airport Avenue',NULL,'NYC','NY','10022','USA',1323,114900.0)
INSERT INTO CUSTOMERS VALUES(141,'Euro+ Shopping Channel','Freyre','Diego','(91) 555 94 44','C/ Moralzarzal, 86',NULL,'Madrid',NULL,'28034','Spain',1370,227600.0)
INSERT INTO CUSTOMERS VALUES(144,'Volvo Model Replicas, Co','Berglund','Christina','0921-12 3555','Berguvsv\u00e4gen  8',NULL,'Lule\u00e5',NULL,'S-958 22','Sweden',1504,53100.0)
INSERT INTO CUSTOMERS VALUES(145,'Danish Wholesale Imports','Petersen','Jytte','31 12 3555','Vinb\u00e6ltet 34',NULL,'Kobenhavn',NULL,'1734','Denmark',1401,83400.0)
INSERT INTO CUSTOMERS VALUES(146,'Saveley & Henriot, Co.','Saveley','Mary','78.32.5555','2, rue du Commerce',NULL,'Lyon',NULL,'69004','France',1337,123900.0)
INSERT INTO CUSTOMERS VALUES(148,'Dragon Souveniers, Ltd.','Natividad','Eric','[phone]','Bronz Sok., Bronz Apt. 3/6 Tesvikiye',NULL,'Singapore',NULL,'079903','Singapore',1621,103800.0)
INSERT INTO CUSTOMERS VALUES(151,'Muscle Machine Inc','Young','Jeff','2125557413','4092 Furth Circle','Suite 400','NYC','NY','10022','USA',1286,138500.0)
INSERT INTO CUSTOMERS VALUES(157,'Diecast Classics Inc.','Yu','Kyung','2155551555','7586 Pompton St.',NULL,'Allentown','PA','70267','USA',1216,100600.0)
INSERT INTO CUSTOMERS VALUES(161,'Technics Stores Inc.','Hirano','Juri','6505556809','9408 Furth Circle',NULL,'Burlingame','CA','94217','USA',1165,84600.0)
INSERT INTO CUSTOMERS VALUES(166,'Handji Gifts& Co','Victorino','Wendy','[phone]','Village Close - 106 Linden Road Sandown','2nd Floor','Singapore',NULL,'069045','Singapore',1612,97900.0)
INSERT INTO CUSTOMERS VALUES(167,'Herkku Gifts','Oeztan','Veysel','[phone]','Drammen 121, PR 744 Sentrum',NULL,'Bergen',NULL,'N 5804','Norway',1504,96800.0)
INSERT INTO CUSTOMERS VALUES(168,'American Souvenirs Inc','Franco','Sue','2035557845','149 Spinnaker Dr.','Suite 101','New Haven','CT','97823','USA',1286,0.0)
INSERT INTO CUSTOMERS VALUES(169,'Porto Imports Co.','de Castro','Isabel','(1) 356-5555','Estrada da sa\u00fade n. 58',NULL,'Lisboa',NULL,'1756','Portugal',NULL,0.0)
INSERT INTO CUSTOMERS VALUES(171,'Daedalus Designs Imports','Ranc\u00e9','Martine','20.16.1555','184, chauss\u00e9e de Tournai',NULL,'Lille',NULL,'59000','France',1370,82900.0)
INSERT INTO CUSTOMERS VALUES(172,'La Corne D''abondance, Co.','Bertrand','Marie','(1) 42.34.2555','265, boulevard Charonne',NULL,'Paris',NULL,'75012','France',1337,84300.0)
INSERT INTO CUSTOMERS VALUES(173,'Cambridge Collectables Co.','Tseng','Kyung','6175555555','4658 Baden Av.',NULL,'Cambridge','MA','51247','USA',1188,43400.0)
INSERT INTO CUSTOMERS VALUES(175,'Gift Depot Inc.','King','Julie','2035552570','25593 South Bay Ln.',NULL,'Bridgewater','CT','97562','USA',1323,84300.0)
INSERT INTO CUSTOMERS VALUES(177,'Osaka Souveniers Co.','Kentary','Mory','[phone]','Dojima Avanza 4F, 1-6-20 Dojima, Kita-ku',NULL,'Osaka','Osaka',' 530-0003','Japan',1621,81200.0)
INSERT INTO CUSTOMERS VALUES(181,'Vitachrome Inc.','Frick','Michael','2125551500','2678 Kingston Rd.','Suite 101','NYC','NY','10022','USA',1286,76400.0)
INSERT INTO CUSTOMERS VALUES(186,'Toys of Finland, Co.','Karttunen','Matti','90-224 8555','Keskuskatu 45',NULL,'Helsinki',NULL,'21240','Finland',1501,96500.0)
INSERT INTO CUSTOMERS VALUES(187,'AV Stores, Co.','Ashworth','Victoria','[phone]','Fauntleroy Circus',NULL,'Manchester',NULL,'EC2 5NT','UK',1501,136800.0)
INSERT INTO CUSTOMERS VALUES(189,'Clover Collections, Co.','Cassidy','Dean','[phone]','25 Maiden Lane','Floor No. 4','Dublin',NULL,'2','Ireland',1504,69400.0)
INSERT INTO CUSTOMERS VALUES(198,'Auto-Moto Classics Inc.','Taylor','Leslie','6175558428','16780 Pompton St.',NULL,'Brickhaven','MA','58339','USA',1216,23000.0)
INSERT INTO CUSTOMERS VALUES(201,'UK Collectables, Ltd.','Devon','Elizabeth','[phone]','Berkeley Gardens 12  Brewery',NULL,'Liverpool',NULL,'WX1 6LT','UK',1501,92700.0)
INSERT INTO CUSTOMERS VALUES(202,'Canadian Gift Exchange Network','Tannamuri','Yoshi','[phone]','1900 Oak St.',NULL,'Vancouver','BC','V3F 2K1','Canada',1323,90300.0)
INSERT INTO CUSTOMERS VALUES(204,'Online Mini Collectables','Barajas','Miguel','6175557555','7635 Spinnaker Dr.',NULL,'Brickhaven','MA','58339','USA',1188,68700.0)
INSERT INTO CUSTOMERS VALUES(205,'Toys4GrownUps.com','Young','Julie','6265557265','78934 Hillside Dr.',NULL,'Pasadena','CA','90003','USA',1166,90700.0)
INSERT INTO CUSTOMERS VALUES(206,'Asian Shopping Network, Co','Walker','Brydey','[phone]','Penthouse Level, Suntec Tower Three, 8 Temasek',NULL,'Singapore',NULL,'038988','Singapore',NULL,0.0)
INSERT INTO CUSTOMERS VALUES(209,'Mini Caravy','Citeaux','Fr\u00e9d\u00e9rique','88.60.1555','24, place Kl\u00e9ber',NULL,'Strasbourg',NULL,'67000','France',1370,53800.0)
INSERT INTO CUSTOMERS VALUES(211,'King Kong Collectables, Co.','Sunwoo','Michael','[phone]','Bank of China Tower, 1 Garden Road','Level 25','Central Hong Kong',NULL,'','Hong Kong',1621,58600.0)
INSERT INTO CUSTOMERS VALUES(216,'Enaco Distributors','Saavedra','Eduardo','(93) 203 4555','Rambla de Catalu\u00f1a, 23',NULL,'Barcelona',NULL,'08022','Spain',1702,60300.0)
INSERT INTO CUSTOMERS VALUES(219,'Boards & Toys Co.','Young','Leslie','3105552373','4097 Douglas Av.',NULL,'Glendale','CA','92561','USA',1166,11000.0)
INSERT INTO CUSTOMERS VALUES(223,'Nat\u00fcrlich Autos','Kloss','Horst','0372-555188','Taucherstra\u00dfe 10',NULL,'Cunewalde',NULL,'01307','Germany',NULL,0.0)
INSERT INTO CUSTOMERS VALUES(227,'Heintze Collectables','Ibsen','Palle','86 21 3555','Smagsloget 45',NULL,'\u00c5rhus',NULL,'8200','Denmark',1401,120800.0)
INSERT INTO CUSTOMERS VALUES(233,'Qu\u00e9bec Home Shopping Network','Fresni\u00e8re','Jean','[phone]','43 rue St. Laurent',NULL,'Montr\u00e9al','Qu\u00e9bec','H1J 1C3','Canada',1286,48700.0)
INSERT INTO CUSTOMERS VALUES(237,'ANG Resellers','Camino','Alejandra','(91) 745 6555','Gran V\u00eda, 1',NULL,'Madrid',NULL,'28001','Spain',NULL,0.0)
INSERT INTO CUSTOMERS VALUES(239,'Collectable Mini Designs Co.','Thompson','Valarie','7605558146','361 Furth Circle',NULL,'San Diego','CA','91217','USA',1166,105000.0)
INSERT INTO CUSTOMERS VALUES(240,'giftsbymail.co.uk','Bennett','Helen','[phone]','Garden House Crowther Way',NULL,'Cowes','Isle of Wight','PO31 7PJ','UK',1501,93900.0)
INSERT INTO CUSTOMERS VALUES(242,'Alpha Cognac','Roulet','Annette','61.77.6555','1 rue Alsace-Lorraine',NULL,'Toulouse',NULL,'31000','France',1370,61100.0)
INSERT INTO CUSTOMERS VALUES(247,'Messner Shopping Network','Messner','Renate','069-0555984','Magazinweg 7',NULL,'Frankfurt',NULL,'60528','Germany',NULL,0.0)
INSERT INTO CUSTOMERS VALUES(249,'Amica Models & Co.','Accorti','Paolo','011-4988555','Via Monte Bianco 34',NULL,'Torino',NULL,'10100','Italy',1401,113000.0)
INSERT INTO CUSTOMERS VALUES(250,'Lyon Souveniers','Da Cunha','Daniel','[phone]','27 rue du Colonel Pierre Avia',NULL,'Paris',NULL,'75508','France',1337,68100.0)
INSERT INTO CUSTOMERS VALUES(256,'Auto Associ\u00e9s & Cie.','Tonini','Daniel','30.59.8555','67, avenue de l''Europe',NULL,'Versailles',NULL,'78000','France',1370,77900.0)
INSERT INTO CUSTOMERS VALUES(259,'Toms Spezialit\u00e4ten, Ltd','Pfalzheim','Henriette','0221-5554327','Mehrheimerstr. 369',NULL,'K\u00f6ln',NULL,'50739','Germany',1504,120400.0)
INSERT INTO CUSTOMERS VALUES(260,'Royal Canadian Collectables, Ltd.','Lincoln','Elizabeth','[phone]','23 Tsawassen Blvd.',NULL,'Tsawassen','BC','T2F 8M4','Canada',1323,89600.0)
INSERT INTO CUSTOMERS VALUES(273,'Franken Gifts, Co','Franken','Peter','089-0877555','Berliner Platz 43',NULL,'M\u00fcnchen',NULL,'80805','Germany',NULL,0.0)
INSERT INTO CUSTOMERS VALUES(276,'Anna''s Decorations, Ltd','O''Hara','Anna','02 9936 8555','201 Miller Street','Level 15','North Sydney','NSW','2060','Australia',1611,107800.0)
INSERT INTO CUSTOMERS VALUES(278,'Rovelli Gifts','Rovelli','Giovanni','035-640555','Via Ludovico il Moro 22',NULL,'Bergamo',NULL,'24100','Italy',1401,119600.0)
INSERT INTO CUSTOMERS VALUES(282,'Souveniers And Things Co.','Huxley','Adrian','[phone]','Monitor Money Building, 815 Pacific Hwy','Level 6','Chatswood','NSW','2067','Australia',1611,93300.0)
INSERT INTO CUSTOMERS VALUES(286,'Marta''s Replicas Co.','Hernandez','Marta','6175558555','39323 Spinnaker Dr.',NULL,'Cambridge','MA','51247','USA',1216,123700.0)
INSERT INTO CUSTOMERS VALUES(293,'BG&E Collectables','Pon','Ed','[phone]','Rte des Arsenaux 41',NULL,'Fribourg',NULL,'1700','Switzerland',NULL,0.0)
INSERT INTO CUSTOMERS VALUES(298,'Vida Sport, Ltd','Holz','Michael','0897-034555','Grenzacherweg 237',NULL,'Gen\u00e8ve',NULL,'1203','Switzerland',1702,141300.0)
INSERT INTO CUSTOMERS VALUES(299,'Norway Gifts By Mail, Co.','Klaeboe','Jan','[phone]','Drammensveien 126 A, PB 744 Sentrum',NULL,'Oslo',NULL,'N 0106','Norway',1504,95100.0)
INSERT INTO CUSTOMERS VALUES(303,'Schuyler Imports','Schuyler','Bradley','[phone]','Kingsfordweg 151',NULL,'Amsterdam',NULL,'1043 GR','Netherlands',NULL,0.0)
INSERT INTO CUSTOMERS VALUES(307,'Der Hund Imports','Anders','Maria','030-0074555','Obere Str. 57',NULL,'Berlin',NULL,'12209','Germany',NULL,0.0)
INSERT INTO CUSTOMERS VALUES(311,'Oulu Toy Supplies, Inc.','Koskitalo','Pirkko','981-443655','Torikatu 38',NULL,'Oulu',NULL,'90110','Finland',1501,90500.0)
INSERT INTO CUSTOMERS VALUES(314,'Petit Auto','Dewey','Catherine','(02) 5554 67','Rue Joseph-Bens 532',NULL,'Bruxelles',NULL,'B-1180','Belgium',1401,79900.0)
INSERT INTO CUSTOMERS VALUES(319,'Mini Classics','Frick','Steve','9145554562','3758 North Pendale Street',NULL,'White Plains','NY','24067','USA',1323,102700.0)
INSERT INTO CUSTOMERS VALUES(320,'Mini Creations Ltd.','Tam','Wing C','5085559555','4575 Hillside Dr.',NULL,'New Bedford','MA','50553','USA',1188,94500.0)
INSERT INTO CUSTOMERS VALUES(321,'Corporate Gift Ideas Co.','Brown','Julie','6505551386','7734 Strong St.',NULL,'San Francisco','CA','94217','USA',1165,105000.0)
INSERT INTO CUSTOMERS VALUES(323,'Down Under Souveniers, Inc','Graham','Mike','[phone]','162-164 Grafton Road','Level 2','Auckland',NULL,'','New Zealand',1612,88000.0)
INSERT INTO CUSTOMERS VALUES(324,'Stylish Desk Decors, Co.','Brown','Ann','[phone]','35 King George',NULL,'London',NULL,'WX3 6FW','UK',1501,77000.0)
INSERT INTO CUSTOMERS VALUES(328,'Tekni Collectables Inc.','Brown','William','2015559350','7476 Moss Rd.',NULL,'Newark','NJ','94019','USA',1323,44100.0)
INSERT INTO CUSTOMERS VALUES(333,'Australian Gift Network, Co','Calaghan','Tony','61-7-3844-6555','31 Duncan St. West End',NULL,'South Brisbane','Queensland','4101','Australia',1611,51600.0)
INSERT INTO CUSTOMERS VALUES(334,'Suominen Souveniers','Suominen','Kalle','[phone]','Software Engineering Center, SEC Oy',NULL,'Espoo',NULL,'FIN-02271','Finland',1501,98800.0)
INSERT INTO CUSTOMERS VALUES(335,'Cramer Spezialit\u00e4ten, Ltd','Cramer','Philip','0555-09555','Maubelstr. 90',NULL,'Brandenburg',NULL,'14776','Germany',NULL,0.0)
INSERT INTO CUSTOMERS VALUES(339,'Classic Gift Ideas, Inc','Cervantes','Francisca','2155554695','782 First Street',NULL,'Philadelphia','PA','71270','USA',1188,81100.0)
INSERT INTO CUSTOMERS VALUES(344,'CAF Imports','Fernandez','Jesus','[phone]','Merchants House, 27-30 Merchant''s Quay',NULL,'Madrid',NULL,'28023','Spain',1702,59600.0)
INSERT INTO CUSTOMERS VALUES(347,'Men ''R'' US Retailers, Ltd.','Chandler','Michael','2155554369','6047 Douglas Av.',NULL,'Los Angeles','CA','91003','USA',1166,57700.0)
INSERT INTO CUSTOMERS VALUES(348,'Asian Treasures, Inc.','McKenna','Patricia','2967 555','8 Johnstown Road',NULL,'Cork','Co. Cork',NULL,'Ireland',NULL,0.0)
INSERT INTO CUSTOMERS VALUES(350,'Marseille Mini Autos','Lebihan','Laurence','91.24.4555','12, rue des Bouchers',NULL,'Marseille',NULL,'13008','France',1337,65000.0)
INSERT INTO CUSTOMERS VALUES(353,'Reims Collectables','Henriot','Paul','26.47.1555','59 rue de l''Abbaye',NULL,'Reims',NULL,'51100','France',1337,81100.0)
INSERT INTO CUSTOMERS VALUES(356,'SAR Distributors, Co','Kuger','Armand','[phone]','Century City-Montague Gardens PO Box 37177',NULL,'Chempet',NULL,' 7442','South Africa',NULL,0.0)
INSERT INTO CUSTOMERS VALUES(357,'GiftsForHim.com','MacKinlay','Wales','64-9-3763555','199 Great North Road',NULL,'Auckland',NULL,'','New Zealand',1612,77700.0)
INSERT INTO CUSTOMERS VALUES(361,'Kommission Auto','Josephs','Karin','0251-555259','Luisenstr. 48',NULL,'M\u00fcnster',NULL,'44087','Germany',NULL,0.0)
INSERT INTO CUSTOMERS VALUES(362,'Gifts4AllAges.com','Yoshido','Juri','6175559555','8616 Spinnaker Dr.',NULL,'Boston','MA','51003','USA',1216,41900.0)
INSERT INTO CUSTOMERS VALUES(363,'Online Diecast Creations Co.','Young','Valarie','6035558647','2304 Long Airport Avenue',NULL,'Nashua','NH','62005','USA',1216,114200.0)
INSERT INTO CUSTOMERS VALUES(369,'Lisboa Souveniers, Inc','Rodriguez','Lino','(1) 354-2555','Jardim das rosas n. 32',NULL,'Lisboa',NULL,'1675','Portugal',NULL,0.0)
INSERT INTO CUSTOMERS VALUES(376,'Precious Collectables','Wang','Yang','0452-076555','Hauptstr. 29',NULL,'Bern',NULL,'3012','Switzerland',1702,0.0)
INSERT INTO CUSTOMERS VALUES(379,'Collectables For Less Inc.','Nelson','Allen','6175558555','7825 Douglas Av.',NULL,'Brickhaven','MA','58339','USA',1188,70700.0)
INSERT INTO CUSTOMERS VALUES(381,'Royale Belge','Cartrain','Pascale','(071) 23 67 2555','Boulevard Tirou, 255',NULL,'Charleroi',NULL,'B-6000','Belgium',1401,23500.0)
INSERT INTO CUSTOMERS VALUES(382,'Salzburg Collectables','Pipps','Georg','6562-9555','Geislweg 14',NULL,'Salzburg',NULL,'5020','Austria',1401,71700.0)