oracle-sample.relax

group: Oracle Sample
description: OT (Oracle Tutorial) Sample Database. [Show E/R Diagram.](https://www.oracletutorial.com/wp-content/uploads/2017/07/Oracle-Sample-Database.png) Source http://www.oracletutorial.com/oracle

regions = {
	region_id:number, region_name:string

1,'Europe'
2,'Americas'
3,'Asia'
4,'Middle East and Africa'

}

countries = {
	country_id:string, country_name:string, region_id:number

'AR','Argentina',2
'AU','Australia',3
'BE','Belgium',1
'BR','Brazil',2
'CA','Canada',2
'CH','Switzerland',1
'CN','China',3
'DE','Germany',1
'DK','Denmark',1
'EG','Egypt',4
'FR','France',1
'IL','Israel',4
'IN','India',3
'IT','Italy',1
'JP','Japan',3
'KW','Kuwait',4
'ML','Malaysia',3
'MX','Mexico',2
'NG','Nigeria',4
'NL','Netherlands',1
'SG','Singapore',3
'UK','United Kingdom',1
'US','United States of America',2
'ZM','Zambia',4
'ZW','Zimbabwe',4

}

locations = {
	location_id:number, address:string, postal_code:string, city:string, state:string, country_id:string

1,'1297 Via Cola di Rie','00989','Roma',null,'IT'
2,'93091 Calle della Testa','10934','Venice',null,'IT'
3,'2017 Shinjuku-ku','1689','Tokyo','Tokyo Prefecture','JP'
4,'9450 Kamiya-cho','6823','Hiroshima',null,'JP'
5,'2014 Jabberwocky Rd','26192','Southlake','Texas','US'
6,'2011 Interiors Blvd','99236','South San Francisco','California','US'
7,'2007 Zagora St','50090','South Brunswick','New Jersey','US'
8,'2004 Charade Rd','98199','Seattle','Washington','US'
9,'147 Spadina Ave','M5V 2L7','Toronto','Ontario','CA'
10,'6092 Boxwood St','YSW 9T2','Whitehorse','Yukon','CA'
11,'40-5-12 Laogianggen','190518','Beijing',null,'CN'
12,'1298 Vileparle (E)','490231','Bombay','Maharashtra','IN'
13,'12-98 Victoria Street','2901','Sydney','New South Wales','AU'
14,'198 Clementi North','540198','Singapore',null,'SG'
15,'8204 Arthur St',null,'London',null,'UK'
16,'Magdalen Centre, The Oxford Science Park','OX9 9ZB','Oxford','Oxford','UK'
17,'9702 Chester Road','09629850293','Stretford','Manchester','UK'
18,'Schwanthalerstr. 7031','80925','Munich','Bavaria','DE'
19,'Rua Frei Caneca 1360 ','01307-002','Sao Paulo','Sao Paulo','BR'
20,'20 Rue des Corps-Saints','1730','Geneva','Geneve','CH'
21,'Murtenstrasse 921','3095','Bern','BE','CH'
22,'Pieter Breughelstraat 837','3029SK','Utrecht','Utrecht','NL'
23,'Mariano Escobedo 9991','11932','Mexico City','Distrito Federal,','MX'

}

warehouses = {
	warehouse_id:number, warehouse_name:string, location_id:number

1,'Southlake, Texas',5
2,'San Francisco',6
3,'New Jersey',7
4,'Seattle, Washington',8
5,'Toronto',9
6,'Sydney',13
7,'Mexico City',23
8,'Beijing',11
9,'Bombay',12

}

employees = {
	employee_id:number, first_name:string, last_name:string, email:string, phone:string, hire_date:date, manager_id:number, job_title:string

107,'Summer','Payne','[email protected]','515.123.8181',2016-06-07,106,'Public Accountant'
106,'Rose','Stephens','[email protected]','515.123.8080',2016-06-07,2,'Accounting Manager'
101,'Annabelle','Dunn','[email protected]','515.123.4444',2016-09-17,2,'Administration Assistant'
1,'Tommy','Bailey','[email protected]','515.123.4567',2016-06-17,null,'President'
3,'Blake','Cooper','[email protected]','515.123.4569',2016-01-13,1,'Administration Vice President'
2,'Jude','Rivera','[email protected]','515.123.4568',2016-09-21,1,'Administration Vice President'
11,'Tyler','Ramirez','[email protected]','515.124.4269',2016-09-28,9,'Accountant'
10,'Ryan','Gray','[email protected]','515.124.4169',2016-08-16,9,'Accountant'
14,'Elliot','Brooks','[email protected]','515.124.4567',2016-12-07,9,'Accountant'
12,'Elliott','James','[email protected]','515.124.4369',2016-09-30,9,'Accountant'
13,'Albert','Watson','[email protected]','515.124.4469',2016-03-07,9,'Accountant'
9,'Mohammad','Peterson','[email protected]','515.124.4569',2016-08-17,2,'Finance Manager'
104,'Harper','Spencer','[email protected]','515.123.7777',2016-06-07,2,'Human Resources Representative'
4,'Louie','Richardson','[email protected]','590.423.4567',2016-01-03,3,'Programmer'
5,'Nathan','Cox','[email protected]','590.423.4568',2016-05-21,4,'Programmer'
8,'Bobby','Torres','[email protected]','590.423.5567',2016-02-07,4,'Programmer'
7,'Charles','Ward','[email protected]','590.423.4560',2016-02-05,4,'Programmer'
6,'Gabriel','Howard','[email protected]','590.423.4569',2016-06-25,4,'Programmer'
102,'Emma','Perkins','[email protected]','515.123.5555',2016-02-17,1,'Marketing Manager'
103,'Amelie','Hudson','[email protected]','603.123.6666',2016-08-17,102,'Marketing Representative'
105,'Gracie','Gardner','[email protected]','515.123.8888',2016-06-07,2,'Public Relations Representative'
17,'Frederick','Price','[email protected]','515.127.4563',2016-12-24,15,'Purchasing Clerk'
16,'Alex','Sanders','[email protected]','515.127.4562',2016-05-18,15,'Purchasing Clerk'
18,'Ollie','Bennett','[email protected]','515.127.4564',2016-07-24,15,'Purchasing Clerk'
19,'Louis','Wood','[email protected]','515.127.4565',2016-11-15,15,'Purchasing Clerk'
20,'Dexter','Barnes','[email protected]','515.127.4566',2016-08-10,15,'Purchasing Clerk'
15,'Rory','Kelly','[email protected]','515.127.4561',2016-12-07,1,'Purchasing Manager'
49,'Isabella','Cole','[email protected]','011.44.1344.619268',2016-10-15,1,'Sales Manager'
48,'Jessica','Woods','[email protected]','011.44.1344.429278',2016-03-10,1,'Sales Manager'
47,'Ella','Wallace','[email protected]','011.44.1344.467268',2016-01-05,1,'Sales Manager'
46,'Ava','Sullivan','[email protected]','011.44.1344.429268',2016-10-01,1,'Sales Manager'
50,'Mia','West','[email protected]','011.44.1344.429018',2016-01-29,1,'Sales Manager'
56,'Evie','Harrison','[email protected]','011.44.1344.486508',2016-11-23,46,'Sales Representative'
57,'Scarlett','Gibson','[email protected]','011.44.1345.429268',2016-01-30,47,'Sales Representative'
58,'Ruby','Mcdonald','[email protected]','011.44.1345.929268',2016-03-04,47,'Sales Representative'
59,'Chloe','Cruz','[email protected]','011.44.1345.829268',2016-08-01,47,'Sales Representative'
60,'Isabelle','Marshall','[email protected]','011.44.1345.729268',2016-03-10,47,'Sales Representative'
61,'Daisy','Ortiz','[email protected]','011.44.1345.629268',2016-12-15,47,'Sales Representative'
62,'Freya','Gomez','[email protected]','011.44.1345.529268',2016-11-03,47,'Sales Representative'
80,'Elizabeth','Dixon','[email protected]','011.44.1644.429262',2016-01-04,50,'Sales Representative'
64,'Florence','Freeman','[email protected]','011.44.1346.229268',2016-03-19,48,'Sales Representative'
65,'Alice','Wells','[email protected]','011.44.1346.329268',2016-01-24,48,'Sales Representative'
66,'Charlotte','Webb','[email protected]','011.44.1346.529268',2016-02-23,48,'Sales Representative'
67,'Sienna','Simpson','[email protected]','011.44.1346.629268',2016-03-24,48,'Sales Representative'
68,'Matilda','Stevens','[email protected]','011.44.1346.729268',2016-04-21,48,'Sales Representative'
69,'Evelyn','Tucker','[email protected]','011.44.1343.929268',2016-03-11,49,'Sales Representative'
70,'Eva','Porter','[email protected]','011.44.1343.829268',2016-03-23,49,'Sales Representative'
71,'Millie','Hunter','[email protected]','011.44.1343.729268',2016-01-24,49,'Sales Representative'
72,'Sofia','Hicks','[email protected]','011.44.1343.629268',2016-02-23,49,'Sales Representative'
73,'Lucy','Crawford','[email protected]','011.44.1343.529268',2016-03-24,49,'Sales Representative'
74,'Elsie','Henry','[email protected]','011.44.1343.329268',2016-04-21,49,'Sales Representative'
75,'Imogen','Boyd','[email protected]','011.44.1644.429267',2016-05-11,50,'Sales Representative'
76,'Layla','Mason','[email protected]','011.44.1644.429266',2016-03-19,50,'Sales Representative'
77,'Rosie','Morales','[email protected]','011.44.1644.429265',2016-03-24,50,'Sales Representative'
78,'Maya','Kennedy','[email protected]','011.44.1644.429264',2016-04-23,50,'Sales Representative'
79,'Esme','Warren','[email protected]','011.44.1644.429263',2016-05-24,50,'Sales Representative'
55,'Grace','Ellis','[email protected]','011.44.1344.987668',2016-12-09,46,'Sales Representative'
54,'Lily','Fisher','[email protected]','011.44.1344.498718',2016-03-30,46,'Sales Representative'
53,'Sophia','Reynolds','[email protected]','011.44.1344.478968',2016-08-20,46,'Sales Representative'
52,'Sophie','Owens','[email protected]','011.44.1344.345268',2016-03-24,46,'Sales Representative'
51,'Poppy','Jordan','[email protected]','011.44.1344.129268',2016-01-30,46,'Sales Representative'
63,'Phoebe','Murray','[email protected]','011.44.1346.129268',2016-11-11,48,'Sales Representative'
85,'Holly','Shaw','[email protected]','650.509.1876',2016-01-27,22,'Shipping Clerk'
86,'Emilia','Holmes','[email protected]','650.509.2876',2016-02-20,22,'Shipping Clerk'
87,'Molly','Rice','[email protected]','650.509.3876',2016-06-24,22,'Shipping Clerk'
88,'Ellie','Robertson','[email protected]','650.509.4876',2016-02-07,22,'Shipping Clerk'
89,'Jasmine','Hunt','[email protected]','650.505.1876',2016-06-14,23,'Shipping Clerk'
90,'Eliza','Black','[email protected]','650.505.2876',2016-08-13,23,'Shipping Clerk'
91,'Lilly','Daniels','[email protected]','650.505.3876',2016-07-11,23,'Shipping Clerk'
92,'Abigail','Palmer','[email protected]','650.505.4876',2016-12-19,23,'Shipping Clerk'
93,'Georgia','Mills','[email protected]','650.501.1876',2016-02-04,24,'Shipping Clerk'
94,'Maisie','Nichols','[email protected]','650.501.2876',2016-03-03,24,'Shipping Clerk'
95,'Eleanor','Grant','[email protected]','650.501.3876',2016-07-01,24,'Shipping Clerk'
96,'Hannah','Knight','[email protected]','650.501.4876',2016-03-17,24,'Shipping Clerk'
97,'Harriet','Ferguson','[email protected]','650.507.9811',2016-04-24,25,'Shipping Clerk'
98,'Amber','Rose','[email protected]','650.507.9822',2016-05-23,25,'Shipping Clerk'
99,'Bella','Stone','[email protected]','650.507.9833',2016-06-21,25,'Shipping Clerk'
100,'Thea','Hawkins','[email protected]','650.507.9844',2016-01-13,25,'Shipping Clerk'
81,'Lola','Ramos','[email protected]','650.507.9876',2016-01-24,21,'Shipping Clerk'
82,'Willow','Reyes','[email protected]','650.507.9877',2016-02-23,21,'Shipping Clerk'
83,'Ivy','Burns','[email protected]','650.507.9878',2016-06-21,21,'Shipping Clerk'
84,'Erin','Gordon','[email protected]','650.507.9879',2016-02-03,21,'Shipping Clerk'
33,'Reggie','Simmons','[email protected]','650.124.8234',2016-04-10,22,'Stock Clerk'
44,'Emily','Hamilton','[email protected]','650.121.2874',2016-03-15,25,'Stock Clerk'
43,'Olivia','Ford','[email protected]','650.121.2994',2016-01-29,25,'Stock Clerk'
42,'Amelia','Myers','[email protected]','650.121.8009',2016-10-17,25,'Stock Clerk'
41,'Connor','Hayes','[email protected]','650.121.1834',2016-04-06,24,'Stock Clerk'
26,'Leon','Powell','[email protected]','650.124.1214',2016-07-16,21,'Stock Clerk'
27,'Kai','Long','[email protected]','650.124.1224',2016-09-28,21,'Stock Clerk'
28,'Aaron','Patterson','[email protected]','650.124.1334',2016-01-14,21,'Stock Clerk'
29,'Roman','Hughes','[email protected]','650.124.1434',2016-03-08,21,'Stock Clerk'
30,'Austin','Flores','[email protected]','650.124.5234',2016-08-20,22,'Stock Clerk'
31,'Ellis','Washington','[email protected]','650.124.6234',2016-10-30,22,'Stock Clerk'
32,'Jamie','Butler','[email protected]','650.124.7234',2016-02-16,22,'Stock Clerk'
45,'Isla','Graham','[email protected]','650.121.2004',2016-07-09,25,'Stock Clerk'
34,'Seth','Foster','[email protected]','650.127.1934',2016-06-14,23,'Stock Clerk'
35,'Carter','Gonzales','[email protected]','650.127.1834',2016-08-26,23,'Stock Clerk'
36,'Felix','Bryant','[email protected]','650.127.1734',2016-12-12,23,'Stock Clerk'
37,'Ibrahim','Alexander','[email protected]','650.127.1634',2016-02-06,23,'Stock Clerk'
38,'Sonny','Russell','[email protected]','650.121.1234',2016-07-14,24,'Stock Clerk'
39,'Kian','Griffin','[email protected]','650.121.2034',2016-10-26,24,'Stock Clerk'
40,'Caleb','Diaz','[email protected]','650.121.2019',2016-02-12,24,'Stock Clerk'
25,'Ronnie','Perry','[email protected]','650.123.5234',2016-11-16,1,'Stock Manager'
24,'Callum','Jenkins','[email protected]','650.123.4234',2016-10-10,1,'Stock Manager'
23,'Jackson','Coleman','[email protected]','650.123.3234',2016-05-01,1,'Stock Manager'
22,'Liam','Henderson','[email protected]','650.123.2234',2016-04-10,1,'Stock Manager'
21,'Jaxon','Ross','[email protected]','650.123.1234',2016-07-18,1,'Stock Manager'

}

product_categories = {
	category_id:number, category_name:string

1,'CPU'
2,'Video Card'
3,'RAM'
4,'Mother Board'
5,'Storage'

}

products = {
	product_id:number, product_name:string, description:string, standard_cost:number, list_price:number, category_id:number

228,'Intel Xeon E5-2699 V3 (OEM/Tray)','Speed:2.3GHz,Cores:18,TDP:145W',2867.51,3410.46,1
248,'Intel Xeon E5-2697 V3','Speed:2.6GHz,Cores:14,TDP:145W',2326.27,2774.98,1
249,'Intel Xeon E5-2698 V3 (OEM/Tray)','Speed:2.3GHz,Cores:16,TDP:135W',2035.18,2660.72,1
2,'Intel Xeon E5-2697 V4','Speed:2.3GHz,Cores:18,TDP:145W',2144.4,2554.99,1
45,'Intel Xeon E5-2685 V3 (OEM/Tray)','Speed:2.6GHz,Cores:12,TDP:120W',2012.11,2501.69,1
46,'Intel Xeon E5-2695 V3 (OEM/Tray)','Speed:2.3GHz,Cores:14,TDP:120W',1925.13,2431.95,1
47,'Intel Xeon E5-2697 V2','Speed:2.7GHz,Cores:12,TDP:130W',2101.59,2377.09,1
51,'Intel Xeon E5-2695 V4','Speed:2.1GHz,Cores:18,TDP:120W',1780.35,2269.99,1
91,'Intel Xeon E5-2695 V2','Speed:2.4GHz,Cores:12,TDP:115W',1793.53,2259.99,1
92,'Intel Xeon E5-2643 V2 (OEM/Tray)','Speed:3.5GHz,Cores:6,TDP:130W',1940.18,2200,1
93,'Intel Xeon E5-2690 (OEM/Tray)','Speed:2.9GHz,Cores:8,TDP:135W',1888.33,2116.72,1
98,'Intel Xeon E5-2687W V3','Speed:3.1GHz,Cores:10,TDP:160W',1781.47,2064.99,1
102,'Intel Xeon E5-2687W V4','Speed:3.0GHz,Cores:12,TDP:160W',1723.83,2042.69,1
158,'Intel Xeon E5-2667 V3 (OEM/Tray)','Speed:3.2GHz,Cores:8,TDP:135W',1504.08,2009.46,1
159,'Intel Xeon E5-2690 V4','Speed:2.6GHz,Cores:14,TDP:135W',1499.26,1994.49,1
160,'Intel Xeon E5-2690 V3','Speed:2.6GHz,Cores:12,TDP:135W',1540.35,1908.73,1
162,'Intel Xeon E5-2470V2','Speed:2.4GHz,Cores:10,TDP:95W',1671.95,1904.7,1
163,'Intel Xeon E5-2683 V4','Speed:2.1GHz,Cores:16,TDP:120W',1706.95,1899.99,1
164,'Intel Xeon E5-2637 V2 (OEM/Tray)','Speed:3.5GHz,Cores:4,TDP:130W',1323.12,1850,1
169,'Intel Xeon E5-2683 V4 (OEM/Tray)','Speed:2.1GHz,Cores:16,TDP:120W',1369.83,1844.89,1
240,'Intel Core i7-4960X Extreme Edition','Speed:3.6GHz,Cores:6,TDP:130W',1496.43,1805.97,1
241,'Intel Xeon E5-2699 V4 (OEM/Tray)','Speed:2.2GHz,Cores:22,TDP:145W',1535.62,1756,1
242,'Intel Xeon E5-1680 V3 (OEM/Tray)','Speed:3.2GHz,Cores:8,TDP:140W',1519.85,1751.99,1
243,'Intel Xeon E5-2643 V4 (OEM/Tray)','Speed:3.4GHz,Cores:6,TDP:135W',1225.59,1708.86,1
19,'Intel Core i7-6950X (OEM/Tray)','Speed:3.0GHz,Cores:10,TDP:140W',1479.56,1704.37,1
52,'Intel Xeon E5-2670 V3','Speed:2.3GHz,Cores:12,TDP:120W',1453.94,1676.98,1
165,'Intel Xeon E5-2680','Speed:2.7GHz,Cores:8,TDP:130W',1479.95,1666.61,1
212,'Intel Xeon E5-2680 V4','Speed:2.4GHz,Cores:14,TDP:120W',1365.13,1639.99,1
166,'Intel Xeon E5-2680 V3 (OEM/Tray)','Speed:2.5GHz,Cores:12,TDP:120W',1166.89,1638.89,1
82,'Intel Core i7-6950X','Speed:3.0GHz,Cores:10,TDP:140W',1052.92,1499.89,1
213,'Intel Xeon E5-2643 V3 (OEM/Tray)','Speed:3.4GHz,Cores:6,TDP:135W',1266.37,1469.96,1
218,'Intel Xeon E5-2660 V4','Speed:2.0GHz,Cores:14,TDP:105W',1194.03,1388.89,1
219,'Intel Xeon E5-2660 V3','Speed:2.6GHz,Cores:10,TDP:105W',1041.99,1299.73,1
85,'Intel Xeon E5-2660 V3 (OEM/Tray)','Speed:2.6GHz,Cores:10,TDP:105W',902.18,1274.99,1
153,'Intel Xeon E5-2650 V2','Speed:2.6GHz,Cores:8,TDP:95W',961.11,1249,1
154,'Intel Xeon E5-2650 V3','Speed:2.3GHz,Cores:10,TDP:105W',906.63,1204.98,1
209,'Intel Core i7-990X Extreme Edition','Speed:3.47GHz,Cores:6,TDP:130W',1072.79,1199.99,1
81,'Intel Xeon E5-2650 V4','Speed:2.2GHz,Cores:12,TDP:105W',945.11,1099.99,1
211,'Intel Xeon E5-2650','Speed:2.0GHz,Cores:8,TDP:95W',869.03,1064.99,1
210,'Intel Core i9-7900X','Speed:3.3GHz,Cores:10,TDP:140W',855.82,1029.99,1
54,'Intel Xeon E5-1660 V3 (OEM/Tray)','Speed:3.0GHz,Cores:8,TDP:140W',914.52,1019.99,1
167,'Intel Xeon E5-2650L V3 (OEM/Tray)','Speed:1.8GHz,Cores:12,TDP:65W',779.17,1010.46,1
214,'Intel Core i7-5960X','Speed:3.0GHz,Cores:8,TDP:140W',865.59,1009.79,1
53,'Intel Core 2 Extreme QX6800','Speed:2.93GHz,Cores:4,TDP:100W',787.72,1003.98,1
59,'Intel Core i7-5960X (OEM/Tray)','Speed:3.0GHz,Cores:8,TDP:140W',879.8,977.99,1
176,'Intel Xeon E5-2650 V3 (OEM/Tray)','Speed:2.3GHz,Cores:10,TDP:105W',799.98,939.49,1
9,'Intel Xeon E5-2640 V4','Speed:2.4GHz,Cores:10,TDP:90W',738.71,899.99,1
119,'Intel Xeon E5-2640 V3','Speed:2.6GHz,Cores:8,TDP:90W',668.24,899.99,1
120,'Intel Core 2 Extreme QX9775','Speed:3.2GHz,Cores:4,TDP:150W',737.68,892,1
16,'Intel Core i7-6900K','Speed:3.2GHz,Cores:8,TDP:140W',792.89,889.89,1
111,'Intel Core i7-6900K (OEM/Tray)','Speed:3.2GHz,Cores:8,TDP:140W',620.28,827.37,1
136,'AMD Opteron 6378','Speed:2.4GHz,Cores:16,TDP:115W',651.92,826.99,1
27,'Intel Core i7-3960X Extreme Edition','Speed:3.3GHz,Cores:6,TDP:130W',573.41,800.74,1
73,'Intel Core i7-4770K','Speed:3.5GHz,Cores:4,TDP:84W',714.15,799,1
70,'Intel Xeon E5-2687W','Speed:3.1GHz,Cores:8,TDP:150W',581.16,710.99,1
74,'Intel Xeon E5-2680 V2','Speed:2.8GHz,Cores:10,TDP:115W',567.81,701.95,1
198,'Intel Core i7-980','Speed:3.33GHz,Cores:6,TDP:130W',563.7,699.99,1
69,'Intel Core i7-7820X','Speed:3.6GHz,Cores:8,TDP:140W',511.1,678.75,1
71,'Intel Core i7-3930K','Speed:3.2GHz,Cores:6,TDP:130W',509.32,660,1
199,'Intel Xeon E5-2630 V4','Speed:2.2GHz,Cores:10,TDP:85W',528.95,647.99,1
76,'Intel Xeon E5-2630 V3','Speed:2.4GHz,Cores:8,TDP:85W',499.96,629.99,1
75,'Intel Core i7-4930K','Speed:3.4GHz,Cores:6,TDP:130W',527.69,624.04,1
200,'Intel Core i7-4790K','Speed:4.0GHz,Cores:4,TDP:88W',461.92,620.95,1
106,'Intel Xeon E5-2640 V2','Speed:2.0GHz,Cores:8,TDP:95W',545.19,608.95,1
8,'Intel Xeon E5-1650 V4','Speed:3.6GHz,Cores:6,TDP:140W',535.47,601.99,1
124,'Intel Xeon E5-1650 V4 (OEM/Tray)','Speed:3.6GHz,Cores:6,TDP:140W',453.14,594.99,1
72,'Intel Xeon E5-2630 V3 (OEM/Tray)','Speed:2.4GHz,Cores:8,TDP:85W',421.9,589.99,1
155,'Intel Xeon E5-2630 V2','Speed:2.6GHz,Cores:6,TDP:80W',493.48,588.95,1
80,'Intel Xeon E5-1650 V3','Speed:3.5GHz,Cores:6,TDP:140W',399.77,564.89,1
132,'Intel Core i7-5930K','Speed:3.5GHz,Cores:6,TDP:140W',481.56,554.99,1
133,'PNY VCQP6000-PB','Chipset:Quadro P6000,Memory:24GBCore Clock:1.42GHz',4058.99,5499.99,2
206,'PNY VCQM6000-24GB-PB','Chipset:Quadro M6000,Memory:24GBCore Clock:988MHz',3619.14,4139,2
207,'PNY VCQM6000-PB','Chipset:Quadro M6000,Memory:12GBCore Clock:988MHz',2505.04,3254.99,2
110,'ATI FirePro W9000','Chipset:FirePro W9000,Memory:6GBCore Clock:975MHz',2785.55,3192.97,2
123,'ATI FirePro S9150','Chipset:FirePro S9150,Memory:16GBCore Clock:900MHz',2628.06,3177.44,2
142,'AMD FirePro W9100','Chipset:FirePro W9100,Memory:16GBCore Clock:930MHz',2483.38,2998.89,2
105,'EVGA 12G-P4-3992-KR','Chipset:GeForce GTX Titan Z,Memory:12GBCore Clock:732MHz',2313.07,2799.99,2
4,'AMD 100-505989','Chipset:FirePro W9100,Memory:32GBCore Clock:930MHz',2128.67,2699.99,2
5,'PNY VCQK6000-PB','Chipset:Quadro K6000,Memory:12GBCore Clock:902MHz',1740.31,2290.79,2
11,'PNY VCQP5000-PB','Chipset:Quadro P5000,Memory:16GBCore Clock:1.61GHz',1602.21,2015.11,2
178,'HP C2J95AT','Chipset:Quadro K5000,Memory:4GBCore Clock:706MHz',1715.91,1999.89,2
267,'EVGA 12G-P4-1999-KR','Chipset:GeForce GTX Titan X,Memory:12GBCore Clock:1.15GHz',1328.03,1799.99,2
177,'PNY VCQM5000-PB','Chipset:Quadro M5000,Memory:8GBCore Clock:861MHz',1268.42,1759.99,2
245,'ATI FirePro S9050','Chipset:FirePro S9050,Memory:12GBCore Clock:900MHz',1237.04,1699,2
161,'AMD 100-5056062','Chipset:Vega Frontier Edition Liquid,Memory:16GBCore Clock:1.5GHz',1343.84,1499.99,2
186,'PNY VCQK5200-PB','Chipset:Quadro K5200,Memory:8GBCore Clock:667MHz',1129.39,1449.98,2
48,'AMD FirePro S7000','Chipset:FirePro S7000,Memory:4GBCore Clock:950MHz',936.42,1218.5,2
184,'AMD 100-506061','Chipset:Vega Frontier Edition,Memory:16GBCore Clock:1.44GHz',706.99,999.99,2
181,'ATI FirePro R5000','Chipset:FirePro R5000,Memory:2GBCore Clock:825MHz',760.59,999.99,2
182,'PNY VCQK4200-PB','Chipset:Quadro K4200,Memory:4GBCore Clock:771MHz',799.05,949.89,2
183,'Asus GTX780TI-3GD5','Chipset:GeForce GTX 780 Ti,Memory:3GBCore Clock:876MHz',781.91,899.99,2
185,'MSI GTX 1080 TI LIGHTNING Z','Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:1.61GHz',688.35,873.98,2
281,'Asus ROG-POSEIDON-GTX1080TI-P11G-GAMING','Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:1.62GHz',696.14,864.98,2
216,'MSI GTX 1080 TI LIGHTNING X','Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:1.57GHz',742.94,863.98,2
6,'Zotac ZT-P10810A-10P','Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:1.48GHz',702.35,849.99,2
108,'MSI GAMING','Chipset:GeForce GTX 780 Ti,Memory:3GBCore Clock:1.02GHz',753.18,849.99,2
83,'Asus STRIX-GTX1080TI-O11G-GAMING','Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:1.57GHz',691.13,829.99,2
215,'PNY VCQP4000-PB','Chipset:Quadro P4000,Memory:8GBCore Clock:1.23GHz',724,829.89,2
12,'Gigabyte GV-N108TAORUSX W-11GD','Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:1.63GHz',596.05,824.98,2
114,'Zotac ZT-70203-10P','Chipset:GeForce GTX 780,Memory:3GBCore Clock:1.01GHz',580.42,820.61,2
103,'EVGA 11G-P4-6598-KR','Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:1.56GHz',663.54,809.99,2
86,'MSI GTX 1080 TI SEA HAWK X','Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:1.57GHz',691.32,804.98,2
3,'Corsair CB-9060011-WW','Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:1.57GHz',573.51,799.99,2
174,'MSI GTX 1080 TI AERO 11G OC','Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:1.51GHz',715.72,798.26,2
175,'NVIDIA VCQM4000-PB','Chipset:Quadro M4000,Memory:8GBCore Clock:N/A',682.09,790,2
58,'Gigabyte GV-N108TAORUS X-11GD','Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:1.61GHz',688.35,784.98,2
270,'Gigabyte GV-N1070WF2OC-8GD','Chipset:GeForce GTX 1070,Memory:8GBCore Clock:1.56GHz',551.62,769.99,2
223,'MSI GeForce GTX 1080 TI ARMOR 11G OC','Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:1.48GHz',644.19,764.98,2
90,'EVGA 11G-P4-6696-KR','Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:1.56GHz',594.46,759.99,2
220,'MSI GeForce GTX 1080 Ti GAMING X 11G','Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:1.57GHz',666.59,759.99,2
221,'Zotac ZT-P10810C-10P','Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:1.65GHz',535.03,759.99,2
269,'Zotac ZT-P10810D-10P','Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:1.57GHz',580.1,759.99,2
87,'PNY VCGGTX1080T11XGPB-OC','Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:1.53GHz',600.92,759.99,2
222,'Zotac ZT-P10810G-10P','Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:1.51GHz',598.25,754.98,2
88,'Gigabyte GV-N98TWF3OC-6GD','Chipset:GeForce GTX 980 Ti,Memory:6GBCore Clock:1.06GHz',633.29,749.99,2
89,'PNY VCGGTX780T3XPB-OC','Chipset:GeForce GTX 780 Ti,Memory:3GBCore Clock:980MHz',592.12,749.99,2
236,'MSI GTX 980 Ti Gaming 6G','Chipset:GeForce GTX 980 Ti,Memory:6GBCore Clock:1.18GHz',539.98,745.32,2
237,'Gigabyte GV-N108TAORUS-11GD','Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:1.59GHz',605.3,744.98,2
238,'EVGA 06G-P4-4998-KR','Chipset:GeForce GTX 980 Ti,Memory:6GBCore Clock:1.19GHz',521.03,741.78,2
239,'MSI GTX 1080 Ti DUKE 11G OC','Chipset:GeForce GTX 1080 Ti,Memory:11GBCore Clock:1.53GHz',555.07,739.99,2
244,'Crucial','Speed:DDR4-2133,Type:288-pin DIMM,CAS:15Module:4x16GBSize:64GB',1139.23,1620.99,5
261,'G.Skill TridentZ RGB','Speed:DDR4-3200,Type:288-pin DIMM,CAS:14Module:8x16GBSize:128GB',1330.26,1504.99,5
262,'Corsair Dominator Platinum','Speed:DDR4-3200,Type:288-pin DIMM,CAS:16Module:8x16GBSize:128GB',1051.97,1449.99,5
265,'G.Skill Trident Z','Speed:DDR4-3200,Type:288-pin DIMM,CAS:14Module:8x16GBSize:128GB',1163.49,1431.99,5
266,'G.Skill Trident Z RGB','Speed:DDR4-3333,Type:288-pin DIMM,CAS:16Module:8x16GBSize:128GB',1174.36,1418.99,5
279,'G.Skill Ripjaws V Series','Speed:DDR4-3000,Type:288-pin DIMM,CAS:14Module:8x16GBSize:128GB',1139.87,1318.99,5
35,'Corsair Dominator Platinum','Speed:DDR4-2800,Type:288-pin DIMM,CAS:15Module:8x16GBSize:128GB',1131.68,1314.99,5
36,'Corsair Vengeance LPX','Speed:DDR4-3000,Type:288-pin DIMM,CAS:15Module:8x16GBSize:128GB',912.98,1299.99,5
37,'Corsair Dominator Platinum','Speed:DDR4-2666,Type:288-pin DIMM,CAS:15Module:8x16GBSize:128GB',1068.66,1264.99,5
38,'Corsair Vengeance LPX','Speed:DDR4-2400,Type:288-pin DIMM,CAS:15Module:8x16GBSize:128GB',1019.51,1199.99,5
65,'Corsair Dominator Platinum','Speed:DDR4-2400,Type:288-pin DIMM,CAS:15Module:8x16GBSize:128GB',1002.47,1199.99,5
276,'Corsair Vengeance LPX','Speed:DDR4-2666,Type:288-pin DIMM,CAS:15Module:8x16GBSize:128GB',867.52,1163.99,5
196,'Corsair Vengeance LPX','Speed:DDR4-2133,Type:288-pin DIMM,CAS:15Module:8x16GBSize:128GB',821.91,1099.99,5
272,'G.Skill Ripjaws 4 Series','Speed:DDR4-2800,Type:288-pin DIMM,CAS:15Module:8x16GBSize:128GB',834.06,1073.99,5
195,'G.Skill Ripjaws 4 Series','Speed:DDR4-2400,Type:288-pin DIMM,CAS:14Module:8x16GBSize:128GB',836.03,1055.99,5
67,'Kingston HyperX Beast','Speed:DDR3-1866,Type:240-pin DIMM,CAS:10Module:8x8GBSize:64GB',708.91,863.05,5
10,'Crucial','Speed:DDR4-2133,Type:288-pin DIMM,CAS:15Module:2x16GBSize:32GB',580.33,811.99,5
112,'Corsair Vengeance Pro','Speed:DDR3-2133,Type:240-pin DIMM,CAS:11Module:8x8GBSize:64GB',596.25,808.92,5
282,'Corsair Dominator Platinum','Speed:DDR4-3200,Type:288-pin DIMM,CAS:15Module:8x8GBSize:64GB',700.5,804.99,5
197,'G.Skill Trident Z RGB','Speed:DDR4-3600,Type:288-pin DIMM,CAS:17Module:4x16GBSize:64GB',622.47,799.99,5
18,'Crucial','Speed:DDR4-2400,Type:288-pin DIMM,CAS:17Module:1x64GBSize:64GB',604.04,799,5
125,'G.Skill Trident Z','Speed:DDR4-3600,Type:288-pin DIMM,CAS:17Module:4x16GBSize:64GB',594.04,768.99,5
68,'Crucial','Speed:DDR4-2133,Type:288-pin DIMM,CAS:15Module:4x16GBSize:64GB',590.13,766.11,5
283,'G.Skill Trident Z','Speed:DDR4-3200,Type:288-pin DIMM,CAS:14Module:8x8GBSize:64GB',647.83,760.99,5
277,'G.Skill Trident Z','Speed:DDR4-3200,Type:288-pin DIMM,CAS:14Module:8x8GBSize:64GB',556.8,758.99,5
21,'Corsair Dominator Platinum','Speed:DDR4-3466,Type:288-pin DIMM,CAS:16Module:4x16GBSize:64GB',609.89,749.99,5
128,'Kingston','Speed:DDR4-2133,Type:288-pin DIMM,CAS:15Module:4x16GBSize:64GB',650.48,741.63,5
129,'Corsair Vengeance LPX','Speed:DDR4-3333,Type:288-pin DIMM,CAS:15Module:4x16GBSize:64GB',609.53,734.99,5
116,'G.Skill Trident Z','Speed:DDR4-3400,Type:288-pin DIMM,CAS:16Module:4x16GBSize:64GB',565.39,731.99,5
15,'G.Skill Trident Z','Speed:DDR4-3466,Type:288-pin DIMM,CAS:16Module:4x16GBSize:64GB',601.56,725.99,5
122,'G.Skill Trident Z','Speed:DDR4-3333,Type:288-pin DIMM,CAS:16Module:4x16GBSize:64GB',532.27,722.99,5
121,'G.Skill Ripjaws V Series','Speed:DDR4-3200,Type:288-pin DIMM,CAS:14Module:8x8GBSize:64GB',603.22,721.99,5
20,'Corsair Dominator Platinum','Speed:DDR4-3200,Type:288-pin DIMM,CAS:15Module:4x16GBSize:64GB',616.53,719.99,5
127,'Corsair Dominator Platinum','Speed:DDR4-3333,Type:288-pin DIMM,CAS:15Module:4x16GBSize:64GB',538.55,719.99,5
109,'G.Skill Trident Z','Speed:DDR4-3200,Type:288-pin DIMM,CAS:14Module:4x16GBSize:64GB',585.26,713.99,5
202,'G.Skill Trident Z','Speed:DDR4-3200,Type:288-pin DIMM,CAS:14Module:4x16GBSize:64GB',533.21,713.99,5
113,'G.Skill Trident Z','Speed:DDR4-3200,Type:288-pin DIMM,CAS:15Module:4x16GBSize:64GB',580.21,704.99,5
13,'G.Skill Ripjaws V Series','Speed:DDR4-3333,Type:288-pin DIMM,CAS:16Module:4x16GBSize:64GB',618.63,704.99,5
14,'G.Skill Ripjaws V Series','Speed:DDR4-3333,Type:288-pin DIMM,CAS:16Module:4x16GBSize:64GB',633.65,704.99,5
115,'Corsair Vengeance LPX','Speed:DDR4-3200,Type:288-pin DIMM,CAS:15Module:8x8GBSize:64GB',565.73,699.99,5
118,'Corsair Dominator Platinum','Speed:DDR4-2800,Type:288-pin DIMM,CAS:15Module:8x8GBSize:64GB',578.46,699.89,5
17,'Corsair Vengeance LPX','Speed:DDR4-3333,Type:288-pin DIMM,CAS:15Module:4x16GBSize:64GB',595.42,699.01,5
117,'G.Skill Ripjaws V Series','Speed:DDR4-3200,Type:288-pin DIMM,CAS:14Module:4x16GBSize:64GB',617.62,695.99,5
77,'G.Skill Ripjaws V Series','Speed:DDR4-3200,Type:288-pin DIMM,CAS:14Module:4x16GBSize:64GB',577.25,695.99,5
78,'G.Skill Ripjaws V Series','Speed:DDR4-3200,Type:288-pin DIMM,CAS:15Module:4x16GBSize:64GB',517.78,686.99,5
204,'G.Skill Ripjaws V Series','Speed:DDR4-3200,Type:288-pin DIMM,CAS:15Module:4x16GBSize:64GB',546.64,686.99,5
7,'G.Skill Ripjaws V Series','Speed:DDR4-3200,Type:288-pin DIMM,CAS:15Module:8x8GBSize:64GB',602.4,680.99,5
278,'G.Skill Ripjaws V Series','Speed:DDR4-3000,Type:288-pin DIMM,CAS:14Module:8x8GBSize:64GB',546.05,677.99,5
203,'Kingston','Speed:DDR3-1333,Type:240-pin DIMM,CAS:9Module:4x16GBSize:64GB',556.84,671.38,5
79,'Corsair Dominator Platinum','Speed:DDR4-2666,Type:288-pin DIMM,CAS:15Module:8x8GBSize:64GB',537.63,659.99,5
201,'Kingston','Speed:DDR3-1600,Type:240-pin DIMM,CAS:11Module:4x8GBSize:32GB',566.98,653.5,5
205,'G.Skill Trident X','Speed:DDR3-3100,Type:240-pin DIMM,CAS:12Module:2x4GBSize:8GB',507.32,649.99,5
29,'Corsair Vengeance LPX','Speed:DDR4-3200,Type:288-pin DIMM,CAS:15Module:4x16GBSize:64GB',571.7,645.99,5
138,'G.Skill Ripjaws V Series','Speed:DDR4-3000,Type:288-pin DIMM,CAS:14Module:4x16GBSize:64GB',499.09,645.99,5
30,'G.Skill Ripjaws V Series','Speed:DDR4-2800,Type:288-pin DIMM,CAS:14Module:4x16GBSize:64GB',452.54,645.2,5
107,'Kingston','Speed:DDR3-1600,Type:240-pin DIMM,CAS:11Module:4x16GBSize:64GB',474.18,644,5
126,'G.Skill Ripjaws V Series','Speed:DDR4-3200,Type:288-pin DIMM,CAS:16Module:8x8GBSize:64GB',510.93,640.99,5
1,'G.Skill Ripjaws V Series','Speed:DDR4-3000,Type:288-pin DIMM,CAS:15Module:8x8GBSize:64GB',450.36,640.99,5
101,'Kingston HyperX Predator','Speed:DDR4-3000,Type:288-pin DIMM,CAS:15Module:4x16GBSize:64GB',471.78,635.99,5
190,'Supermicro X10SDV-8C-TLN4F','CPU:Xeon D-1541,Form Factor:Mini ITX,RAM Slots:4,Max RAM:64GB',664.29,948.99,4
62,'Intel DP35DPM','CPU:LGA775,Form Factor:ATX,RAM Slots:4,Max RAM:8GB',626.22,789.79,4
189,'Asus X99-E-10G WS','CPU:LGA2011-3,Form Factor:SSI CEB,RAM Slots:8,Max RAM:128GB',582.02,649,4
191,'Asus ROG MAXIMUS IX EXTREME','CPU:LGA1151,Form Factor:EATX,RAM Slots:4,Max RAM:64GB',480.89,573.99,4
63,'Asus RAMPAGE V EXTREME','CPU:LGA2011-3,Form Factor:EATX,RAM Slots:8,Max RAM:64GB',459,572.96,4
193,'Asus Z10PE-D8 WS','CPU:LGA2011-3 x 2,Form Factor:SSI EEB,RAM Slots:8,Max RAM:512GB',504.14,561.59,4
271,'MSI X99A GODLIKE GAMING CARBON','CPU:LGA2011-3,Form Factor:EATX,RAM Slots:8,Max RAM:128GB',415,549.59,4
64,'Supermicro H8DG6-F','CPU:G34 x 2,Form Factor:EATX,RAM Slots:16,Max RAM:512GB',416.64,525.99,4
192,'Asus Rampage V Edition 10','CPU:LGA2011-3,Form Factor:EATX,RAM Slots:8,Max RAM:128GB',452.5,519.99,4
225,'Gigabyte GA-Z270X-Gaming 9','CPU:LGA1151,Form Factor:EATX,RAM Slots:4,Max RAM:64GB',380.05,503.98,4
252,'Gigabyte X299 AORUS Gaming 9','CPU:LGA2066,Form Factor:ATX,RAM Slots:8,Max RAM:128GB',395.24,499.99,4
274,'ASRock E3C224D4M-16RE','CPU:LGA1150,Form Factor:ATX,RAM Slots:4,Max RAM:32GB',364.79,499.99,4
61,'Asus PRIME X299-DELUXE','CPU:LGA2066,Form Factor:ATX,RAM Slots:8,Max RAM:128GB',409.92,487.3,4
188,'Asus X99-E WS/USB 3.1','CPU:LGA2011-3,Form Factor:SSI CEB,RAM Slots:8,Max RAM:128GB',428.89,482.49,4
28,'Supermicro X9SRH-7TF','CPU:LGA2011,Form Factor:ATX,RAM Slots:8,Max RAM:64GB',411.64,479.99,4
137,'Asus Z10PE-D16 WS','CPU:LGA2011-3 x 2,Form Factor:SSI EEB,RAM Slots:16,Max RAM:1TB',332.52,469.99,4
32,'ASRock X99 Extreme11','CPU:LGA2011-3,Form Factor:EATX,RAM Slots:8,Max RAM:128GB',380.55,469.99,4
31,'Supermicro MBD-X10DAX','CPU:LGA2011-3 x 2,Form Factor:EATX,RAM Slots:16,Max RAM:',385.24,443.72,4
84,'Asus X99-DELUXE/U3.1','CPU:LGA2011-3,Form Factor:ATX,RAM Slots:8,Max RAM:64GB',332.38,440.3,4
141,'Supermicro X11SSL-CF','CPU:LGA1151,Form Factor:Micro ATX,RAM Slots:4,Max RAM:64GB',317.81,419.99,4
34,'Asus KGPE-D16','CPU:G34 x 2,Form Factor:SSI EEB,RAM Slots:16,Max RAM:256GB',360.72,417.98,4
143,'Asus Z10PE-D16','CPU:LGA2011-3 Narrow x 2,Form Factor:SSI EEB,RAM Slots:16,Max RAM:1TB',293.3,402.99,4
217,'ASRock C2750D4I','CPU:Atom C2750,Form Factor:Mini ITX,RAM Slots:4,Max RAM:64GB',339.55,401.98,4
66,'Gigabyte X299 AORUS Gaming 7','CPU:LGA2066,Form Factor:ATX,RAM Slots:8,Max RAM:128GB',283.91,399.99,4
275,'MSI X99A GODLIKE GAMING','CPU:LGA2011-3,Form Factor:EATX,RAM Slots:8,Max RAM:128GB',302.95,399.99,4
194,'MSI X299 GAMING M7 ACK','CPU:LGA2066,Form Factor:ATX,RAM Slots:8,Max RAM:128GB',278.71,397.42,4
156,'Supermicro MBD-X10DRI-O','CPU:LGA2011-3 Narrow x 2,Form Factor:EATX,RAM Slots:16,Max RAM:1TB',291.34,394.99,4
157,'Asus MAXIMUS IX FORMULA','CPU:LGA1151,Form Factor:ATX,RAM Slots:4,Max RAM:64GB',339.12,388.99,4
170,'Asus X99-DELUXE II','CPU:LGA2011-3,Form Factor:ATX,RAM Slots:8,Max RAM:128GB',289.33,383.98,4
171,'ASRock Fatal1ty X299 Professional Gaming i9','CPU:LGA2066,Form Factor:ATX,RAM Slots:8,Max RAM:128GB',287.5,382.98,4
172,'ASRock EP2C612 WS','CPU:LGA2011-3 x 2,Form Factor:SSI EEB,RAM Slots:8,Max RAM:',308.84,358.49,4
173,'ASRock Z270 SuperCarrier','CPU:LGA1151,Form Factor:ATX,RAM Slots:4,Max RAM:64GB',264.35,353.98,4
187,'Asus MAXIMUS VIII EXTREME/ASSEMBLY','CPU:LGA1151,Form Factor:EATX,RAM Slots:4,Max RAM:64GB',253.41,353.98,4
224,'Asus STRIX X299-E GAMING','CPU:LGA2066,Form Factor:ATX,RAM Slots:8,Max RAM:128GB',306,349.99,4
246,'Gigabyte X299 AORUS Ultra Gaming','CPU:LGA2066,Form Factor:ATX,RAM Slots:8,Max RAM:128GB',287.78,343.99,4
247,'Asus TUF X299 MARK 1','CPU:LGA2066,Form Factor:ATX,RAM Slots:8,Max RAM:128GB',241.15,339.99,4
250,'Asus Z170-WS','CPU:LGA1151,Form Factor:ATX,RAM Slots:4,Max RAM:64GB',279.4,338.99,4
251,'MSI X299 GAMING PRO CARBON AC','CPU:LGA2066,Form Factor:ATX,RAM Slots:8,Max RAM:128GB',238.8,337.81,4
287,'MSI X99A XPOWER GAMING TITANIUM','CPU:LGA2011-3,Form Factor:EATX,RAM Slots:8,Max RAM:128GB',257.23,329.99,4
288,'Asus ROG STRIX X99 GAMING','CPU:LGA2011-3,Form Factor:ATX,RAM Slots:8,Max RAM:128GB',255.86,319.99,4
179,'Asus SABERTOOTH X99','CPU:LGA2011-3,Form Factor:ATX,RAM Slots:8,Max RAM:64GB',252.57,312.67,4
226,'Asus PRIME X299-A','CPU:LGA2066,Form Factor:ATX,RAM Slots:8,Max RAM:128GB',274.56,309.85,4
227,'Gigabyte GA-X99-UD5 WIFI','CPU:LGA2011-3,Form Factor:EATX,RAM Slots:8,Max RAM:64GB',217.83,305,4
39,'ASRock EP2C602-4L/D16','CPU:LGA2011 x 2,Form Factor:SSI EEB,RAM Slots:16,Max RAM:512GB',225.47,301.99,4
40,'MSI Z170A KRAIT GAMING 3X','CPU:LGA1151,Form Factor:ATX,RAM Slots:4,Max RAM:64GB',245.4,299.89,4
41,'MSI Z170 Krait Gaming','CPU:LGA1151,Form Factor:ATX,RAM Slots:4,Max RAM:64GB',231.58,299.89,4
42,'MSI Z170A KRAIT GAMING','CPU:LGA1151,Form Factor:ATX,RAM Slots:4,Max RAM:64GB',262.4,299.89,4
43,'Asus MAXIMUS IX CODE','CPU:LGA1151,Form Factor:ATX,RAM Slots:4,Max RAM:64GB',266.15,298.98,4
134,'Asus Sabertooth 990FX','CPU:AM3+,Form Factor:ATX,RAM Slots:4,Max RAM:32GB',252.31,295.72,4
140,'MSI X99A WORKSTATION','CPU:LGA2011-3,Form Factor:ATX,RAM Slots:8,Max RAM:128GB',239.95,289.97,4
144,'Intel DG43RK','CPU:LGA775,Form Factor:Micro ATX,RAM Slots:4,Max RAM:8GB',219.69,289.79,4
145,'Asus VANGUARD B85','CPU:LGA1150,Form Factor:Micro ATX,RAM Slots:4,Max RAM:32GB',258.1,287,4
146,'EVGA Z270 Classified K','CPU:LGA1151,Form Factor:EATX,RAM Slots:4,Max RAM:64GB',234.26,283.98,4
147,'EVGA Classified','CPU:LGA2011-3,Form Factor:EATX,RAM Slots:8,Max RAM:128GB',240.62,283.98,4
148,'MSI Z270 XPOWER GAMING TITANIUM','CPU:LGA1151,Form Factor:ATX,RAM Slots:4,Max RAM:64GB',212.69,282.98,4
149,'ASRock X299 Taichi','CPU:LGA2066,Form Factor:ATX,RAM Slots:8,Max RAM:128GB',214.36,282.98,4
150,'MSI X299 TOMAHAWK ARCTIC','CPU:LGA2066,Form Factor:ATX,RAM Slots:8,Max RAM:128GB',223.92,281.98,4
151,'Supermicro X10SAT-O','CPU:LGA1150,Form Factor:ATX,RAM Slots:4,Max RAM:32GB',207.08,281.97,4
152,'Gigabyte X299 AORUS Gaming 3','CPU:LGA2066,Form Factor:ATX,RAM Slots:8,Max RAM:128GB',227.48,280.98,4
180,'Supermicro MBD-X10DAL-I-O','CPU:LGA2011-3 x 2,Form Factor:ATX,RAM Slots:8,Max RAM:512GB',239.28,279.99,4
268,'Western Digital WD10EZEX','Series:Caviar Blue,Type:7200RPM,Capacity:1TB,Cache:64MB',35.83,47.88,5
24,'Seagate ST2000DM006','Series:Barracuda,Type:7200RPM,Capacity:2TB,Cache:64MB',47.93,66.89,5
25,'Samsung MZ-75E250B/AM','Series:850 EVO-Series,Type:SSD,Capacity:250GB,Cache:N/A',87.98,104.88,5
26,'Samsung MZ-75E500B/AM','Series:850 EVO-Series,Type:SSD,Capacity:500GB,Cache:N/A',157.81,178.09,5
104,'SanDisk SDSSDA-240G-G26','Series:SSD PLUS,Type:SSD,Capacity:240GB,Cache:N/A',61.1,83.88,5
135,'Samsung MZ-V6E250','Series:960 EVO,Type:SSD,Capacity:250GB,Cache:512MB',92.98,127.88,5
284,'Kingston SA400S37/120G','Series:A400,Type:SSD,Capacity:120GB,Cache:N/A',40.63,54.99,5
285,'Samsung MZ-75E1T0B/AM','Series:850 EVO-Series,Type:SSD,Capacity:1TB,Cache:N/A',260.23,339.99,5
286,'Samsung MZ-V6E500','Series:960 EVO,Type:SSD,Capacity:500GB,Cache:512MB',209.62,234,5
22,'Seagate ST3000DM008','Series:Barracuda,Type:7200RPM,Capacity:3TB,Cache:64MB',61.63,83.61,5
23,'Western Digital WDS250G1B0A','Series:Blue,Type:SSD,Capacity:250GB,Cache:N/A',72.54,89.89,5
33,'ADATA ASU800SS-128GT-C','Series:Ultimate SU800,Type:SSD,Capacity:128GB,Cache:N/A',37.78,52.65,5
44,'Seagate ST1000DM010','Series:BarraCuda,Type:7200RPM,Capacity:1TB,Cache:64MB',42.18,49.37,5
49,'Samsung MZ-75E4T0B','Series:850 EVO,Type:SSD,Capacity:4TB,Cache:4GB',1153.64,1499.99,5
50,'Intel SSDPECME040T401','Series:DC P3608,Type:SSD,Capacity:4TB,Cache:N/A',7123.66,8867.99,5
130,'Western Digital WD2003FZEX','Series:BLACK SERIES,Type:7200RPM,Capacity:2TB,Cache:64MB',91.76,117.45,5
131,'Samsung MZ-V6P512BW','Series:960 PRO,Type:SSD,Capacity:512GB,Cache:512MB',223.99,279.99,5
139,'Hitachi HUS724030ALE641','Series:Ultrastar 7K4000,Type:7200RPM,Capacity:3TB,Cache:64MB',54.03,65.92,5
208,'Samsung MZ-V6P2T0BW','Series:960 Pro,Type:SSD,Capacity:2TB,Cache:2GB',840.11,1199.99,5
229,'Seagate ST10000DM0004','Series:BarraCuda Pro,Type:7200RPM,Capacity:10TB,Cache:256MB',284.23,399.99,5
230,'ADATA ASU800SS-512GT-C','Series:Ultimate SU800,Type:SSD,Capacity:512GB,Cache:N/A',113.29,136.69,5
231,'Samsung MZ-V6E1T0','Series:960 EVO,Type:SSD,Capacity:1TB,Cache:1000MB',358.06,449.99,5
232,'Western Digital WD1003FZEX','Series:BLACK SERIES,Type:7200RPM,Capacity:1TB,Cache:64MB',61.76,70.89,5
233,'SanDisk SDSSDA-120G-G26','Series:SSD PLUS,Type:SSD,Capacity:120GB,Cache:N/A',52.7,59.99,5
234,'Crucial CT525MX300SSD1','Series:MX300,Type:SSD,Capacity:525GB,Cache:N/A',135.59,150.99,5
235,'Hitachi A7K1000-1000','Series:Ultrastar,Type:7200RPM,Capacity:1TB,Cache:32MB',29.94,41.99,5
253,'Samsung MZ-V6P1T0BW','Series:960 Pro,Type:SSD,Capacity:1TB,Cache:1GB',466.49,579.99,5
254,'Samsung MZ-7KE256BW','Series:850 Pro Series,Type:SSD,Capacity:256GB,Cache:N/A',97.19,119.99,5
255,'Seagate ST2000DX002','Series:FireCuda,Type:Hybrid,Capacity:2TB,Cache:64MB',64.48,90.99,5
256,'Western Digital WD5000AACS','Series:Caviar Green,Type:5400RPM,Capacity:500GB,Cache:16MB',20.14,26.99,5
257,'SanDisk SDSSDHII-240G-G25','Series:Ultra II,Type:SSD,Capacity:240GB,Cache:N/A',73.39,84.95,5
258,'PNY SSD7CS1311-120-RB','Series:CS1311,Type:SSD,Capacity:120GB,Cache:N/A',50.59,57.98,5
259,'PNY SSD9SC240GMDA-RB','Series:XLR8,Type:SSD,Capacity:240GB,Cache:N/A',58.4,80.72,5
260,'Crucial CT1050MX300SSD1','Series:MX300,Type:SSD,Capacity:1.1TB,Cache:N/A',192.52,267.99,5
263,'Western Digital WDS250G1B0B','Series:Blue,Type:SSD,Capacity:250GB,Cache:N/A',70.71,89.99,5
264,'Samsung MZ-75E120B/AM','Series:850 EVO-Series,Type:SSD,Capacity:120GB,Cache:N/A',74.41,88.99,5
280,'Western Digital WDS500G1B0B','Series:Blue,Type:SSD,Capacity:500GB,Cache:N/A',106.89,149.88,5
60,'Hitachi HUA723020ALA640','Series:Ultrastar 7K3000,Type:7200RPM,Capacity:2TB,Cache:64MB',45.18,59.99,5
94,'Western Digital WD2500AVVS','Series:AV-GP,Type:5400RPM,Capacity:250GB,Cache:8MB',12.63,15.55,5
99,'Seagate ST1000DX002','Series:FireCuda,Type:Hybrid,Capacity:1TB,Cache:64MB',55.41,68.06,5
100,'Crucial CT275MX300SSD1','Series:MX300,Type:SSD,Capacity:275GB,Cache:N/A',79.21,97.88,5
168,'Seagate ST31000340NS - FFP','Series:Barracuda ES,Type:7200RPM,Capacity:1TB,Cache:32MB',34.4,43.99,5
273,'Western Digital WD101KRYZ','Series:Gold,Type:7200RPM,Capacity:10TB,Cache:256MB',313.96,443.64,5
55,'Crucial CT525MX300SSD4','Series:MX300,Type:SSD,Capacity:525GB,Cache:N/A',121.92,150.99,5
56,'Western Digital WD2500AAJS','Series:Caviar Blue,Type:7200RPM,Capacity:250GB,Cache:8MB',15.23,16.99,5
57,'Western Digital WD20EZRZ','Series:Blue,Type:5400RPM,Capacity:2TB,Cache:64MB',58.01,67.34,5
95,'Western Digital WDS256G1X0C','Series:Black PCIe,Type:SSD,Capacity:256GB,Cache:N/A',85.87,109.99,5
96,'SanDisk SDSSDHII-480G-G25','Series:Ultra II,Type:SSD,Capacity:480GB,Cache:N/A',102.62,141.56,5
97,'Kingston SV300S37A/120G','Series:SSDNow V300 Series,Type:SSD,Capacity:120GB,Cache:N/A',45.93,59.87,5

}

customers = {
	customer_id:number, name:string, address:string, credit_limit:number, website:string

177,'United Continental Holdings','2904 S Salina St, Syracuse, NY',5000,'http://www.unitedcontinentalholdings.com'
180,'INTL FCStone','5344 Haverford Ave, Philadelphia, PA',5000,'http://www.intlfcstone.com'
184,'Publix Super Markets','1795 Wu Meng, Muang Chonburi, ',1200,'http://www.publix.com'
187,'ConocoPhillips','Walpurgisstr 69, Munich, ',2400,'http://www.conocophillips.com'
190,'3M','Via Frenzy 6903, Roma, ',1200,'http://www.3m.com'
192,'Exelon','Via Luminosa 162, Firenze, ',500,'http://www.exeloncorp.com'
208,'Tesoro','Via Notoriosa 1942, Firenze, ',500,'http://www.tsocorp.com'
207,'Northwestern Mutual','1831 No Wong, Peking, ',3600,'http://www.northwesternmutual.com'
200,'Enterprise Products Partners','Via Notoriosa 1949, Firenze, ',2400,'http://www.enterpriseproducts.com'
204,'Rite Aid','Piazza Cacchiatore 23, San Giminiano, ',3600,'http://www.riteaid.com'
212,'Qualcomm','Piazza Svizzera, Milano, ',500,'http://www.qualcomm.com'
216,'EMC','Via Delle Grazie 11, San Giminiano, ',700,'http://www.emc.com'
220,'Time Warner Cable','1597 Legend St, Mysore, Kar',3700,'http://www.twc.com'
223,'Northrop Grumman','1606 Sangam Blvd, New Delhi, ',5000,'http://www.northropgrumman.com'
39,'Lear','2115 N Towne Ln Ne, Cedar Rapids, IA',500,'http://www.lear.com'
43,'Facebook','5112 Sw 9Th St, Des Moines, IA',500,'http://www.facebook.com'
46,'Supervalu','8989 N Port Washington Rd, Milwaukee, WI',500,'http://www.supervalu.com'
49,'NextEra Energy','4715 Sprecher Rd, Madison, WI',600,'http://www.nexteraenergy.com'
52,'PG&E Corp.','8600 W National Ave, Milwaukee, WI',700,'http://www.pge.com'
55,'Goodyear Tire & Rubber','600 N Broadway Fl 1, Milwaukee, WI',700,'http://www.goodyear.com'
59,'Micron Technology','411 E Wisconsin Ave # 2550, Milwaukee, WI',700,'http://www.micron.com'
62,'ConAgra Foods','122 E Dayton St, Madison, WI',900,'http://www.conagrafoods.com'
66,'Bank of New York Mellon Corp.','666 22Nd Ave Ne, Minneapolis, MN',1200,'http://www.bnymellon.com'
71,'Genuine Parts','200 1St St Sw, Rochester, MN',1200,'http://www.genpt.com'
75,'Omnicom Group','2134 W Genesee St, Syracuse, NY',1200,'http://www.omnicomgroup.com'
79,'Monsanto','137 Lark St, Albany, NY',1200,'http://www.monsanto.com'
83,'National Oilwell Varco','1 Palisade Ave Fl 2, Yonkers, NY',1200,'http://www.nov.com'
86,'Marriott International','Po Box 2152, Buffalo, NY',1200,'http://www.marriott.com'
228,'Kinder Morgan','1614 Gitanjali Rd, Calcutta, ',5000,'http://www.kindermorgan.com'
231,'Molina Healthcare','1617 Crackers St, Bangalore - India, Kar',300,'http://www.molinahealthcare.com'
235,'Lincoln National','1622 Roja St, Chennai, Tam',5000,'http://www.lfg.com'
238,'C.H. Robinson Worldwide','1628 Pataudi St, New Delhi, ',1900,'http://www.chrobinson.com'
242,'Synnex','1647 Suspense St, Cochin, Ker',500,'http://www.synnex.com'
245,'HollyFrontier','1656 Veterans Rd, Chennai, Tam',2500,'http://www.hollyfrontier.com'
249,'PBF Energy','Piazza Quattre Stagioni 4, Roma, ',3700,'http://www.pbfenergy.com'
255,'Waste Management','Via Di Firenze 231, Roma, ',2400,'http://www.wm.com'
259,'Parker-Hannifin','Canale Grande 2, Roma, ',700,'http://www.parker.com'
263,'Farmers Insurance Exchange','Via Dello Croce 93, Tellaro, ',100,'http://www.farmers.com'
268,'VF','1971 Limelight Blvd, Samutprakarn, ',1200,'http://www.vfc.com'
313,'Hertz Global Holdings','1616 Crackers Blvd, Bangalore - India, Kar',5000,'http://www.hertz.com'
319,'BB&T Corp.','1668 Chong Tao, Beijing, ',200,'http://www.bbt.com'
32,'Global Partners','1135 Catherine St, Ann Arbor, MI',400,'http://www.globalp.com'
63,'Sempra Energy','633 S Hawley Rd, Milwaukee, WI',900,'http://www.sempra.com'
78,'Precision Castparts','726 Union St, Hudson, NY',1200,'http://www.precast.com'
111,'W.W. Grainger','378 S Negley Ave, Pittsburgh, PA',1500,'http://www.grainger.com'
125,'Air Products & Chemicals','612 Jefferson Ave, Scranton, PA',2300,'http://www.airproducts.com'
163,'Charter Communications','802 North Ave, Pittsburgh, PA',3600,'http://www.charter.com'
195,'Applied Materials','Via Dolorosa 69, Tellaro, ',700,'http://www.appliedmaterials.com'
206,'Ally Financial','Via Notoriosa 1949, Ventimiglia, ',3600,'http://www.ally.com'
218,'Lennar','1592 Silverado St, Bangalore, Kar',700,'http://www.lennar.com'
243,'Hormel Foods','1648 Anamika St, Cochin, Ker',500,'http://www.hormelfoods.com'
254,'PayPal Holdings','Via Dello Croce 93, Roma, ',1200,'http://www.paypal.com'
266,'Autoliv','Via Delle Capeletti 52, San Giminiano, ',400,'http://www.autoliv.com'
294,'Corning','Pfannenstilstr 13, Egg, ZH',2300,'http://www.corning.com'
301,'Univar','1598 Legend St, Bangalore, Kar',5000,'http://www.univar.com'
314,'Thrivent Financial for Lutherans','1617 Crackers St, Bangalore - India, Kar',900,'http://www.thrivent.com'
88,'Walmart','1790 Grand Blvd, Schenectady, NY',1200,'http://www.walmart.com'
89,'Exxon Mobil','7 Ingelside Ln, White Plains, NY',1200,'http://www.exxonmobil.com'
90,'Apple','18 Glenridge Rd, Schenectady, NY',1200,'http://www.apple.com'
91,'Berkshire Hathaway','6432 Rising Sun Ave, Philadelphia, PA',1200,'http://www.berkshirehathaway.com'
92,'McKesson','Rr 10, Reading, PA',1200,'http://www.mckesson.com'
93,'UnitedHealth Group','2455 Rose Garden Rd, Pittsburgh, PA',1200,'http://www.unitedhealthgroup.com'
94,'CVS Health','1812 Timberline Rd, Altoona, PA',1200,'http://www.cvshealth.com'
95,'General Motors','141 Schiller St, Reading, PA',1200,'http://www.gm.com'
96,'Ford Motor','1126 Pawlings Rd, Norristown, PA',1200,'http://www.ford.com'
97,'AT&T','55 Church Hill Rd, Reading, PA',1200,'http://www.att.com'
98,'General Electric','354 N Prince St, Lancaster, PA',1200,'http://www.ge.com'
99,'AmerisourceBergen','115 Chestnut St, Philadelphia, PA',1400,'http://www.amerisourcebergen.com'
100,'Verizon','2899 Grand Ave, Pittsburgh, PA',1400,'http://www.verizon.com'
101,'Chevron','Po Box 39, Indiana, PA',1400,'http://www.chevron.com'
102,'Costco','1604 Broadway Ave, Pittsburgh, PA',1400,'http://www.costco.com'
103,'Fannie Mae','4734 Liberty Ave, Pittsburgh, PA',1400,'http://www.fanniemae.com'
104,'Kroger','21 Thornwood Rd, Harrisburg, PA',1400,'http://www.thekrogerco.com'
105,'Amazon.com','3725 W Lake Rd, Erie, PA',1400,'http://www.amazon.com'
106,'Walgreens Boots Alliance','1808 4Th Ave, Altoona, PA',1400,'http://www.walgreensbootsalliance.com'
107,'HP','Station Sq, Pittsburgh, PA',1400,'http://www.hp.com'
108,'Cardinal Health','4020 Garden Ave, Erie, PA',1400,'http://www.cardinal.com'
109,'Express Scripts Holding','100 N Peach St, Philadelphia, PA',1400,'http://www.express-scripts.com'
110,'J.P. Morgan Chase','835 Heister Ln, Reading, PA',1400,'http://www.jpmorganchase.com'
112,'Boeing','5643 N 5Th St, Philadelphia, PA',1500,'http://www.boeing.com'
113,'Microsoft','1401 W Warren Rd, Bradford, PA',1500,'http://www.microsoft.com'
114,'Bank of America Corp.','815 Freeport Rd, Pittsburgh, PA',1500,'http://www.bankofamerica.com'
115,'Wells Fargo','327 N Washington Ave # 300, Scranton, PA',1900,'http://www.wellsfargo.com'
117,'Home Depot','4901 Locust Ln, Harrisburg, PA',2300,'http://www.homedepot.com'
118,'Citigroup','3376 Perrysville Ave, Pittsburgh, PA',2300,'http://www.citigroup.com'
119,'Phillips 66','220 Penn Ave # 300, Scranton, PA',2300,'http://www.phillips66.com'
121,'IBM','522 Swede St, Norristown, PA',2300,'http://www.ibm.com'
122,'Valero Energy','7708 City Ave, Philadelphia, PA',2300,'http://www.valero.com'
123,'Anthem','1801 Lititz Pike, Lancaster, PA',2300,'http://www.antheminc.com'
124,'Procter & Gamble','101 E Olney Ave, Philadelphia, PA',2300,'http://www.pg.com'
127,'Alphabet','36 W 34Th St, Erie, PA',2400,'http://www.google.com'
128,'Comcast','1007 Mount Royal Blvd, Pittsburgh, PA',2400,'http://www.comcastcorporation.com'
129,'Target','601 Market St, Philadelphia, PA',2400,'http://www.target.com'
132,'MetLife','5122 Sinclair Ln, Baltimore, MD',2400,'http://www.metlife.com'
133,'Archer Daniels Midland','680 Bel Air Rd, Bel Air, MD',2400,'http://www.adm.com'
135,'Freddie Mac','8004 Stansbury Rd, Baltimore, MD',2400,'http://www.freddiemac.com'
136,'PepsiCo','10209 Yearling Dr, Rockville, MD',2400,'http://www.pepsico.com'
137,'United Technologies','3000 Greenmount Ave, Baltimore, MD',2400,'http://www.utc.com'
139,'Lowe?s','1262 Vocke Rd, Cumberland, MD',2400,'http://www.lowes.com'
140,'UPS','3314 Eastern Ave, Baltimore, MD',2400,'http://www.ups.com'
142,'Prudential Financial','11200 Scaggsville Rd, Laurel, MD',2400,'http://www.prudential.com'
144,'Humana','2300 Harford Rd, Baltimore, MD',2400,'http://www.humana.com'
145,'Disney','2 2Nd St # A, Ocean City, MD',2400,'http://www.disney.com'
146,'Cisco Systems','6917 W Oklahoma Ave, Milwaukee, WI',2400,'http://www.cisco.com'
148,'Dow Chemical','160 Glenwood Ave, Minneapolis, MN',2400,'http://www.dow.com'
149,'Sysco','6915 Grand Ave, Hammond, IN',2400,'http://www.sysco.com'
151,'Caterpillar','65 Cadillac Sq # 2701, Detroit, MI',2500,'http://www.caterpillar.com'
152,'Lockheed Martin','3435 Tuscany Dr Se, Grand Rapids, MI',2500,'http://www.lockheedmartin.com'
155,'Coca-Cola','810 1St Ave, Council Bluffs, IA',3500,'http://www.coca-colacompany.com'
156,'HCA Holdings','500 W Oklahoma Ave, Milwaukee, WI',3500,'http://www.hcahealthcare.com'
159,'Energy Transfer Equity','1721 E Lake St, Minneapolis, MN',3600,'http://www.energytransfer.com'
160,'Tyson Foods','255 Great Arrow Ave, Buffalo, NY',3600,'http://www.tysonfoods.com'
162,'Delta Air Lines','6640 Campbell Blvd, Lockport, NY',3600,'http://www.delta.com'
164,'Nationwide','1136 Arch St, Philadelphia, PA',3600,'http://www.nationwide.com'
166,'Best Buy','Rt 6 E, Warren, PA',3700,'http://www.bestbuy.com'
167,'Merck','1924 Bedford St, Cumberland, MD',3700,'http://www.merck.com'
169,'Liberty Mutual Insurance Group','2713 N Bendix Dr, South Bend, IN',3700,'http://www.libertymutual.com'
171,'Honeywell International','752 W Huron St, Pontiac, MI',3700,'http://www.honeywell.com'
173,'Massachusetts Mutual Life Insurance','1330 N Memorial Dr, Racine, WI',5000,'http://www.massmutual.com'
175,'Morgan Stanley','8 Automation Ln, Albany, NY',5000,'http://www.morganstanley.com'
176,'Cigna','811 N Brandywine Ave, Schenectady, NY',5000,'http://www.cigna.com'
178,'Allstate','3025 Sussex Ave, Pittsburgh, PA',5000,'http://www.allstate.com'
179,'TIAA','932 High St, Lancaster, PA',5000,'http://www.tiaa.org'
181,'CHS','6959 Tulip St, Philadelphia, PA',5000,'http://www.chsinc.com'
182,'American Express','511 S Central Ave # A, Baltimore, MD',5000,'http://www.americanexpress.com'
183,'Gilead Sciences','400 E Joppa Rd, Baltimore, MD',5000,'http://www.gilead.com'
185,'General Dynamics','1796 Tsing Tao, Muang Nonthaburi, ',1200,'http://www.generaldynamics.com'
186,'TJX','1810 Tucker Crt, Mumbai, ',5000,'http://www.tjx.com'
188,'Nike','Sendlinger Tor 4, Munich, ',2400,'http://www.nike.com'
189,'World Fuel Services','Theresienstr 15, Munich, ',2400,'http://www.wfscorp.com'
191,'Mondelez International','1822 Ironweed St, Toronto, ONT',1200,'http://www.mondelezinternational.com'
193,'Twenty-First Century Fox','Via Notoriosa 1932 Rd, Firenze, ',500,'http://www.21cf.com'
194,'Deere','Via Notoriosa 1941, Firenze, ',500,'http://www.johndeere.com'
209,'Time Warner','Via Delle Grazie 11, Tellaro, ',2400,'http://www.timewarner.com'
196,'DuPont','Via Notoriosa 1943, Firenze, ',2400,'http://www.dupont.com'
197,'Avnet','Via Luminosa 162, Tellaro, ',700,'http://www.avnet.com'
199,'Macy?s','Via Di Firenze 231, Tellaro, ',700,'http://www.macysinc.com'
201,'Travelers Cos.','Via Frenzy 6903, Tellaro, ',3600,'http://www.travelers.com'
203,'Philip Morris International','Piazza Quattre Stagioni 4, San Giminiano, ',3600,'http://www.pmi.com'
205,'Tech Data','Via Notoriosa 1932, Tellaro, ',3600,'http://www.techdata.com'
211,'McDonald?s','2034 Sabrina Rd, Samutprakarn, ',3700,'http://www.aboutmcdonalds.com'
213,'Sears Holdings','Ruella Delle Spiriti, Milano, ',500,'http://www.searsholdings.com'
215,'Capital One Financial','Via Delle Capeletti 52, San Giminiano, ',1500,'http://www.capitalone.com'
217,'USAA','Via Delli Capelli 2, San Giminiano, ',700,'http://www.usaa.com'
219,'Duke Energy','1593 Silverado St, Bangalore, Kar',5000,'http://www.duke-energy.com'
221,'Halliburton','1602 Sholay St, Chennai, Tam',1500,'http://www.halliburton.com'
224,'Arrow Electronics','1607 Sangam Blvd, New Delhi, ',5000,'http://www.arrow.com'
1,'Raytheon','514 W Superior St, Kokomo, IN',100,'http://www.raytheon.com'
2,'Plains GP Holdings','2515 Bloyd Ave, Indianapolis, IN',100,'http://www.plainsallamerican.com'
3,'US Foods Holding','8768 N State Rd 37, Bloomington, IN',100,'http://www.usfoods.com'
4,'AbbVie','6445 Bay Harbor Ln, Indianapolis, IN',100,'http://www.abbvie.com'
5,'Centene','4019 W 3Rd St, Bloomington, IN',100,'http://www.centene.com'
6,'Community Health Systems','1608 Portage Ave, South Bend, IN',100,'http://www.chs.net'
7,'Alcoa','23943 Us Highway 33, Elkhart, IN',100,'http://www.alcoa.com'
8,'International Paper','136 E Market St # 800, Indianapolis, IN',100,'http://www.internationalpaper.com'
9,'Emerson Electric','1905 College St, South Bend, IN',100,'http://www.emerson.com'
10,'Union Pacific','3512 Rockville Rd # 137C, Indianapolis, IN',200,'http://www.up.com'
11,'Amgen','1303 E University St, Bloomington, IN',200,'http://www.amgen.com'
12,'U.S. Bancorp','115 N Weinbach Ave, Evansville, IN',200,'http://www.usbank.com'
13,'Staples','2067 Rollett Ln, Evansville, IN',200,'http://www.staples.com'
14,'Danaher','1105 E Allendale Dr, Bloomington, IN',200,'http://www.danaher.com'
15,'Whirlpool','18305 Van Dyke St, Detroit, MI',200,'http://www.whirlpoolcorp.com'
16,'Aflac','Lucas Dr Bldg 348, Detroit, MI',200,'http://www.aflac.com'
17,'AutoNation','1801 Monroe Ave Nw, Grand Rapids, MI',200,'http://www.autonation.com'
18,'Progressive','4925 Kendrick St Se, Grand Rapids, MI',200,'http://www.progressive.com'
19,'Abbott Laboratories','3310 Dixie Ct, Saginaw, MI',200,'http://www.abbott.com'
20,'Dollar General','113 Washington Sq N, Lansing, MI',200,'http://www.dollargeneral.com'
21,'Tenet Healthcare','2500 S Pennsylvania Ave, Lansing, MI',200,'http://www.tenethealth.com'
22,'Eli Lilly','3213 S Cedar St, Lansing, MI',200,'http://www.lilly.com'
24,'Southwest Airlines','6654 W Lafayette St, Detroit, MI',200,'http://www.southwest.com'
25,'Penske Automotive Group','27 Benton Rd, Saginaw, MI',200,'http://www.penskeautomotive.com'
26,'ManpowerGroup','8201 Livernois Ave, Detroit, MI',300,'http://www.manpowergroup.com'
28,'Kohl?s','3100 E Eisenhower Pky # 100, Ann Arbor, MI',300,'http://www.kohlscorporation.com'
29,'Starbucks','952 Vassar Dr, Kalamazoo, MI',400,'http://www.starbucks.com'
30,'Paccar','150 W Jefferson Ave # 2500, Detroit, MI',400,'http://www.paccar.com'
31,'Cummins','40 Pearl St Nw # 1020, Grand Rapids, MI',400,'http://www.cummins.com'
33,'Altria Group','301 E Genesee Ave, Saginaw, MI',400,'http://www.altria.com'
34,'Xerox','9936 Dexter Ave, Detroit, MI',400,'http://www.xerox.com'
35,'Kimberly-Clark','1660 University Ter, Ann Arbor, MI',400,'http://www.kimberly-clark.com'
36,'Hartford Financial Services Group','15713 N East St, Lansing, MI',400,'http://www.thehartford.com'
38,'Kraft Heinz','10315 Hickman Rd, Des Moines, IA',500,'http://www.kraftheinzcompany.com'
40,'Fluor','1928 Sherwood Dr, Council Bluffs, IA',500,'http://www.fluor.com'
41,'AECOM','2102 E Kimberly Rd, Davenport, IA',500,'http://www.aecom.com'
44,'Jabil Circuit','221 3Rd Ave Se # 300, Cedar Rapids, IA',500,'http://www.jabil.com'
45,'CenturyLink','2120 Heights Dr, Eau Claire, WI',500,'http://www.centurylink.com'
47,'General Mills','6555 W Good Hope Rd, Milwaukee, WI',600,'http://www.generalmills.com'
48,'Southern','1314 N Stoughton Rd, Madison, WI',600,'http://www.southerncompany.com'
50,'Thermo Fisher Scientific','6161 N 64Th St, Milwaukee, WI',700,'http://www.thermofisher.com'
51,'American Electric Power','11016 W Lincoln Ave, Milwaukee, WI',700,'http://www.aep.com'
53,'NGL Energy Partners','615 N Sherman Ave, Madison, WI',700,'http://www.nglenergypartners.com'
54,'Bristol-Myers Squibb','512 E Grand Ave, Beloit, WI',700,'http://www.bms.com'
56,'Nucor','5235 N Ironwood Ln, Milwaukee, WI',700,'http://www.nucor.com'
57,'PNC Financial Services Group','322 E Michigan St, Milwaukee, WI',700,'http://www.pnc.com'
58,'Health Net','1400 Bellinger St Fl 4, Eau Claire, WI',700,'http://www.healthnet.com'
60,'Colgate-Palmolive','808 3Rd St # 100, Wausau, WI',700,'http://www.colgatepalmolive.com'
61,'Freeport-McMoRan','300 Crooks St, Green Bay, WI',900,'http://www.fcx.com'
64,'Gap','2122 Campbell Rd, La Crosse, WI',1200,'http://www.gapinc.com'
65,'Baker Hughes','3324 N Oakland Ave, Milwaukee, WI',1200,'http://www.bakerhughes.com'
67,'Dollar Tree','1501 Lowry Ave N, Minneapolis, MN',1200,'http://www.dollartree.com'
69,'Whole Foods Market','4200 Yosemite Ave S, Minneapolis, MN',1200,'http://www.wholefoodsmarket.com'
70,'PPG Industries','2800 Chicago Ave # 100, Minneapolis, MN',1200,'http://www.ppg.com'
72,'Icahn Enterprises','314 W Superior St # 1015, Duluth, MN',1200,'http://www.ielp.com'
74,'Performance Food Group','2720 Brewerton Rd, Syracuse, NY',1200,'http://www.pfgc.com'
76,'DISH Network','1522 Main St, Niagara Falls, NY',1200,'http://www.dish.com'
77,'FirstEnergy','49 N Pine Ave, Albany, NY',1200,'http://www.firstenergycorp.com'
80,'AES','33 Fulton St, Poughkeepsie, NY',1200,'http://www.aes.com'
81,'CarMax','2360 Maxon Rd, Schenectady, NY',1200,'http://www.carmax.com'
84,'NRG Energy','500 S Salina St # 500, Syracuse, NY',1200,'http://www.nrgenergy.com'
85,'Western Digital','33 Pine St, Lockport, NY',1200,'http://www.westerndigital.com'
226,'Office Depot','1612 Talaivar St, Chennai, Tam',5000,'http://www.officedepot.com'
227,'Nordstrom','1613 Victoria St, Calcutta, ',5000,'http://www.nordstrom.com'
229,'Aramark','1615 Crackers Crt, Chennai - India, ',300,'http://www.aramark.com'
230,'DaVita HealthCare Partners','1616 Mr. India Ln, Bombay - India, Kar',300,'http://www.davita.com'
232,'WellCare Health Plans','1618 Villains St, New Delhi - India, ',1200,'http://www.wellcare.com'
233,'CBS','1619 Bowlers Rd, Chandigarh, Har',1200,'http://www.cbscorporation.com'
234,'Visa','1620 Sixers Crt, Bombay, Kar',5000,'http://www.visa.com'
236,'Ecolab','1623 Hey Ram St, Chennai - India, ',5000,'http://www.ecolab.com'
237,'Kellogg','1627 Sowdagar St, New Delhi, ',1900,'http://www.kelloggcompany.com'
239,'Textron','1632 Splash St, Chandigarh, Har',2500,'http://www.textron.com'
240,'Loews','1636 Pretty Blvd, Bangalore, Kar',5000,'http://www.loews.com'
241,'Illinois Tool Works','1646 Brazil Blvd, Chennai, Tam',500,'http://www.itw.com'
244,'Viacom','1650 Teesri Manjil Crt, Kashmir, ',3700,'http://www.viacom.com'
246,'Land O?Lakes','1662 Talaivar St, Chennai, Tam',1500,'http://www.landolakesinc.com'
248,'Devon Energy','Piazza Del Congresso 22, Roma, ',3700,'http://www.devonenergy.com'
251,'Yum Brands','Ruella Delle Spiriti, Roma, ',500,'http://www.yum.com'
252,'Texas Instruments','Via Del Disegno 194, Roma, ',500,'http://www.ti.com'
253,'CDW','Via Delle Capeletti 52, Roma, ',500,'http://www.cdw.com'
256,'Marsh & McLennan','Via Dolorosa 69, Roma, ',2400,'http://www.mmc.com'
257,'Chesapeake Energy','Via Notoriosa 1942, Ventimiglia, ',700,'http://www.chk.com'
260,'Occidental Petroleum','Piazza Cacchiatore 23, Roma, ',700,'http://www.oxy.com'
261,'Guardian Life Ins. Co. of America','Via Del Disegno 194, San Giminiano, ',600,'http://www.guardianlife.com'
264,'J.C. Penney','Via Dello Croce 93, San Giminiano, ',400,'http://www.jcpenney.com'
265,'Consolidated Edison','Ruella Delle Spiriti, San Giminiano, ',400,'http://www.conedison.com'
267,'Cognizant Technology Solutions','Via Delli Capelli 2, Tellaro, ',400,'http://www.cognizant.com'
269,'Ameriprise Financial','Harmoniegasse 3, Baden-Daettwil, AG',500,'http://www.ameriprise.com'
271,'Computer Sciences','Alfred E. Neumann-Weg 3, Baden-Daettwil, AG',500,'http://www.csc.com'
272,'L Brands','Dr. Herbert Bitto Str 23, Baden-Daettwil, AG',2300,'http://www.lb.com'
273,'Jacobs Engineering Group','Taefernstr 4, Baden-Daettwil, AG',2300,'http://www.jacobs.com'
275,'Principal Financial','Helebardenweg 5, Baden-Daettwil, AG',3500,'http://www.principal.com'
276,'Ross Stores','Zum Freundlichen Nachbarn 5, Baden-Daettwil, AG',3500,'http://www.rossstores.com'
277,'Bed Bath & Beyond','Ziegenwiese 3, Baden-Daettwil, AG',3500,'http://www.bedbathandbeyond.com'
278,'CSX','Am Waldrand 5, Baden-Daettwil, AG',3500,'http://www.csx.com'
279,'Toys ?R? Us','Zur Kantine 9, Baden-Daettwil, AG',1200,'http://www.toysrusinc.com'
280,'Las Vegas Sands','Grosse Bahnhostrasse 3, Baden-Daettwil, AG',1200,'http://www.sands.com'
281,'Leucadia National','Paradeplatz 4, Zuerich, ZH',1200,'http://www.leucadia.com'
282,'Dominion Resources','Badenerstr 1941, Zuerich, ZH',3500,'http://www.dom.com'
283,'United States Steel','Welschdoerfchen 1941, Chur, ZH',3500,'http://www.ussteel.com'
284,'L-3 Communications','Le Reduit, Tschiertschen, GR',1400,'http://www.l-3com.com'
285,'Edison International','Bendlehn, Trogen, SG',1400,'http://www.edisoninvestor.com'
286,'Entergy','Spisertor 3, St. Gallen, SG',1400,'http://www.entergy.com'
287,'ADP','Langstr 14, Zuerich, ZH',700,'http://www.adp.com'
288,'First Data','Roessligasse 4, Zurich, ZH',700,'http://www.firstdata.com'
289,'BlackRock','Zum Froehlichen Schweizer 3, Zurich, ZH',5000,'http://www.blackrock.com'
290,'WestRock','Chrottenweg, Bern, BE',5000,'http://www.westrock.com'
291,'Voya Financial','Bruppacher Str 3, Baden-Daettwil, AG',5000,'http://www.voya.com'
292,'Sherwin-Williams','Limmatquai, Zuerich, ZH',1800,'http://www.sherwin.com'
293,'Hilton Worldwide Holdings','Dreikoenigsstr 3, Zurich, ZH',1800,'http://www.hiltonworldwide.com'
295,'R.R. Donnelley & Sons','Kreuzstr 32, Zurich, ZH',2300,'http://www.rrdonnelley.com'
296,'Stanley Black & Decker','1539 Stripes Rd, Baden-Daettwil, AG',2300,'http://www.stanleyblackanddecker.com'
299,'Murphy USA','1593 Silverado St, Bangalore, Kar',1400,'http://corporate.murphyusa.com'
300,'CBRE Group','1596 Commando Blvd, Bangalore, Kar',1200,'http://www.cbre.com'
302,'D.R. Horton','1599 Legend Rd, Bangalore, Kar',5000,'http://www.drhorton.com'
303,'Estee Lauder','1600 Target Crt, Bangalore, Kar',5000,'http://www.elcompanies.com'
304,'Praxair','1603 Rebel St, Bangalore, Kar',500,'http://www.praxair.com'
305,'Biogen','1604 Volunteers Rd, Bangalore, Kar',500,'http://www.biogen.com'
307,'State Street Corp.','1607 Abwdrts St, Bangalore, Kar',3500,'http://www.statestreet.com'
308,'Unum Group','1608 Amadeus St, Bangalore, Kar',3500,'http://www.unum.com'
309,'Reynolds American','1610 Betrayal Crt, Bangalore, Kar',5000,'http://www.reynoldsamerican.com'
311,'Group 1 Automotive','1614 Crackers Rd, Bangalore - India, Kar',2300,'http://www.group1auto.com'
312,'Henry Schein','1615 Crackers Crt, Bangalore - India, Kar',5000,'http://www.henryschein.com'
315,'Norfolk Southern','1618 Footloose St, Bangalore - India, Kar',900,'http://www.nscorp.com'
316,'Reinsurance Group of America','1619 Footloose Rd, Bangalore - India, Kar',900,'http://www.rgare.com'
317,'Public Service Enterprise Group','1621 Gargon! Blvd, Bangalore - India, Kar',600,'http://www.pseg.com'
23,'DTE Energy','8110 Jackson Rd, Ann Arbor, MI',200,'http://www.dteenergy.com'
27,'Assurant','101 N Falahee Rd, Jackson, MI',300,'http://www.assurant.com'
37,'Huntsman','555 John F Kennedy Rd, Dubuque, IA',500,'http://www.huntsman.com'
42,'Becton Dickinson','1691 Asbury Rd, Dubuque, IA',500,'http://www.bd.com'
68,'AutoZone','113 N 1St St, Minneapolis, MN',1200,'http://www.autozone.com'
73,'Navistar International','1409 Willow St # 600, Minneapolis, MN',1200,'http://www.navistar.com'
82,'Discover Financial Services','85 High St, Buffalo, NY',1200,'http://www.discoverfinancial.com'
87,'Liberty Interactive','2979 Hamburg St, Schenectady, NY',1200,'http://www.libertyinteractive.com'
116,'Baxter International','810 Race St, Philadelphia, PA',1900,'http://www.baxter.com'
120,'Stryker','135 S 18Th St # 1, Philadelphia, PA',2300,'http://www.stryker.com'
130,'Western Refining','5565 Baynton St, Philadelphia, PA',2400,'http://www.wnr.com'
154,'Universal Health Services','1751 Madison Ave, Council Bluffs, IA',3500,'http://www.uhsinc.com'
158,'Owens & Minor','310 Broadway St, Alexandria, MN',3600,'http://www.owens-minor.com'
168,'Advance Auto Parts','2674 Collingwood St, Detroit, MI',3700,'http://www.advanceautoparts.com'
172,'MasterCard','660 Woodward Ave # 2290, Detroit, MI',3700,'http://www.mastercard.com'
198,'Eastman Chemical','2017 Convoy St, Tokyo, ',2400,'http://www.eastman.com'
202,'Sonic Automotive','Piazza Del Congresso 22, San Giminiano, ',3600,'http://www.sonicautomotive.com'
210,'CST Brands','2033 Spartacus St, Samutprakarn, ',3700,'http://www.cstbrands.com'
214,'eBay','Via Del Disegno 194, Milano, ',1500,'http://www.ebay.com'
222,'GameStop','1605 Bazigar Crt, Pune, ',5000,'http://www.gamestopcorp.com'
225,'Reliance Steel & Aluminum','1609 Pakija Rd, New Delhi, ',3700,'http://www.rsac.com'
247,'Celgene','1667 2010 St, Batavia, Ker',500,'http://www.celgene.com'
250,'Genworth Financial','Piazza Svizzera, Roma, ',2400,'http://www.genworth.com'
258,'Priceline Group','Via Notoriosa 1943, Ventimiglia, ',700,'http://www.pricelinegroup.com'
262,'MGM Resorts International','Piazza Svizzera, San Giminiano, ',100,'http://www.mgmresorts.com'
270,'Fidelity National Financial','Sonnenberg 4, Baden-Daettwil, AG',500,'http://www.fnf.com'
274,'Republic Services','Kreuzritterplatz 5, Baden-Daettwil, AG',3500,'http://www.republicservices.com'
298,'Peter Kiewit Sons?','1592 Silverado St, Bangalore, Kar',1400,'http://www.kiewit.com'
306,'Mosaic','1606 Volunteers Blvd, Bangalore, Kar',3500,'http://www.mosaicco.com'
310,'Core-Mark Holding','1611 Carmen Blvd, Bangalore, Kar',5000,'http://www.core-mark.com'
318,'Cameron International','1667 2010 St, Batavia, IL',200,'http://www.c-a-m.com'
297,'Xcel Energy','1540 Stripes Crt, Baden-Daettwil, AG',400,'http://www.xcelenergy.com'
126,'State Farm Insurance Cos.','223 4Th Ave # 1100, Pittsburgh, PA',2300,'http://www.statefarm.com'
131,'Johnson & Johnson','5640 Fishers Ln, Rockville, MD',2400,'http://www.jnj.com'
134,'Marathon Petroleum','4301 Ashland Ave, Baltimore, MD',2400,'http://www.marathonpetroleum.com'
138,'Aetna','200 E Fort Ave, Baltimore, MD',2400,'http://www.aetna.com'
141,'AIG','12817 Coastal Hwy, Ocean City, MD',2400,'http://www.aig.com'
143,'Intel','9435 Washington Blvd N # M, Laurel, MD',2400,'http://www.intel.com'
147,'Pfizer','206 S Broadway # 707, Rochester, MN',2400,'http://www.pfizer.com'
150,'FedEx','2215 Oak Industrial Dr Ne, Grand Rapids, MI',2400,'http://www.fedex.com'
153,'New York Life Insurance','215 4Th Ave Se, Cedar Rapids, IA',2500,'http://www.newyorklife.com'
157,'Ingram Micro','4811 S 76Th St # 205, Milwaukee, WI',3600,'http://www.ingrammicro.com'
161,'American Airlines Group','800 Carter St, Rochester, NY',3600,'http://www.aa.com'
165,'Johnson Controls','6Th And Master St, Philadelphia, PA',3600,'http://www.johnsoncontrols.com'
170,'Goldman Sachs Group','23985 Bedford Rd N, Battle Creek, MI',3700,'http://www.gs.com'
174,'Oracle','701 Seneca St, Buffalo, NY',5000,'http://www.oracle.com'

}

contacts = {
	contact_id:number, first_name:string, last_name:string, email:string, phone:string, customer_id:number

1,'Flor','Stone','[email protected]','+1 317 123 4104',1
2,'Lavera','Emerson','[email protected]','+1 317 123 4111',2
3,'Fern','Head','[email protected]','+1 812 123 4115',3
4,'Shyla','Ortiz','[email protected]','+1 317 123 4126',4
5,'Jeni','Levy','[email protected]','+1 812 123 4129',5
6,'Matthias','Hannah','[email protected]','+1 219 123 4136',6
7,'Matthias','Cruise','[email protected]','+1 219 123 4138',7
8,'Meenakshi','Mason','[email protected]','+1 317 123 4141',8
9,'Christian','Cage','[email protected]','+1 219 123 4142',9
10,'Charlie','Sutherland','[email protected]','+1 317 123 4146',10
11,'Charlie','Pacino','[email protected]','+1 812 123 4150',11
12,'Guillaume','Jackson','[email protected]','+1 812 123 4151',12
13,'Daniel','Costner','[email protected]','+1 812 123 4153',13
14,'Dianne','Derek','[email protected]','+1 812 123 4157',14
15,'Geraldine','Schneider','[email protected]','+1 313 123 4159',15
16,'Geraldine','Martin','[email protected]','+1 313 123 4160',16
17,'Guillaume','Edwards','[email protected]','+1 616 123 4162',17
18,'Maurice','Mahoney','[email protected]','+1 616 123 4181',18
19,'Maurice','Hasan','[email protected]','+1 517 123 4191',19
20,'Diane','Higgins','[email protected]','+1 517 123 4199',20
21,'Dianne','Sen','[email protected]','+1 517 123 4201',21
22,'Maurice','Daltrey','[email protected]','+1 517 123 4206',22
23,'Tess','Roth','[email protected]','+1 313 123 4219',23
24,'Ka','Kaufman','[email protected]','+1 313 123 4222',24
25,'Sharyl','Montoya','[email protected]','+1 517 123 4225',25
26,'Daniel','Glass','[email protected]','+1 313 123 4226',26
27,'Rena','Arnold','[email protected]','+1 517 123 4228',27
28,'Arlyne','Ingram','[email protected]','+1 313 123 4230',28
29,'Willie','Barrera','[email protected]','+1 616 123 4234',29
30,'Mireya','Cochran','[email protected]','+1 313 123 4242',30
31,'Marlene','Odom','[email protected]','+1 616 123 4245',31
32,'Jaclyn','Atkinson','[email protected]','+1 313 123 4248',32
33,'Al','Schultz','[email protected]','+1 517 123 4253',33
34,'Felicitas','Riley','[email protected]','+1 313 123 4255',34
35,'Cora','Calhoun','[email protected]','+1 313 123 4263',35
36,'Trula','Buckley','[email protected]','+1 517 123 4265',36
37,'Sasha','Wallace','[email protected]','+1 319 123 4271',37
38,'Caitlin','Hill','[email protected]','+1 515 123 4273',38
39,'Gino','Pickett','[email protected]','+1 319 123 4278',39
40,'Amira','Macdonald','[email protected]','+1 712 123 4280',40
41,'Mack','Morse','[email protected]','+1 319 123 4282',41
42,'Eboni','Jarvis','[email protected]','+1 319 123 4288',42
43,'Gabrielle','Dennis','[email protected]','+1 515 123 4290',43
44,'Classie','Norris','[email protected]','+1 319 123 4301',44
45,'Khalilah','Holman','[email protected]','+1 745 123 4306',45
46,'Isreal','Rose','[email protected]','+1 414 123 4307',46
47,'Verena','Hopper','[email protected]','+1 414 123 4308',47
48,'Audie','Flores','[email protected]','+1 608 123 4309',48
49,'Gertrude','Cooke','[email protected]','+1 608 123 4318',49
50,'Princess','Kane','[email protected]','+1 414 123 4323',50
51,'Jacinta','Faulkner','[email protected]','+1 414 123 4324',51
52,'Lashon','Wall','[email protected]','+1 414 123 4328',52
53,'Corliss','Mcneil','[email protected]','+1 608 123 4332',53
54,'Brock','Webb','[email protected]','+1 608 123 4344',54
55,'Melany','Mcmahon','[email protected]','+1 414 123 4347',55
56,'Rogelio','Kirby','[email protected]','+1 414 123 4348',56
57,'Wallace','Dillard','[email protected]','+1 414 123 4350',57
58,'Gia','Boyle','[email protected]','+1 745 123 4367',58
59,'Tennie','Gay','[email protected]','+1 414 123 4369',59
60,'Ophelia','Hurst','[email protected]','+1 715 123 4372',60
61,'Ciara','Flowers','[email protected]','+1 414 123 4373',61
62,'Birgit','Stephenson','[email protected]','+1 608 123 4374',62
63,'Shameka','Spencer','[email protected]','+1 414 123 4376',63
64,'Alysa','Kane','[email protected]','+1 608 123 4378',64
65,'Fransisca','Reeves','[email protected]','+1 414 123 4381',65
66,'Jessika','Merritt','[email protected]','+1 612 123 4397',66
67,'Agustina','Conner','[email protected]','+1 612 123 4399',67
68,'Roxanna','Wade','[email protected]','+1 612 123 4408',68
69,'Virgie','Mays','[email protected]','+1 612 123 4417',69
70,'Trang','Mcconnell','[email protected]','+1 612 123 4419',70
71,'Nada','West','[email protected]','+1 507 123 4421',71
72,'Catherina','Haney','[email protected]','+1 218 123 4429',72
73,'Harriette','Melton','[email protected]','+1 612 123 4434',73
74,'Willette','Rodgers','[email protected]','+1 315 123 4442',74
75,'Calandra','Williamson','[email protected]','+1 315 123 4447',75
76,'Tamatha','Delgado','[email protected]','+1 716 123 4457',76
77,'Felix','Ferguson','[email protected]','+1 518 123 4459',77
78,'Elwood','Hampton','[email protected]','+1 518 123 4464',78
79,'Josh','Roach','[email protected]','+1 518 123 4474',79
80,'Luanna','Scott','[email protected]','+1 914 123 4494',80
81,'Meryl','Cole','[email protected]','+1 518 123 4496',81
82,'Jannet','Elliott','[email protected]','+1 716 123 4575',82
83,'Fae','Glenn','[email protected]','+1 914 123 4578',83
84,'Francisco','Cummings','[email protected]','+1 315 123 4597',84
85,'Ermelinda','Benton','[email protected]','+1 716 123 4599',85
86,'Lasonya','Beard','[email protected]','+1 716 123 4605',86
87,'Rayna','Tran','[email protected]','+1 518 123 4617',87
88,'Annice','Boyer','[email protected]','+1 518 123 4618',88
89,'Ja','Whitfield','[email protected]','+1 914 123 4619',89
90,'Jaime','Lester','[email protected]','+1 518 123 4624',90
91,'Charlsie','Lindsey','[email protected]','+1 215 123 4644',91
92,'Jannette','Henry','[email protected]','+1 610 123 4657',92
93,'Margart','Mccall','[email protected]','+1 412 123 4662',93
94,'Twanna','Cleveland','[email protected]','+1 814 123 4663',94
95,'Bronwyn','Horn','[email protected]','+1 610 123 4664',95
96,'Jon','Petersen','[email protected]','+1 610 123 4667',96
97,'Denny','Daniel','[email protected]','+1 610 123 4669',97
98,'Avis','Moore','[email protected]','+1 717 123 4674',98
99,'Eden','Burke','[email protected]','+1 215 123 4676',99
100,'Elisha','Lloyd','[email protected]','+1 412 123 4681',100
101,'Samara','Barnett','[email protected]','+1 412 123 4684',101
102,'Nadia','Sawyer','[email protected]','+1 412 123 4688',102
103,'Melita','Holcomb','[email protected]','+1 412 123 4691',103
104,'Evita','Dickerson','[email protected]','+1 717 123 4692',104
105,'Aundrea','Barry','[email protected]','+1 814 123 4696',105
106,'Irvin','Leach','[email protected]','+1 814 123 4697',106
107,'Kellee','Molina','[email protected]','+1 412 123 4700',107
108,'Ronny','Sykes','[email protected]','+1 814 123 4706',108
109,'Ocie','Walton','[email protected]','+1 215 123 4708',109
110,'Reva','Fuller','[email protected]','+1 610 123 4714',110
111,'Marica','Henderson','[email protected]','+1 412 123 4718',111
112,'Vanetta','Gross','[email protected]','+1 215 123 4721',112
113,'Audrea','Hayden','[email protected]','+1 814 123 4722',113
114,'Neda','Mcfadden','[email protected]','+1 412 123 4724',114
115,'Dell','Wilkinson','[email protected]','+1 717 123 4730',115
116,'Sharee','Carver','[email protected]','+1 215 123 4738',116
117,'Joaquina','Mcconnell','[email protected]','+1 717 123 4739',117
118,'Carlyn','Calderon','[email protected]','+1 412 123 4740',118
119,'Olga','Wilkins','[email protected]','+1 717 123 4741',119
120,'Delpha','Golden','[email protected]','+1 215 123 4743',120
121,'Sharell','Branch','[email protected]','+1 610 123 4744',121
122,'Eleanor','Farley','[email protected]','+1 215 123 4745',122
123,'Justina','Hayes','[email protected]','+1 717 123 4746',123
124,'Omer','Macdonald','[email protected]','+1 215 123 4748',124
125,'Roseline','Hill','[email protected]','+1 717 123 4752',125
126,'Janeen','Holt','[email protected]','+1 412 123 4763',126
127,'Tory','Avila','[email protected]','+1 814 123 4766',127
128,'Keila','Slater','[email protected]','+1 412 123 4767',128
129,'Jazmin','Burch','[email protected]','+1 215 123 4768',129
130,'Tandy','Ramsey','[email protected]','+1 215 123 4771',130
131,'Debra','Herring','[email protected]','+1 301 123 4794',131
132,'Monnie','Walker','[email protected]','+1 410 123 4795',132
133,'Alvaro','Hooper','[email protected]','+1 410 123 4800',133
134,'Leandro','West','[email protected]','+1 410 123 4805',134
135,'Lurline','Dennis','[email protected]','+1 410 012 4715',135
136,'Aurea','Sanders','[email protected]','+1 301 123 4809',136
137,'Stacia','Rutledge','[email protected]','+1 410 123 4812',137
138,'Philomena','Elliott','[email protected]','+1 410 123 4813',138
139,'Gonzalo','Stone','[email protected]','+1 301 123 4814',139
140,'So','Hardin','[email protected]','+1 410 123 4816',140
141,'Lauren','Rodriquez','[email protected]','+1 410 123 4817',141
142,'Loan','Patton','[email protected]','+1 301 123 4818',142
143,'Ha','Lowe','[email protected]','+1 301 123 4819',143
144,'Alexandra','Mcgowan','[email protected]','+1 410 123 4822',144
145,'Melissa','Nichols','[email protected]','+1 410 123 4840',145
146,'Keesha','Cohen','[email protected]','+1 414 123 4363',146
147,'Elvera','Benson','[email protected]','+1 507 123 4387',147
148,'Lanora','Ray','[email protected]','+1 612 123 4436',148
149,'Jimmy','Weber','[email protected]','+1 219 123 4145',149
150,'Mae','Wilkinson','[email protected]','+1 616 123 4190',150
151,'Lino','Noble','[email protected]','+1 313 123 4241',151
152,'Kathie','Jordan','[email protected]','+1 616 123 4259',152
153,'Heike','Emerson','[email protected]','+1 319 123 4269',153
154,'Princess','Jones','[email protected]','+1 712 123 4284',154
155,'Doretha','Tyler','[email protected]','+1 712 123 4289',155
156,'Emilio','Duncan','[email protected]','+1 414 123 4312',156
157,'Glinda','Lambert','[email protected]','+1 414 123 4364',157
158,'Emery','Schneider','[email protected]','+1 320 123 4385',158
159,'Amado','Jefferson','[email protected]','+1 612 123 4407',159
160,'Hisako','Herrera','[email protected]','+1 716 123 4456',160
161,'Jamee','Mclaughlin','[email protected]','+1 716 123 4582',161
162,'Audrie','Cannon','[email protected]','+1 716 123 4627',162
163,'Lacey','Walters','[email protected]','+1 412 123 4677',163
164,'Weldon','Robinson','[email protected]','+1 215 123 4702',164
165,'Solange','Gates','[email protected]','+1 215 123 4749',165
166,'Jame','Calhoun','[email protected]','+1 814 123 4755',166
167,'Stefan','Walters','[email protected]','+1 301 123 4831',167
168,'Arlene','Elliott','[email protected]','+1 313 123 4167',168
169,'Sofia','Burnett','[email protected]','+1 219 123 4116',169
170,'Christal','Grant','[email protected]','+1 616 123 4166',170
171,'Violeta','Stokes','[email protected]','+1 810 123 4212',171
172,'Jackeline','Finley','[email protected]','+1 313 123 4240',172
173,'Heidy','Massey','[email protected]','+1 414 123 4340',173
174,'Yolando','Wilkerson','[email protected]','+1 716 123 4485',174
175,'Lucinda','Hurley','[email protected]','+1 518 123 4532',175
176,'Gita','Logan','[email protected]','+1 518 123 4562',176
177,'Felicita','Alston','[email protected]','+1 315 123 4585',177
178,'Lela','Ewing','[email protected]','+1 412 123 4659',178
179,'Gabriel','Pollard','[email protected]','+1 717 123 4679',179
180,'Vincenza','Walton','[email protected]','+1 215 123 4709',180
181,'Shandra','Higgins','[email protected]','+1 215 123 4751',181
182,'Thomasena','Pickett','[email protected]','+1 410 123 4807',182
183,'Aaron','Holder','[email protected]','+1 410 123 4829',183
184,'Carlos','Moody','[email protected]','+86 811 012 4093',184
185,'Javier','Kim','[email protected]','+86 123 012 4095',185
186,'Fran','Battle','[email protected]','+91 80 012 4123',186
187,'Shelia','Brewer','[email protected]','+49 89 012 4129',187
188,'Jeri','Randall','[email protected]','+49 90 012 4131',188
189,'Jermaine','Cote','[email protected]','+49 91 012 4133',189
190,'Kenneth','Simmons','[email protected]','+39 6 012 4543',190
191,'Dulce','Matthews','[email protected]','+1 416 012 4147',191
192,'Kristle','Cain','[email protected]','+39 55 012 4547',192
193,'Erika','Murray','[email protected]','+39 55 012 4551',193
194,'Maud','Cohen','[email protected]','+39 55 012 4555',194
195,'Rolanda','Vang','[email protected]','+39 10 012 4365',195
196,'Renea','Carney','[email protected]','+39 55 012 4565',196
197,'Sybil','Harding','[email protected]','+39 10 012 4367',197
198,'Colette','Estrada','[email protected]','+81 565 012 4567',198
199,'Maximo','Ortega','[email protected]','+39 10 012 4369',199
200,'Kina','Larsen','[email protected]','+39 55 012 4569',200
201,'Jarvis','Allison','[email protected]','+39 10 012 4371',201
202,'Collene','Newton','[email protected]','+39 49 012 4373',202
203,'Vella','Hancock','[email protected]','+39 49 012 4375',203
204,'Retta','Martinez','[email protected]','+39 49 012 4377',204
205,'Annelle','Lawrence','[email protected]','+39 10 012 4379',205
206,'Sherron','Simon','[email protected]','+39 10 012 4381',206
207,'Carita','Mcintyre','[email protected]','+86 10 012 4165',207
208,'Stephaine','Booker','[email protected]','+39 55 012 4559',208
209,'Emilie','Parsons','[email protected]','+39 10 012 4363',209
210,'Jaleesa','Bowen','[email protected]','+66 76 012 4633',210
211,'Jeannie','Poole','[email protected]','+91 80 012 4637',211
212,'Adrienne','Lang','[email protected]','+39 2 012 4771',212
213,'Jess','Nguyen','[email protected]','+39 2 012 4773',213
214,'Tandy','House','[email protected]','+39 2 012 4775',214
215,'Herman','Stokes','[email protected]','+39 49 012 4777',215
216,'Keesha','Lambert','[email protected]','+39 49 012 4779',216
217,'Lauren','Williamson','[email protected]','+39 49 012 4781',217
218,'Lucius','Abbott','[email protected]','+91 80 012 4783',218
219,'Beatrice','Ford','[email protected]','+91 80 012 4785',219
220,'Tamisha','Vargas','[email protected]','+91 80 012 4793',220
221,'Dick','Lamb','[email protected]','+91 80 012 4803',221
222,'Yolanda','Ball','[email protected]','+91 80 012 4809',222
223,'Jerica','Brooks','[email protected]','+91 11 012 4811',223
224,'Nichol','Carter','[email protected]','+91 11 012 4813',224
225,'Bobby','Wilson','[email protected]','+91 11 012 4817',225
226,'Eve','Saunders','[email protected]','+91 80 012 4823',226
227,'Ginger','Atkinson','[email protected]','+91 33 012 4825',227
228,'Kenton','Harrell','[email protected]','+91 33 012 4827',228
229,'Misti','Velazquez','[email protected]','+91 80 012 4829',229
230,'Brandie','Buchanan','[email protected]','+91 22 012 4831',230
231,'Kandi','Holden','[email protected]','+91 80 012 4833',231
232,'Lashonda','Cunningham','[email protected]','+91 11 012 4835',232
233,'Roxanne','Michalkow','[email protected]','+91 172 012 4837',233
234,'Phuong','Sanders','[email protected]','+91 22 012 4839',234
235,'Vida','Kline','[email protected]','+91 80 012 4841',235
236,'Mayola','Houston','[email protected]','+91 80 012 4843',236
237,'Cristine','Bell','[email protected]','+91 11 012 4851',237
238,'Shamika','Bauer','[email protected]','+91 11 012 4853',238
239,'Rebbeca','Day','[email protected]','+91 172 012 4861',239
240,'Maryrose','Cain','[email protected]','+91 80 012 4869',240
241,'Johnie','Rojas','[email protected]','+91 80 012 4887',241
242,'Verla','Christian','[email protected]','+91 80 012 4889',242
243,'Teressa','Hewitt','[email protected]','+91 80 012 4891',243
244,'Shenna','Blair','[email protected]','+91 141 012 4895',244
245,'Latoyia','Burt','[email protected]','+91 80 012 4907',245
246,'Shaquita','Norman','[email protected]','+91 80 012 4919',246
247,'Myrna','Romero','[email protected]','+91 80 012 4931',247
248,'Bill','Stein','[email protected]','+39 6 012 4501',248
249,'Olivia','Conrad','[email protected]','+39 6 012 4503',249
250,'Marianne','Bryant','[email protected]','+39 6 012 4507',250
251,'Dustin','Paul','[email protected]','+39 6 012 4511',251
252,'Elroy','Wolf','[email protected]','+39 6 012 4515',252
253,'Jadwiga','Morrison','[email protected]','+39 6 012 4519',253
254,'Isabella','Ortega','[email protected]','+39 6 012 4531',254
255,'Katia','Case','[email protected]','+39 6 012 4535',255
256,'Enriqueta','Odom','[email protected]','+39 6 012 4539',256
257,'Don','Hansen','[email protected]','+39 10 012 4385',257
258,'Herb','Sloan','[email protected]','+39 10 012 4387',258
259,'Blanche','Robbins','[email protected]','+39 6 012 4389',259
260,'Gaynell','Burton','[email protected]','+39 6 012 4391',260
261,'Marhta','Baldwin','[email protected]','+39 49 012 4409',261
262,'Peter','Gamble','[email protected]','+39 49 012 4411',262
263,'Nathan','Callahan','[email protected]','+39 10 012 4413',263
264,'Tereasa','Padilla','[email protected]','+39 49 012 4415',264
265,'Merrilee','Phillips','[email protected]','+39 49 012 4417',265
266,'Tisha','Mcdonald','[email protected]','+39 49 012 4419',266
267,'Napoleon','Cruz','[email protected]','+39 10 012 4421',267
268,'Basilia','Downs','[email protected]','+66 76 012 4441',268
269,'Alessandra','Estrada','[email protected]','+41 56 012 3527',269
270,'Sherron','Flores','[email protected]','+41 57 012 3529',270
271,'Elicia','Townsend','[email protected]','+41 58 012 3531',271
272,'Percy','Hernandez','[email protected]','+41 59 012 3533',272
273,'Shelia','Cain','[email protected]','+41 60 012 3535',273
274,'Charlene','Booker','[email protected]','+41 61 012 3537',274
275,'Mac','Mckay','[email protected]','+41 62 012 3539',275
276,'Jamison','Merritt','[email protected]','+41 63 012 3541',276
277,'Quinton','Woods','[email protected]','+41 64 012 3543',277
278,'Cathey','Mcdowell','[email protected]','+41 65 012 3545',278
279,'Deneen','Hays','[email protected]','+41 66 012 3547',279
280,'Jackson','Morin','[email protected]','+41 67 012 3549',280
281,'Margo','Hoffman','[email protected]','+41 2 012 3551',281
282,'Adah','Myers','[email protected]','+41 3 012 3553',282
283,'Florene','Craig','[email protected]','+41 81 012 3555',283
284,'Janey','Burris','[email protected]','+41 81 012 3557',284
285,'Evelina','Campbell','[email protected]','+41 71 012 3559',285
286,'Thi','Maxwell','[email protected]','+41 71 012 3561',286
287,'Aleshia','Reese','[email protected]','+41 4 012 3563',287
288,'Dorotha','Wong','[email protected]','+41 6 012 3565',288
289,'Estela','Donovan','[email protected]','+41 7 012 3567',289
290,'Hassan','Rivers','[email protected]','+41 31 012 3569',290
291,'Jen','Mcmahon','[email protected]','+41 68 012 3571',291
292,'Barbie','Carter','[email protected]','+41 5 012 3573',292
293,'Cleo','English','[email protected]','+41 8 012 3575',293
294,'Liana','Pena','[email protected]','+41 1 012 3577',294
295,'Francina','Slater','[email protected]','+41 9 012 3579',295
296,'Josie','Steele','[email protected]','+41 69 012 3581',296
297,'Maryrose','Roberson','[email protected]','+41 70 012 3583',297
298,'Elly','Salinas','[email protected]','+91 80 012 3687',298
299,'Ginny','Carlson','[email protected]','+91 80 012 3689',299
300,'Mozelle','Schneider','[email protected]','+91 80 012 3695',300
301,'Adam','Jacobs','[email protected]','+91 80 012 3699',301
302,'Vernia','Hayes','[email protected]','+91 80 012 3701',302
303,'Ismael','Solomon','[email protected]','+91 80 012 3703',303
304,'Ivey','Rutledge','[email protected]','+91 80 012 3709',304
305,'Jame','Terrell','[email protected]','+91 80 012 3711',305
306,'Daina','Combs','[email protected]','+91 80 012 3715',306
307,'Lashunda','Davidson','[email protected]','+91 80 012 3717',307
308,'Arlette','Thornton','[email protected]','+91 80 012 3719',308
309,'Darron','Robertson','[email protected]','+91 80 012 3723',309
310,'Maple','Barnett','[email protected]','+91 80 012 3725',310
311,'Charlsie','Carey','[email protected]','+91 80 012 3731',311
312,'Frank','Shannon','[email protected]','+91 80 012 3733',312
313,'Josiah','Beasley','[email protected]','+91 80 012 3735',313
314,'Annabelle','Butler','[email protected]','+91 80 012 3737',314
315,'Ed','Mueller','[email protected]','+91 80 012 3739',315
316,'Colleen','Estrada','[email protected]','+91 80 012 3741',316
317,'Nikia','Kent','[email protected]','+91 80 012 3745',317
318,'Amber','Brady','[email protected]','+91 80 012 3837',318
319,'Wendell','Massey','[email protected]','+86 10 012 3839',319

}

orders = {
	order_id:number, customer_id:number, status:string, salesman_id:number, order_date:date

105,1,'Pending',54,2016-11-17
44,2,'Pending',55,2017-02-20
101,3,'Pending',55,2017-01-03
1,4,'Pending',56,2017-10-15
5,5,'Canceled',56,2017-04-09
28,6,'Canceled',57,2017-08-15
87,7,'Canceled',57,2016-12-01
4,8,'Shipped',59,2015-04-09
41,9,'Shipped',59,2017-05-11
82,44,'Shipped',60,2016-12-03
102,45,'Shipped',61,2016-12-20
26,46,'Shipped',62,2016-08-16
43,47,'Shipped',62,2015-05-02
53,48,'Shipped',62,2016-09-29
81,49,'Shipped',62,2016-12-13
83,16,'Shipped',62,2016-12-02
93,17,'Shipped',62,2016-10-27
94,1,'Shipped',62,2017-10-27
79,2,'Shipped',64,2016-12-14
80,3,'Shipped',64,2016-12-13
2,4,'Shipped',null,2015-04-26
3,5,'Shipped',null,2017-04-26
6,6,'Shipped',null,2015-04-09
7,7,'Shipped',null,2017-02-15
8,8,'Shipped',null,2017-02-14
9,9,'Shipped',null,2017-02-14
10,44,'Pending',null,2017-01-24
11,45,'Shipped',null,2016-11-29
12,46,'Shipped',null,2016-11-29
13,47,'Shipped',null,2016-11-29
14,48,'Shipped',null,2017-09-28
15,49,'Shipped',null,2017-09-27
16,16,'Pending',null,2016-09-27
17,17,'Shipped',null,2017-09-27
18,18,'Shipped',null,2016-08-16
19,19,'Shipped',null,2016-05-27
20,20,'Shipped',null,2017-05-27
21,21,'Pending',null,2017-05-27
22,22,'Canceled',null,2016-05-26
23,23,'Shipped',null,2016-09-07
24,41,'Shipped',null,2016-09-07
25,42,'Shipped',null,2016-08-24
27,43,'Canceled',null,2016-08-16
29,44,'Shipped',null,2017-08-14
30,45,'Shipped',null,2017-08-12
31,46,'Canceled',null,2017-08-12
32,47,'Shipped',null,2017-03-09
33,48,'Shipped',null,2017-03-07
34,49,'Shipped',null,2016-06-12
35,50,'Shipped',null,2016-09-05
36,51,'Shipped',null,2017-09-05
37,52,'Shipped',null,2017-02-19
38,53,'Canceled',57,2015-05-31
39,54,'Shipped',62,2016-10-22
40,55,'Shipped',62,2017-05-11
42,56,'Canceled',64,2015-05-03
45,57,'Shipped',64,2017-02-20
46,58,'Pending',62,2017-02-20
47,59,'Canceled',62,2016-10-10
48,60,'Canceled',64,2016-10-10
49,61,'Shipped',55,2016-10-02
50,62,'Pending',55,2016-10-02
51,63,'Shipped',59,2016-10-02
52,64,'Shipped',60,2016-10-02
54,65,'Shipped',56,2016-09-29
55,66,'Pending',59,2016-09-29
56,67,'Canceled',55,2016-09-29
57,68,'Shipped',57,2017-08-24
58,69,'Shipped',57,2016-08-24
59,70,'Shipped',59,2015-06-29
60,1,'Shipped',62,2017-06-30
61,2,'Shipped',54,2016-06-30
62,3,'Shipped',62,2015-06-30
63,4,'Shipped',61,2016-06-30
64,5,'Shipped',64,2016-06-21
65,6,'Shipped',64,2013-06-21
66,7,'Canceled',61,2016-06-21
67,8,'Canceled',61,2016-06-14
68,9,'Pending',null,2016-06-13
69,44,'Canceled',54,2017-03-17
70,45,'Canceled',61,2017-02-21
71,46,'Shipped',54,2017-02-21
72,47,'Shipped',64,2016-02-17
73,48,'Shipped',null,2016-02-17
74,49,'Shipped',64,2017-02-10
75,16,'Shipped',null,2017-02-10
76,17,'Shipped',55,2017-02-10
77,1,'Shipped',60,2017-01-02
78,2,'Pending',64,2015-12-14
84,3,'Shipped',64,2015-12-01
85,4,'Pending',55,2016-12-01
86,5,'Pending',60,2016-11-30
88,6,'Shipped',61,2017-11-01
89,7,'Shipped',55,2015-10-27
90,8,'Pending',55,2015-10-28
91,9,'Pending',56,2016-10-28
92,44,'Shipped',59,2015-10-28
95,45,'Shipped',59,2016-09-19
96,46,'Shipped',56,2016-09-14
97,47,'Canceled',60,2016-07-12
98,48,'Shipped',55,2017-03-18
99,49,'Shipped',60,2017-01-07
100,16,'Pending',54,2017-01-05
103,17,'Pending',64,2016-02-08
104,18,'Shipped',60,2017-02-01

}

order_items = {
	order_id:number, item_id:number, product_id:number, quantity:number, unit_price:number

70,7,32,132,469.99
73,5,192,124,519.99
74,7,27,92,800.74
75,11,6,128,849.99
76,10,95,106,109.99
77,5,271,148,549.59
81,7,79,127,659.99
82,9,284,138,54.99
83,8,174,117,798.26
84,6,131,34,279.99
87,11,271,58,549.59
90,8,92,49,2200
91,11,226,77,309.85
93,5,121,141,721.99
94,9,12,33,824.98
99,9,17,144,699.01
102,3,247,149,339.99
104,7,178,145,1999.89
105,6,183,79,899.99
2,9,200,75,620.95
4,8,18,116,799
6,7,7,119,680.99
8,9,268,148,47.88
2,1,43,111,298.98
3,1,24,111,66.89
4,1,280,47,149.88
5,1,149,70,282.98
6,1,199,67,647.99
7,1,227,74,305
8,1,87,92,759.99
9,1,108,139,849.99
10,1,145,118,287
11,1,96,113,141.56
12,1,191,41,573.99
13,1,84,46,440.3
14,1,129,98,734.99
1,1,137,116,469.99
15,1,287,60,329.99
16,1,166,70,1638.89
17,1,149,51,282.98
18,1,213,105,1469.96
19,1,38,53,1199.99
20,1,126,105,640.99
21,1,36,79,1299.99
22,1,83,44,829.99
23,1,202,104,713.99
24,1,121,129,721.99
25,1,43,109,298.98
26,1,200,114,620.95
27,1,71,38,660
28,1,31,61,443.72
29,1,7,38,680.99
30,1,235,70,41.99
31,1,101,68,635.99
32,1,251,83,337.81
33,1,55,93,150.99
34,1,185,141,873.98
35,1,174,133,798.26
36,1,204,45,686.99
37,1,35,150,1314.99
38,1,71,90,660
39,1,186,116,1449.98
40,1,141,106,419.99
41,1,268,80,47.88
42,1,34,45,417.98
43,1,67,74,863.05
44,1,220,118,759.99
45,1,74,43,701.95
46,1,120,51,892
47,1,178,73,1999.89
48,1,165,46,1666.61
49,1,172,104,358.49
50,1,215,49,829.89
51,1,21,34,749.99
52,1,235,123,41.99
53,1,100,130,97.88
54,1,208,73,1199.99
55,1,102,127,2042.69
56,1,84,70,440.3
57,1,224,75,349.99
58,1,64,55,525.99
59,1,178,101,1999.89
60,1,205,74,649.99
61,1,174,114,798.26
62,1,188,130,482.49
63,1,70,72,710.99
64,1,199,61,647.99
65,1,280,104,149.88
66,1,77,143,695.99
67,1,287,61,329.99
68,1,163,98,1899.99
69,1,206,57,4139
70,1,185,146,873.98
71,1,19,146,1704.37
72,1,129,101,734.99
73,1,245,120,1699
74,1,104,97,83.88
75,1,58,73,784.98
76,1,109,92,713.99
77,1,203,65,671.38
78,1,92,147,2200
79,1,285,145,339.99
80,1,213,63,1469.96
81,1,128,133,741.63
82,1,91,42,2259.99
83,1,264,35,88.99
84,1,106,137,608.95
85,1,155,114,588.95
86,1,202,46,713.99
87,1,47,123,2377.09
88,1,278,139,677.99
89,1,247,45,339.99
90,1,65,84,1199.99
91,1,122,89,722.99
92,1,208,114,1199.99
93,1,257,70,84.95
94,1,255,38,90.99
95,1,52,138,1676.98
96,1,260,34,267.99
97,1,110,39,3192.97
98,1,66,104,399.99
99,1,95,66,109.99
100,1,280,70,149.88
101,1,17,47,699.01
102,1,196,69,1099.99
103,1,6,117,849.99
104,1,129,74,734.99
105,1,31,116,443.72
1,2,78,77,686.99
3,2,56,65,16.99
5,2,15,45,725.99
8,2,12,70,824.98
9,2,99,123,68.06
10,2,10,102,811.99
12,2,63,58,572.96
15,2,154,67,1204.98
16,2,155,106,588.95
19,2,24,62,66.89
20,2,41,78,299.89
21,2,101,146,635.99
22,2,116,45,731.99
23,2,190,50,948.99
25,2,239,119,739.99
27,2,141,77,419.99
28,2,121,120,721.99
29,2,82,62,1499.89
31,2,176,97,939.49
33,2,153,33,1249
35,2,70,134,710.99
36,2,101,105,635.99
37,2,67,129,863.05
38,2,169,52,1844.89
39,2,153,108,1249
40,2,101,131,635.99
41,2,219,82,1299.73
43,2,287,66,329.99
46,2,4,112,2699.99
47,2,55,107,150.99
48,2,158,98,2009.46
53,2,168,89,43.99
55,2,32,70,469.99
58,2,120,32,892
59,2,166,34,1638.89
60,2,13,138,704.99
61,2,56,75,16.99
63,2,54,47,1019.99
65,2,113,83,704.99
66,2,218,40,1388.89
67,2,144,121,289.79
68,2,248,42,2774.98
69,2,71,66,660
70,2,83,52,829.99
71,2,241,38,1756
72,2,211,123,1064.99
74,2,250,86,338.99
75,2,187,74,353.98
76,2,177,98,1759.99
77,2,168,136,43.99
78,2,169,50,1844.89
79,2,265,53,1431.99
82,2,107,71,644
83,2,196,54,1099.99
84,2,199,137,647.99
85,2,230,35,136.69
86,2,156,47,394.99
87,2,233,96,59.99
88,2,11,106,2015.11
89,2,102,84,2042.69
90,2,64,60,525.99
91,2,220,127,759.99
92,2,34,126,417.98
94,2,186,146,1449.98
95,2,143,64,402.99
97,2,207,82,3254.99
101,2,113,134,704.99
104,2,171,90,382.98
105,2,242,67,1751.99
1,3,64,52,525.99
8,3,71,87,660
9,3,265,90,1431.99
12,3,42,75,299.89
15,3,246,133,343.99
16,3,235,56,41.99
19,3,23,142,89.89
22,3,24,77,66.89
25,3,29,65,645.99
27,3,68,96,766.11
28,3,41,56,299.89
29,3,268,118,47.88
36,3,100,102,97.88
38,3,264,89,88.99
39,3,109,33,713.99
40,3,250,131,338.99
41,3,69,86,678.75
43,3,110,94,3192.97
46,3,187,86,353.98
47,3,65,99,1199.99
57,2,177,110,1759.99
58,3,113,73,704.99
59,3,118,105,699.89
60,3,272,144,1073.99
61,3,146,59,283.98
65,3,116,35,731.99
66,3,286,35,234
67,3,167,94,1010.46
68,3,183,50,899.99
69,3,253,112,579.99
71,3,195,75,1055.99
72,3,273,145,443.64
75,3,33,143,52.65
76,3,163,134,1899.99
77,3,218,143,1388.89
78,3,125,119,768.99
83,3,116,76,731.99
86,3,287,45,329.99
87,3,130,119,117.45
89,3,224,89,349.99
91,3,266,83,1418.99
97,3,270,61,769.99
101,3,135,134,127.88
104,3,45,48,2501.69
105,3,275,45,399.99
1,4,210,87,1029.99
8,4,25,40,104.88
9,4,288,62,319.99
12,4,144,70,289.79
13,2,85,82,1274.99
14,2,206,133,4139
16,4,95,42,109.99
18,2,226,57,309.85
22,4,288,44,319.99
24,2,227,61,305
25,4,209,80,1199.99
26,2,186,92,1449.98
27,4,263,95,89.99
28,4,208,139,1199.99
29,4,141,32,419.99
30,2,200,137,620.95
33,3,217,67,401.98
36,4,10,72,811.99
38,4,61,59,487.3
40,4,230,80,136.69
41,4,258,49,57.98
43,4,105,86,2799.99
44,2,215,148,829.89
46,4,264,104,88.99
57,3,238,122,741.78
58,4,186,70,1449.98
59,4,47,138,2377.09
60,4,92,125,2200
61,4,34,71,417.98
67,4,109,117,713.99
68,4,163,125,1899.99
73,2,35,130,1314.99
75,4,142,115,2998.89
76,4,272,56,1073.99
77,4,2,99,2554.99
78,4,200,87,620.95
79,3,204,138,686.99
83,4,261,106,1504.99
86,4,121,76,721.99
89,4,253,126,579.99
90,3,134,106,295.72
91,4,194,75,397.42
94,3,218,86,1388.89
105,4,138,80,645.99
1,5,138,131,645.99
2,2,265,121,1431.99
3,3,28,63,479.99
5,3,216,82,863.98
6,2,138,41,645.99
8,5,284,118,54.99
12,5,208,133,1199.99
13,3,240,80,1805.97
15,4,239,71,739.99
19,4,259,46,80.72
21,3,250,120,338.99
22,5,160,59,1908.73
23,3,210,80,1029.99
24,3,47,51,2377.09
25,5,235,45,41.99
27,5,118,122,699.89
28,5,27,99,800.74
29,5,258,137,57.98
30,3,260,37,267.99
32,2,142,130,2998.89
35,3,211,87,1064.99
38,5,209,149,1199.99
40,5,98,149,2064.99
41,5,179,83,312.67
46,5,181,94,999.99
55,3,260,79,267.99
57,4,164,114,1850
58,5,62,143,789.79
59,5,203,117,671.38
60,5,278,114,677.99
67,5,80,129,564.89
68,5,108,150,849.99
69,4,82,58,1499.89
74,3,242,61,1751.99
75,5,192,37,519.99
76,5,89,133,749.99
78,5,181,37,999.99
82,3,254,121,119.99
89,5,44,55,49.37
91,5,272,111,1073.99
94,4,80,133,564.89
1,6,126,95,640.99
2,3,195,39,1055.99
3,4,64,46,525.99
5,4,31,77,443.72
12,6,236,114,745.32
13,4,30,60,645.2
14,3,231,87,449.99
15,5,230,92,136.69
18,3,93,83,2116.72
19,5,107,106,644
22,6,56,43,16.99
23,4,116,74,731.99
25,6,28,85,479.99
27,6,29,133,645.99
29,6,30,75,645.2
30,4,237,50,744.98
31,3,191,147,573.99
38,6,278,76,677.99
39,4,53,128,1003.98
40,6,273,82,443.64
41,6,287,112,329.99
46,6,60,80,59.99
47,4,33,98,52.65
58,6,213,77,1469.96
59,6,154,126,1204.98
65,4,248,42,2774.98
66,4,103,88,809.99
68,6,13,141,704.99
69,5,278,71,677.99
70,3,102,84,2042.69
74,4,106,82,608.95
75,6,95,81,109.99
76,6,167,46,1010.46
78,6,206,145,4139
81,2,241,134,1756
82,4,157,113,388.99
87,4,127,59,719.99
89,6,122,140,722.99
91,6,123,37,3177.44
92,3,65,132,1199.99
95,3,271,69,549.59
99,2,118,37,699.89
1,7,30,41,645.2
2,4,18,49,799
3,5,107,112,644
4,2,137,75,469.99
5,5,31,78,443.72
9,5,145,58,287
10,3,182,83,949.89
12,7,141,110,419.99
13,5,167,89,1010.46
15,6,253,83,579.99
19,6,103,105,809.99
22,7,17,60,699.01
23,5,5,59,2290.79
26,3,279,71,1318.99
27,7,155,51,588.95
29,7,166,103,1638.89
30,5,43,68,298.98
31,4,226,34,309.85
34,2,131,113,279.99
38,7,49,139,1499.99
39,5,38,144,1199.99
40,7,258,99,57.98
41,7,25,101,104.88
42,2,10,147,811.99
44,3,271,37,549.59
46,7,155,114,588.95
47,5,149,123,282.98
59,7,152,82,280.98
61,5,15,32,725.99
66,5,174,66,798.26
67,6,108,82,849.99
70,4,82,139,1499.89
74,5,3,101,799.99
75,7,106,74,608.95
76,7,196,125,1099.99
79,4,63,146,572.96
81,3,69,104,678.75
82,5,48,59,1218.5
83,5,101,122,635.99
84,3,269,147,759.99
87,5,265,74,1431.99
90,4,93,146,2116.72
91,7,118,113,699.89
92,4,110,111,3192.97
95,4,86,123,804.98
97,4,33,67,52.65
99,3,84,98,440.3
101,4,284,52,54.99
102,2,95,117,109.99
103,2,258,142,57.98
1,8,170,129,383.98
2,5,160,30,1908.73
3,6,36,81,1299.99
4,3,7,140,680.99
8,6,127,34,719.99
9,6,14,48,704.99
10,4,172,133,358.49
12,8,256,85,26.99
13,6,1,127,640.99
16,5,45,80,2501.69
19,7,30,94,645.2
21,4,1,135,640.99
22,8,222,99,754.98
23,6,169,40,1844.89
27,8,71,127,660
29,8,10,81,811.99
31,5,79,56,659.99
32,3,73,134,799
34,3,39,100,301.99
36,5,255,143,90.99
37,3,147,100,283.98
39,6,20,112,719.99
40,8,31,30,443.72
42,3,249,76,2660.72
44,4,158,100,2009.46
46,8,123,116,3177.44
54,2,4,136,2699.99
58,7,108,49,849.99
61,6,5,50,2290.79
67,7,78,124,686.99
70,5,124,106,594.99
73,3,31,102,443.72
75,8,24,82,66.89
81,4,49,83,1499.99
82,6,180,56,279.99
83,6,233,86,59.99
84,4,95,36,109.99
87,6,174,84,798.26
90,5,73,129,799
91,8,196,102,1099.99
95,5,107,76,644
97,5,99,48,68.06
98,2,48,44,1218.5
99,4,36,71,1299.99
101,5,150,36,281.98
104,4,48,51,1218.5
105,5,103,77,809.99
1,9,196,139,1099.99
2,6,182,95,949.89
3,7,125,73,768.99
4,4,287,60,329.99
7,2,230,49,136.69
8,7,16,135,889.89
9,7,124,117,594.99
10,5,218,68,1388.89
11,2,40,79,299.89
12,9,282,117,804.99
13,7,39,67,301.99
14,4,114,40,820.61
16,6,131,53,279.99
18,4,91,141,2259.99
22,9,8,89,601.99
23,7,286,36,234
24,4,24,59,66.89
27,9,93,132,2116.72
28,6,210,120,1029.99
29,9,233,71,59.99
32,4,30,105,645.2
33,4,55,93,150.99
34,4,143,106,402.99
36,6,205,33,649.99
39,7,185,101,873.98
40,9,170,31,383.98
43,5,86,114,804.98
46,9,2,65,2554.99
53,3,9,106,899.99
54,3,68,134,766.11
57,5,132,77,554.99
58,8,157,65,388.99
61,7,52,45,1676.98
67,8,247,39,339.99
69,6,3,46,799.99
70,6,50,68,8867.99
75,9,20,34,719.99
76,8,201,91,653.5
81,5,55,144,150.99
82,7,70,31,710.99
83,7,18,49,799
84,5,87,119,759.99
87,7,7,66,680.99
89,7,76,109,629.99
90,6,185,147,873.98
94,5,181,143,999.99
95,6,71,135,660
97,6,219,132,1299.73
99,5,200,58,620.95
101,6,20,138,719.99
104,5,281,85,864.98
1,10,64,147,525.99
2,7,204,100,686.99
3,8,190,127,948.99
4,5,20,80,719.99
6,3,94,90,15.55
10,6,64,96,525.99
12,10,210,37,1029.99
13,8,1,95,640.99
14,5,239,125,739.99
15,7,83,118,829.99
16,7,256,44,26.99
18,5,87,103,759.99
22,10,90,95,759.99
23,8,241,126,1756
24,5,41,83,299.89
26,4,164,78,1850
27,10,150,58,281.98
30,6,4,82,2699.99
33,5,62,84,789.79
34,5,68,37,766.11
35,4,41,79,299.89
39,8,179,102,312.67
40,10,215,36,829.89
41,8,21,31,749.99
42,4,213,103,1469.96
43,6,235,86,41.99
46,10,214,91,1009.79
58,9,136,134,826.99
66,6,97,130,59.87
68,7,189,139,649
69,7,79,49,659.99
81,6,65,61,1199.99
82,8,213,56,1469.96
87,8,257,110,84.95
89,8,151,127,281.97
90,7,250,125,338.99
92,5,114,112,820.61
93,2,169,46,1844.89
94,6,4,111,2699.99
99,6,1,43,640.99
101,7,102,123,2042.69
1,11,169,105,1844.89
2,8,141,97,419.99
4,6,159,96,1994.49
6,4,258,145,57.98
10,7,127,52,719.99
12,11,169,114,1844.89
13,9,225,137,503.98
14,6,188,79,482.49
15,8,241,77,1756
16,8,138,142,645.99
18,6,259,60,80.72
19,8,91,130,2259.99
22,11,234,144,150.99
23,9,14,86,704.99
24,6,276,99,1163.99
26,5,151,36,281.97
27,11,116,67,731.99
30,7,155,64,588.95
33,6,190,70,948.99
42,5,252,85,499.99
43,7,1,57,640.99
45,2,66,126,399.99
58,10,163,31,1899.99
60,6,51,79,2269.99
65,5,119,141,899.99
66,7,49,78,1499.99
68,8,204,56,686.99
87,9,121,142,721.99
91,9,43,44,298.98
92,6,164,91,1850
93,3,251,30,337.81
94,7,172,37,358.49
99,7,201,31,653.5
1,12,226,103,309.85
6,5,11,74,2015.11
10,8,18,124,799
12,12,96,120,141.56
13,10,245,138,1699
14,7,113,32,704.99
18,7,188,133,482.49
19,9,63,83,572.96
22,12,108,45,849.99
23,10,187,110,353.98
25,7,135,132,127.88
27,12,92,105,2200
28,7,54,131,1019.99
29,10,76,62,629.99
32,5,85,148,1274.99
33,7,18,41,799
36,7,152,45,280.98
42,6,78,47,686.99
43,8,169,73,1844.89
45,3,68,88,766.11
57,6,164,44,1850
58,11,152,51,280.98
59,8,287,96,329.99
60,7,189,146,649
66,8,75,122,624.04
67,9,91,138,2259.99
69,8,169,67,1844.89
73,4,45,54,2501.69
74,6,187,137,353.98
75,10,72,86,589.99
76,9,155,78,588.95
87,10,76,96,629.99
91,10,269,104,759.99
92,7,108,104,849.99
93,4,43,113,298.98
94,8,258,73,57.98
99,8,102,101,2042.69
104,6,51,139,2269.99
1,13,178,121,1999.89
4,7,262,79,1449.99
6,6,89,150,749.99
8,8,100,68,97.88
9,8,93,132,2116.72
10,9,119,107,899.99
14,8,238,64,741.78
16,9,135,76,127.88
18,8,136,32,826.99
19,10,200,93,620.95
22,13,281,73,864.98
25,8,2,65,2554.99
27,13,111,102,827.37
28,8,40,105,299.89
29,11,115,52,699.99
31,6,171,103,382.98
32,6,102,147,2042.69
33,8,13,75,704.99
34,6,101,62,635.99
35,5,186,41,1449.98
36,8,141,144,419.99
39,9,144,125,289.79
40,11,184,88,999.99
41,9,55,61,150.99
42,7,139,149,65.92
46,11,89,119,749.99
51,2,7,64,680.99
53,4,177,96,1759.99
58,12,62,148,789.79
59,9,154,82,1204.98
64,2,126,52,640.99
65,6,262,118,1449.99
66,9,279,90,1318.99
67,10,239,45,739.99
68,9,177,84,1759.99
69,9,261,55,1504.99

}

inventories = {
	product_id:number, warehouse_id:number, quantity:number

210,8,122
211,8,123
212,8,123
214,8,124
216,8,125
217,8,125
218,8,126
220,8,149
221,8,150
222,8,150
223,8,151
229,8,123
230,8,124
231,8,124
232,8,124
233,8,124
234,8,124
235,8,125
241,8,121
242,8,121
243,8,121
245,8,137
254,8,136
255,8,136
256,8,136
257,8,136
258,8,136
259,8,137
260,8,137
263,8,137
264,8,137
269,8,178
270,8,178
271,8,183
272,8,184
273,8,156
274,8,160
276,8,187
277,8,187
278,8,188
280,8,154
281,8,167
283,8,194
284,8,268
285,8,176
286,8,177
2,9,23
3,9,35
4,9,35
5,9,36
6,9,36
7,9,36
8,9,36
9,9,36
11,9,37
12,9,37
13,9,37
14,9,38
15,9,41
17,9,3
18,9,3
19,9,3
20,9,4
21,9,4
27,9,5
29,9,6
30,9,6
31,9,7
32,9,7
34,9,8
46,9,6
47,9,0
54,9,33
62,9,32
63,9,33
67,9,34
68,9,34
69,9,35
70,9,35
71,9,35
72,9,35
73,9,27
74,9,27
76,9,28
78,9,29
79,9,29
80,9,29
84,9,33
87,9,35
88,9,7
89,9,8
90,9,8
91,9,22
98,9,32
101,9,3
102,9,36
103,9,5
105,9,6
106,9,6
107,9,6
108,9,6
109,9,6
110,9,7
114,9,8
115,9,9
116,9,9
117,9,9
119,9,10
120,9,10
121,9,10
122,9,11
123,9,11
124,9,11
125,9,11
126,9,12
128,9,12
129,9,12
132,9,13
133,9,13
136,9,14
137,9,15
138,9,16
141,9,18
142,9,19
159,9,15
160,9,21
161,9,36
163,9,35
166,9,54
174,9,74
175,9,74
182,9,110
184,9,111
185,9,111
188,9,119
189,9,119
190,9,120
191,9,120
193,9,121
195,9,122
196,9,122
198,9,122
199,9,123
200,9,123
201,9,124
203,9,124
204,9,125
205,9,125
207,9,109
210,9,110
211,9,111
212,9,111
214,9,112
216,9,113
217,9,113
218,9,114
220,9,134
221,9,135
222,9,135
223,9,136
241,9,109
242,9,109
243,9,109
245,9,125
269,9,161
270,9,161
271,9,165
272,9,166
274,9,148
276,9,169
277,9,169
278,9,170
281,9,155
283,9,179
3,1,106
4,1,106
5,1,106
6,1,107
11,1,108
12,1,108
80,1,125
87,1,131
88,1,117
89,1,118
90,1,118
103,1,125
105,1,126
108,1,126
110,1,127
114,1,128
123,1,131
132,1,133
133,1,133
142,1,89
161,1,132
174,1,170
175,1,170
182,1,175
184,1,175
185,1,176
207,1,205
216,1,209
220,1,196
221,1,197
222,1,197
223,1,197
245,1,221
269,1,222
270,1,222
281,1,251
3,2,96
4,2,96
5,2,96
6,2,96
7,2,97
8,2,97
9,2,97
11,2,98
12,2,98
13,2,98
14,2,98
15,2,99
17,2,100
18,2,101
19,2,101
20,2,104
21,2,105
22,2,114
23,2,114
24,2,115
25,2,115
26,2,115
27,2,106
29,2,107
30,2,107
33,2,117
35,2,118
36,2,118
37,2,119
38,2,119
39,2,119
40,2,119
41,2,119
42,2,122
43,2,122
44,2,122
50,2,117
54,2,110
62,2,149
63,2,149
67,2,154
68,2,154
69,2,154
70,2,155
71,2,155
72,2,155
73,2,111
74,2,111
76,2,112
78,2,113
79,2,113
80,2,113
87,2,119
88,2,167
89,2,167
90,2,167
94,2,91
99,2,94
100,2,94
101,2,173
103,2,178
104,2,81
105,2,178
106,2,178
107,2,178
108,2,179
109,2,179
110,2,179
114,2,180
115,2,181
116,2,182
117,2,182
119,2,183
120,2,183
121,2,183
122,2,183
123,2,184
124,2,184
125,2,184
126,2,184
128,2,185
129,2,185
130,2,88
131,2,88
132,2,185
133,2,185
134,2,89
135,2,89
136,2,186
138,2,191
139,2,93
140,2,94
142,2,194
144,2,95
145,2,96
146,2,96
147,2,96
148,2,97
149,2,97
150,2,101
151,2,101
152,2,101
161,2,120
166,2,138
168,2,128
174,2,158
175,2,158
182,2,177
184,2,178
185,2,178
188,2,171
189,2,172
190,2,172
191,2,173
193,2,173
195,2,174
196,2,174
198,2,175
199,2,176
200,2,176
201,2,176
203,2,177
204,2,177
205,2,177
207,2,193
210,2,194
211,2,195
212,2,195
214,2,196
216,2,197
218,2,198
220,2,184
221,2,185
222,2,185
223,2,185
227,2,189
228,2,189
229,2,212
230,2,213
231,2,213
232,2,213
233,2,213
234,2,213
235,2,214
236,2,214
237,2,214
238,2,214
239,2,214
245,2,209
254,2,225
255,2,225
256,2,225
257,2,226
258,2,226
259,2,226
260,2,226
261,2,226
262,2,227
263,2,227
264,2,227
265,2,227
269,2,210
270,2,210
271,2,215
272,2,216
273,2,264
274,2,232
276,2,219
277,2,219
278,2,220
279,2,244
280,2,244
281,2,239
283,2,226
284,2,353
285,2,267
286,2,267
2,3,100
3,3,88
4,3,88
5,3,89
6,3,89
11,3,90
12,3,90
46,3,112
47,3,66
80,3,101
87,3,107
88,3,118
89,3,118
90,3,118
91,3,94
98,3,69
102,3,73
103,3,126
105,3,126
108,3,127
110,3,127
114,3,131
123,3,135
132,3,136
133,3,136
142,3,142
159,3,87
160,3,93
161,3,108
163,3,107
174,3,146
175,3,146
182,3,245
184,3,246
185,3,246
207,3,181
216,3,185
220,3,272
221,3,273
222,3,273
223,3,273
241,3,181
242,3,181
243,3,181
245,3,197
269,3,304
270,3,304
281,3,227
3,4,63
4,4,63
5,4,63
6,4,64
7,4,64
8,4,67
9,4,67
11,4,68
12,4,68
13,4,68
14,4,68
15,4,69
17,4,70
18,4,71
19,4,71
20,4,71
21,4,72
27,4,73
29,4,74
30,4,74
54,4,88
62,4,74
63,4,74
67,4,76
68,4,76
69,4,76
70,4,76
71,4,76
72,4,77
73,4,87
74,4,87
76,4,88
78,4,89
79,4,89
80,4,89
87,4,95
88,4,86
89,4,86
90,4,86
101,4,95
103,4,97
105,4,97
106,4,97
107,4,97
108,4,98
109,4,98
110,4,98
114,4,99
115,4,100
116,4,100
117,4,101
119,4,102
120,4,102
121,4,102
122,4,102
123,4,103
124,4,103
125,4,103
126,4,103
128,4,103
129,4,104
132,4,104
133,4,104
136,4,105
138,4,107
142,4,110
161,4,96
166,4,114
174,4,134
175,4,134
182,4,210
184,4,211
185,4,211
188,4,219
189,4,219
190,4,223
191,4,223
193,4,223
195,4,224
196,4,225
198,4,225
199,4,226
200,4,226
201,4,227
203,4,227
204,4,227
205,4,228
207,4,169
210,4,170
211,4,171
212,4,171
214,4,172
216,4,173
218,4,174
220,4,234
221,4,235
222,4,235
223,4,236
245,4,185
269,4,266
270,4,266
271,4,271
272,4,272
274,4,208
276,4,275
277,4,275
278,4,276
281,4,215
283,4,282
2,5,71
3,5,46
4,5,46
5,5,47
6,5,47
11,5,48
12,5,48
22,5,73
23,5,74
24,5,74
25,5,74
26,5,74
33,5,77
35,5,77
36,5,78
37,5,78
38,5,78
39,5,78
40,5,78
41,5,79
42,5,81
43,5,81
44,5,82
46,5,90
47,5,44
50,5,69
80,5,77
87,5,83
88,5,62
89,5,63
90,5,63
91,5,70
94,5,85
98,5,86
99,5,88
100,5,88
102,5,90
103,5,73
104,5,84
105,5,74
108,5,74
110,5,75
114,5,76
123,5,79
130,5,42
131,5,42
132,5,81
133,5,81
134,5,42
135,5,43
139,5,47
140,5,47
142,5,87
144,5,49
145,5,49
146,5,50
147,5,50
148,5,50
149,5,50
150,5,54
151,5,54
152,5,54
159,5,63
160,5,69
161,5,84
163,5,83
168,5,92
174,5,122
175,5,122
182,5,184
184,5,184
185,5,185
207,5,157
216,5,161
220,5,208
221,5,209
222,5,209
223,5,209
229,5,163
230,5,163
231,5,163
232,5,163
233,5,164
234,5,164
235,5,164
236,5,164
237,5,164
238,5,165
239,5,165
241,5,157
242,5,157
243,5,157
245,5,173
254,5,175
255,5,175
256,5,175
257,5,176
258,5,176
259,5,176
260,5,176
261,5,176
262,5,177
263,5,177
264,5,177
265,5,177
269,5,237
270,5,237
273,5,199
279,5,193
280,5,194
281,5,203
284,5,220
285,5,216
286,5,216
2,6,58
3,6,29
4,6,30
5,6,30
6,6,30
7,6,30
8,6,30
9,6,31
11,6,31
12,6,32
13,6,32
14,6,32
15,6,33
17,6,34
18,6,35
19,6,35
20,6,35
21,6,36
22,6,62
23,6,62
24,6,62
25,6,62
26,6,63
27,6,37
29,6,38
30,6,38
31,6,39
32,6,39
33,6,65
34,6,39
35,6,66
36,6,66
37,6,66
38,6,66
39,6,66
40,6,67
41,6,67
42,6,69
43,6,69
44,6,70
46,6,29
47,6,33
50,6,84
54,6,66
56,6,58
57,6,66
62,6,30
63,6,30
67,6,34
68,6,35
69,6,35
70,6,35
71,6,35
72,6,35
73,6,63
74,6,63
76,6,64
78,6,65
79,6,65
80,6,65
84,6,69
87,6,71
88,6,44
89,6,45
90,6,45
91,6,58
94,6,71
95,6,60
96,6,60
98,6,72
99,6,73
100,6,74
101,6,51
102,6,76
103,6,53
104,6,71
105,6,53
106,6,53
107,6,53
108,6,54
109,6,54
110,6,54
114,6,55
115,6,56
116,6,56
117,6,57
119,6,58
120,6,58
121,6,58
122,6,58
123,6,59
124,6,59
125,6,59
126,6,59
128,6,59
129,6,60
130,6,78
131,6,29
132,6,60
133,6,60
134,6,29
135,6,29
136,6,61
137,6,65
138,6,66
139,6,34
140,6,34
141,6,68
142,6,69
144,6,36
145,6,36
146,6,37
147,6,37
148,6,37
149,6,37
150,6,41
151,6,41
152,6,41
157,6,42
159,6,51
160,6,57
161,6,72
163,6,71
166,6,90
168,6,80
170,6,81
172,6,85
173,6,94
174,6,110
175,6,110
182,6,163
184,6,164
185,6,164
188,6,172
189,6,172
190,6,173
191,6,173
193,6,174
195,6,175
196,6,175
198,6,176
199,6,176
200,6,177
201,6,177
203,6,177
204,6,178
205,6,178
207,6,145
210,6,146
211,6,147
212,6,147
214,6,148
216,6,149
217,6,149
218,6,150
220,6,185
221,6,185
222,6,186
223,6,186
227,6,141
228,6,141
229,6,149
230,6,149
231,6,150
232,6,150
233,6,150
234,6,150
235,6,150
236,6,151
237,6,151
238,6,151
239,6,151
241,6,145
242,6,145
243,6,145
245,6,161
247,6,148
251,6,150
254,6,161
255,6,162
256,6,162
257,6,162
258,6,162
259,6,162
260,6,163
261,6,163
262,6,163
263,6,163
264,6,163
265,6,164
269,6,214
270,6,214
271,6,221
272,6,222
273,6,184
274,6,184
276,6,225
277,6,225
278,6,226
279,6,180
280,6,180
281,6,191
283,6,232
284,6,320
285,6,202
286,6,203
287,6,212
288,6,213
2,7,46
3,7,63
4,7,63
5,7,63
6,7,63
11,7,65
12,7,65
22,7,50
23,7,50
24,7,50
25,7,51
26,7,51
33,7,53
35,7,54
36,7,54
37,7,55
38,7,55
39,7,55
40,7,55
41,7,55
42,7,57
43,7,58
44,7,58
46,7,18
47,7,22
50,7,58
80,7,53
87,7,59
88,7,27
89,7,27
90,7,27
91,7,46
94,7,57
98,7,58
99,7,60
100,7,60
102,7,62
103,7,35
104,7,58
105,7,35
108,7,36
110,7,36
114,7,37
123,7,41
130,7,66
131,7,66
132,7,45
133,7,45
134,7,17
135,7,17
139,7,21
140,7,21
142,7,51
144,7,23
145,7,23
146,7,24
147,7,24
148,7,24
149,7,24
150,7,28
151,7,28
152,7,28
159,7,39
160,7,45
161,7,60
163,7,59
168,7,68
174,7,98
175,7,98
182,7,143
184,7,143
185,7,144
207,7,133
216,7,137
220,7,167
221,7,168
222,7,168
223,7,168
229,7,136
230,7,136
231,7,136
232,7,137
233,7,137
234,7,137
235,7,137
241,7,133
242,7,133
243,7,133
245,7,149
254,7,148
255,7,148
256,7,149
257,7,149
258,7,149
259,7,149
260,7,149
263,7,150
264,7,150
269,7,196
270,7,196
273,7,170
280,7,167
281,7,179
284,7,294
285,7,189
286,7,189
2,8,34
3,8,49
4,8,49
5,8,49
6,8,50
7,8,50
8,8,50
9,8,50
11,8,51
12,8,51
13,8,51
14,8,51
15,8,52
17,8,54
18,8,54
19,8,54
20,8,5
21,8,5
22,8,38
23,8,39
24,8,39
25,8,39
26,8,39
27,8,6
29,8,7
30,8,7
31,8,8
32,8,8
33,8,42
34,8,9
35,8,42
36,8,43
37,8,43
38,8,43
39,8,43
40,8,44
41,8,44
42,8,46
43,8,46
44,8,47
46,8,7
47,8,11
50,8,32
54,8,44
62,8,47
63,8,47
67,8,49
68,8,49
69,8,50
70,8,50
71,8,50
72,8,50
73,8,39
74,8,39
76,8,40
78,8,41
79,8,41
80,8,41
84,8,45
87,8,47
88,8,12
89,8,12
90,8,13
91,8,34
94,8,44
98,8,45
99,8,47
100,8,47
101,8,18
102,8,49
103,8,20
104,8,46
105,8,20
106,8,21
107,8,21
108,8,21
109,8,21
110,8,22
114,8,23
115,8,24
116,8,24
117,8,24
119,8,25
120,8,25
121,8,25
122,8,26
123,8,26
124,8,26
125,8,26
126,8,26
128,8,27
129,8,27
130,8,53
131,8,53
132,8,28
133,8,28
134,8,54
135,8,54
136,8,28
137,8,29
138,8,31
139,8,8
140,8,9
141,8,33
142,8,34
144,8,10
145,8,11
146,8,11
147,8,11
148,8,12
149,8,12
150,8,15
151,8,15
152,8,15
159,8,27
160,8,33
161,8,48
163,8,47
166,8,66
168,8,56
174,8,86
175,8,86
182,8,128
184,8,128
185,8,129
188,8,137
189,8,137
190,8,137
191,8,138
193,8,138
195,8,139
196,8,139
198,8,140
199,8,141
200,8,141
201,8,142
203,8,142
204,8,142
205,8,142
207,8,121

}