sampledata.script

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

INSERT INTO CUSTOMERS VALUES(385,'Cruz & Sons Co.','Cruz','Arnold','[phone]','15 McCallum Street - NatWest Center #13-03',NULL,'Makati City',NULL,'1227 MM','Philippines',1621,81500.0)
INSERT INTO CUSTOMERS VALUES(386,'L''ordine Souveniers','Moroni','Maurizio','0522-556555','Strada Provinciale 124',NULL,'Reggio Emilia',NULL,'42100','Italy',1401,121400.0)
INSERT INTO CUSTOMERS VALUES(398,'Tokyo Collectables, Ltd','Shimamura','Akiko','[phone]','2-2-8 Roppongi',NULL,'Minato-ku','Tokyo','106-0032','Japan',1621,94400.0)
INSERT INTO CUSTOMERS VALUES(406,'Auto Canal+ Petit','Perrier','Dominique','(1) 47.55.6555','25, rue Lauriston',NULL,'Paris',NULL,'75016','France',1337,95000.0)
INSERT INTO CUSTOMERS VALUES(409,'Stuttgart Collectable Exchange','M\u00fcller','Rita','0711-555361','Adenauerallee 900',NULL,'Stuttgart',NULL,'70563','Germany',NULL,0.0)
INSERT INTO CUSTOMERS VALUES(412,'Extreme Desk Decorations, Ltd','McRoy','Sarah','04 499 9555','101 Lambton Quay','Level 11','Wellington',NULL,'','New Zealand',1612,86800.0)
INSERT INTO CUSTOMERS VALUES(415,'Bavarian Collectables Imports, Co.','Donnermeyer','Michael',' [phone]','Hansastr. 15',NULL,'Munich',NULL,'80686','Germany',1504,77000.0)
INSERT INTO CUSTOMERS VALUES(424,'Classic Legends Inc.','Hernandez','Maria','2125558493','5905 Pompton St.','Suite 750','NYC','NY','10022','USA',1286,67500.0)
INSERT INTO CUSTOMERS VALUES(443,'Feuer Online Stores, Inc','Feuer','Alexander','0342-555176','Heerstr. 22',NULL,'Leipzig',NULL,'04179','Germany',NULL,0.0)
INSERT INTO CUSTOMERS VALUES(447,'Gift Ideas Corp.','Lewis','Dan','2035554407','2440 Pompton St.',NULL,'Glendale','CT','97561','USA',1323,49700.0)
INSERT INTO CUSTOMERS VALUES(448,'Scandinavian Gift Ideas','Larsson','Maria','0695-34 6555','\u00c5kergatan 24',NULL,'Br\u00e4cke',NULL,'S-844 67','Sweden',1504,116400.0)
INSERT INTO CUSTOMERS VALUES(450,'The Sharp Gifts Warehouse','Frick','Sue','4085553659','3086 Ingle Ln.',NULL,'San Jose','CA','94217','USA',1165,77600.0)
INSERT INTO CUSTOMERS VALUES(452,'Mini Auto Werke','Mendel','Roland','7675-3555','Kirchgasse 6',NULL,'Graz',NULL,'8010','Austria',1401,45300.0)
INSERT INTO CUSTOMERS VALUES(455,'Super Scale Inc.','Murphy','Leslie','2035559545','567 North Pendale Street',NULL,'New Haven','CT','97823','USA',1286,95400.0)
INSERT INTO CUSTOMERS VALUES(456,'Microscale Inc.','Kuo','Kee','2125551957','5290 North Pendale Street','Suite 200','NYC','NY','10022','USA',1286,39800.0)
INSERT INTO CUSTOMERS VALUES(458,'Corrida Auto Replicas, Ltd','Sommer','Mart\u00edn','(91) 555 22 82','C/ Araquil, 67',NULL,'Madrid',NULL,'28023','Spain',1702,104600.0)
INSERT INTO CUSTOMERS VALUES(459,'Warburg Exchange','Ottlieb','Sven','0241-039123','Walserweg 21',NULL,'Aachen',NULL,'52066','Germany',NULL,0.0)
INSERT INTO CUSTOMERS VALUES(462,'FunGiftIdeas.com','Benitez','Violeta','5085552555','1785 First Street',NULL,'New Bedford','MA','50553','USA',1216,85800.0)
INSERT INTO CUSTOMERS VALUES(465,'Anton Designs, Ltd.','Anton','Carmen','[phone]','c/ Gobelas, 19-1 Urb. La Florida',NULL,'Madrid',NULL,'28023','Spain',NULL,0.0)
INSERT INTO CUSTOMERS VALUES(471,'Australian Collectables, Ltd','Connery','Sean','61-9-3844-6555','7 Allen Street',NULL,'Glen Waverly','Victoria','3150','Australia',1611,60300.0)
INSERT INTO CUSTOMERS VALUES(473,'Frau da Collezione','Ricotti','Franco','[phone]','20093 Cologno Monzese, via Alessandro Volta 16',NULL,'Milan',NULL,'','Italy',1401,34800.0)
INSERT INTO CUSTOMERS VALUES(475,'West Coast Collectables Co.','Thompson','Steve','3105553722','3675 Furth Circle',NULL,'Burbank','CA','94019','USA',1166,55400.0)
INSERT INTO CUSTOMERS VALUES(477,'Mit Vergn\u00fcgen & Co.','Moos','Hanna','0621-08555','Forsterstr. 57',NULL,'Mannheim',NULL,'68306','Germany',NULL,0.0)
INSERT INTO CUSTOMERS VALUES(480,'Kremlin Collectables, Co.','Semenov','Alexander','[phone]','2 Pobedy Square',NULL,'Saint Petersburg',NULL,'196143','Russia',NULL,0.0)
INSERT INTO CUSTOMERS VALUES(481,'Raanan Stores, Inc','Altagar,G M','Raanan','+ 972 9 959 8555','3 Hagalim Blv.,',NULL,'Herzlia',NULL,'47625','Israel',NULL,0.0)
INSERT INTO CUSTOMERS VALUES(484,'Iberia Gift Imports, Corp.','Roel','Jos\u00e9 Pedro','(95) 555 82 82','C/ Romero, 33',NULL,'Sevilla',NULL,'41101','Spain',1702,65700.0)
INSERT INTO CUSTOMERS VALUES(486,'Motor Mint Distributors Inc.','Hernandez','Rosa','2155559857','11328 Douglas Av.',NULL,'Philadelphia','PA','71270','USA',1323,72600.0)
INSERT INTO CUSTOMERS VALUES(487,'Signal Collectibles Ltd.','Taylor','Sue','4155554312','2793 Furth Circle',NULL,'Brisbane','CA','94217','USA',1165,60300.0)
INSERT INTO CUSTOMERS VALUES(489,'Double Decker Gift Stores, Ltd','Hardy','Thomas','[phone]','120 Hanover Sq.',NULL,'London',NULL,'WA1 1DP','UK',1501,43300.0)
INSERT INTO CUSTOMERS VALUES(495,'Diecast Collectables','Franco','Valarie','6175552555','6251 Ingle Ln.',NULL,'Boston','MA','51003','USA',1188,85100.0)
INSERT INTO CUSTOMERS VALUES(496,'Kelly''s Gift Shop','Snowden','Tony','[phone]','Arenales 1938 3''A''',NULL,'Auckland',NULL,'','New Zealand',1612,110000.0)
INSERT INTO EMPLOYEES VALUES(1002,'Murphy','Diane','x5800','[e-mail]','1',NULL,'President')
INSERT INTO EMPLOYEES VALUES(1056,'Patterson','Mary','x4611','[e-mail]','1',1002,'VP Sales')
INSERT INTO EMPLOYEES VALUES(1076,'Firrelli','Jeff','x9273','[e-mail]','1',1002,'VP Marketing')
INSERT INTO EMPLOYEES VALUES(1088,'Patterson','William','x4871','[e-mail]','6',1056,'Sales Manager (JAPAN, APAC)')
INSERT INTO EMPLOYEES VALUES(1102,'Bondur','Gerard','x5408','[e-mail]','4',1056,'Sale Manager (EMEA)')
INSERT INTO EMPLOYEES VALUES(1143,'Bow','Anthony','x5428','[e-mail]','1',1056,'Sales Manager (NA)')
INSERT INTO EMPLOYEES VALUES(1165,'Jennings','Leslie','x3291','[e-mail]','1',1143,'Sales Rep')
INSERT INTO EMPLOYEES VALUES(1166,'Thompson','Leslie','x4065','[e-mail]','1',1143,'Sales Rep')
INSERT INTO EMPLOYEES VALUES(1188,'Firrelli','Julie','x2173','[e-mail]','2',1143,'Sales Rep')
INSERT INTO EMPLOYEES VALUES(1216,'Patterson','Steve','x4334','[e-mail]','2',1143,'Sales Rep')
INSERT INTO EMPLOYEES VALUES(1286,'Tseng','Foon Yue','x2248','[e-mail]','3',1143,'Sales Rep')
INSERT INTO EMPLOYEES VALUES(1323,'Vanauf','George','x4102','[e-mail]','3',1143,'Sales Rep')
INSERT INTO EMPLOYEES VALUES(1337,'Bondur','Loui','x6493','[e-mail]','4',1102,'Sales Rep')
INSERT INTO EMPLOYEES VALUES(1370,'Hernandez','Gerard','x2028','[e-mail]','4',1102,'Sales Rep')
INSERT INTO EMPLOYEES VALUES(1401,'Castillo','Pamela','x2759','[e-mail]','4',1102,'Sales Rep')
INSERT INTO EMPLOYEES VALUES(1501,'Bott','Larry','x2311','[e-mail]','7',1102,'Sales Rep')
INSERT INTO EMPLOYEES VALUES(1504,'Jones','Barry','x102','[e-mail]','7',1102,'Sales Rep')
INSERT INTO EMPLOYEES VALUES(1611,'Fixter','Andy','x101','[e-mail]','6',1088,'Sales Rep')
INSERT INTO EMPLOYEES VALUES(1612,'Marsh','Peter','x102','[e-mail]','6',1088,'Sales Rep')
INSERT INTO EMPLOYEES VALUES(1619,'King','Tom','x103','[e-mail]','6',1088,'Sales Rep')
INSERT INTO EMPLOYEES VALUES(1621,'Nishi','Mami','x101','[e-mail]','5',1088,'Sales Rep')
INSERT INTO EMPLOYEES VALUES(1625,'Kato','Yoshimi','x102','[e-mail]','5',1088,'Sales Rep')
INSERT INTO EMPLOYEES VALUES(1702,'Gerard','Martin','x2312','[e-mail]','4',1102,'Sales Rep')
INSERT INTO OFFICES VALUES('1','San Francisco','[phone]','100 Market Street','Suite 300','CA','USA','94080','NA')
INSERT INTO OFFICES VALUES('2','Boston','[phone]','1550 Court Place','Suite 102','MA','USA','02107','NA')
INSERT INTO OFFICES VALUES('3','NYC','[phone]','523 East 53rd Street','apt. 5A','NY','USA','10022','NA')
INSERT INTO OFFICES VALUES('4','Paris','[phone]','43 Rue Jouffroy D''abbans',NULL,'','France','75017','EMEA')
INSERT INTO OFFICES VALUES('5','Tokyo','[phone]','4-1 Kioicho',NULL,'Chiyoda-Ku','Japan','102-8578','Japan')
INSERT INTO OFFICES VALUES('6','Sydney','[phone]','5-11 Wentworth Avenue','Floor #2',NULL,'Australia','NSW 2010','APAC')
INSERT INTO OFFICES VALUES('7','London','[phone]','25 Old Broad Street','Level 7',NULL,'UK','EC2N 1HN','EMEA')
INSERT INTO ORDERDETAILS VALUES(10100,'S18_1749',30,171.7,3)
INSERT INTO ORDERDETAILS VALUES(10100,'S18_2248',50,67.8,2)
INSERT INTO ORDERDETAILS VALUES(10100,'S18_4409',22,86.51,4)
INSERT INTO ORDERDETAILS VALUES(10100,'S24_3969',49,34.47,1)
INSERT INTO ORDERDETAILS VALUES(10101,'S18_2325',25,151.28,4)
INSERT INTO ORDERDETAILS VALUES(10101,'S18_2795',26,145.13,1)
INSERT INTO ORDERDETAILS VALUES(10101,'S24_1937',45,31.2,3)
INSERT INTO ORDERDETAILS VALUES(10101,'S24_2022',46,53.76,2)
INSERT INTO ORDERDETAILS VALUES(10102,'S18_1342',39,123.29,2)
INSERT INTO ORDERDETAILS VALUES(10102,'S18_1367',41,50.14,1)
INSERT INTO ORDERDETAILS VALUES(10103,'S10_1949',26,207.87,11)
INSERT INTO ORDERDETAILS VALUES(10103,'S10_4962',42,128.53,4)
INSERT INTO ORDERDETAILS VALUES(10103,'S12_1666',27,125.74,8)
INSERT INTO ORDERDETAILS VALUES(10103,'S18_1097',35,112.0,10)
INSERT INTO ORDERDETAILS VALUES(10103,'S18_2432',22,54.09,2)
INSERT INTO ORDERDETAILS VALUES(10103,'S18_2949',27,83.07,12)
INSERT INTO ORDERDETAILS VALUES(10103,'S18_2957',35,57.46,14)
INSERT INTO ORDERDETAILS VALUES(10103,'S18_3136',25,101.58,13)
INSERT INTO ORDERDETAILS VALUES(10103,'S18_3320',46,104.17,16)
INSERT INTO ORDERDETAILS VALUES(10103,'S18_4600',36,117.45,5)
INSERT INTO ORDERDETAILS VALUES(10103,'S18_4668',41,47.29,9)
INSERT INTO ORDERDETAILS VALUES(10103,'S24_2300',36,102.23,1)
INSERT INTO ORDERDETAILS VALUES(10103,'S24_4258',25,114.92,15)
INSERT INTO ORDERDETAILS VALUES(10103,'S32_1268',31,104.01,3)
INSERT INTO ORDERDETAILS VALUES(10103,'S32_3522',45,75.63,7)
INSERT INTO ORDERDETAILS VALUES(10103,'S700_2824',42,106.21,6)
INSERT INTO ORDERDETAILS VALUES(10104,'S12_3148',34,175.25,1)
INSERT INTO ORDERDETAILS VALUES(10104,'S12_4473',41,112.58,9)
INSERT INTO ORDERDETAILS VALUES(10104,'S18_2238',24,144.08,8)
INSERT INTO ORDERDETAILS VALUES(10104,'S18_2319',29,130.09,12)
INSERT INTO ORDERDETAILS VALUES(10104,'S18_3232',23,198.13,13)
INSERT INTO ORDERDETAILS VALUES(10104,'S18_4027',38,140.75,3)
INSERT INTO ORDERDETAILS VALUES(10104,'S24_1444',35,55.49,6)
INSERT INTO ORDERDETAILS VALUES(10104,'S24_2840',44,39.6,10)
INSERT INTO ORDERDETAILS VALUES(10104,'S24_4048',26,112.37,5)
INSERT INTO ORDERDETAILS VALUES(10104,'S32_2509',35,47.62,11)
INSERT INTO ORDERDETAILS VALUES(10104,'S32_3207',49,65.87,4)
INSERT INTO ORDERDETAILS VALUES(10104,'S50_1392',33,112.28,7)
INSERT INTO ORDERDETAILS VALUES(10104,'S50_1514',32,53.31,2)
INSERT INTO ORDERDETAILS VALUES(10105,'S10_4757',50,144.16,2)
INSERT INTO ORDERDETAILS VALUES(10105,'S12_1108',41,211.96,15)
INSERT INTO ORDERDETAILS VALUES(10105,'S12_3891',29,157.45,14)
INSERT INTO ORDERDETAILS VALUES(10105,'S18_3140',22,139.32,11)
INSERT INTO ORDERDETAILS VALUES(10105,'S18_3259',38,113.95,13)
INSERT INTO ORDERDETAILS VALUES(10105,'S18_4522',41,82.5,10)
INSERT INTO ORDERDETAILS VALUES(10105,'S24_2011',43,147.47,9)
INSERT INTO ORDERDETAILS VALUES(10105,'S24_3151',44,72.58,4)
INSERT INTO ORDERDETAILS VALUES(10105,'S24_3816',50,79.67,1)
INSERT INTO ORDERDETAILS VALUES(10105,'S700_1138',41,70.67,5)
INSERT INTO ORDERDETAILS VALUES(10105,'S700_1938',29,70.15,12)
INSERT INTO ORDERDETAILS VALUES(10105,'S700_2610',31,65.77,3)
INSERT INTO ORDERDETAILS VALUES(10105,'S700_3505',39,81.14,6)
INSERT INTO ORDERDETAILS VALUES(10105,'S700_3962',22,116.19,7)
INSERT INTO ORDERDETAILS VALUES(10105,'S72_3212',25,56.78,8)
INSERT INTO ORDERDETAILS VALUES(10106,'S18_1662',36,146.65,12)
INSERT INTO ORDERDETAILS VALUES(10106,'S18_2581',34,90.39,2)
INSERT INTO ORDERDETAILS VALUES(10106,'S18_3029',41,83.44,18)
INSERT INTO ORDERDETAILS VALUES(10106,'S18_3856',41,116.46,17)
INSERT INTO ORDERDETAILS VALUES(10106,'S24_1785',28,88.63,4)
INSERT INTO ORDERDETAILS VALUES(10106,'S24_2841',49,74.68,13)
INSERT INTO ORDERDETAILS VALUES(10106,'S24_3420',31,52.6,14)
INSERT INTO ORDERDETAILS VALUES(10106,'S24_3949',50,64.83,11)
INSERT INTO ORDERDETAILS VALUES(10106,'S24_4278',26,63.76,3)
INSERT INTO ORDERDETAILS VALUES(10106,'S32_4289',33,72.92,5)
INSERT INTO ORDERDETAILS VALUES(10106,'S50_1341',39,40.15,6)
INSERT INTO ORDERDETAILS VALUES(10106,'S700_1691',31,106.87,7)
INSERT INTO ORDERDETAILS VALUES(10106,'S700_2047',30,105.91,16)
INSERT INTO ORDERDETAILS VALUES(10106,'S700_2466',34,110.69,9)
INSERT INTO ORDERDETAILS VALUES(10106,'S700_2834',32,124.58,1)
INSERT INTO ORDERDETAILS VALUES(10106,'S700_3167',44,74.4,8)
INSERT INTO ORDERDETAILS VALUES(10106,'S700_4002',48,61.44,10)
INSERT INTO ORDERDETAILS VALUES(10106,'S72_1253',48,52.64,15)
INSERT INTO ORDERDETAILS VALUES(10107,'S10_1678',30,95.7,2)
INSERT INTO ORDERDETAILS VALUES(10107,'S10_2016',39,99.91,5)
INSERT INTO ORDERDETAILS VALUES(10107,'S10_4698',27,224.65,4)
INSERT INTO ORDERDETAILS VALUES(10107,'S12_2823',21,144.6,1)